wiki‎ > ‎

mysql

Auto increment

ALTER TABLE `ondfabricants` MODIFY `id` INT AUTO_INCREMENT;

Kill a process


SHOW FULL PROCESSLIST;
kill xxx;

InnoDB configuration

With a mysql installed through homebrew, custom configuration can be set in /usr/local/etc/my.cnf

Comments