Hello again all. Thanks for the help on the query time issue, I have begun a transition.
I have another question. I have some queries which are apparently going into a "Sleep" mode in my database. Can anyone point me in the right direction on this for more information? Thanks, Darren +----+-----------------+------------+--------+---------+-------+-------+ ------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+------------+--------+---------+-------+-------+ ------------------+ | 15 | web | localhost | mailer | Sleep | 47743 | NULL | NULL | | 20 | adssurvey | 66.6.196.2 | mailer | Sleep | 370 | NULL | NULL | | 22 | root | localhost | mailer | Query | 0 | NULL | show processlist | +----+-----------------+------------+--------+---------+-------+-------+ ------------------+ 3 rows in set (0.00 sec) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
