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

http://www.cowboycoded.com/tag/innodb_buffer_pool_size/