Hi List,
I've searched the archives and the web many times in the past for answers to the
following
questions but never really got a complete understanding of what is going on. Hopefully
someone on
the list will be able to take the time to set me straight.
I have a typical php + mysql + linux setup. Today I noticed a high load, and checked
things out
with:
mysql% show processlist;
it showed 6 processes running:
[ I'll skip all the ascii output since it usually ends up garbled]
6 rows in set (0.00 sec)
however if I do:
ps axuw | grep "mysql" | wc -l
I get:
28
What is going on here?
Do I have 28 mysqld's waiting around for requests and just 6 actually processes
running?
Is there any way to regulate this - something similiar to apache's max_clients, min
spare server,
max spare servers, etc?
We often have mysql just totally melt down a server - someone will run a bit query and
then all
the others start to back-up. We then end up with a ton of queries trying run at once,
the load
goes to 50 or even 100(!).
How can I stop this? Any tips at all on regulating the use of mysql - this is an ISP
server so it
is very hard to make sure that all usrs are running sensible and well-constructed
database
schema's.
I have tried to contact mysql for consulting but their beginning prices are too high
for our
modest budget. Does anyone else know of ways to get some help if no one on the list is
able to
advise?
Thanks!
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
