我在我们的服务器上有一个很大的问题，主机约十个magento网站。 我做了所有明显的优化，如操作码的APC，caching后端的APC，innodb设置调整，magento编译等。
网站加载正确，但有时候，每天5-6次，有MySQL的查询“COMMIT”，阻止MySQL服务器，并把很长一段时间执行（> 500s）。 然后，所有新的传入连接的服务器是满载错误“太多连接”。
这里的问题来了Phpmyadmin的截图： http ://imagesia.com/process_2l0n
我的my.cnf（没有第一个默认部分）
# # * Fine Tuning # key_buffer = 384M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP #max_connections = 100 table_cache = 2048 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_type = 1 query_cache_limit = 1M query_cache_size = 64M # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. # As of 5.1 you can enable the log at runtime! #general_log_file = /var/log/mysql/mysql.log #general_log = 1 log_error = /var/log/mysql/error.log # Here you can see queries with especially long duration log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 5 #log-queries-not-using-indexes # # The following can be used as easy to replay backup logs or for replication. # note: if you are setting up a replication slave, see README.Debian about # other settings you may need to change. #server-id = 1 #log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! innodb_buffer_pool_size = 1024M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 64M innodb_flush_method=O_DIRECT # # * Security Features # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". # # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem # limite à partir de laquelle les tables temporaires sont créées sur le DD tmp_table_size=128M max_heap_table_size=128M 有任何想法吗 ？
感谢您的帮助。
我在MySQLtuner的帮助下做了许多MySQL优化，现在问题没有了。