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
