If you can turn on the query log the amount of disk space it takes would be well worth troubleshooting the problem. Try and discern the last queries run on them, in order to help. Perhaps do this twice and you could check for consitency. How much disk space is in use on the drives related to it? Remember that disk space can vary immensley in seconds on some larger servers. Sometimes it may not even claim the space as taken, though it really is, if you catch my drift. Does the mysqld die or lockup? Does the entire server lockup?
What day and time do you get it? Are there any cron jobs running that are doing anything? Perhaps someone has a script to pull something off your site once a week, and this is causing it? (Refer to troubleshooting explained above with query log) -----Original Message----- From: Sam Iam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 12:06 PM To: MySQL List Subject: RH 7.2 connections problems w 16 web servers to 2 MySQL servers We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers & is supposed to act as a failover machine for the other group of 8 web servers. The failover won't work now as if one MySQL goes down the cost of the 8 web servers switching over is so high the other MySQL locks up. Each Apache / PHP server takes up hundreds of connections even when they're idle so we ran into the Linux connection limit of 1000 & had to recompile to get past that. Our actual MySQL CPU useage is low but the goes when with the connection overhead when starting up or failing over a bank of machines. We get a mysterious MySQL lockup once a week at the same day & time. Questions : - Is our configuration of 2 sets of 8 Apache/PHP web servers & 1 MySQL servers just not a good idea ? - Would we better off with FreeBSD ? - Is there anyone doing any similar setups with lots of web servers & a few MySQLs ? - Is there any way to get Apache / PHP to use fewer connections ? We pay for MySQL support but haven't had much help from them. - Sam. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
