Hello,


Our linux box is having a MYSQL heavy activity running and this has cause some user to get the error "Can't Open table"..some time.

How do I trace who is using the MYSQL queries or the user who forget to close his queries?


Any command to run on the shell?


Thanks..



Andy

Log onto MySQL as root and run:

show processlist;

If you have a lot of connections left open, you may want to put directives like this into /etc/my.cnf

set-variable = max_connections=500
set-variable = wait_timeout=10

Hi,

We are using HC version 1.4.1 to generate the stats for all the sites on our windows 2000 server.

When we go to the stats page ,the total number of Visit and Pages amount is the same.Is there any possibility of this to be happen as we try to check on our Cpanel > webalizer ,the amount is different.

It happens to all domains.



Thanks


Andy