如何优化我的MySQL服务器? [英] How can I optimize my MySQL server?

问题描述

我的phpmyadmin状态信息中记录了3,066,691个查询和一些红色数字:

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

• 慢查询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

phpmyadmin中也有绿色数字，但我不知道它们是什么意思?我使用Typo3和MySQL.

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

推荐答案

MySQL Tunin入门脚本对我有帮助.它提供了一些有用的提示，并显示了哪些值是好的，哪些值是不好的. 我猜对于TYPO3，一些slow_queries没问题，可能只在后端发生.

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.

这篇关于如何优化我的MySQL服务器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！