|
You can check on your mysql server by connecting through the
shell with the mysql client.
show processlist;
shows you processes you're mysql server is handling......here
you can see how many idle requests are lingering around and
for how long.....you'll see they stick around VERY long meaning
at that point they're not able to take new queries. This is the
most common reason while mysql runs out of processes and
crashes.......increasing the amount of concurent threads helps
but actually you're not solving the problem.....you just give the
problem more space before it becomes critical and you're wasting
valuable system resources..
status;
shows you the status of the mysql server and gives you some
stats info on what's going on...
DynaMite
|