2 ms·
run "show full processlist" to see what's going on. use explain on the slow queries. create indexes or restructure as necessary. post your config, the queries,
by joshu 18y ago
run "show full processlist" to see what's going on. use explain on the slow queries. create indexes or restructure as necessary.
post your config, the queries, the schema, if you want help.
- gtani 18y agomysqltuner is another decent 30000 foot view tool: http://mysqltuner.com/mysqltuner.pl http://mysqltuner.com/mysqltuner.pl I might try stackoverflow, describe your queries, schema, indexes, and the whole stack: O/S, db server hardware, ORM, what web app is getting it (PHP, ASP, django, whatever)