MySQL uses more than 500% of the CPU
Create folder mysql_tmp on the biggest partition you have. 
Add the line tmpdir = /path/to/the/mysql_tmp to the section [mysqld] of the mysql.conf.
restart mysql
perform REPAIR for all the tables in your working base