RH 6 - ~100 Mysql children using 100% CPU
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
RE: binding a domain name to a MySQL instance
The solution we took was to write a global configuration file and share connection data as need. This way it only needs to be changed in one place. Furthermore, if you connect as follows: dbi:mysql:host=db_01;database=database_name and then on your client machine, either via bind or the /etc/hosts file, point the db_01 host name to the IP of your database server. I've been doing this for some time, works very well. Hope this helps, -Bart -Original Message- From: ari davidow [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:23 PM To: [EMAIL PROTECTED] Subject: binding a domain name to a MySQL instance Is there any way to bind something other than the hostname to a MySQL instance? I'm going to be moving a database from one server to another, and would like the scripts that reference that data to simply talk to db.mydomain.com, rather than have to reconfigure things during launch. Is this possible? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [EMAIL PROTECTED] - 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
MySQL 3.23.46 - Redhat 6.2 - cannot connect to server
We're having severe problems here. We've been running 2.23.3 on Redhat 6.2 for a while and all has been well. I've also installed mysql several times with no issues. We had a hard drive go out today, and since then we have not been able to get mysql to successfully start and accept connections. Typing an simple mysqladmin version gives no error message whatsoever. When trying to reinstall and use the latest version, running 'make test' hangs at Installing Master Databases. Though the server does start up, we can't interact with it in any way. If anyone can be of use, please advise. Thanks, -Bart - 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