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

Reply via email to