Basic tuning of the mySQL is accomplished in the /etc/my.cnf file. If you want to get all geeky and into this reference the seminal document over on the mysql dev site. This should result in a speed increase in your system. It certainly has in my system running mySQL 5.x.
The information below is expressed as a set of ratios that begins with your system RAM and then works from there.
innodb_buffer_pool_size = $SYSTEMRAM/2 innodb_additional_mem_pool_size = $innodb_buffer_pool_size/20 innodb_log_file_size = $innodb_buffer_pool_size/4 innodb_log_buffer_size = $innodb_buffer_pool_size/50 or a minimum value of 8MB
Note bene: Changing your log file size can results in a mySQL refusing to start. Simply remove these files from you mysql data directory and they will be created on the next startup.