John Wards wrote: > 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 >> >>
Hi, You may try to start mysqld with --log-slow-queries option. Regards -- Joseph Bueno NetClub/Trader.com --------------------------------------------------------------------- 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