Greetings, I'm running the latest stable release of MySql on RH 6 on a dual 1GH+ machine w/ 1GB of ram and I've set max_connections to 300. Once the server reaches about 110 connections tho, even tho I have plenty of memory left they're using 100% of my CPU. The majority are sleeping because I'm maintaining a persistent connection for each apache child proc, which I'd like to continue doing. I've heard that mysql doesn't have trouble handling 500 - 1000+ connections. Am I missing something? I've also modified safe_mysqld and added the following:
-O key_buffer=512k -O sort_buffer=100k -O record_buffer=100k But memory isn't the problem, CPU is. Any help is appreciated! /bart -----Original Message----- From: Mike Blain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 8:07 PM To: [EMAIL PROTECTED] Subject: mysql.sock?? I just recently installed MySQL from source. Trying to set the root password and keep getting this error: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! How do I create mysql.sock? Thanks, Mike --------------------------------------------------------------------- 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