PHP graphs cause high load on server

[nrathke]

Hi,

I have a server running only 51.58 values/sec but viewing graphs on a page causes high load on the server.

With no browsers connected to the system the 1min load is .02 with 1 browser even viewing 5 graphs per page the 1min load goes to +2.30 trying to view a page with 18+ graphs for a cluster makes the zabbix system time out on http/s requests.

The system configuration is
Zabbix 2.0.4 Mysql on Centos 6.3
4 core Intel(R) Xeon(R) CPU E5507 @ 2.27GHz
8GB RAM
hardware raid 5 with 4 OCZ Vertex 4 SSD drives

any help would be greatly appreciated

-nick

[mcmyst]

InnoDB or MyISAM ?
If innoDB, how much innodb_buffer_pool_size ?
Is your mount point where mysql data directory mounted with noatime and nodiratime ?
Do you have any I/O wait on your CPU utilization ?

[nrathke]

thanks for the fast reply

using Innodb
innodb_buffer_pool_size 2097152
data directory is mounted sync with noatime and nodiratime
io wait goes for 0.2% with no browser connected to +5% with 3 browsers connected on 2 different systems.


-Nick

[nrathke]

here is what innotop has to say if that helps (I am not really a DB guy...)

uptime max_query_time time_behind_master connections locked_count qps spark_qps run spark_run open slave_running longest_sql
9m 9s 39 0 192.14632454117 17 65 Off DELETE history_uint
9m 10s 39 0 299.228802772783 _ 15 _ 64 Off DELETE history_uint
9m 11s 39 0 197.508621324073 ^_ 16 __ 64 Off DELETE history_uint
9m 12s 39 0 194.153408108647 ^__ 14 ^^_ 65 Off DELETE history_uint
9m 13s 39 0 216.386812392071 ^___ 15 ^^_- 64 Off DELETE history_uint

[mcmyst]

Download this script:

https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl

And run it on your server only after having more than 24h of uptime on your database server. This should tell you what you could tune on your DB server.

I think there is something wrong with your setup, 50nvps is very low... Are you running the database and the server on the same hardware ? Do you use proxy ?

[nrathke]

Thanks for the script. I'll run it tomorrow, with me try to tune things up its only be up for 12h now.

Everything is on the same server no proxy. I can add another CPU to the server and more memory if I need to. I can also move the system to a bigger physical server and upgrade the RAID card if need be.

-Nick