Howdy all, I am having trouble configuring my server parameters with my.cnf because there seems to be several mysql server instances (mysqld processes) running on my linux box. What I would like to do is bump up the innodb_buffer_pool_size on the server to 512M (the box has 3GB of RAM). The problem is that there seem to be several instances of mysql server running concurrently on the box. Each one of them allocates 512M for the buffer pool and the box grinds to a halt, completely out of RAM to do anything!
I've included a snippet of the top command display (I hope that you can read it easily). PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM CTIME CPU COMMAND 18913 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:01 3 mysqld 18914 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:00 1 mysqld 18915 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:01 1 mysqld 18916 mysql 15 0 30160 29M 2944 S 0.0 0.9 83:48 0 mysqld 18917 mysql 15 0 30160 29M 2944 S 0.0 0.9 6:25 1 mysqld 18918 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:00 3 mysqld 18919 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:32 0 mysqld 18920 mysql 15 0 30160 29M 2944 S 0.0 0.9 12:05 1 mysqld 18921 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:00 3 mysqld 31277 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:24 3 mysqld 31807 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:00 0 mysqld 31808 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:02 0 mysqld 32211 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:00 0 mysqld 32212 mysql 15 0 30160 29M 2944 S 0.0 0.9 0:00 2 mysqld In windows when I run mysql as a service there is only one mysql process running. The configuration settings have proven to work quite well there because there is never more than one mysql process. So, how do I have only one instance of the server running at any given time under linux? I'm starting mysql using the mysqld_safe script through the command: service mysql start I'm pretty new to linux so perhaps that is where my problem lies. Any ideas as to what I'm doing incorrectly? Thanks, Tripp __________________________________ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
