Mysql WorkLoad Report

Host Name Ip addr Port Db role Version Uptime

a1-dba-tech01.hz 10.128.6.21 3309 master 5.6.17 0y 5m 24d 2h 59mi 6s

Host Name	Ip addr	Port	Db role	Version	Uptime
a1-dba-tech01.hz	10.128.6.21	3309	master	5.6.17	0y 5m 24d 2h 59mi 6s

Platform cores cpus sockets memory

Linux x86_64 12 24 2 126 GB

Platform	cores	cpus	sockets	memory
Linux x86_64	12	24	2	126 GB

Snap Id Snap Time Threads_connected Threads_running

Begin Snap: 144976 2014-12-01 16:58:01 128.00 2.00
End Snap: 145025 2014-12-01 17:47:01 126.00 2.00
Elapsed: 2940 (seconds)

	Snap Id	Snap Time	Threads_connected	Threads_running
Begin Snap:	144976	2014-12-01 16:58:01	128.00	2.00
End Snap:	145025	2014-12-01 17:47:01	126.00	2.00
Elapsed:	2940 (seconds)

Start snap value and end snap value

Begin End Diff

query_cache_size : 1048576.00 1048576.00 0

thread_cache_size : 48.00 48.00 0

table_definition_cache : 784.00 784.00 0

max_connections : 6000.00 6000.00 0

table_open_cache : 768.00 768.00 0

slow_launch_time : 2.00 2.00 0

max_heap_table_size : 16777216.00 16777216.00 0

tmp_table_size : 1073741824.00 1073741824.00 0

open_files_limit : 60000.00 60000.00 0

Max_used_connections : 136.00 136.00 0

Threads_connected : 128.00 126.00 -2

Threads_cached : 8.00 10.00 2

Threads_created : 639.00 639.00 0

Threads_running : 2.00 2.00 0

Connections : 18847102.00 18852784.00 5682

key_buffer_size : 67108864.00 67108864.00 0

join_buffer_size : 16777216.00 16777216.00 0

sort_buffer_size : 8388608.00 8388608.00 0

Key_blocks_not_flushed : 0.00 0.00 0

Key_blocks_unused : 53579.00 53579.00 0

Key_blocks_used : 238.00 238.00 0

Key_read_requests : 14376733696.00 14381009920.00 4276224

Key_reads : 6.00 6.00 0

Key_write_requests : 3034217216.00 3035064064.00 846848

Key_writes : 88.00 88.00 0

Questions : 1190073728.00 1190239616.00 165888

Com_select : 650632704.00 650719104.00 86400

Com_insert : 51116112.00 51131372.00 15260

Com_update : 127006448.00 127020200.00 13752

Com_delete : 73742.00 73742.00 0

Bytes_received : 222904401920.00 222952701952.00 48300032

Bytes_sent : 2505043607552.00 2505558720512.00 515112960

Qcache_hits : 0.00 0.00 0

Qcache_inserts : 0.00 0.00 0

Select_full_join : 532704.00 532752.00 48

Select_scan : 38490416.00 38501172.00 10756

Slow_queries : 8595.00 8605.00 10

Com_commit : 149965632.00 149982384.00 16752

Com_rollback : 5553.00 5553.00 0

Open_files : 64.00 64.00 0

Open_table_definitions : 276.00 276.00 0

Open_tables : 378.00 378.00 0

Opened_files : 28097216.00 28101976.00 4760

Opened_table_definitions : 24739.00 24769.00 30

Opened_tables : 25293.00 25323.00 30

Created_tmp_disk_tables : 7009534.00 7010709.00 1175

Created_tmp_files : 9237.00 9247.00 10

Created_tmp_tables : 44243688.00 44252008.00 8320

Binlog_cache_disk_use : 127578.00 127619.00 41

Binlog_cache_use : 131804976.00 131820936.00 15960

Aborted_clients : 1243.00 1243.00 0

Sort_merge_passes : 222.00 222.00 0

Sort_range : 4962711.00 4962960.00 249

Sort_rows : 7117402112.00 7117975040.00 572928

Sort_scan : 16841872.00 16843612.00 1740

Table_locks_immediate : 12576600064.00 12576757760.00 157696

Table_locks_waited : 0.00 0.00 0

Handler_read_first : 35378416.00 35392796.00 14380

Handler_read_key : 214531194880.00 214752182272.00 220987392

Handler_read_last : 6693245.00 6701455.00 8210

Handler_read_next : 52197666816.00 52208214016.00 10547200

Handler_read_prev : 40321112.00 40321112.00 0

Handler_read_rnd : 3451403776.00 3451990528.00 586752

Innodb_rows_updated : 230899760.00 230922128.00 22368

Innodb_rows_deleted : 317521.00 317521.00 0

Innodb_rows_read : 107164172288.00 107206090752.00 41918464

Innodb_buffer_pool_read_requests: 640344784896.00 640879755264.00 534970368

Innodb_buffer_pool_reads : 4456343.00 4456343.00 0

Innodb_buffer_pool_pages_data : 4085181.00 4085094.00 -87

Innodb_buffer_pool_pages_free : 8195.00 8194.00 -1

Innodb_buffer_pool_pages_dirty : 12.00 11.00 -1

Innodb_buffer_pool_pages_flushed: 2320867584.00 2321790976.00 923392

Innodb_data_reads : 5104538.00 5104538.00 0

Innodb_data_writes : 2574532608.00 2575519488.00 986880

Innodb_data_read : 83551141888.00 83551141888.00 0

Innodb_data_written : 76643875946496.00 76674267873280.00 30391926784

Innodb_os_log_fsyncs : 151359296.00 151380368.00 21072

Innodb_os_log_written : 593131339776.00 593270079488.00 138739712

history_list : 2394.00 2050.00 -344

log_bytes_written : 532056571904.00 532184760320.00 128188416

log_bytes_flushed : 532056571904.00 532184760320.00 128188416

last_checkpoint : 532056571904.00 532184727552.00 128155648

queries_inside : 0.00 0.00 0

queries_queued : 0.00 0.00 0

read_views : 0.00 0.00 0

innodb_open_files : 4096.00 4096.00 0

innodb_log_waits : 0.00 0.00 0

	Begin	End	Diff
query_cache_size :	1048576.00	1048576.00	0
thread_cache_size :	48.00	48.00	0
table_definition_cache :	784.00	784.00	0
max_connections :	6000.00	6000.00	0
table_open_cache :	768.00	768.00	0
slow_launch_time :	2.00	2.00	0
max_heap_table_size :	16777216.00	16777216.00	0
tmp_table_size :	1073741824.00	1073741824.00	0
open_files_limit :	60000.00	60000.00	0
Max_used_connections :	136.00	136.00	0
Threads_connected :	128.00	126.00	-2
Threads_cached :	8.00	10.00	2
Threads_created :	639.00	639.00	0
Threads_running :	2.00	2.00	0
Connections :	18847102.00	18852784.00	5682
key_buffer_size :	67108864.00	67108864.00	0
join_buffer_size :	16777216.00	16777216.00	0
sort_buffer_size :	8388608.00	8388608.00	0
Key_blocks_not_flushed :	0.00	0.00	0
Key_blocks_unused :	53579.00	53579.00	0
Key_blocks_used :	238.00	238.00	0
Key_read_requests :	14376733696.00	14381009920.00	4276224
Key_reads :	6.00	6.00	0
Key_write_requests :	3034217216.00	3035064064.00	846848
Key_writes :	88.00	88.00	0
Questions :	1190073728.00	1190239616.00	165888
Com_select :	650632704.00	650719104.00	86400
Com_insert :	51116112.00	51131372.00	15260
Com_update :	127006448.00	127020200.00	13752
Com_delete :	73742.00	73742.00	0
Bytes_received :	222904401920.00	222952701952.00	48300032
Bytes_sent :	2505043607552.00	2505558720512.00	515112960
Qcache_hits :	0.00	0.00	0
Qcache_inserts :	0.00	0.00	0
Select_full_join :	532704.00	532752.00	48
Select_scan :	38490416.00	38501172.00	10756
Slow_queries :	8595.00	8605.00	10
Com_commit :	149965632.00	149982384.00	16752
Com_rollback :	5553.00	5553.00	0
Open_files :	64.00	64.00	0
Open_table_definitions :	276.00	276.00	0
Open_tables :	378.00	378.00	0
Opened_files :	28097216.00	28101976.00	4760
Opened_table_definitions :	24739.00	24769.00	30
Opened_tables :	25293.00	25323.00	30
Created_tmp_disk_tables :	7009534.00	7010709.00	1175
Created_tmp_files :	9237.00	9247.00	10
Created_tmp_tables :	44243688.00	44252008.00	8320
Binlog_cache_disk_use :	127578.00	127619.00	41
Binlog_cache_use :	131804976.00	131820936.00	15960
Aborted_clients :	1243.00	1243.00	0
Sort_merge_passes :	222.00	222.00	0
Sort_range :	4962711.00	4962960.00	249
Sort_rows :	7117402112.00	7117975040.00	572928
Sort_scan :	16841872.00	16843612.00	1740
Table_locks_immediate :	12576600064.00	12576757760.00	157696
Table_locks_waited :	0.00	0.00	0
Handler_read_first :	35378416.00	35392796.00	14380
Handler_read_key :	214531194880.00	214752182272.00	220987392
Handler_read_last :	6693245.00	6701455.00	8210
Handler_read_next :	52197666816.00	52208214016.00	10547200
Handler_read_prev :	40321112.00	40321112.00	0
Handler_read_rnd :	3451403776.00	3451990528.00	586752
Innodb_rows_updated :	230899760.00	230922128.00	22368
Innodb_rows_deleted :	317521.00	317521.00	0
Innodb_rows_read :	107164172288.00	107206090752.00	41918464
Innodb_buffer_pool_read_requests:	640344784896.00	640879755264.00	534970368
Innodb_buffer_pool_reads :	4456343.00	4456343.00	0
Innodb_buffer_pool_pages_data :	4085181.00	4085094.00	-87
Innodb_buffer_pool_pages_free :	8195.00	8194.00	-1
Innodb_buffer_pool_pages_dirty :	12.00	11.00	-1
Innodb_buffer_pool_pages_flushed:	2320867584.00	2321790976.00	923392
Innodb_data_reads :	5104538.00	5104538.00	0
Innodb_data_writes :	2574532608.00	2575519488.00	986880
Innodb_data_read :	83551141888.00	83551141888.00	0
Innodb_data_written :	76643875946496.00	76674267873280.00	30391926784
Innodb_os_log_fsyncs :	151359296.00	151380368.00	21072
Innodb_os_log_written :	593131339776.00	593270079488.00	138739712
history_list :	2394.00	2050.00	-344
log_bytes_written :	532056571904.00	532184760320.00	128188416
log_bytes_flushed :	532056571904.00	532184760320.00	128188416
last_checkpoint :	532056571904.00	532184727552.00	128155648
queries_inside :	0.00	0.00	0
queries_queued :	0.00	0.00	0
read_views :	0.00	0.00	0
innodb_open_files :	4096.00	4096.00	0
innodb_log_waits :	0.00	0.00	0

Some Key Load Info

Per Second

TPS: 9

Com_select(s): 29

Com_insert(s): 5

Com_update(s): 4

Com_delete(s): 0

Innodb t_row PS: 313

Innodb_rows_inserted(s): 306

Innodb_rows_updated(s): 7

Innodb_rows_deleted(s): 0

Innodb_rows_read(s): 14257

Innodb_data_reads(s): 0

Innodb_data_writes(s): 335

Innodb_data_read(kb/s): 0

Innodb_data_written(kb/s): 10095

Innodb_os_log_fsyncs(s): 7

Innodb_os_log_written(kb/s): 46

	Per Second
TPS:	9
Com_select(s):	29
Com_insert(s):	5
Com_update(s):	4
Com_delete(s):	0
Innodb t_row PS:	313
Innodb_rows_inserted(s):	306
Innodb_rows_updated(s):	7
Innodb_rows_deleted(s):	0
Innodb_rows_read(s):	14257
Innodb_data_reads(s):	0
Innodb_data_writes(s):	335
Innodb_data_read(kb/s):	0
Innodb_data_written(kb/s):	10095
Innodb_os_log_fsyncs(s):	7
Innodb_os_log_written(kb/s):	46

Some Key Hits

Percentage

key_buffer_read_hits %: 100

key_buffer_write_hits %: 100

Innodb_buffer_read_hits %: 100

Query_cache_hits %: 0

Thread_cache_hits %: 100

	Percentage
key_buffer_read_hits %:	100
key_buffer_write_hits %:	100
Innodb_buffer_read_hits %:	100
Query_cache_hits %:	0
Thread_cache_hits %:	100

Top 10 Timed Events

event_name wait time(picsecond) wait count
wait/io/table/sql/handler 353949694556535 18654836

wait/io/file/innodb/innodb_data_file 48921080697335 1050462

wait/io/file/innodb/innodb_log_file 8976181435760 42128

wait/io/file/myisam/dfile 6037627875510 3250229

wait/io/file/sql/binlog 5049307555985 85114

wait/io/file/myisam/kfile 389958809625 38783

wait/lock/table/sql/handler 224775804715 297586

wait/io/file/sql/dbopt 2852096940 367

wait/io/file/sql/FRM 1808381575 450

wait/io/file/sql/slow_log 268795835 16

event_name	wait time(picsecond)	wait count
wait/io/table/sql/handler	353949694556535	18654836
wait/io/file/innodb/innodb_data_file	48921080697335	1050462
wait/io/file/innodb/innodb_log_file	8976181435760	42128
wait/io/file/myisam/dfile	6037627875510	3250229
wait/io/file/sql/binlog	5049307555985	85114
wait/io/file/myisam/kfile	389958809625	38783
wait/lock/table/sql/handler	224775804715	297586
wait/io/file/sql/dbopt	2852096940	367
wait/io/file/sql/FRM	1808381575	450
wait/io/file/sql/slow_log	268795835	16

event_name	read bytes	read count
wait/io/file/myisam/dfile	289170779	1664825
wait/io/file/sql/binlog	31598182	50015
wait/io/file/myisam/kfile	659799	2350
wait/io/file/sql/FRM	67910	230
wait/io/file/sql/global_ddl_log	0	0
wait/io/file/innodb/innodb_log_file	0	0
wait/io/file/sql/des_key_file	0	0
wait/io/file/myisammrg/MRG	0	0
wait/io/file/sql/binlog_index	0	0
wait/io/file/mysys/proc_meminfo	0	0

Top 10 write file Events

event_name read bytes read count
wait/io/file/innodb/innodb_data_file 30198071296 956375

wait/io/file/myisam/dfile 167769276 744321

wait/io/file/innodb/innodb_log_file 138348544 21070

wait/io/file/sql/binlog 31598182 19161

wait/io/file/myisam/kfile 743721 28208

wait/io/file/sql/slow_log 6248 11

wait/io/file/sql/global_ddl_log 0 0

wait/io/file/sql/des_key_file 0 0

wait/io/file/myisammrg/MRG 0 0

wait/io/file/sql/binlog_index 0 0

event_name	read bytes	read count
wait/io/file/innodb/innodb_data_file	30198071296	956375
wait/io/file/myisam/dfile	167769276	744321
wait/io/file/innodb/innodb_log_file	138348544	21070
wait/io/file/sql/binlog	31598182	19161
wait/io/file/myisam/kfile	743721	28208
wait/io/file/sql/slow_log	6248	11
wait/io/file/sql/global_ddl_log	0	0
wait/io/file/sql/des_key_file	0	0
wait/io/file/myisammrg/MRG	0	0
wait/io/file/sql/binlog_index	0	0

Performance Schema Stats

Top IO Stat by host

host_name io_count io_latency_count(ms)
10.128.250.51 3355098 18161.34

10.128.6.22 50015 138.37

10.128.3.57 2275 354.54

10.128.6.21 300 1.18

10.128.250.50 0 0.00

10.128.3.46 0 0.00

10.128.250.101 0 0.00

host_name	io_count	io_latency_count(ms)
10.128.250.51	3355098	18161.34
10.128.6.22	50015	138.37
10.128.3.57	2275	354.54
10.128.6.21	300	1.18
10.128.250.50	0	0.00
10.128.3.46	0	0.00
10.128.250.101	0	0.00

Top Summary statment by host

host total total_latency max_latency lock_latency rows_sent rows_examined rows_affected full_scans
10.128.250.51 149116 466724.91 6605055.36 15217.93 4563314 14990892 938556 7584

10.128.6.21 1726 54270.12 839.17 329.14 41459 2819568 0 1079

10.128.3.57 11095 1167.37 7845.02 77.20 3307 1028 661 367

10.128.6.230 1176 989.75 89.33 64.57 100254 100254 0 588

10.128.3.46 0 0.00 10.10 0.00 0 0 0 0

10.128.6.22 0 0.00 1.08 0.00 0 0 0 0

10.128.250.101 0 0.00 495.14 0.00 0 0 0 0

10.128.250.50 0 0.00 214.18 0.00 0 0 0 0

host	total	total_latency	max_latency	lock_latency	rows_sent	rows_examined	rows_affected	full_scans
10.128.250.51	149116	466724.91	6605055.36	15217.93	4563314	14990892	938556	7584
10.128.6.21	1726	54270.12	839.17	329.14	41459	2819568	0	1079
10.128.3.57	11095	1167.37	7845.02	77.20	3307	1028	661	367
10.128.6.230	1176	989.75	89.33	64.57	100254	100254	0	588
10.128.3.46	0	0.00	10.10	0.00	0	0	0	0
10.128.6.22	0	0.00	1.08	0.00	0	0	0	0
10.128.250.101	0	0.00	495.14	0.00	0	0	0	0
10.128.250.50	0	0.00	214.18	0.00	0	0	0	0

Top IO Stat by user

user_name io_count io_latency_count(ms)
zabbix 3355090 18160.36

background 1059957 50729.87

repl 50005 138.34

dbadmin 2575 355.72

sms 0 0.00

dbread 0 0.00

root 0 0.00

dbmonitor 0 0.00

user_name	io_count	io_latency_count(ms)
zabbix	3355090	18160.36
background	1059957	50729.87
repl	50005	138.34
dbadmin	2575	355.72
sms	0	0.00
dbread	0	0.00
root	0	0.00
dbmonitor	0	0.00

Top Summary statment by user

user total total_latency max_latency lock_latency rows_sent rows_examined rows_affected full_scans
zabbix 149168 466822.70 6605049.96 15222.21 4563453 14991198 938560 7594

dbadmin 13997 56435.93 8741.97 470.95 145020 2920850 661 2034

dbmonitor 3435 527.06 28.15 80.13 1766 883 0 883

repl 0 0.00 1.08 0.00 0 0 0 0

dbread 0 0.00 708.87 0.00 0 0 0 0

root 0 0.00 666646.03 0.00 0 0 0 0

sms 0 0.00 60.66 0.00 0 0 0 0

user	total	total_latency	max_latency	lock_latency	rows_sent	rows_examined	rows_affected	full_scans
zabbix	149168	466822.70	6605049.96	15222.21	4563453	14991198	938560	7594
dbadmin	13997	56435.93	8741.97	470.95	145020	2920850	661	2034
dbmonitor	3435	527.06	28.15	80.13	1766	883	0	883
repl	0	0.00	1.08	0.00	0	0	0	0
dbread	0	0.00	708.87	0.00	0	0	0	0
root	0	0.00	666646.03	0.00	0	0	0	0
sms	0	0.00	60.66	0.00	0	0	0	0

Global Read File IO by Bytes

file_name count_read total_read(KB) avg_read(KB) write_pct
@@datadir/mysql/proc.MYD 196 276.96 1.43 0.58

@@datadir/zabbix/tmp_his.frm 230 66.32 0.29 0.01

@@datadir/zabbix/events.ibd 0 0.00 16.00 99.89

@@datadir/zabbix/functions.ibd 0 0.00 16.00 99.49

@@datadir/zabbix/#sql-886f_9e82c6.frm 0 0.00 0.56 66.24

@@datadir/zabbix/item_discovery.ibd 0 0.00 16.00 100.00

@@datadir/zabbix/graphs_items.ibd 0 0.00 16.00 99.31

@@datadir/zabbix/httptest.frm 0 0.00 0.50 0.00

@@datadir/zabbix/triggers.ibd 0 0.00 16.00 99.97

@@datadir/zabbix/auditlog.ibd 0 0.00 16.00 96.05

file_name	count_read	total_read(KB)	avg_read(KB)	write_pct
@@datadir/mysql/proc.MYD	196	276.96	1.43	0.58
@@datadir/zabbix/tmp_his.frm	230	66.32	0.29	0.01
@@datadir/zabbix/events.ibd	0	0.00	16.00	99.89
@@datadir/zabbix/functions.ibd	0	0.00	16.00	99.49
@@datadir/zabbix/#sql-886f_9e82c6.frm	0	0.00	0.56	66.24
@@datadir/zabbix/item_discovery.ibd	0	0.00	16.00	100.00
@@datadir/zabbix/graphs_items.ibd	0	0.00	16.00	99.31
@@datadir/zabbix/httptest.frm	0	0.00	0.50	0.00
@@datadir/zabbix/triggers.ibd	0	0.00	16.00	99.97
@@datadir/zabbix/auditlog.ibd	0	0.00	16.00	96.05

Global Write File IO by Bytes

file_name count_write total_write(KB) avg_write(KB) write_pct
@@datadir/ibdata0 72414 15252992.00 157.95 100.00

@@datadir/zabbix/events.ibd 13769 220304.00 16.11 99.89

@@datadir/ib_logfile3 20633 134884.50 3.84 100.00

@@datadir/zabbix/sessions.ibd 2278 40480.00 16.05 100.00

@@datadir/zabbix/item_discovery.ibd 1322 21152.00 16.00 100.00

@@datadir/zabbix/hosts.ibd 640 10240.00 16.00 100.00

@@datadir/test/dml_health_check.ibd 367 5872.00 16.00 100.00

@@datadir/zabbix/groups_performance.ibd 98 5600.00 20.37 100.00

@@datadir/test/heartbeat.ibd 294 4704.00 16.00 100.00

@@datadir/zabbix/triggers.ibd 131 2096.00 16.01 99.97

file_name	count_write	total_write(KB)	avg_write(KB)	write_pct
@@datadir/ibdata0	72414	15252992.00	157.95	100.00
@@datadir/zabbix/events.ibd	13769	220304.00	16.11	99.89
@@datadir/ib_logfile3	20633	134884.50	3.84	100.00
@@datadir/zabbix/sessions.ibd	2278	40480.00	16.05	100.00
@@datadir/zabbix/item_discovery.ibd	1322	21152.00	16.00	100.00
@@datadir/zabbix/hosts.ibd	640	10240.00	16.00	100.00
@@datadir/test/dml_health_check.ibd	367	5872.00	16.00	100.00
@@datadir/zabbix/groups_performance.ibd	98	5600.00	20.37	100.00
@@datadir/test/heartbeat.ibd	294	4704.00	16.00	100.00
@@datadir/zabbix/triggers.ibd	131	2096.00	16.01	99.97

Global File IO Latency

file_name total total_latency(ms) count_read read_latency(ms) count_write write_latency(ms) count_misc misc_latency(ms)
@@datadir/ibdata0 124687 17682.43 0 0.00 72414.00 12841.89 52273.00 4840.54

@@datadir/ib_logfile3 41260 8809.46 0 0.00 20630.00 1398.14 20630.00 7411.32

@@datadir/zabbix/events.ibd 25232 2132.59 0 0.00 13769.00 531.55 11463.00 1601.04

@@datadir/zabbix/item_discovery.ibd 2406 208.35 0 0.00 1322.00 47.06 1084.00 161.29

@@datadir/ib_logfile0 858 164.88 0 0.00 429.00 15.49 429.00 149.39

@@datadir/zabbix/escalations.ibd 6 0.76 0 0.00 3.00 0.14 3.00 0.62

@@datadir/ib_logfile1 0 0.00 0 0.00 0.00 0.00 0.00 0.00

@@datadir/zabbix/trends_uint#P#p201410.ibd 0 0.00 0 0.00 0.00 0.00 0.00 0.00

@@datadir/zabbix/history_uint#P#p20140929.ibd 0 0.00 0 0.00 0.00 0.00 0.00 0.00

@@datadir/ib_logfile2 0 0.00 0 0.00 0.00 0.00 0.00 0.00

file_name	total	total_latency(ms)	count_write	write_latency(ms)	count_misc	misc_latency(ms)
@@datadir/ibdata0	124687	17682.43	72414.00	12841.89	52273.00	4840.54
@@datadir/ib_logfile3	41260	8809.46	20630.00	1398.14	20630.00	7411.32
@@datadir/zabbix/events.ibd	25232	2132.59	13769.00	531.55	11463.00	1601.04
@@datadir/zabbix/item_discovery.ibd	2406	208.35	1322.00	47.06	1084.00	161.29
@@datadir/ib_logfile0	858	164.88	429.00	15.49	429.00	149.39
@@datadir/zabbix/escalations.ibd	6	0.76	3.00	0.14	3.00	0.62
@@datadir/ib_logfile1	0	0.00	0.00	0.00	0.00	0.00
@@datadir/zabbix/trends_uint#P#p201410.ibd	0	0.00	0.00	0.00	0.00	0.00
@@datadir/zabbix/history_uint#P#p20140929.ibd	0	0.00	0.00	0.00	0.00	0.00
@@datadir/ib_logfile2	0	0.00	0.00	0.00	0.00	0.00

Global Event IO Latency

event_name total total_latency(ms) avg_latency(ms) max_latency(ms) read_latency(ms) write_latency(ms) misc_latency(ms) total_read total_written
innodb/innodb_data_file 1050467 48921.23 0.05 3757.52 0.00 39902.80 9018.43 0 30197317632

innodb/innodb_log_file 42116 8974.05 0.20 7323.70 0.00 1413.60 7560.44 0 138337792

sql/binlog 85096 5047.94 0.06 2891.94 138.31 475.17 4434.47 31595564 31595564

myisam/dfile 3250229 6037.63 0.00 185.38 1461.73 4042.20 533.70 289170779 167769276

myisam/kfile 38783 389.96 0.01 1458.66 5.02 131.17 253.76 659799 743721

sql/dbopt 367 2.85 0.01 25.76 0.00 0.00 2.85 0 0

sql/FRM 450 1.81 0.01 36.93 0.40 0.00 1.41 67910 0

sql/slow_log 16 0.27 0.03 14.72 0.00 0.17 0.10 0 6248

innodb/innodb_temp_file 0 0.00 0.60 8.80 0.00 0.00 0.00 0 0

sql/binlog_index 0 0.00 0.09 15.29 0.00 0.00 0.00 0 0

event_name	total	total_latency(ms)	avg_latency(ms)	max_latency(ms)	read_latency(ms)	write_latency(ms)	misc_latency(ms)	total_read	total_written
innodb/innodb_data_file	1050467	48921.23	0.05	3757.52	0.00	39902.80	9018.43	0	30197317632
innodb/innodb_log_file	42116	8974.05	0.20	7323.70	0.00	1413.60	7560.44	0	138337792
sql/binlog	85096	5047.94	0.06	2891.94	138.31	475.17	4434.47	31595564	31595564
myisam/dfile	3250229	6037.63	0.00	185.38	1461.73	4042.20	533.70	289170779	167769276
myisam/kfile	38783	389.96	0.01	1458.66	5.02	131.17	253.76	659799	743721
sql/dbopt	367	2.85	0.01	25.76	0.00	0.00	2.85	0	0
sql/FRM	450	1.81	0.01	36.93	0.40	0.00	1.41	67910	0
sql/slow_log	16	0.27	0.03	14.72	0.00	0.17	0.10	0	6248
innodb/innodb_temp_file	0	0.00	0.60	8.80	0.00	0.00	0.00	0	0
sql/binlog_index	0	0.00	0.09	15.29	0.00	0.00	0.00	0	0

Global Event Class Wait latency

event_class total total_latency min_latency avg_latency max_latency
wait/io/file 16757168226 69.86h 0 ps 15.01 us 7.32 s

wait/io/table 88077551769 138.59h 30.03 ns 5.66 us 4.29 s

wait/lock/table 12906567226 1.38h 20.79 ns 384.41 ns 10.31 ms

event_class	total	total_latency	min_latency	avg_latency	max_latency
wait/io/file	16757168226	69.86h	0 ps	15.01 us	7.32 s
wait/io/table	88077551769	138.59h	30.03 ns	5.66 us	4.29 s
wait/lock/table	12906567226	1.38h	20.79 ns	384.41 ns	10.31 ms

Global Satament Table Full Scan

db exec_count no_idx_count no_gidx_count no_ind_use_pct rows_sent rows_exam last_seen_time_stamp
zabbix 10675316 10675316 0 100 3661998826 7323997652 2014-12-01 17:47:03

zabbix 3737197 3738290 0 100 3737922 3738068 2014-12-01 17:47:03

zabbix 1205678 1205722 0 100 1205701 1205703 2014-12-01 17:47:03

zabbix 247850 247850 0 100 247846 247898 2014-12-01 17:47:03

zabbix 247850 247850 0 100 247850 247850 2014-12-01 17:47:03

zabbix 2921843 2 0 0 2921843 5844465 2014-12-01 17:47:03

zabbix 246219 246219 0 100 143302064 143302064 2014-12-01 17:47:02

zabbix 246219 246219 0 100 1049633 803414 2014-12-01 17:47:02

zabbix 246220 246220 0 100 75221087 86418318 2014-12-01 17:47:01

zabbix 246219 246219 0 100 129293425 129293425 2014-12-01 17:47:01

db	exec_count	no_idx_count	no_ind_use_pct	rows_sent	rows_exam	last_seen_time_stamp
zabbix	10675316	10675316	100	3661998826	7323997652	2014-12-01 17:47:03
zabbix	3737197	3738290	100	3737922	3738068	2014-12-01 17:47:03
zabbix	1205678	1205722	100	1205701	1205703	2014-12-01 17:47:03
zabbix	247850	247850	100	247846	247898	2014-12-01 17:47:03
zabbix	247850	247850	100	247850	247850	2014-12-01 17:47:03
zabbix	2921843	2	0	2921843	5844465	2014-12-01 17:47:03
zabbix	246219	246219	100	143302064	143302064	2014-12-01 17:47:02
zabbix	246219	246219	100	1049633	803414	2014-12-01 17:47:02
zabbix	246220	246220	100	75221087	86418318	2014-12-01 17:47:01
zabbix	246219	246219	100	129293425	129293425	2014-12-01 17:47:01

Global Satament Table Full SQL

query digest
SELECT `escalationid` , `actionid` , `triggerid` , `eventid` , `r_eventid` , `nextcheck` , `esc_step` , STATUS , `itemid` FROM `escalations` ORDER BY `actionid` , `triggerid` , `itemid` , `escalationid` e658ad35a5912d7cfeed39d0e65624af

SELECT `dv` . `mandatory` , `dv` . `optional` FROM `dbversion` `dv` b4a3f50693a3f75f89b48a3ca26a861b

SELECT `c` . * FROM `config` `c` 0e12373dffaecb705e39b000fd42ddf6

SELECT `t` . `hostmacroid` , `t` . `hostid` , `t` . `macro` , `t` . `value` FROM `hostmacro` `t` WHERE ( `t` . `hostid` BETWEEN ? AND ? OR `t` . `hostid` BETWEEN ? AND ? OR `t` . `hostid` IN (...) ) ORDER BY `t` . `hostmacroid` fc8a55cdfec89bff6c5653330d0cc4eb

SELECT `t` . `globalmacroid` , `t` . `macro` , `t` . `value` FROM `globalmacro` `t` ORDER BY `t` . `globalmacroid` 7974aba897a76c8c89d27c3987d2cb4d

SELECT `hostid` , STATUS FROM HOSTS WHERE HOST = ? AND STATUS IN (...) 9ef63b35db6f2276a6011fee83581ab0

SELECT `d` . `triggerid_down` , `d` . `triggerid_up` FROM `trigger_depends` `d` ORDER BY `d` . `triggerid_down` cd3ff4b5b0128bd064e6ac9f43f53e09

SELECT `r` . `name` , `e` . `expressionid` , `e` . `expression` , `e` . `expression_type` , `e` . `exp_delimiter` , `e` . `case_sensitive` FROM `regexps` `r` , `expressions` `e` WHERE `r` . `regexpid` = `e` . `regexpid` 98a25c864505a55f225b9223b0037d30

SELECT `hostid` , `proxy_hostid` , HOST , `ipmi_authtype` , `ipmi_privilege` , `ipmi_username` , `ipmi_password` , `maintenance_status` , `maintenance_type` , `maintenance_from` , `errors_from` , `available` , `disable_until` , `snmp_errors_from` , `snmp_available` , `snmp_disable_until` , `ipmi_errors_from` , `ipmi_available` , `ipmi_disable_until` , `jmx_errors_from` , `jmx_available` , `jmx_disable_until` , STATUS , NAME FROM HOSTS WHERE STATUS IN (...) AND `flags` != ? 0a513ea43c133bdaa6e384bb71b3b472

SELECT `hostid` , `templateid` FROM `hosts_templates` ORDER BY `hostid` , `templateid` 72469696ed699567a97cd1af91d1f5b7

query	digest
SELECT `escalationid` , `actionid` , `triggerid` , `eventid` , `r_eventid` , `nextcheck` , `esc_step` , STATUS , `itemid` FROM `escalations` ORDER BY `actionid` , `triggerid` , `itemid` , `escalationid`	e658ad35a5912d7cfeed39d0e65624af
SELECT `dv` . `mandatory` , `dv` . `optional` FROM `dbversion` `dv`	b4a3f50693a3f75f89b48a3ca26a861b
SELECT `c` . * FROM `config` `c`	0e12373dffaecb705e39b000fd42ddf6
SELECT `t` . `hostmacroid` , `t` . `hostid` , `t` . `macro` , `t` . `value` FROM `hostmacro` `t` WHERE ( `t` . `hostid` BETWEEN ? AND ? OR `t` . `hostid` BETWEEN ? AND ? OR `t` . `hostid` IN (...) ) ORDER BY `t` . `hostmacroid`	fc8a55cdfec89bff6c5653330d0cc4eb
SELECT `t` . `globalmacroid` , `t` . `macro` , `t` . `value` FROM `globalmacro` `t` ORDER BY `t` . `globalmacroid`	7974aba897a76c8c89d27c3987d2cb4d
SELECT `hostid` , STATUS FROM HOSTS WHERE HOST = ? AND STATUS IN (...)	9ef63b35db6f2276a6011fee83581ab0
SELECT `d` . `triggerid_down` , `d` . `triggerid_up` FROM `trigger_depends` `d` ORDER BY `d` . `triggerid_down`	cd3ff4b5b0128bd064e6ac9f43f53e09
SELECT `r` . `name` , `e` . `expressionid` , `e` . `expression` , `e` . `expression_type` , `e` . `exp_delimiter` , `e` . `case_sensitive` FROM `regexps` `r` , `expressions` `e` WHERE `r` . `regexpid` = `e` . `regexpid`	98a25c864505a55f225b9223b0037d30
SELECT `hostid` , `proxy_hostid` , HOST , `ipmi_authtype` , `ipmi_privilege` , `ipmi_username` , `ipmi_password` , `maintenance_status` , `maintenance_type` , `maintenance_from` , `errors_from` , `available` , `disable_until` , `snmp_errors_from` , `snmp_available` , `snmp_disable_until` , `ipmi_errors_from` , `ipmi_available` , `ipmi_disable_until` , `jmx_errors_from` , `jmx_available` , `jmx_disable_until` , STATUS , NAME FROM HOSTS WHERE STATUS IN (...) AND `flags` != ?	0a513ea43c133bdaa6e384bb71b3b472
SELECT `hostid` , `templateid` FROM `hosts_templates` ORDER BY `hostid` , `templateid`	72469696ed699567a97cd1af91d1f5b7

Global Satament TEMP Table Usage

db exec_count total_latency(ms) memory_tmp_tables disk_tmp_tables avg_tmp_tables_per_query tmp_tables_to_disk_pct last_seen
zabbix 6373892 7182546.48 6373894 6373894 1 100 2014-12-01 17:46:55

zabbix 501069 281280.66 8775 8775 0 100 2014-12-01 17:46:43

zabbix 6529073 2406121.62 6529152 0 1 0 2014-12-01 17:46:55

zabbix 6373872 3617498.02 6373889 0 1 0 2014-12-01 17:46:55

zabbix 1385207 585526.44 1385834 0 1 0 2014-12-01 14:27:17

zabbix 247850 151342.39 247850 0 1 0 2014-12-01 17:47:03

zabbix 247850 73528.05 247850 0 1 0 2014-12-01 17:47:03

zabbix 247850 79208.01 247850 0 1 0 2014-12-01 17:47:03

zabbix 171673 96837.30 171684 0 1 0 2014-12-01 14:27:32

zabbix 208725 63015.85 128660 0 1 0 2014-12-01 14:27:17

db	exec_count	total_latency(ms)	memory_tmp_tables	disk_tmp_tables	avg_tmp_tables_per_query	tmp_tables_to_disk_pct	last_seen
zabbix	6373892	7182546.48	6373894	6373894	1	100	2014-12-01 17:46:55
zabbix	501069	281280.66	8775	8775	0	100	2014-12-01 17:46:43
zabbix	6529073	2406121.62	6529152	0	1	0	2014-12-01 17:46:55
zabbix	6373872	3617498.02	6373889	0	1	0	2014-12-01 17:46:55
zabbix	1385207	585526.44	1385834	0	1	0	2014-12-01 14:27:17
zabbix	247850	151342.39	247850	0	1	0	2014-12-01 17:47:03
zabbix	247850	73528.05	247850	0	1	0	2014-12-01 17:47:03
zabbix	247850	79208.01	247850	0	1	0	2014-12-01 17:47:03
zabbix	171673	96837.30	171684	0	1	0	2014-12-01 14:27:32
zabbix	208725	63015.85	128660	0	1	0	2014-12-01 14:27:17

Global Satament TEMP Table SQL

query digest
SELECT DISTINCTROW `t` . `triggerid` , `t` . `description` , `t` . `expression` , `t` . `status` , `t` . `type` , `t` . `priority` , `t` . `comments` , `t` . `url` FROM TRIGGERS `t` , `functions` `f` , `items` `i` , `item_discovery` `id` WHERE `t` . `triggerid` = `f` . `triggerid` AND `f` . `itemid` = `i` . `itemid` AND `i` . `itemid` = `id` . `itemid` AND `id` . `parent_itemid` = ? 7a980a590fedd684ec08c891af751ce2

SELECT `a` . `alertid` , `a` . `mediatypeid` , `a` . `sendto` , `a` . `subject` , `a` . `message` , `a` . `status` , `mt` . `mediatypeid` , `mt` . `type` , `mt` . `description` , `mt` . `smtp_server` , `mt` . `smtp_helo` , `mt` . `smtp_email` , `mt` . `exec_path` , `mt` . `gsm_modem` , `mt` . `username` , `mt` . `passwd` , `a` . `retries` FROM `alerts` `a` , `media_type` `mt` WHERE `a` . `mediatypeid` = `mt` . `mediatypeid` AND `a` . `status` = ? AND `a` . `alerttype` = ? ORDER BY `a` . `alertid` 1ad601430fb9bfa8eb8442130e7afe50

SELECT DISTINCTROW `i` . `itemid` , `i` . `flags` FROM `items` `i` , `functions` `f` WHERE `i` . `itemid` = `f` . `itemid` AND `f` . `triggerid` = ? 74e3e0ae4565f56895d19349aabeb609

SELECT DISTINCTROW `g` . `graphid` , `g` . `name` , `g` . `width` , `g` . `height` , `g` . `yaxismin` , `g` . `yaxismax` , `g` . `show_work_period` , `g` . `show_triggers` , `g` . `graphtype` , `g` . `show_legend` , `g` . `show_3d` , `g` . `percent_left` , `g` . `percent_right` , `g` . `ymin_type` , `g` . `ymin_itemid` , `g` . `ymax_type` , `g` . `ymax_itemid` FROM `graphs` `g` , `graphs_items` `gi` , `items` `i` , `item_discovery` `id` WHERE `g` . `graphid` = `gi` . `graphid` AND `gi` . `itemid` = `i` . `itemid` AND `i` . `itemid` = `id` . `itemid` AND `id` . `parent_itemid` = ? d1b740728a17c7ee2aa3803f014716e6

SELECT DISTINCTROW `hg` . `groupid` FROM `hosts_groups` `hg` , HOSTS `h` , `items` `i` , `functions` `f` , TRIGGERS `t` WHERE `hg` . `hostid` = `h` . `hostid` AND `h` . `hostid` = `i` . `hostid` AND `i` . `itemid` = `f` . `itemid` AND `f` . `triggerid` = `t` . `triggerid` AND `t` . `triggerid` = ? AND `hg` . `groupid` = ? 4c579b42a0516bebedce3c27155fc274

SELECT DISTINCTROW `templateid` FROM `hosts_templates` WHERE ( `hostid` BETWEEN ? AND ? OR `hostid` IN (...) ) 06e56078d4bfa5f19d53b7de9842b984

SELECT DISTINCTROW `templateid` FROM `hosts_templates` WHERE `hostid` IN (...) 32a0a17611ff06cbd4a84b3847fa118a

SELECT `t` . `groupid` FROM `groups` `t` , `config` `r` WHERE `t` . `groupid` = `r` . `discovery_groupid` ORDER BY `t` . `groupid` d4785ceb1e8bf4dab713d8c29b599882

SELECT DISTINCTROW `a` . * , `u` . `alias` , `u` . `name` , `u` . `surname` FROM `acknowledges` `a` , `users` `u` WHERE `a` . `eventid` IN (...) AND `a` . `userid` = `u` . `userid` ORDER BY `a` . `clock` DESC 1f429a59149a31fccb7c6bef398dc174

SELECT DISTINCTROW `i` . `hostid` , `t` . `templateid` FROM `items` `i` , `functions` `f` , TRIGGERS `t` WHERE `i` . `itemid` = `f` . `itemid` AND `f` . `triggerid` = `t` . `templateid` AND `t` . `triggerid` = ? 6e2860d2c925cbe1130f10eef6dbbd6f

query	digest
SELECT DISTINCTROW `t` . `triggerid` , `t` . `description` , `t` . `expression` , `t` . `status` , `t` . `type` , `t` . `priority` , `t` . `comments` , `t` . `url` FROM TRIGGERS `t` , `functions` `f` , `items` `i` , `item_discovery` `id` WHERE `t` . `triggerid` = `f` . `triggerid` AND `f` . `itemid` = `i` . `itemid` AND `i` . `itemid` = `id` . `itemid` AND `id` . `parent_itemid` = ?	7a980a590fedd684ec08c891af751ce2
SELECT `a` . `alertid` , `a` . `mediatypeid` , `a` . `sendto` , `a` . `subject` , `a` . `message` , `a` . `status` , `mt` . `mediatypeid` , `mt` . `type` , `mt` . `description` , `mt` . `smtp_server` , `mt` . `smtp_helo` , `mt` . `smtp_email` , `mt` . `exec_path` , `mt` . `gsm_modem` , `mt` . `username` , `mt` . `passwd` , `a` . `retries` FROM `alerts` `a` , `media_type` `mt` WHERE `a` . `mediatypeid` = `mt` . `mediatypeid` AND `a` . `status` = ? AND `a` . `alerttype` = ? ORDER BY `a` . `alertid`	1ad601430fb9bfa8eb8442130e7afe50
SELECT DISTINCTROW `i` . `itemid` , `i` . `flags` FROM `items` `i` , `functions` `f` WHERE `i` . `itemid` = `f` . `itemid` AND `f` . `triggerid` = ?	74e3e0ae4565f56895d19349aabeb609
SELECT DISTINCTROW `g` . `graphid` , `g` . `name` , `g` . `width` , `g` . `height` , `g` . `yaxismin` , `g` . `yaxismax` , `g` . `show_work_period` , `g` . `show_triggers` , `g` . `graphtype` , `g` . `show_legend` , `g` . `show_3d` , `g` . `percent_left` , `g` . `percent_right` , `g` . `ymin_type` , `g` . `ymin_itemid` , `g` . `ymax_type` , `g` . `ymax_itemid` FROM `graphs` `g` , `graphs_items` `gi` , `items` `i` , `item_discovery` `id` WHERE `g` . `graphid` = `gi` . `graphid` AND `gi` . `itemid` = `i` . `itemid` AND `i` . `itemid` = `id` . `itemid` AND `id` . `parent_itemid` = ?	d1b740728a17c7ee2aa3803f014716e6
SELECT DISTINCTROW `hg` . `groupid` FROM `hosts_groups` `hg` , HOSTS `h` , `items` `i` , `functions` `f` , TRIGGERS `t` WHERE `hg` . `hostid` = `h` . `hostid` AND `h` . `hostid` = `i` . `hostid` AND `i` . `itemid` = `f` . `itemid` AND `f` . `triggerid` = `t` . `triggerid` AND `t` . `triggerid` = ? AND `hg` . `groupid` = ?	4c579b42a0516bebedce3c27155fc274
SELECT DISTINCTROW `templateid` FROM `hosts_templates` WHERE ( `hostid` BETWEEN ? AND ? OR `hostid` IN (...) )	06e56078d4bfa5f19d53b7de9842b984
SELECT DISTINCTROW `templateid` FROM `hosts_templates` WHERE `hostid` IN (...)	32a0a17611ff06cbd4a84b3847fa118a
SELECT `t` . `groupid` FROM `groups` `t` , `config` `r` WHERE `t` . `groupid` = `r` . `discovery_groupid` ORDER BY `t` . `groupid`	d4785ceb1e8bf4dab713d8c29b599882
SELECT DISTINCTROW `a` . * , `u` . `alias` , `u` . `name` , `u` . `surname` FROM `acknowledges` `a` , `users` `u` WHERE `a` . `eventid` IN (...) AND `a` . `userid` = `u` . `userid` ORDER BY `a` . `clock` DESC	1f429a59149a31fccb7c6bef398dc174
SELECT DISTINCTROW `i` . `hostid` , `t` . `templateid` FROM `items` `i` , `functions` `f` , TRIGGERS `t` WHERE `i` . `itemid` = `f` . `itemid` AND `f` . `triggerid` = `t` . `templateid` AND `t` . `triggerid` = ?	6e2860d2c925cbe1130f10eef6dbbd6f

Global Segments by Index

table_schema table_name index_name rows_selected select_latency(ms) rows_inserted insert_latency(ms) rows_updated update_latency(ms) rows_deleted delete_latency(ms)
zabbix items items_1 8083593 21094.34 0 0.00 0 0.00 0 0.00

zabbix functions functions_2 6803698 16096.50 0 0.00 0 0.00 0 0.00

zabbix triggers PRIMARY 1710786 3555.35 0 0.00 40 7.20 0 0.00

zabbix history history_1 521540 293733.58 0 0.00 0 0.00 0 0.00

zabbix items PRIMARY 36808 343.15 0 0.00 244 8.42 0 0.00

zabbix functions functions_1 15616 95.94 0 0.00 0 0.00 0 0.00

zabbix hosts PRIMARY 4120 52.72 0 0.00 670 37.11 0 0.00

table_schema	table_name	index_name	rows_selected	select_latency(ms)	rows_updated	update_latency(ms)
zabbix	items	items_1	8083593	21094.34	0	0.00
zabbix	functions	functions_2	6803698	16096.50	0	0.00
zabbix	triggers	PRIMARY	1710786	3555.35	40	7.20
zabbix	history	history_1	521540	293733.58	0	0.00
zabbix	items	PRIMARY	36808	343.15	244	8.42
zabbix	functions	functions_1	15616	95.94	0	0.00
zabbix	hosts	PRIMARY	4120	52.72	670	37.11

Global Segments by Table

table_schema table_name rows_selected select_latency(ms) rows_inserted insert_latency(ms) rows_updated update_latency(ms) rows_deleted delete_latency(ms)
zabbix items 8120401 21437.49 0 0.00 244 8.42 0 0.00

zabbix functions 6819314 16192.44 0 0.00 0 0.00 0 0.00

zabbix triggers 1710786 3555.35 0 0.00 40 7.20 0 0.00

zabbix history 521540 293733.58 74660 1455.35 0 0.00 0 0.00

zabbix hosts 136360 479.06 0 0.00 670 37.11 0 0.00

zabbix item_discovery 90560 486.30 0 0.00 20594 193.35 0 0.00

zabbix escalations 2946 21.53 0 0.00 6 0.15 0 0.00

zabbix sessions 1194 36.71 1092 121.12 102 2.57 0 0.00

table_schema	table_name	rows_selected	select_latency(ms)	rows_inserted	insert_latency(ms)	rows_updated	update_latency(ms)
zabbix	items	8120401	21437.49	0	0.00	244	8.42
zabbix	functions	6819314	16192.44	0	0.00	0	0.00
zabbix	triggers	1710786	3555.35	0	0.00	40	7.20
zabbix	history	521540	293733.58	74660	1455.35	0	0.00
zabbix	hosts	136360	479.06	0	0.00	670	37.11
zabbix	item_discovery	90560	486.30	0	0.00	20594	193.35
zabbix	escalations	2946	21.53	0	0.00	6	0.15
zabbix	sessions	1194	36.71	1092	121.12	102	2.57

Innodb activity(1)

Snap Time Com_ins Com_upd Com_del Com_sel TPS Buf_read_req Hit% Innodb_rows_ins Innodb_rows_upd Innodb_rows_del Innodb_rows_read Innodb_log_fsyncs Innodb_log_wrn(k/s) Threads_running
2014-12-01 16:59:01 5 4 0 24 9 13107 100 285 2 0 4096 6 42 3.00

2014-12-01 17:00:01 4 4 0 28 8 20753 100 285 5 0 4778 6 41 3.00

2014-12-01 17:01:01 6 5 0 30 11 834491 100 576 47 0 53384 7 84 2.00

2014-12-01 17:02:01 5 4 0 29 9 13107 100 320 5 0 4369 7 48 2.00

2014-12-01 17:03:01 5 6 0 33 11 16384 100 426 140 0 5051 8 77 2.00

2014-12-01 17:04:01 5 4 0 25 9 13107 100 320 3 0 4232 6 48 2.00

2014-12-01 17:05:01 5 4 0 26 9 39321 100 324 1 0 5597 7 49 3.00

2014-12-01 17:06:01 4 4 0 28 8 814830 100 307 4 0 52155 6 46 2.00

2014-12-01 17:07:01 5 4 0 25 9 13107 100 290 1 0 4232 6 42 3.00

2014-12-01 17:08:01 5 4 0 28 9 13107 100 311 4 0 4232 6 45 3.00

2014-12-01 17:09:01 5 4 0 27 9 3276 100 294 3 0 409 6 43 3.00

2014-12-01 17:10:01 5 4 0 28 9 40413 100 285 4 0 5734 6 42 3.00

2014-12-01 17:11:01 5 5 0 28 10 812646 100 311 6 0 52019 7 46 2.00

2014-12-01 17:12:01 4 4 0 32 8 14199 100 285 8 0 4369 7 43 2.00

2014-12-01 17:13:01 5 4 0 29 9 13107 100 315 4 0 4096 7 45 2.00

2014-12-01 17:14:01 5 4 0 29 9 13107 100 290 4 0 4232 7 43 2.00

2014-12-01 17:15:02 5 4 0 27 9 41900 100 285 3 0 5908 7 44 3.00

2014-12-01 17:16:02 4 4 0 26 8 811554 100 294 2 0 51882 6 45 2.00

2014-12-01 17:17:02 5 5 0 32 10 13107 100 294 6 0 4232 8 43 2.00

2014-12-01 17:18:02 5 5 0 30 10 13107 100 315 6 0 4232 7 49 2.00

2014-12-01 17:19:01 5 4 0 24 9 13329 100 295 1 0 4165 6 44 2.00

2014-12-01 17:20:01 5 4 0 26 9 29491 100 290 1 0 5188 6 42 3.00

2014-12-01 17:21:02 5 4 0 29 9 811142 100 306 3 0 51837 7 46 2.00

2014-12-01 17:22:01 4 5 0 34 9 13329 100 295 4 0 4304 7 44 2.00

2014-12-01 17:23:01 5 6 0 46 11 13107 100 311 5 0 4232 9 49 3.00

2014-12-01 17:24:01 5 4 0 40 9 13107 100 290 2 0 4232 6 42 2.00

2014-12-01 17:25:01 5 4 0 36 9 21845 100 290 2 0 4642 7 43 3.00

2014-12-01 17:26:01 5 5 0 39 10 832307 100 307 8 0 53248 8 46 2.00

2014-12-01 17:27:01 5 5 0 27 10 13107 100 290 7 0 4232 7 43 3.00

2014-12-01 17:28:01 4 3 0 25 7 13107 100 307 1 0 4232 5 45 2.00

2014-12-01 17:29:01 5 4 0 26 9 13107 100 285 3 0 4096 7 42 2.00

2014-12-01 17:30:01 4 4 0 26 8 25122 100 290 3 0 4915 6 41 3.00

2014-12-01 17:31:01 5 4 0 27 9 829030 100 311 4 0 52974 7 45 2.00

2014-12-01 17:32:02 4 4 0 27 8 12892 100 281 4 0 4163 6 41 2.00

2014-12-01 17:33:01 5 5 0 26 10 13329 100 316 4 0 4304 8 46 2.00

2014-12-01 17:34:02 4 4 0 27 8 12892 100 281 3 0 4163 7 43 2.00

2014-12-01 17:35:02 5 4 0 26 9 41506 100 290 2 0 5870 6 42 3.00

2014-12-01 17:36:02 4 4 0 30 8 811554 100 307 4 0 52019 7 44 2.00

2014-12-01 17:37:01 4 4 0 24 8 13329 100 273 2 0 4165 6 40 2.00

2014-12-01 17:38:01 5 4 0 25 9 13107 100 311 2 0 4232 6 46 2.00

2014-12-01 17:39:01 5 4 0 26 9 13107 100 285 2 0 4232 6 43 4.00

2014-12-01 17:40:01 5 4 0 27 9 26214 100 290 3 0 4915 6 42 3.00

2014-12-01 17:41:01 5 5 0 29 10 827938 100 307 5 0 52838 7 45 2.00

2014-12-01 17:42:01 5 5 0 37 10 15291 100 290 8 0 5188 8 44 2.00

2014-12-01 17:43:01 5 4 0 28 9 13107 100 311 2 0 4096 6 45 2.00

2014-12-01 17:44:02 4 4 0 29 8 12892 100 281 2 0 4163 6 40 2.00

2014-12-01 17:45:02 5 4 0 27 9 58982 100 290 1 0 7236 7 43 3.00

2014-12-01 17:46:02 4 4 0 28 8 795170 100 307 2 0 50653 6 44 2.00

2014-12-01 17:47:01 5 4 0 24 9 12218 100 290 3 0 4026 7 43 2.00

Snap Time	Com_ins	Com_upd	Com_sel	TPS	Buf_read_req	Hit%	Innodb_rows_ins	Innodb_rows_upd	Innodb_rows_read	Innodb_log_fsyncs	Innodb_log_wrn(k/s)	Threads_running
2014-12-01 16:59:01	5	4	24	9	13107	100	285	2	4096	6	42	3.00
2014-12-01 17:00:01	4	4	28	8	20753	100	285	5	4778	6	41	3.00
2014-12-01 17:01:01	6	5	30	11	834491	100	576	47	53384	7	84	2.00
2014-12-01 17:02:01	5	4	29	9	13107	100	320	5	4369	7	48	2.00
2014-12-01 17:03:01	5	6	33	11	16384	100	426	140	5051	8	77	2.00
2014-12-01 17:04:01	5	4	25	9	13107	100	320	3	4232	6	48	2.00
2014-12-01 17:05:01	5	4	26	9	39321	100	324	1	5597	7	49	3.00
2014-12-01 17:06:01	4	4	28	8	814830	100	307	4	52155	6	46	2.00
2014-12-01 17:07:01	5	4	25	9	13107	100	290	1	4232	6	42	3.00
2014-12-01 17:08:01	5	4	28	9	13107	100	311	4	4232	6	45	3.00
2014-12-01 17:09:01	5	4	27	9	3276	100	294	3	409	6	43	3.00
2014-12-01 17:10:01	5	4	28	9	40413	100	285	4	5734	6	42	3.00
2014-12-01 17:11:01	5	5	28	10	812646	100	311	6	52019	7	46	2.00
2014-12-01 17:12:01	4	4	32	8	14199	100	285	8	4369	7	43	2.00
2014-12-01 17:13:01	5	4	29	9	13107	100	315	4	4096	7	45	2.00
2014-12-01 17:14:01	5	4	29	9	13107	100	290	4	4232	7	43	2.00
2014-12-01 17:15:02	5	4	27	9	41900	100	285	3	5908	7	44	3.00
2014-12-01 17:16:02	4	4	26	8	811554	100	294	2	51882	6	45	2.00
2014-12-01 17:17:02	5	5	32	10	13107	100	294	6	4232	8	43	2.00
2014-12-01 17:18:02	5	5	30	10	13107	100	315	6	4232	7	49	2.00
2014-12-01 17:19:01	5	4	24	9	13329	100	295	1	4165	6	44	2.00
2014-12-01 17:20:01	5	4	26	9	29491	100	290	1	5188	6	42	3.00
2014-12-01 17:21:02	5	4	29	9	811142	100	306	3	51837	7	46	2.00
2014-12-01 17:22:01	4	5	34	9	13329	100	295	4	4304	7	44	2.00
2014-12-01 17:23:01	5	6	46	11	13107	100	311	5	4232	9	49	3.00
2014-12-01 17:24:01	5	4	40	9	13107	100	290	2	4232	6	42	2.00
2014-12-01 17:25:01	5	4	36	9	21845	100	290	2	4642	7	43	3.00
2014-12-01 17:26:01	5	5	39	10	832307	100	307	8	53248	8	46	2.00
2014-12-01 17:27:01	5	5	27	10	13107	100	290	7	4232	7	43	3.00
2014-12-01 17:28:01	4	3	25	7	13107	100	307	1	4232	5	45	2.00
2014-12-01 17:29:01	5	4	26	9	13107	100	285	3	4096	7	42	2.00
2014-12-01 17:30:01	4	4	26	8	25122	100	290	3	4915	6	41	3.00
2014-12-01 17:31:01	5	4	27	9	829030	100	311	4	52974	7	45	2.00
2014-12-01 17:32:02	4	4	27	8	12892	100	281	4	4163	6	41	2.00
2014-12-01 17:33:01	5	5	26	10	13329	100	316	4	4304	8	46	2.00
2014-12-01 17:34:02	4	4	27	8	12892	100	281	3	4163	7	43	2.00
2014-12-01 17:35:02	5	4	26	9	41506	100	290	2	5870	6	42	3.00
2014-12-01 17:36:02	4	4	30	8	811554	100	307	4	52019	7	44	2.00
2014-12-01 17:37:01	4	4	24	8	13329	100	273	2	4165	6	40	2.00
2014-12-01 17:38:01	5	4	25	9	13107	100	311	2	4232	6	46	2.00
2014-12-01 17:39:01	5	4	26	9	13107	100	285	2	4232	6	43	4.00
2014-12-01 17:40:01	5	4	27	9	26214	100	290	3	4915	6	42	3.00
2014-12-01 17:41:01	5	5	29	10	827938	100	307	5	52838	7	45	2.00
2014-12-01 17:42:01	5	5	37	10	15291	100	290	8	5188	8	44	2.00
2014-12-01 17:43:01	5	4	28	9	13107	100	311	2	4096	6	45	2.00
2014-12-01 17:44:02	4	4	29	8	12892	100	281	2	4163	6	40	2.00
2014-12-01 17:45:02	5	4	27	9	58982	100	290	1	7236	7	43	3.00
2014-12-01 17:46:02	4	4	28	8	795170	100	307	2	50653	6	44	2.00
2014-12-01 17:47:01	5	4	24	9	12218	100	290	3	4026	7	43	2.00

Innodb activity(2)

Snap Time Indb_pdata Indb_pfree Indb_pdirty Indb_pflush Indb_dreads Indb_dwrites Indb_dread(k/s) Indb_dwritten(k/s) his_list Inlog_uflush Inlog_uckpt queries_inside queries_queued read_views
2014-12-01 16:59:01 4085180.00 8196.00 14.00 302 0 324 0 9693 2395.00 0 2 0.00 0.00 0.00

2014-12-01 17:00:01 4085181.00 8197.00 17.00 302 0 324 0 9830 2476.00 0 0 0.00 0.00 1.00

2014-12-01 17:01:01 4085174.00 8193.00 20.00 392 0 413 0 12561 2087.00 0 3 0.00 0.00 0.00

2014-12-01 17:02:01 4085173.00 8194.00 34.00 320 0 341 0 10376 2203.00 0 2 0.00 0.00 0.00

2014-12-01 17:03:01 4085173.00 8195.00 11.00 349 0 371 0 11195 1929.00 0 5 0.00 0.00 0.00

2014-12-01 17:04:01 4085175.00 8193.00 24.00 320 0 341 0 10240 1941.00 0 2 0.00 0.00 0.00

2014-12-01 17:05:01 4085173.00 8196.00 27.00 324 0 349 0 10513 2030.00 0 0 0.00 0.00 1.00

2014-12-01 17:06:01 4085164.00 8193.00 18.00 320 0 337 0 10240 2088.00 0 2 0.00 0.00 0.00

2014-12-01 17:07:01 4085165.00 8195.00 33.00 307 0 332 0 9966 2131.00 0 2 0.00 0.00 0.00

2014-12-01 17:08:01 4085166.00 8194.00 39.00 320 0 341 0 10240 2196.00 0 4 0.00 0.00 0.00

2014-12-01 17:09:01 4085167.00 8193.00 4.00 311 0 332 0 9966 2109.00 0 2 0.00 0.00 1.00

2014-12-01 17:10:01 4085167.00 8195.00 39.00 307 0 328 0 9966 2102.00 0 0 0.00 0.00 1.00

2014-12-01 17:11:01 4085164.00 8185.00 1029.00 302 0 320 0 9557 2200.00 0 2 0.00 0.00 0.00

2014-12-01 17:12:01 4085157.00 8192.00 0.00 324 0 349 0 10513 2296.00 0 2 0.00 0.00 0.00

2014-12-01 17:13:01 4085158.00 8192.00 647.00 307 0 332 0 9966 2263.00 0 4 0.00 0.00 0.00

2014-12-01 17:14:01 4085165.00 8185.00 1098.00 307 0 324 0 9693 2353.00 0 2 0.00 0.00 0.00

2014-12-01 17:15:02 4085172.00 8180.00 1122.00 306 0 331 0 10072 2280.00 0 4 0.00 0.00 1.00

2014-12-01 17:16:02 4085148.00 8193.00 50.00 324 0 341 0 10240 2326.00 0 0 0.00 0.00 0.00

2014-12-01 17:17:02 4085148.00 8193.00 0.00 315 0 341 0 10240 2455.00 0 0 0.00 0.00 0.00

2014-12-01 17:18:02 4085148.00 8193.00 13.00 324 0 345 0 10376 2484.00 0 2 0.00 0.00 0.00

2014-12-01 17:19:01 4085149.00 8192.00 28.00 312 0 334 0 10135 2483.00 0 0 0.00 0.00 0.00

2014-12-01 17:20:01 4085149.00 8193.00 31.00 311 0 328 0 9830 2568.00 0 2 0.00 0.00 1.00

2014-12-01 17:21:02 4085135.00 8193.00 22.00 310 0 335 0 10206 1955.00 0 2 0.00 0.00 0.00

2014-12-01 17:22:01 4085135.00 8193.00 21.00 316 0 338 0 9997 1951.00 0 2 0.00 0.00 0.00

2014-12-01 17:23:01 4085136.00 8191.00 38.00 324 0 349 0 10513 2077.00 0 2 0.00 0.00 0.00

2014-12-01 17:24:01 4085135.00 8192.00 29.00 307 0 328 0 9966 2096.00 0 0 0.00 0.00 0.00

2014-12-01 17:25:01 4085133.00 8195.00 0.00 311 0 332 0 9830 2051.00 0 2 0.00 0.00 1.00

2014-12-01 17:26:01 4085124.00 8192.00 7.00 315 0 341 0 10240 1552.00 0 0 0.00 0.00 0.00

2014-12-01 17:27:01 4085125.00 8191.00 33.00 311 0 328 0 9966 1674.00 0 1 0.00 0.00 0.00

2014-12-01 17:28:01 4085123.00 8193.00 30.00 311 0 332 0 10103 1738.00 0 1 0.00 0.00 0.00

2014-12-01 17:29:01 4085124.00 8192.00 29.00 307 0 328 0 9830 1827.00 0 4 0.00 0.00 0.00

2014-12-01 17:30:01 4085121.00 8196.00 37.00 307 0 328 0 9830 1838.00 0 2 0.00 0.00 1.00

2014-12-01 17:31:01 4085113.00 8192.00 39.00 315 0 332 0 10103 1385.00 0 4 0.00 0.00 0.00

2014-12-01 17:32:02 4085113.00 8192.00 873.00 285 0 310 0 9266 1476.00 0 2 0.00 0.00 0.00

2014-12-01 17:33:01 4085113.00 8192.00 859.00 321 0 347 0 10413 1517.00 0 2 0.00 0.00 0.00

2014-12-01 17:34:02 4085113.00 8192.00 0.00 314 0 335 0 10072 1586.00 0 4 0.00 0.00 0.00

2014-12-01 17:35:02 4085119.00 8187.00 974.00 290 0 307 0 9284 1582.00 0 2 0.00 0.00 1.00

2014-12-01 17:36:02 4085099.00 8194.00 7.00 328 0 354 0 10649 1586.00 0 0 0.00 0.00 0.00

2014-12-01 17:37:01 4085101.00 8192.00 22.00 295 0 312 0 9441 1611.00 0 0 0.00 0.00 0.00

2014-12-01 17:38:01 4085100.00 8195.00 24.00 315 0 337 0 10103 1662.00 0 2 0.00 0.00 0.00

2014-12-01 17:39:01 4085102.00 8195.00 36.00 307 0 328 0 9830 1725.00 0 2 0.00 0.00 0.00

2014-12-01 17:40:01 4085106.00 8200.00 28.00 307 0 324 0 9830 1821.00 0 0 0.00 0.00 1.00

2014-12-01 17:41:01 4085107.00 8193.00 0.00 311 0 337 0 10103 1594.00 0 2 0.00 0.00 0.00

2014-12-01 17:42:01 4085105.00 8194.00 30.00 311 0 332 0 9966 1665.00 0 0 0.00 0.00 0.00

2014-12-01 17:43:01 4085106.00 8193.00 31.00 320 0 341 0 10240 1751.00 0 2 0.00 0.00 0.00

2014-12-01 17:44:02 4085105.00 8194.00 35.00 297 0 318 0 9669 1850.00 0 4 0.00 0.00 0.00

2014-12-01 17:45:02 4085105.00 8196.00 7.00 307 0 328 0 9830 1934.00 0 0 0.00 0.00 1.00

2014-12-01 17:46:02 4085094.00 8194.00 0.00 311 0 332 0 9966 1970.00 0 2 0.00 0.00 0.00

2014-12-01 17:47:01 4085094.00 8194.00 11.00 312 0 334 0 9997 2050.00 0 0 0.00 0.00 0.00

Snap Time	Indb_pdata	Indb_pfree	Indb_pdirty	Indb_pflush	Indb_dwrites	Indb_dwritten(k/s)	his_list	Inlog_uckpt	read_views
2014-12-01 16:59:01	4085180.00	8196.00	14.00	302	324	9693	2395.00	2	0.00
2014-12-01 17:00:01	4085181.00	8197.00	17.00	302	324	9830	2476.00	0	1.00
2014-12-01 17:01:01	4085174.00	8193.00	20.00	392	413	12561	2087.00	3	0.00
2014-12-01 17:02:01	4085173.00	8194.00	34.00	320	341	10376	2203.00	2	0.00
2014-12-01 17:03:01	4085173.00	8195.00	11.00	349	371	11195	1929.00	5	0.00
2014-12-01 17:04:01	4085175.00	8193.00	24.00	320	341	10240	1941.00	2	0.00
2014-12-01 17:05:01	4085173.00	8196.00	27.00	324	349	10513	2030.00	0	1.00
2014-12-01 17:06:01	4085164.00	8193.00	18.00	320	337	10240	2088.00	2	0.00
2014-12-01 17:07:01	4085165.00	8195.00	33.00	307	332	9966	2131.00	2	0.00
2014-12-01 17:08:01	4085166.00	8194.00	39.00	320	341	10240	2196.00	4	0.00
2014-12-01 17:09:01	4085167.00	8193.00	4.00	311	332	9966	2109.00	2	1.00
2014-12-01 17:10:01	4085167.00	8195.00	39.00	307	328	9966	2102.00	0	1.00
2014-12-01 17:11:01	4085164.00	8185.00	1029.00	302	320	9557	2200.00	2	0.00
2014-12-01 17:12:01	4085157.00	8192.00	0.00	324	349	10513	2296.00	2	0.00
2014-12-01 17:13:01	4085158.00	8192.00	647.00	307	332	9966	2263.00	4	0.00
2014-12-01 17:14:01	4085165.00	8185.00	1098.00	307	324	9693	2353.00	2	0.00
2014-12-01 17:15:02	4085172.00	8180.00	1122.00	306	331	10072	2280.00	4	1.00
2014-12-01 17:16:02	4085148.00	8193.00	50.00	324	341	10240	2326.00	0	0.00
2014-12-01 17:17:02	4085148.00	8193.00	0.00	315	341	10240	2455.00	0	0.00
2014-12-01 17:18:02	4085148.00	8193.00	13.00	324	345	10376	2484.00	2	0.00
2014-12-01 17:19:01	4085149.00	8192.00	28.00	312	334	10135	2483.00	0	0.00
2014-12-01 17:20:01	4085149.00	8193.00	31.00	311	328	9830	2568.00	2	1.00
2014-12-01 17:21:02	4085135.00	8193.00	22.00	310	335	10206	1955.00	2	0.00
2014-12-01 17:22:01	4085135.00	8193.00	21.00	316	338	9997	1951.00	2	0.00
2014-12-01 17:23:01	4085136.00	8191.00	38.00	324	349	10513	2077.00	2	0.00
2014-12-01 17:24:01	4085135.00	8192.00	29.00	307	328	9966	2096.00	0	0.00
2014-12-01 17:25:01	4085133.00	8195.00	0.00	311	332	9830	2051.00	2	1.00
2014-12-01 17:26:01	4085124.00	8192.00	7.00	315	341	10240	1552.00	0	0.00
2014-12-01 17:27:01	4085125.00	8191.00	33.00	311	328	9966	1674.00	1	0.00
2014-12-01 17:28:01	4085123.00	8193.00	30.00	311	332	10103	1738.00	1	0.00
2014-12-01 17:29:01	4085124.00	8192.00	29.00	307	328	9830	1827.00	4	0.00
2014-12-01 17:30:01	4085121.00	8196.00	37.00	307	328	9830	1838.00	2	1.00
2014-12-01 17:31:01	4085113.00	8192.00	39.00	315	332	10103	1385.00	4	0.00
2014-12-01 17:32:02	4085113.00	8192.00	873.00	285	310	9266	1476.00	2	0.00
2014-12-01 17:33:01	4085113.00	8192.00	859.00	321	347	10413	1517.00	2	0.00
2014-12-01 17:34:02	4085113.00	8192.00	0.00	314	335	10072	1586.00	4	0.00
2014-12-01 17:35:02	4085119.00	8187.00	974.00	290	307	9284	1582.00	2	1.00
2014-12-01 17:36:02	4085099.00	8194.00	7.00	328	354	10649	1586.00	0	0.00
2014-12-01 17:37:01	4085101.00	8192.00	22.00	295	312	9441	1611.00	0	0.00
2014-12-01 17:38:01	4085100.00	8195.00	24.00	315	337	10103	1662.00	2	0.00
2014-12-01 17:39:01	4085102.00	8195.00	36.00	307	328	9830	1725.00	2	0.00
2014-12-01 17:40:01	4085106.00	8200.00	28.00	307	324	9830	1821.00	0	1.00
2014-12-01 17:41:01	4085107.00	8193.00	0.00	311	337	10103	1594.00	2	0.00
2014-12-01 17:42:01	4085105.00	8194.00	30.00	311	332	9966	1665.00	0	0.00
2014-12-01 17:43:01	4085106.00	8193.00	31.00	320	341	10240	1751.00	2	0.00
2014-12-01 17:44:02	4085105.00	8194.00	35.00	297	318	9669	1850.00	4	0.00
2014-12-01 17:45:02	4085105.00	8196.00	7.00	307	328	9830	1934.00	0	1.00
2014-12-01 17:46:02	4085094.00	8194.00	0.00	311	332	9966	1970.00	2	0.00
2014-12-01 17:47:01	4085094.00	8194.00	11.00	312	334	9997	2050.00	0	0.00

MySql peak point Info(you can use myawrsrpt to generate a snap report)

Snap ID Snap Time user system idle iowait load1 load5 Threads_connected Threads_running lock_waits

OS Load Info

Snap Time load1 load5 load15
2014-12-01 16:58:01 1.34 1.93 1.98

2014-12-01 16:59:01 1.75 1.92 1.97

2014-12-01 17:00:01 1.90 1.94 1.97

2014-12-01 17:01:01 1.91 1.94 1.97

2014-12-01 17:02:01 1.85 1.93 1.96

2014-12-01 17:03:01 1.10 1.71 1.88

2014-12-01 17:04:01 1.51 1.70 1.87

2014-12-01 17:05:01 1.71 1.72 1.86

2014-12-01 17:06:01 2.32 1.93 1.92

2014-12-01 17:07:01 1.92 1.89 1.91

2014-12-01 17:08:01 1.70 1.86 1.89

2014-12-01 17:09:01 1.84 1.85 1.89

2014-12-01 17:10:01 2.20 1.95 1.92

2014-12-01 17:11:01 2.99 2.22 2.01

2014-12-01 17:12:01 2.91 2.33 2.06

2014-12-01 17:13:01 2.64 2.38 2.09

2014-12-01 17:14:01 2.81 2.47 2.14

2014-12-01 17:15:02 2.65 2.50 2.17

2014-12-01 17:16:02 2.73 2.56 2.21

2014-12-01 17:17:02 1.99 2.40 2.18

2014-12-01 17:18:02 2.22 2.39 2.18

2014-12-01 17:19:01 2.26 2.38 2.19

2014-12-01 17:20:01 1.78 2.22 2.15

2014-12-01 17:21:02 1.91 2.20 2.15

2014-12-01 17:22:01 1.50 2.04 2.09

2014-12-01 17:23:01 1.39 1.92 2.05

2014-12-01 17:24:01 1.93 1.99 2.06

2014-12-01 17:25:01 2.07 1.99 2.06

2014-12-01 17:26:01 2.34 2.08 2.08

2014-12-01 17:27:01 2.45 2.18 2.12

2014-12-01 17:28:01 2.25 2.16 2.11

2014-12-01 17:29:01 2.61 2.26 2.14

2014-12-01 17:30:01 2.06 2.20 2.13

2014-12-01 17:31:01 2.60 2.35 2.19

2014-12-01 17:32:02 2.58 2.40 2.21

2014-12-01 17:33:01 2.23 2.32 2.19

2014-12-01 17:34:02 1.54 2.10 2.12

2014-12-01 17:35:02 2.07 2.13 2.13

2014-12-01 17:36:02 2.16 2.16 2.14

2014-12-01 17:37:01 2.51 2.24 2.16

2014-12-01 17:38:01 1.93 2.14 2.13

2014-12-01 17:39:01 2.62 2.26 2.17

2014-12-01 17:40:01 2.80 2.37 2.21

2014-12-01 17:41:01 2.53 2.36 2.21

2014-12-01 17:42:01 2.28 2.32 2.21

2014-12-01 17:43:01 2.27 2.32 2.21

2014-12-01 17:44:02 2.12 2.27 2.20

2014-12-01 17:45:02 1.58 2.08 2.14

2014-12-01 17:46:02 1.75 2.05 2.12

2014-12-01 17:47:01 1.95 2.04 2.11

Snap Time	load1	load5	load15
2014-12-01 16:58:01	1.34	1.93	1.98
2014-12-01 16:59:01	1.75	1.92	1.97
2014-12-01 17:00:01	1.90	1.94	1.97
2014-12-01 17:01:01	1.91	1.94	1.97
2014-12-01 17:02:01	1.85	1.93	1.96
2014-12-01 17:03:01	1.10	1.71	1.88
2014-12-01 17:04:01	1.51	1.70	1.87
2014-12-01 17:05:01	1.71	1.72	1.86
2014-12-01 17:06:01	2.32	1.93	1.92
2014-12-01 17:07:01	1.92	1.89	1.91
2014-12-01 17:08:01	1.70	1.86	1.89
2014-12-01 17:09:01	1.84	1.85	1.89
2014-12-01 17:10:01	2.20	1.95	1.92
2014-12-01 17:11:01	2.99	2.22	2.01
2014-12-01 17:12:01	2.91	2.33	2.06
2014-12-01 17:13:01	2.64	2.38	2.09
2014-12-01 17:14:01	2.81	2.47	2.14
2014-12-01 17:15:02	2.65	2.50	2.17
2014-12-01 17:16:02	2.73	2.56	2.21
2014-12-01 17:17:02	1.99	2.40	2.18
2014-12-01 17:18:02	2.22	2.39	2.18
2014-12-01 17:19:01	2.26	2.38	2.19
2014-12-01 17:20:01	1.78	2.22	2.15
2014-12-01 17:21:02	1.91	2.20	2.15
2014-12-01 17:22:01	1.50	2.04	2.09
2014-12-01 17:23:01	1.39	1.92	2.05
2014-12-01 17:24:01	1.93	1.99	2.06
2014-12-01 17:25:01	2.07	1.99	2.06
2014-12-01 17:26:01	2.34	2.08	2.08
2014-12-01 17:27:01	2.45	2.18	2.12
2014-12-01 17:28:01	2.25	2.16	2.11
2014-12-01 17:29:01	2.61	2.26	2.14
2014-12-01 17:30:01	2.06	2.20	2.13
2014-12-01 17:31:01	2.60	2.35	2.19
2014-12-01 17:32:02	2.58	2.40	2.21
2014-12-01 17:33:01	2.23	2.32	2.19
2014-12-01 17:34:02	1.54	2.10	2.12
2014-12-01 17:35:02	2.07	2.13	2.13
2014-12-01 17:36:02	2.16	2.16	2.14
2014-12-01 17:37:01	2.51	2.24	2.16
2014-12-01 17:38:01	1.93	2.14	2.13
2014-12-01 17:39:01	2.62	2.26	2.17
2014-12-01 17:40:01	2.80	2.37	2.21
2014-12-01 17:41:01	2.53	2.36	2.21
2014-12-01 17:42:01	2.28	2.32	2.21
2014-12-01 17:43:01	2.27	2.32	2.21
2014-12-01 17:44:02	2.12	2.27	2.20
2014-12-01 17:45:02	1.58	2.08	2.14
2014-12-01 17:46:02	1.75	2.05	2.12
2014-12-01 17:47:01	1.95	2.04	2.11

OS CPU Info

Snap Time user system idle iowait
2014-12-01 16:58:01 6.00 3.00 91.00 0.00

2014-12-01 16:59:01 5.00 5.00 89.00 0.00

2014-12-01 17:00:01 13.00 5.00 82.00 0.00

2014-12-01 17:01:01 6.00 6.00 88.00 0.00

2014-12-01 17:02:01 5.00 5.00 89.00 0.00

2014-12-01 17:03:01 6.00 3.00 91.00 0.00

2014-12-01 17:04:01 10.00 5.00 85.00 0.00

2014-12-01 17:05:01 6.00 3.00 91.00 0.00

2014-12-01 17:06:01 8.00 5.00 86.00 0.00

2014-12-01 17:07:01 11.00 6.00 80.00 3.00

2014-12-01 17:08:01 8.00 5.00 87.00 0.00

2014-12-01 17:09:01 6.00 6.00 89.00 0.00

2014-12-01 17:10:01 14.00 12.00 74.00 0.00

2014-12-01 17:11:01 7.00 7.00 86.00 0.00

2014-12-01 17:12:01 6.00 3.00 91.00 0.00

2014-12-01 17:13:01 10.00 5.00 85.00 0.00

2014-12-01 17:14:01 11.00 5.00 84.00 0.00

2014-12-01 17:15:02 10.00 3.00 85.00 3.00

2014-12-01 17:16:02 13.00 5.00 82.00 0.00

2014-12-01 17:17:02 9.00 3.00 89.00 0.00

2014-12-01 17:18:02 5.00 5.00 89.00 0.00

2014-12-01 17:19:01 8.00 5.00 87.00 0.00

2014-12-01 17:20:01 14.00 5.00 81.00 0.00

2014-12-01 17:21:02 11.00 8.00 81.00 0.00

2014-12-01 17:22:01 6.00 3.00 92.00 0.00

2014-12-01 17:23:01 6.00 6.00 89.00 0.00

2014-12-01 17:24:01 5.00 5.00 89.00 0.00

2014-12-01 17:25:01 8.00 3.00 89.00 0.00

2014-12-01 17:26:01 8.00 3.00 89.00 0.00

2014-12-01 17:27:01 12.00 5.00 83.00 0.00

2014-12-01 17:28:01 14.00 8.00 78.00 0.00

2014-12-01 17:29:01 8.00 5.00 87.00 0.00

2014-12-01 17:30:01 17.00 6.00 78.00 0.00

2014-12-01 17:31:01 10.00 3.00 87.00 0.00

2014-12-01 17:32:02 9.00 3.00 88.00 0.00

2014-12-01 17:33:01 11.00 6.00 83.00 0.00

2014-12-01 17:34:02 13.00 5.00 82.00 0.00

2014-12-01 17:35:02 9.00 3.00 88.00 0.00

2014-12-01 17:36:02 6.00 3.00 92.00 0.00

2014-12-01 17:37:01 8.00 5.00 88.00 0.00

2014-12-01 17:38:01 9.00 3.00 89.00 0.00

2014-12-01 17:39:01 6.00 6.00 89.00 0.00

2014-12-01 17:40:01 15.00 3.00 82.00 0.00

2014-12-01 17:41:01 5.00 3.00 92.00 0.00

2014-12-01 17:42:01 11.00 5.00 84.00 0.00

2014-12-01 17:43:01 5.00 5.00 89.00 0.00

2014-12-01 17:44:02 8.00 5.00 87.00 0.00

2014-12-01 17:45:02 12.00 3.00 85.00 0.00

2014-12-01 17:46:02 8.00 5.00 87.00 0.00

2014-12-01 17:47:01 12.00 3.00 85.00 0.00

Snap Time	user	system	idle	iowait
2014-12-01 16:58:01	6.00	3.00	91.00	0.00
2014-12-01 16:59:01	5.00	5.00	89.00	0.00
2014-12-01 17:00:01	13.00	5.00	82.00	0.00
2014-12-01 17:01:01	6.00	6.00	88.00	0.00
2014-12-01 17:02:01	5.00	5.00	89.00	0.00
2014-12-01 17:03:01	6.00	3.00	91.00	0.00
2014-12-01 17:04:01	10.00	5.00	85.00	0.00
2014-12-01 17:05:01	6.00	3.00	91.00	0.00
2014-12-01 17:06:01	8.00	5.00	86.00	0.00
2014-12-01 17:07:01	11.00	6.00	80.00	3.00
2014-12-01 17:08:01	8.00	5.00	87.00	0.00
2014-12-01 17:09:01	6.00	6.00	89.00	0.00
2014-12-01 17:10:01	14.00	12.00	74.00	0.00
2014-12-01 17:11:01	7.00	7.00	86.00	0.00
2014-12-01 17:12:01	6.00	3.00	91.00	0.00
2014-12-01 17:13:01	10.00	5.00	85.00	0.00
2014-12-01 17:14:01	11.00	5.00	84.00	0.00
2014-12-01 17:15:02	10.00	3.00	85.00	3.00
2014-12-01 17:16:02	13.00	5.00	82.00	0.00
2014-12-01 17:17:02	9.00	3.00	89.00	0.00
2014-12-01 17:18:02	5.00	5.00	89.00	0.00
2014-12-01 17:19:01	8.00	5.00	87.00	0.00
2014-12-01 17:20:01	14.00	5.00	81.00	0.00
2014-12-01 17:21:02	11.00	8.00	81.00	0.00
2014-12-01 17:22:01	6.00	3.00	92.00	0.00
2014-12-01 17:23:01	6.00	6.00	89.00	0.00
2014-12-01 17:24:01	5.00	5.00	89.00	0.00
2014-12-01 17:25:01	8.00	3.00	89.00	0.00
2014-12-01 17:26:01	8.00	3.00	89.00	0.00
2014-12-01 17:27:01	12.00	5.00	83.00	0.00
2014-12-01 17:28:01	14.00	8.00	78.00	0.00
2014-12-01 17:29:01	8.00	5.00	87.00	0.00
2014-12-01 17:30:01	17.00	6.00	78.00	0.00
2014-12-01 17:31:01	10.00	3.00	87.00	0.00
2014-12-01 17:32:02	9.00	3.00	88.00	0.00
2014-12-01 17:33:01	11.00	6.00	83.00	0.00
2014-12-01 17:34:02	13.00	5.00	82.00	0.00
2014-12-01 17:35:02	9.00	3.00	88.00	0.00
2014-12-01 17:36:02	6.00	3.00	92.00	0.00
2014-12-01 17:37:01	8.00	5.00	88.00	0.00
2014-12-01 17:38:01	9.00	3.00	89.00	0.00
2014-12-01 17:39:01	6.00	6.00	89.00	0.00
2014-12-01 17:40:01	15.00	3.00	82.00	0.00
2014-12-01 17:41:01	5.00	3.00	92.00	0.00
2014-12-01 17:42:01	11.00	5.00	84.00	0.00
2014-12-01 17:43:01	5.00	5.00	89.00	0.00
2014-12-01 17:44:02	8.00	5.00	87.00	0.00
2014-12-01 17:45:02	12.00	3.00	85.00	0.00
2014-12-01 17:46:02	8.00	5.00	87.00	0.00
2014-12-01 17:47:01	12.00	3.00	85.00	0.00

OS IO Info

Snap Time rd_ios_s wr_ios_s rkbs wkbs queue svc_t busy
2014-12-01 16:58:01 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2014-12-01 16:59:01 0.00 1073.68 0.00 4294.74 0.00 0.00 0.00

2014-12-01 17:00:01 0.00 1578.95 0.00 6315.79 0.00 0.00 0.00

2014-12-01 17:01:01 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2014-12-01 17:02:01 0.00 583.78 0.00 3113.51 0.06 0.11 6.49

2014-12-01 17:03:01 0.00 1165.71 0.00 4662.86 0.00 0.00 0.00

2014-12-01 17:04:01 0.00 984.62 0.00 3938.46 0.12 0.12 12.31

2014-12-01 17:05:01 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2014-12-01 17:06:01 0.00 1556.76 0.00 6227.03 0.00 0.00 0.00

2014-12-01 17:07:01 754.29 2331.43 12068.57 10148.57 0.34 0.09 27.43

2014-12-01 17:08:01 0.00 505.26 0.00 2778.95 0.00 0.00 0.00

2014-12-01 17:09:01 0.00 4466.67 0.00 34666.67 0.67 0.09 40.00

2014-12-01 17:10:01 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2014-12-01 17:11:01 0.00 2400.00 0.00 10593.10 0.08 0.03 8.28

2014-12-01 17:12:01 0.00 548.57 0.00 2194.29 0.00 0.00 0.00

2014-12-01 17:13:01 0.00 1440.00 0.00 5760.00 0.12 0.04 6.00

2014-12-01 17:14:01 0.00 1894.74 0.00 8589.47 0.19 0.07 12.63

2014-12-01 17:15:02 184.62 492.31 2953.85 1969.23 1.11 1.45 98.46

2014-12-01 17:16:02 0.00 1389.47 0.00 13389.47 0.13 0.05 6.32

2014-12-01 17:17:02 0.00 2331.43 0.00 10148.57 0.07 0.03 6.86

2014-12-01 17:18:02 0.00 1578.95 0.00 7073.68 0.13 0.04 6.32

2014-12-01 17:19:01 0.00 1600.00 0.00 7138.46 0.12 0.04 6.15

2014-12-01 17:20:01 0.00 2400.00 0.00 10897.30 0.39 0.11 25.95

2014-12-01 17:21:02 0.00 2000.00 0.00 8000.00 0.00 0.00 0.00

2014-12-01 17:22:01 0.00 3400.00 0.00 23733.33 0.07 0.02 6.67

2014-12-01 17:23:01 0.00 822.86 0.00 3291.43 0.14 0.17 13.71

2014-12-01 17:24:01 0.00 1037.84 0.00 4151.35 0.06 0.06 6.49

2014-12-01 17:25:01 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2014-12-01 17:26:01 0.00 1894.74 0.00 8589.47 0.06 0.03 6.32

2014-12-01 17:27:01 0.00 3657.14 0.00 15542.86 0.40 0.06 22.86

2014-12-01 17:28:01 0.00 3243.24 0.00 14270.27 0.19 0.06 19.46

2014-12-01 17:29:01 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2014-12-01 17:30:01 0.00 7800.00 0.00 162666.67 0.67 0.03 20.00

2014-12-01 17:31:01 0.00 553.85 0.00 3200.00 0.00 0.00 0.00

2014-12-01 17:32:02 0.00 600.00 0.00 4500.00 0.00 0.00 0.00

2014-12-01 17:33:01 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2014-12-01 17:34:02 0.00 2778.95 0.00 12126.32 0.32 0.09 25.26

2014-12-01 17:35:02 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2014-12-01 17:36:02 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2014-12-01 17:37:01 0.00 1020.00 0.00 5040.00 0.00 0.00 0.00

2014-12-01 17:38:01 0.00 2194.29 0.00 9600.00 0.00 0.00 0.00

2014-12-01 17:39:01 0.00 1600.00 0.00 6666.67 0.00 0.00 0.00

2014-12-01 17:40:01 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2014-12-01 17:41:01 0.00 518.92 0.00 2335.14 0.00 0.00 0.00

2014-12-01 17:42:01 0.00 1515.79 0.00 6063.16 0.19 0.08 12.63

2014-12-01 17:43:01 0.00 518.92 0.00 2075.68 0.00 0.00 0.00

2014-12-01 17:44:02 0.00 1831.58 0.00 8084.21 0.13 0.03 6.32

2014-12-01 17:45:02 0.00 2964.71 0.00 12705.88 0.14 0.02 7.06

2014-12-01 17:46:02 0.00 821.05 0.00 3284.21 0.00 0.00 0.00

2014-12-01 17:47:01 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Snap Time	rd_ios_s	wr_ios_s	rkbs	wkbs	queue	svc_t	busy
2014-12-01 16:58:01	0.00	0.00	0.00	0.00	0.00	0.00	0.00
2014-12-01 16:59:01	0.00	1073.68	0.00	4294.74	0.00	0.00	0.00
2014-12-01 17:00:01	0.00	1578.95	0.00	6315.79	0.00	0.00	0.00
2014-12-01 17:01:01	0.00	0.00	0.00	0.00	0.00	0.00	0.00
2014-12-01 17:02:01	0.00	583.78	0.00	3113.51	0.06	0.11	6.49
2014-12-01 17:03:01	0.00	1165.71	0.00	4662.86	0.00	0.00	0.00
2014-12-01 17:04:01	0.00	984.62	0.00	3938.46	0.12	0.12	12.31
2014-12-01 17:05:01	0.00	0.00	0.00	0.00	0.00	0.00	0.00
2014-12-01 17:06:01	0.00	1556.76	0.00	6227.03	0.00	0.00	0.00
2014-12-01 17:07:01	754.29	2331.43	12068.57	10148.57	0.34	0.09	27.43
2014-12-01 17:08:01	0.00	505.26	0.00	2778.95	0.00	0.00	0.00
2014-12-01 17:09:01	0.00	4466.67	0.00	34666.67	0.67	0.09	40.00
2014-12-01 17:10:01	0.00	0.00	0.00	0.00	0.00	0.00	0.00
2014-12-01 17:11:01	0.00	2400.00	0.00	10593.10	0.08	0.03	8.28
2014-12-01 17:12:01	0.00	548.57	0.00	2194.29	0.00	0.00	0.00
2014-12-01 17:13:01	0.00	1440.00	0.00	5760.00	0.12	0.04	6.00
2014-12-01 17:14:01	0.00	1894.74	0.00	8589.47	0.19	0.07	12.63
2014-12-01 17:15:02	184.62	492.31	2953.85	1969.23	1.11	1.45	98.46
2014-12-01 17:16:02	0.00	1389.47	0.00	13389.47	0.13	0.05	6.32
2014-12-01 17:17:02	0.00	2331.43	0.00	10148.57	0.07	0.03	6.86
2014-12-01 17:18:02	0.00	1578.95	0.00	7073.68	0.13	0.04	6.32
2014-12-01 17:19:01	0.00	1600.00	0.00	7138.46	0.12	0.04	6.15
2014-12-01 17:20:01	0.00	2400.00	0.00	10897.30	0.39	0.11	25.95
2014-12-01 17:21:02	0.00	2000.00	0.00	8000.00	0.00	0.00	0.00
2014-12-01 17:22:01	0.00	3400.00	0.00	23733.33	0.07	0.02	6.67
2014-12-01 17:23:01	0.00	822.86	0.00	3291.43	0.14	0.17	13.71
2014-12-01 17:24:01	0.00	1037.84	0.00	4151.35	0.06	0.06	6.49
2014-12-01 17:25:01	0.00	0.00	0.00	0.00	0.00	0.00	0.00
2014-12-01 17:26:01	0.00	1894.74	0.00	8589.47	0.06	0.03	6.32
2014-12-01 17:27:01	0.00	3657.14	0.00	15542.86	0.40	0.06	22.86
2014-12-01 17:28:01	0.00	3243.24	0.00	14270.27	0.19	0.06	19.46
2014-12-01 17:29:01	0.00	0.00	0.00	0.00	0.00	0.00	0.00
2014-12-01 17:30:01	0.00	7800.00	0.00	162666.67	0.67	0.03	20.00
2014-12-01 17:31:01	0.00	553.85	0.00	3200.00	0.00	0.00	0.00
2014-12-01 17:32:02	0.00	600.00	0.00	4500.00	0.00	0.00	0.00
2014-12-01 17:33:01	0.00	0.00	0.00	0.00	0.00	0.00	0.00
2014-12-01 17:34:02	0.00	2778.95	0.00	12126.32	0.32	0.09	25.26
2014-12-01 17:35:02	0.00	0.00	0.00	0.00	0.00	0.00	0.00
2014-12-01 17:36:02	0.00	0.00	0.00	0.00	0.00	0.00	0.00
2014-12-01 17:37:01	0.00	1020.00	0.00	5040.00	0.00	0.00	0.00
2014-12-01 17:38:01	0.00	2194.29	0.00	9600.00	0.00	0.00	0.00
2014-12-01 17:39:01	0.00	1600.00	0.00	6666.67	0.00	0.00	0.00
2014-12-01 17:40:01	0.00	0.00	0.00	0.00	0.00	0.00	0.00
2014-12-01 17:41:01	0.00	518.92	0.00	2335.14	0.00	0.00	0.00
2014-12-01 17:42:01	0.00	1515.79	0.00	6063.16	0.19	0.08	12.63
2014-12-01 17:43:01	0.00	518.92	0.00	2075.68	0.00	0.00	0.00
2014-12-01 17:44:02	0.00	1831.58	0.00	8084.21	0.13	0.03	6.32
2014-12-01 17:45:02	0.00	2964.71	0.00	12705.88	0.14	0.02	7.06
2014-12-01 17:46:02	0.00	821.05	0.00	3284.21	0.00	0.00	0.00
2014-12-01 17:47:01	0.00	0.00	0.00	0.00	0.00	0.00	0.00

OS Other Info

Snap Time swap_in swap_out net_recv net_send file_system total_mb used_mb used_pct mount_point
2014-12-01 16:58:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943152.00 36.00 /storage/sas

2014-12-01 16:59:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943159.00 36.00 /storage/sas

2014-12-01 17:00:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943165.00 36.00 /storage/sas

2014-12-01 17:01:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943182.00 36.00 /storage/sas

2014-12-01 17:02:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943190.00 36.00 /storage/sas

2014-12-01 17:03:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943198.00 36.00 /storage/sas

2014-12-01 17:04:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943214.00 36.00 /storage/sas

2014-12-01 17:05:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943232.00 36.00 /storage/sas

2014-12-01 17:06:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943245.00 36.00 /storage/sas

2014-12-01 17:07:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943253.00 36.00 /storage/sas

2014-12-01 17:08:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943268.00 36.00 /storage/sas

2014-12-01 17:09:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943287.00 36.00 /storage/sas

2014-12-01 17:10:01 0.00 41.00 0.00 0.00 /dev/sdb 2814021.00 943291.00 36.00 /storage/sas

2014-12-01 17:11:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943306.00 36.00 /storage/sas

2014-12-01 17:12:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943314.00 36.00 /storage/sas

2014-12-01 17:13:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943324.00 36.00 /storage/sas

2014-12-01 17:14:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943331.00 36.00 /storage/sas

2014-12-01 17:15:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943351.00 36.00 /storage/sas

2014-12-01 17:16:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943370.00 36.00 /storage/sas

2014-12-01 17:17:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943387.00 36.00 /storage/sas

2014-12-01 17:18:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943396.00 36.00 /storage/sas

2014-12-01 17:19:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943414.00 36.00 /storage/sas

2014-12-01 17:20:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943427.00 36.00 /storage/sas

2014-12-01 17:21:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943439.00 36.00 /storage/sas

2014-12-01 17:22:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943446.00 36.00 /storage/sas

2014-12-01 17:23:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943461.00 36.00 /storage/sas

2014-12-01 17:24:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943465.00 36.00 /storage/sas

2014-12-01 17:25:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943475.00 36.00 /storage/sas

2014-12-01 17:26:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943483.00 36.00 /storage/sas

2014-12-01 17:27:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943494.00 36.00 /storage/sas

2014-12-01 17:28:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943512.00 36.00 /storage/sas

2014-12-01 17:29:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943537.00 36.00 /storage/sas

2014-12-01 17:30:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943541.00 36.00 /storage/sas

2014-12-01 17:31:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943568.00 36.00 /storage/sas

2014-12-01 17:32:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943579.00 36.00 /storage/sas

2014-12-01 17:33:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943587.00 36.00 /storage/sas

2014-12-01 17:34:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943593.00 36.00 /storage/sas

2014-12-01 17:35:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943596.00 36.00 /storage/sas

2014-12-01 17:36:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943611.00 36.00 /storage/sas

2014-12-01 17:37:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943618.00 36.00 /storage/sas

2014-12-01 17:38:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943622.00 36.00 /storage/sas

2014-12-01 17:39:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943643.00 36.00 /storage/sas

2014-12-01 17:40:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943660.00 36.00 /storage/sas

2014-12-01 17:41:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943669.00 36.00 /storage/sas

2014-12-01 17:42:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943680.00 36.00 /storage/sas

2014-12-01 17:43:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943697.00 36.00 /storage/sas

2014-12-01 17:44:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943709.00 36.00 /storage/sas

2014-12-01 17:45:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943718.00 36.00 /storage/sas

2014-12-01 17:46:02 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943733.00 36.00 /storage/sas

2014-12-01 17:47:01 0.00 0.00 0.00 0.00 /dev/sdb 2814021.00 943740.00 36.00 /storage/sas

Snap Time	swap_out	file_system	total_mb	used_mb	used_pct	mount_point
2014-12-01 16:58:01	0.00	/dev/sdb	2814021.00	943152.00	36.00	/storage/sas
2014-12-01 16:59:01	0.00	/dev/sdb	2814021.00	943159.00	36.00	/storage/sas
2014-12-01 17:00:01	0.00	/dev/sdb	2814021.00	943165.00	36.00	/storage/sas
2014-12-01 17:01:01	0.00	/dev/sdb	2814021.00	943182.00	36.00	/storage/sas
2014-12-01 17:02:01	0.00	/dev/sdb	2814021.00	943190.00	36.00	/storage/sas
2014-12-01 17:03:01	0.00	/dev/sdb	2814021.00	943198.00	36.00	/storage/sas
2014-12-01 17:04:01	0.00	/dev/sdb	2814021.00	943214.00	36.00	/storage/sas
2014-12-01 17:05:01	0.00	/dev/sdb	2814021.00	943232.00	36.00	/storage/sas
2014-12-01 17:06:01	0.00	/dev/sdb	2814021.00	943245.00	36.00	/storage/sas
2014-12-01 17:07:01	0.00	/dev/sdb	2814021.00	943253.00	36.00	/storage/sas
2014-12-01 17:08:01	0.00	/dev/sdb	2814021.00	943268.00	36.00	/storage/sas
2014-12-01 17:09:01	0.00	/dev/sdb	2814021.00	943287.00	36.00	/storage/sas
2014-12-01 17:10:01	41.00	/dev/sdb	2814021.00	943291.00	36.00	/storage/sas
2014-12-01 17:11:01	0.00	/dev/sdb	2814021.00	943306.00	36.00	/storage/sas
2014-12-01 17:12:01	0.00	/dev/sdb	2814021.00	943314.00	36.00	/storage/sas
2014-12-01 17:13:01	0.00	/dev/sdb	2814021.00	943324.00	36.00	/storage/sas
2014-12-01 17:14:01	0.00	/dev/sdb	2814021.00	943331.00	36.00	/storage/sas
2014-12-01 17:15:02	0.00	/dev/sdb	2814021.00	943351.00	36.00	/storage/sas
2014-12-01 17:16:02	0.00	/dev/sdb	2814021.00	943370.00	36.00	/storage/sas
2014-12-01 17:17:02	0.00	/dev/sdb	2814021.00	943387.00	36.00	/storage/sas
2014-12-01 17:18:02	0.00	/dev/sdb	2814021.00	943396.00	36.00	/storage/sas
2014-12-01 17:19:01	0.00	/dev/sdb	2814021.00	943414.00	36.00	/storage/sas
2014-12-01 17:20:01	0.00	/dev/sdb	2814021.00	943427.00	36.00	/storage/sas
2014-12-01 17:21:02	0.00	/dev/sdb	2814021.00	943439.00	36.00	/storage/sas
2014-12-01 17:22:01	0.00	/dev/sdb	2814021.00	943446.00	36.00	/storage/sas
2014-12-01 17:23:01	0.00	/dev/sdb	2814021.00	943461.00	36.00	/storage/sas
2014-12-01 17:24:01	0.00	/dev/sdb	2814021.00	943465.00	36.00	/storage/sas
2014-12-01 17:25:01	0.00	/dev/sdb	2814021.00	943475.00	36.00	/storage/sas
2014-12-01 17:26:01	0.00	/dev/sdb	2814021.00	943483.00	36.00	/storage/sas
2014-12-01 17:27:01	0.00	/dev/sdb	2814021.00	943494.00	36.00	/storage/sas
2014-12-01 17:28:01	0.00	/dev/sdb	2814021.00	943512.00	36.00	/storage/sas
2014-12-01 17:29:01	0.00	/dev/sdb	2814021.00	943537.00	36.00	/storage/sas
2014-12-01 17:30:01	0.00	/dev/sdb	2814021.00	943541.00	36.00	/storage/sas
2014-12-01 17:31:01	0.00	/dev/sdb	2814021.00	943568.00	36.00	/storage/sas
2014-12-01 17:32:02	0.00	/dev/sdb	2814021.00	943579.00	36.00	/storage/sas
2014-12-01 17:33:01	0.00	/dev/sdb	2814021.00	943587.00	36.00	/storage/sas
2014-12-01 17:34:02	0.00	/dev/sdb	2814021.00	943593.00	36.00	/storage/sas
2014-12-01 17:35:02	0.00	/dev/sdb	2814021.00	943596.00	36.00	/storage/sas
2014-12-01 17:36:02	0.00	/dev/sdb	2814021.00	943611.00	36.00	/storage/sas
2014-12-01 17:37:01	0.00	/dev/sdb	2814021.00	943618.00	36.00	/storage/sas
2014-12-01 17:38:01	0.00	/dev/sdb	2814021.00	943622.00	36.00	/storage/sas
2014-12-01 17:39:01	0.00	/dev/sdb	2814021.00	943643.00	36.00	/storage/sas
2014-12-01 17:40:01	0.00	/dev/sdb	2814021.00	943660.00	36.00	/storage/sas
2014-12-01 17:41:01	0.00	/dev/sdb	2814021.00	943669.00	36.00	/storage/sas
2014-12-01 17:42:01	0.00	/dev/sdb	2814021.00	943680.00	36.00	/storage/sas
2014-12-01 17:43:01	0.00	/dev/sdb	2814021.00	943697.00	36.00	/storage/sas
2014-12-01 17:44:02	0.00	/dev/sdb	2814021.00	943709.00	36.00	/storage/sas
2014-12-01 17:45:02	0.00	/dev/sdb	2814021.00	943718.00	36.00	/storage/sas
2014-12-01 17:46:02	0.00	/dev/sdb	2814021.00	943733.00	36.00	/storage/sas
2014-12-01 17:47:01	0.00	/dev/sdb	2814021.00	943740.00	36.00	/storage/sas

TOP SLOW SQL

checksum db name ts_min ts_max ts_cnt Query_time_sum Query_time_pct_95 Lock_time_sum Lock_time_pct_95 Rows_sent_sum Rows_sent_pct_95 sample
2421751182617816582 zabbix 2014-12-01 16:30:31 2014-12-01 17:25:30 12 353.774 28.7497 0.074655 0.0075447 0 0 insert into tmp_his ...

checksum	db name	ts_min	ts_max	ts_cnt	Query_time_sum	Query_time_pct_95	Lock_time_sum	Lock_time_pct_95	Rows_sent_sum	Rows_sent_pct_95	sample
2421751182617816582	zabbix	2014-12-01 16:30:31	2014-12-01 17:25:30	12	353.774	28.7497	0.074655	0.0075447	0	0	insert into tmp_his ...

TOP SQL DETAIL

checksum sql detail
2421751182617816582 insert into tmp_his select h.hostid,i.itemid,hi.value,hi.clock,i.name,h.name from hosts h, items i,(select a.itemid,a.value,a.clock from history a, (select max(clock) clock,itemid from history group by itemid) b where a.itemid=b.itemid and a.clock=b.clock) hi where h.hostid=i.hostid and i.itemid=hi.itemid and i.key_ in ('system.cpu.load[percpu,avg1]','iostat[iops]','system.cpu.util[,idle]','vm.memory.usage')