On Sun, Feb 18, 2001 at 12:10:49PM +0800, Teddy A Jasin wrote:
> Hi,
> The problem is when I execute show processlist; the mysql
> replied syntax error. So i cant use the processlist.
> here's wat the mysql respond:
> SHOW PROCESSLIST;parse error near 'PROCESSLIST' at line 1
show processlist works fine in any MySQL I use (3.22.27 and up)
with the standard MySQL client. What version of MySQL are you
using and what client do you use to enter the query?
Fred.
> teddy----- Original Message -----
> From: "Fred van Engen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, February 18, 2001 2:09 AM
> Subject: Re: mysql extremely slow
>
>
> > On Sun, Feb 18, 2001 at 01:18:04AM +0800, Teddy A Jasin wrote:
> > > Hi All,
> > > Below is the status that I got from my server's mysql server, can anyone
> > > explain to me more on this?? and as u see here... currently mysql server
> > > is running extremely slow:
> > >
> >
> > Try posting a 'show processlist' so you can figure out what query
> > it is working on. Maybe you have some long running query that blocks
> > everything else?
> >
> > show variables and show status alone don't tell much.
> >
> > Regards,
> >
> > Fred.
> >
> > --
> > Fred van Engen XO Communications B.V.
> > email: [EMAIL PROTECTED] Televisieweg 2
> > tel: +31 36 5462400 1322 AC Almere
> > fax: +31 36 5462424 The Netherlands
> >
> > ---------------------------------------------------------------------
> > 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
>
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
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
