hi everyone, I've got a mysql server, a quad xeon 700MHz, with 8 gigs of ram, and a raid 50 disk array running as two 50 GB partitions, shared over 8 15,000 RPM disks, on a hardware raid card, with 128Mb Cache.
Running RedHat Linux 7.2, with Ext3 FS, and Kernel 2.4.9-21 Enterprise (SMP) I'm trying to tweak out the performance to the maximum usage of this hardware, and I found the following on the docs: This can be done by adding renice -20 $$ command to safe_mysqld. In our testing on a 4-CPU machine, increasing the priority gave 60% increase in throughput with 400 clients. So I added the renice -20 $$ line to safe_mysqld, and I get the following: (tailing the .err log while running safe_mysqld. [root@ac mysql]# ./bin/safe_mysqld 18249: old priority 0, new priority -20 Starting mysqld daemon with databases from /usr/local/mysql/data 020223 09:16:25 mysqld ended [root@ac mysql]# 020223 09:16:25 mysqld started nice: unrecognized option `---15' Try `nice --help' for more information. 020223 09:16:25 mysqld ended [root@ac mysql]# pico bin/safe_mysqld Here I removed the renice line and: [root@ac mysql]# ./bin/safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data 020223 09:16:48 mysqld started /usr/local/mysql/bin/mysqld: ready for connections Any Ideas? Also, I am experiencing another strange problem, I have created: ./data/my.cnf and placed the following into it: [safe_mysqld] open-files-limit=8192 max_connections=1024 but when I run: [root@ac mysql]# ./bin/mysqladmin -p variables Enter password: | max_connections | 100 I am using: | | version | 3.23.46 of Mysql Any assistance would be greatly appreciated. I am not sure if I placed my.cnf in the wrong directory. Reading safe_mysqld seems to point that I placed it in the right place. -- Lloyd Duhon Founder Open Space Initiative http://openspaceinitiative.org/ The Exploration of the Universe is our responsibility! --------------------------------------------------------------------- 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