too high cpu is used by the mysql database

[Sancho]

Like it

Up

0

Down

Drop it

::

Hi
I am using a 1.3.1 version of pandora as a result of a previous question related to lossing polling you have answered.
I have a problem with the amount of cpu used by the mysql in order to satify the demand of the pandora system. I found post in wich you told that we must to purge the database, but i do not think the problem is in that point.
As a consequence of that problem with the cpu i have developed two servers, one for servers and remote workstation, with 130 agents and 1500 data checks working only with the funcionality of the agent. In that case i have a dabase witch 11 million records and all works fine. The other server is for network monitoring with 30 agents 200 checks and a database of 2 million records, working with snmp and icmp checks (i think that part is for the network_server) and in these case (the server is better than the other used by servers and workstations) the system works very slowly with a hight utilization of the cpu.
As you see i am a little puzzle with these behaviour and the diference is that: the system works fine when we are using the agent, but when we use the snmp and icmp polling the system works very slowly.
I would appreciate any help in these isue.
thanks and regards

Probably you need to optimize and use a customed value of network threads, retries, timeouts. Are you running the dabatabase maintance script on your database ?.

[Sancho]

Like it

Up

0

Down

Drop it

::

Hi
I am using a 1.3.1 version of pandora as a result of a previous question related to lossing polling you have answered.
I have a problem with the amount of cpu used by the mysql in order to satify the demand of the pandora system. I found post in wich you told that we must to purge the database, but i do not think the problem is in that point.
thanks and regards

Almost forget… be sure to optimize Mysql, default mysql configuration on almost all linux servers is good for testing, but not for a production usage.

[Raul77]

Like it

Up

0

Down

Drop it

::

Hi
I do not known where to found the dabatabase maintance script, is the web db maintenance, or is another script you have to maintain the database? . Related the post you send about to increase the performance of the database, i would apreciate any suggestion, but in these case why the other server with much more sensors and agent works fine meanwhile the other works slowly? basicaly the both the servers are the same installation, opensuse 10.2 with the default mysql installation. I would also appreciate any information related to what params of the pandora_server.conf i should tune to increase the performance of the mysql
Thanks very much for your welcome help.

[Raul77]

Like it

Up

0

Down

Drop it

::

I am trying to tune the mysql database. I have a server with 2 GB RAM, and disk ultra320 15000 rpm scsi. As i have no other critical applications in the server so i try to give to mysql the highest amount of memory that i can. I have made that performance having in mind the sqlserver database (with i have more experience in that, and as a rule of thumb to increase the performance in sqlserver, you must increase the amount of memory available to it) The tunning i have made is this:

SET GLOBAL key_buffer_size=512000000;
SET GLOBAL query_cache_size=512000000;
SET GLOBAL query_cache_limit=4000000;
SET GLOBAL tmp_table_size=128000000;
SET GLOBAL table_cache=512;
SET GLOBAL sort_buffer_size=32000000;
SET GLOBAL myisam_sort_buffer_size=32000000;

These helps, but the % of CPU is too hight yet. (70 – 80%).
I wold appreciate any help in order to increase the performance of the pandora server.
Thanks & Regards

[Sancho]

Like it

Up

0

Down

Drop it

::

I am trying to tune the mysql database. I have a server with 2 GB RAM, and disk ultra320 15000 rpm scsi. As i have no other critical applications in the server so i try to give to mysql the highest amount of memory that i can. I have made that performance having in mind the sqlserver database (with i have more experience in that, and as a rule of thumb to increase the performance in sqlserver, you must increase the amount of memory available to it) The tunning i have made is
Thanks & Regards

How many spare data items do you have ?

SELECT COUNT(*) FROM tdata;

How many modules do you have ?

SELECT COUNT(*) FROM tagente_modulo

I suppose you have binary log disabled and all kind of replication, isn’t ?

[Raul77]

Like it

Up

0

Down

Drop it

::

Hi
i have found the point, it was the configuration of the innodb, by default in suse (i do not know if the rest of distros is the same) it come with a really bad tunning. The poit was the amount of pages it have, to operate with the data.
The clue was the amount of Innodb_buffer_pool_reads. It was to high and i found that i have a ridiculous number of buffer memory pages, so i increase the amount to 512 MB and now it works really well.
So the tuning i have made is:
increase the amount of memory at the:
– general buffer of mysql
– buffer of inodb

Thanks very much for the help.