also some of the queries are copying to a tmp table and i know this aint good! but I can't see the full query in show processlist how do you do this.
Cheers John ----- Original Message ----- From: "John Wards" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 4:03 PM Subject: MySQL eating processer > Hi, > > MySQL is using between 40-60% of the processer and I can't figure out why. > Has anyone got any handy hints how to start getting this down other than > telling my users to ef-off. I am getting about 100,000 page imps a day which > is a fair few but not that much. > > I am unsure where to start! > > Cheers > John Wards > SportNetwork.net > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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