In you're my.cnf file (in /etc by default on a linux box) add under [mysqld] the option log for text logging.
for example [mysqld] log=mylogfile Whatever user mysqld is running as must have write perms to the log file. You can then anaylze this as it will contain connections and queries. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -----Original Message----- From: Sheni R. Meledath Sent: Wednesday, January 05, 2005 12:18 AM To: Tom Crimmins Cc: mysql@lists.mysql.com Subject: RE: MySQL Load on server Dear Tom, Thank you very much. Is there a way to log all the processes on the MySQL server to analyze later. At 09:48 AM 1/5/2005, Tom Crimmins wrote: >If I understand correctly, this is what you want: > >SHOW PROCESSLIST > >--- >Tom Crimmins >Interface Specialist >Pottawattamie County, Iowa > > >-----Original Message----- >From: Sheni R. Meledath >Sent: Tuesday, January 04, 2005 11:40 PM >To: MySQL Masters >Subject: MySQL Load on server > >Hello: > >We have multiple web sites hosted on a virtual web server. Many of the >web sites are using MySQL databases. Recently we are having problems >with the CPU load due to mysql processes. We are not able to track the >corrupted database or script (PHP). There are many databases on the server. > >CPU Load on server > >CPU states: % user, % nice, % system, % interrupt, % idle > >Mem: 654M Active, 82M Inact, 142M Wired, 37M Cache, 112M Buf, 90M > >Free > >Swap: 1024M Total, 226M Used, 798M Free, 22% Inuse > > > >PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND > >28181 cyber001 50 0 32088K 7180K RUN 282:01 71.29% 71.29% mysqld > >Is there any way to track the processes on the MySQL databases? Please >suggest a solution to fix this problem. Thank You. > > > >Regards >Sheni R Meledath >[EMAIL PROTECTED] Regards Sheni R Meledath [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
