hey...
i'm getting a weird problem... i'm running a mysql 3.23 server on a dual-processor
machine with 2 GB RAM. The number of tables are very few.. and so are the records.
I've configured max_connectins as 2000 and i'm using PHP 4.0.4pl1 to access the
database. I'm using persistent connections to the database. I'm running a load test
software on the server to check the scalability. And i get problems galore. It works
perfectly for upto 100 users, but at that figure, I get 2 common errors - Connection
to MySQL lost during query and Cannot connect to mysql server on <host>. In spite of
increasing max connections to 2000 and table_cache to 200. Any solutions? this is
very very urgent... Another problem while i'm at it..:) the mysql server dies in
between sometimes and takes /tmp/mysql.sock along with it. The problem is that when i
try to restart the server, i get the error message that the server may already be
running. A ps waux does not show mysqld. When i try to connect using mysql or
mysqladmin, i get an error. But when i do a netstat -a, i get a list of all
established connections with mysql!! and i see /tmp/mysql.sock listed as a listening
socket. How do i remove all these so that i can restart the server?
Sorry for the long mail, but I really am desperate now..
Tx.
Vinod
------------------------------
so little time, so many things to do...
_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
---------------------------------------------------------------------
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
