First shutdown MySQL
service mysql stop
Assuming you don't care if you loose any data, like on a fresh install, you need to remove some files in preparation for the changes in config files.
cd /var/lib/mysql rm ibdata1 rm ib_logfile0 rm ib_logfile1
Then edit /etc/mysql/my.cnf and place the following at the bottom of [mysqld] section. It should be below the line where you can see "# ssl-key=/etc/mysql/server-key.pem"
innodb_file_per_table innodb_autoextend_increment = 50 innodb_log_files_in_group = 2 innodb_log_file_size = 512M innodb_buffer_pool_size = 1024M innodb_additional_mem_pool_size = 8M innodb_log_buffer_size = 8M
Then start your mysql service
service mysql startThis should speed up many of your queries and bulk updates. I am not very sure if the above setups have any pitfalls for production use. In such cases, consider to consult a MySQL expert. But for development, this is good enough.