Hi, To display the full query, just type SHOW FULL PROCESSLIST;
Regards, Jocelyn ----- Original Message ----- From: "John Wards" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 5:10 PM Subject: Re: MySQL eating processer > 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 > > > > --------------------------------------------------------------------- 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