27 Oct
2011
27 Oct
'11
9:52 a.m.
Hi Tim,
1. User the InnoDB Engine in MySQL. I read about it and don't know if it's the best way. Why InnoDB engine? MySAM engine is more fast.
2. Increase the number of SQL sockets in sql.conf (num_sql_socks). The default is 5, try 25. Ok.
3. Increase the number of connections (max_connections) in my.cnf to match the number of SQL sockets in sql.conf. Ok.
4. Enable the MySQL slow query log (slow_query_log) in my.cnf. 5. Check the MySQL slow query log file for problems. I've enable the slow query and set up to 2 sec. The log don't show any slow query .. It's much time? I've tested whith mtop[1] too, no slow queries.
Thanks! Sds, --- Daniel Menezes Links: [1] http://mtop.sourceforge.net/