How can I optimize my MySQL server?

Question

I have 3,0666,691 queries in the log 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.

Answer 1

MySQL Tunin Primer Script was useful for me. He gives some useful hints and shows which values ​​are good, which is bad. For TYPO3, I assume that some slow_queries are not a problem, most likely this will happen only in the backend.