Reply With QuoteIm thinking theres something else afoot here watson...what other processes do you have going on those servers?
Oh... I own a very high loading forum running on Linux.
To solve it, I have divided the forum into two servers:
Web server: Apache with web pages
Database server: MySQL with forum data
Yip, the loading is distributed but unfortunately, the loadings of the seperated servers are still very high.
Any ideas ...
Im thinking theres something else afoot here watson...what other processes do you have going on those servers?
No other process that may cause the problem...
In MySQL server, I always see
%CPU %MEM TIME CPU COMMAND
59.9 2.6 197:33 0 mysqld
In Apache web server, I always see huge number of apache(httpd) connections. And I am not under any attack.
Thanks for your reply.
wow
My entire box is running at less than 10% CPU util......what are the specs on your box?
The database server is located in datacenter with detail specs...
CPU: Pentium III 700Hz
RAM: 768MB RAM
SWAP: 512MB SWAP x 2
RedHat 9.0
Kernel version: 2.4.20-8smp
mysql-3.23.54a-11
%CPU is 99.9% at pitch time
I guess the load is normal for a low end server.
I find it interesting nobody asked how high load.. in some measureable way, not that I'm any expert on db. How are we supposed to know if your box's load is typical without knowing how much load is on it?
Only thing there is to base info off of is the cpu useage, which is "high".. can't really say that the cpu useage is high when considering the cpu useage (as a load meter).
What to do to speed it up, hrm. I believe mysql is faster than postgrest/etc.. not sure what RH9 defaults to. It is possible you've simply got more load than 2 boxes can handle adequately. I'm sure it's possible to distribute further. Like, storage for db on a raid server, with multiple db machines sharing the same hostname (which resolves to multiple IPs) using said raid server. Course, it might be simpler just to add more CPU to your current server, or go SMP.
i disagree, coltrane runs on a 333mhz and my httpd, mysql daemons are always running...
root 2497 0.0 0.0 18936 76 ? S May15 0:09 /usr/sbin/httpd
apache 5743 0.0 0.2 20392 808 ? S Jun01 0:00 [httpd]
apache 5744 0.0 0.2 19032 776 ? S Jun01 0:00 [httpd]
apache 5745 0.0 0.2 19064 908 ? S Jun01 0:00 [httpd]
apache 5746 0.0 0.2 19032 768 ? S Jun01 0:00 [httpd]
apache 5747 0.0 0.2 20416 804 ? S Jun01 0:00 [httpd]
apache 5748 0.0 0.2 19032 776 ? S Jun01 0:00 [httpd]
apache 5749 0.0 0.7 20328 2360 ? S Jun01 0:00 [httpd]
apache 5750 0.0 0.2 19032 864 ? S Jun01 0:00 [httpd]
root 2414 0.0 0.0 4192 12 ? S May15 0:00 /bin/sh /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
mysql 2444 0.0 0.0 13912 0 ? SW May15 0:00 [mysqld]
The only thing thats using a percentage of real CPU is X
Now if coltrane's box was hosting /., X would be so sluggish he wouldn't have been able to make that post.
Posting Permissions
Bookmarks