I am having heavy CPU utilization on the zabbix server, mostly consumed by the MySQL process. I checked the MySQL database performance using phpMyAdmin and this is a summary of the data in red:
Slow queries: 1K
Handler_read_rnd 296 M (The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler_read_rnd_next 1 G (The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have)
Created_tmp_disk_tables 31 M (The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based)
Is this normal? Am running Zabbix 1.1.1 with housekeeper patch on a Solaris 10 server with 1 GB RAM and 1x1 GHz CPU
Slow queries: 1K
Handler_read_rnd 296 M (The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler_read_rnd_next 1 G (The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have)
Created_tmp_disk_tables 31 M (The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based)
Is this normal? Am running Zabbix 1.1.1 with housekeeper patch on a Solaris 10 server with 1 GB RAM and 1x1 GHz CPU
Comment