I need my mysql db sloq quires fixed and optimized..
this is a sample from my server company:
the entire log in /var/log/mysqld.slow_queries.log. here is an excerpt of the log file:
# Time: 120309 14:46:33
# UseratHost: yyy[yyy] at [xx.xx.xxx.xxx]
# Query_time: 22 Lock_time: 0 Rows_sent: 1 Rows_examined: 137440
SELECT COUNT(*) AS total FROM d_wholeinf WHERE suspend_admin!=’y’ AND wh_id IN (SELECT who FROM d_favorites WHERE pid=5940 AND authorize=0);
# Time: 120309 14:46:34
# UseratHo…
