Server load and MYSQL
Aaron
aaron at aarons.net
Mon Oct 21 16:49:44 CDT 2002
Hi all. I'm looking for a second opinion. (or a third, fourth, fifth....)
Here's the situation: I'm running a server with the following specs: Dual P3 1.3Ghz, 1GB ECC
Registered RAM, Dual 18GB SCSI Ultra 160 10K RPM drives, Adaptec 29160 (the 64bit version)... <--
Important specs. :)
This server is running RedHat 7.3 (with an upgraded kernel. 2.4.18-17smp) and all the normal stuff.
(apache, bind, mysql, php, etc etc etc) The web site it serves gets 20,000 unique visitors a day
and the databases are roughly 6GB.
For the last two months I've had no end to the problems. First, the machine would crash randomly,
once a day. I figured out that it was a Kernel bug, hence the reason for the upgrade.
Second, every once in a while (once every 3 or 4 days) Apache would crash and I'l look at the load
to find it at 300 - 400. It wouldn't let me soft reboot it so I'd have to shut it down.
I moved the databases and the domlogs to the second drive and that seems to have relieved some of
the load and stopped the /var and /usr partitions from hitting 100% full every day, but it's still
not uncommon for me to see loads in the 8-9 range. I'd like to get the machine a little more
stable.
So my questions....
1. Does anyone have an opinion on switching the journaling system to writeback? It looks like
that's better for database writes but not so good for data integrity.
2. I saw something about MySQL taking 28MB of memory for each process it spawns and that that
could be reduced and would lighten the load, but I can't get any details. Also, in my my.cnf file
it says it's set to 1MB. Is there something I'm overlooking?
Any help, suggestions, opinions, etc would be greatly appreciated.
Aaron
More information about the Kclug
mailing list