14ġ5 Test 2: CPU utilization MySQL PostgreSQL User System iowait Almost same load (PG is slightly stable and low io) Copyright 2013 SRA OSS, Inc. 13ġ4 Test 2: Tuning Same Buffer and Transaction log size MySQL o Innodb_buffer_pool_size = 512MB o Innodb_log_file_size = 256MB x innodb_log_files_in_group=2(default) = log size 512MB PostgreSQL o shared_buffers = 512MB o checkpoint_segments = 32 16MB/each segmnet log size 512MB Copyright 2013 SRA OSS, Inc. 12ġ3 Test 1: Zabbix Performance MySQL PostgreSQL zabbix :Values processed by Zabbix server per second zabbix:zabbix queue PG cannot keep up with processing Copyright 2013 SRA OSS, Inc. 11ġ2 Test 1: CPU utilization MySQL PostgreSQL User System iowait PG: Heavy io wait Copyright 2013 SRA OSS, Inc. 10ġ1 Test 1: default DB Config MySQL o character-set-server=utf8 o skip-character-set-client-handshake o innodb_file_per_table PostgreSQL o ALL default PostgreSQL uses files per table Copyright 2013 SRA OSS, Inc. 9ġ0 Test 1 o Default DB setting Test 2 Simple Test o Same buffer size and Transaction log size Each Test is o Monitoring 4 hours o comparing CPU utilization and Zabbix performance Copyright 2013 SRA OSS, Inc. 8ĩ Test Target Simulate 600 hosts ( 2 agent servers ) items ( 44 items/1 host,5 sec interval, keep history 1day) triggers ( 17 triggers / 1 host ) Starting with empty history Monitoring for: 4 hours (short run) 36 hours (long run) Zabbix: modified CacheSize=64M in zabbix_nf Copyright 2013 SRA OSS, Inc. 7Ĩ Software Zabbix ( alpha release) Use latest release version for the components o MySQL o PostgreSQL o Apache httpd o PHP Copyright 2013 SRA OSS, Inc. 6ħ MySQL vs PostgreSQL Zabbix benchmark with MySQL and PostgreSQL Environment o Amazon EC2 M1 medium instance o 3.75 Gib RAM o 2ECU (1 core) o 410 GB instance storage o OS: Amazon Linux AMI (64bit) o 3 servers ( 1 for Zabbix server and DB,2 for Zabbix Agent) Copyright 2013 SRA OSS, Inc.
5Ħ PostgreSQL is Slow? The Performance of PG was improved from 9.2! Compared with PG9.1 o Read Query 4x Faster o Write Query 5x Faster Reference: PostgreSQL 9.2 release news Robert Performance Improvement in PostgreSQL Copyright 2013 SRA OSS, Inc. 5 Which database engine are you using for Zabbix? Copyright 2013 SRA OSS, Inc.
0 kommentar(er)
