How can I optimize my MySQL server? [closed]

问题:

I have 3,066,691 queries logged and some red numbers in my phpmyadmin status information:

• Slow_queries 24
• Innodb_buffer_pool_reads 2,2 M
• Innodb_log_waits 8
• Innodb_row_lock_time_avg 49
• Innodb_row_lock_waits 1
• Created_tmp_disk_tables 21

There are also green numbers in phpmyadmin but I don't know what they mean ? I use Typo3 and MySQL.

回答1:

The MySQL Tunin Primer Script was helpfull for me. It gives some helpfull hints and shows which values are good, which one bad. For TYPO3 i guess, some slow_queries are no problem, the will probably occur only in the backend.