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 2m 21d 20h 5mi 6s

Host Name	Ip addr	Port	Db role	Version	Uptime
a1-dba-tech01.hz	10.128.6.21	3309	master	5.6.17	0y 2m 21d 20h 5mi 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: 13570 2014-08-29 03:40:02 55.00 2.00
End Snap: 14003 2014-08-29 10:53:02 56.00 2.00
Elapsed: 25980 (seconds)

	Snap Id	Snap Time	Threads_connected	Threads_running
Begin Snap:	13570	2014-08-29 03:40:02	55.00	2.00
End Snap:	14003	2014-08-29 10:53:02	56.00	2.00
Elapsed:	25980 (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 : 64.00 64.00 0

Threads_connected : 55.00 56.00 1

Threads_cached : 7.00 6.00 -1

Threads_created : 129.00 129.00 0

Threads_running : 2.00 2.00 0

Connections : 6937360.00 6962712.00 25352

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 : 4666632704.00 4689440768.00 22808064

Key_reads : 6.00 6.00 0

Key_write_requests : 1084680576.00 1089544960.00 4864384

Key_writes : 14.00 14.00 0

Questions : 530589984.00 532194240.00 1604256

Com_select : 299831552.00 300729792.00 898240

Com_insert : 16958116.00 17031496.00 73380

Com_update : 54845800.00 55028208.00 182408

Com_delete : 31410.00 31523.00 113

Bytes_received : 88244404224.00 88565956608.00 321552384

Bytes_sent : 1008018980864.00 1011527581696.00 3508600832

Qcache_hits : 0.00 0.00 0

Qcache_inserts : 0.00 0.00 0

Select_full_join : 341591.00 342456.00 865

Select_scan : 15391932.00 15432033.00 40101

Slow_queries : 42.00 42.00 0

Com_commit : 66561384.00 66750368.00 188984

Com_rollback : 59.00 59.00 0

Open_files : 64.00 64.00 0

Open_table_definitions : 194.00 194.00 0

Open_tables : 359.00 359.00 0

Opened_files : 11216930.00 11267133.00 50203

Opened_table_definitions : 198.00 198.00 0

Opened_tables : 370.00 370.00 0

Created_tmp_disk_tables : 2803361.00 2815910.00 12549

Created_tmp_files : 350.00 350.00 0

Created_tmp_tables : 17281098.00 17325480.00 44382

Binlog_cache_disk_use : 46115.00 46303.00 188

Binlog_cache_use : 56408004.00 56598332.00 190328

Aborted_clients : 483.00 483.00 0

Sort_merge_passes : 0.00 0.00 0

Sort_range : 1826008.00 1829394.00 3386

Sort_rows : 3223526656.00 3232870400.00 9343744

Sort_scan : 9867497.00 9888606.00 21109

Table_locks_immediate : 7419970048.00 7421421056.00 1451008

Table_locks_waited : 0.00 0.00 0

Handler_read_first : 11647130.00 11683579.00 36449

Handler_read_key : 21708929024.00 21747750912.00 38821888

Handler_read_last : 24812.00 24812.00 0

Handler_read_next : 16943371264.00 17004293120.00 60921856

Handler_read_prev : 16240111.00 16240111.00 0

Handler_read_rnd : 1449092864.00 1453375872.00 4283008

Innodb_rows_updated : 135278016.00 135534288.00 256272

Innodb_rows_deleted : 155804.00 155931.00 127

Innodb_rows_read : 29217943552.00 29295419392.00 77475840

Innodb_buffer_pool_read_requests: 104735006720.00 104983756800.00 248750080

Innodb_buffer_pool_reads : 371220.00 371237.00 17

Innodb_buffer_pool_pages_data : 4141098.00 4141176.00 78

Innodb_buffer_pool_pages_free : 8192.00 8189.00 -3

Innodb_buffer_pool_pages_dirty : 5899.00 13177.00 7278

Innodb_buffer_pool_pages_flushed: 521111040.00 522683936.00 1572896

Innodb_data_reads : 387364.00 387381.00 17

Innodb_data_writes : 593701056.00 595519872.00 1818816

Innodb_data_read : 6275387392.00 6275665920.00 278528

Innodb_data_written : 17294741733376.00 17347210379264.00 52468645888

Innodb_os_log_fsyncs : 63292736.00 63511304.00 218568

Innodb_os_log_written : 218906050560.00 219833909248.00 927858688

history_list : 3485.00 3545.00 60

log_bytes_written : 202416979968.00 203233067008.00 816087040

log_bytes_flushed : 202416979968.00 203233067008.00 816087040

last_checkpoint : 202413850624.00 203220500480.00 806649856

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 :	64.00	64.00	0
Threads_connected :	55.00	56.00	1
Threads_cached :	7.00	6.00	-1
Threads_created :	129.00	129.00	0
Threads_running :	2.00	2.00	0
Connections :	6937360.00	6962712.00	25352
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 :	4666632704.00	4689440768.00	22808064
Key_reads :	6.00	6.00	0
Key_write_requests :	1084680576.00	1089544960.00	4864384
Key_writes :	14.00	14.00	0
Questions :	530589984.00	532194240.00	1604256
Com_select :	299831552.00	300729792.00	898240
Com_insert :	16958116.00	17031496.00	73380
Com_update :	54845800.00	55028208.00	182408
Com_delete :	31410.00	31523.00	113
Bytes_received :	88244404224.00	88565956608.00	321552384
Bytes_sent :	1008018980864.00	1011527581696.00	3508600832
Qcache_hits :	0.00	0.00	0
Qcache_inserts :	0.00	0.00	0
Select_full_join :	341591.00	342456.00	865
Select_scan :	15391932.00	15432033.00	40101
Slow_queries :	42.00	42.00	0
Com_commit :	66561384.00	66750368.00	188984
Com_rollback :	59.00	59.00	0
Open_files :	64.00	64.00	0
Open_table_definitions :	194.00	194.00	0
Open_tables :	359.00	359.00	0
Opened_files :	11216930.00	11267133.00	50203
Opened_table_definitions :	198.00	198.00	0
Opened_tables :	370.00	370.00	0
Created_tmp_disk_tables :	2803361.00	2815910.00	12549
Created_tmp_files :	350.00	350.00	0
Created_tmp_tables :	17281098.00	17325480.00	44382
Binlog_cache_disk_use :	46115.00	46303.00	188
Binlog_cache_use :	56408004.00	56598332.00	190328
Aborted_clients :	483.00	483.00	0
Sort_merge_passes :	0.00	0.00	0
Sort_range :	1826008.00	1829394.00	3386
Sort_rows :	3223526656.00	3232870400.00	9343744
Sort_scan :	9867497.00	9888606.00	21109
Table_locks_immediate :	7419970048.00	7421421056.00	1451008
Table_locks_waited :	0.00	0.00	0
Handler_read_first :	11647130.00	11683579.00	36449
Handler_read_key :	21708929024.00	21747750912.00	38821888
Handler_read_last :	24812.00	24812.00	0
Handler_read_next :	16943371264.00	17004293120.00	60921856
Handler_read_prev :	16240111.00	16240111.00	0
Handler_read_rnd :	1449092864.00	1453375872.00	4283008
Innodb_rows_updated :	135278016.00	135534288.00	256272
Innodb_rows_deleted :	155804.00	155931.00	127
Innodb_rows_read :	29217943552.00	29295419392.00	77475840
Innodb_buffer_pool_read_requests:	104735006720.00	104983756800.00	248750080
Innodb_buffer_pool_reads :	371220.00	371237.00	17
Innodb_buffer_pool_pages_data :	4141098.00	4141176.00	78
Innodb_buffer_pool_pages_free :	8192.00	8189.00	-3
Innodb_buffer_pool_pages_dirty :	5899.00	13177.00	7278
Innodb_buffer_pool_pages_flushed:	521111040.00	522683936.00	1572896
Innodb_data_reads :	387364.00	387381.00	17
Innodb_data_writes :	593701056.00	595519872.00	1818816
Innodb_data_read :	6275387392.00	6275665920.00	278528
Innodb_data_written :	17294741733376.00	17347210379264.00	52468645888
Innodb_os_log_fsyncs :	63292736.00	63511304.00	218568
Innodb_os_log_written :	218906050560.00	219833909248.00	927858688
history_list :	3485.00	3545.00	60
log_bytes_written :	202416979968.00	203233067008.00	816087040
log_bytes_flushed :	202416979968.00	203233067008.00	816087040
last_checkpoint :	202413850624.00	203220500480.00	806649856
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): 34

Com_insert(s): 2

Com_update(s): 7

Com_delete(s): 0

Innodb t_row PS: 220

Innodb_rows_inserted(s): 210

Innodb_rows_updated(s): 9

Innodb_rows_deleted(s): 0

Innodb_rows_read(s): 2982

Innodb_data_reads(s): 0

Innodb_data_writes(s): 70

Innodb_data_read(kb/s): 0

Innodb_data_written(kb/s): 1972

Innodb_os_log_fsyncs(s): 8

Innodb_os_log_written(kb/s): 34

	Per Second
TPS:	9
Com_select(s):	34
Com_insert(s):	2
Com_update(s):	7
Com_delete(s):	0
Innodb t_row PS:	220
Innodb_rows_inserted(s):	210
Innodb_rows_updated(s):	9
Innodb_rows_deleted(s):	0
Innodb_rows_read(s):	2982
Innodb_data_reads(s):	0
Innodb_data_writes(s):	70
Innodb_data_read(kb/s):	0
Innodb_data_written(kb/s):	1972
Innodb_os_log_fsyncs(s):	8
Innodb_os_log_written(kb/s):	34

Some Key Hits

Percentage

key_buffer_read_hits %: 100

key_buffer_write_hits %: 100

Innodb_buffer_read_hits %: 99.99

Query_cache_hits %: 0

Thread_cache_hits %: 100

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

Top 10 Timed Events

event_name wait time(picsecond) wait count
idle 2749339419871000000 3095558

wait/io/table/sql/handler 361158492515975 111193666

wait/io/file/innodb/innodb_log_file 87786043460885 436951

wait/io/file/innodb/innodb_data_file 69327634626635 1657383

wait/io/file/sql/binlog 59725654595530 981919

wait/io/file/myisam/dfile 39372359580015 19995031

wait/io/file/myisam/kfile 3527027446250 417765

wait/lock/table/sql/handler 1824860691885 2900663

wait/io/file/sql/dbopt 25161801280 3243

wait/io/file/sql/slow_log 4852342880 42

event_name	wait time(picsecond)	wait count
idle	2749339419871000000	3095558
wait/io/table/sql/handler	361158492515975	111193666
wait/io/file/innodb/innodb_log_file	87786043460885	436951
wait/io/file/innodb/innodb_data_file	69327634626635	1657383
wait/io/file/sql/binlog	59725654595530	981919
wait/io/file/myisam/dfile	39372359580015	19995031
wait/io/file/myisam/kfile	3527027446250	417765
wait/lock/table/sql/handler	1824860691885	2900663
wait/io/file/sql/dbopt	25161801280	3243
wait/io/file/sql/slow_log	4852342880	42

event_name	read bytes	read count
wait/io/file/myisam/dfile	1971150401	10391148
wait/io/file/sql/binlog	215152949	583622
wait/io/file/myisam/kfile	7050621	25098
wait/io/file/sql/map	0	0
wait/io/file/myisam/data_tmp	0	0
wait/io/file/sql/trigger	0	0
wait/io/file/sql/relay_log_info	0	0
wait/io/file/sql/master_info	0	0
wait/io/file/sql/global_ddl_log	0	0
wait/io/file/innodb/innodb_log_file	0	0

Top 10 write file Events

event_name read bytes read count
wait/io/file/innodb/innodb_data_file 52109623296 1600257

wait/io/file/myisam/dfile 1147598088 4314766

wait/io/file/innodb/innodb_log_file 926151168 218472

wait/io/file/sql/binlog 215152949 208027

wait/io/file/myisam/kfile 8238045 304824

wait/io/file/sql/slow_log 1372 7

wait/io/file/sql/map 0 0

wait/io/file/myisam/data_tmp 0 0

wait/io/file/sql/trigger 0 0

wait/io/file/sql/relay_log_info 0 0

event_name	read bytes	read count
wait/io/file/innodb/innodb_data_file	52109623296	1600257
wait/io/file/myisam/dfile	1147598088	4314766
wait/io/file/innodb/innodb_log_file	926151168	218472
wait/io/file/sql/binlog	215152949	208027
wait/io/file/myisam/kfile	8238045	304824
wait/io/file/sql/slow_log	1372	7
wait/io/file/sql/map	0	0
wait/io/file/myisam/data_tmp	0	0
wait/io/file/sql/trigger	0	0
wait/io/file/sql/relay_log_info	0	0

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-08-29 03:47:02 2 6 0 29 8 9440 100 204 6 0 2974 7 34 2.00

2014-08-29 03:54:03 2 7 0 39 9 9807 100 205 8 0 3011 8 36 2.00

2014-08-29 04:01:02 2 6 0 31 8 9990 100 232 13 0 3118 8 37 2.00

2014-08-29 04:08:02 2 7 0 37 9 9947 100 227 23 0 3111 8 37 2.00

2014-08-29 04:15:02 2 6 0 29 8 9401 100 205 6 0 2979 7 34 2.00

2014-08-29 04:22:03 2 7 0 36 9 9729 100 207 7 0 3011 8 34 2.00

2014-08-29 04:29:02 2 7 0 42 9 9814 100 204 7 0 3020 8 33 2.00

2014-08-29 04:36:02 2 6 0 32 8 8679 100 205 7 0 2647 8 32 2.00

2014-08-29 04:43:02 2 6 0 31 8 9440 100 205 6 0 2969 8 32 3.00

2014-08-29 04:50:02 2 6 0 33 8 9596 100 202 6 0 2993 8 32 2.00

2014-08-29 04:57:02 2 7 0 36 9 9693 100 205 7 0 2998 8 33 2.00

2014-08-29 05:04:02 2 7 0 32 9 10337 100 251 29 0 3223 8 41 2.00

2014-08-29 05:11:02 2 6 0 35 8 9459 100 209 7 0 2993 8 33 2.00

2014-08-29 05:18:02 3 6 0 29 9 9440 100 208 6 0 2993 8 33 2.00

2014-08-29 05:25:03 2 7 0 46 9 9982 100 204 8 0 3011 9 34 2.00

2014-08-29 05:32:02 2 6 0 31 8 9541 100 204 6 0 2991 8 33 2.00

2014-08-29 05:39:03 2 6 0 34 8 8620 100 204 7 0 2622 8 35 2.00

2014-08-29 05:46:02 2 6 0 29 8 9521 100 205 5 0 2996 7 34 2.00

2014-08-29 05:53:02 2 7 0 38 9 9771 100 205 8 0 3003 8 36 2.00

2014-08-29 06:00:02 2 6 0 31 8 9830 100 203 7 0 3086 8 34 3.00

2014-08-29 06:07:02 2 7 0 36 9 10005 100 253 29 0 3125 8 41 2.00

2014-08-29 06:14:02 2 6 0 31 8 9420 100 207 6 0 3008 8 33 2.00

2014-08-29 06:21:02 3 6 0 33 9 9654 100 208 7 0 2993 8 33 2.00

2014-08-29 06:28:03 2 7 0 44 9 9573 100 205 8 0 2962 9 35 4.00

2014-08-29 06:35:02 2 6 0 30 8 8719 100 202 7 0 2698 8 33 2.00

2014-08-29 06:42:03 2 6 0 33 8 9651 100 204 7 0 2991 8 35 2.00

2014-08-29 06:49:02 2 6 0 30 8 9462 100 205 6 0 2986 8 36 2.00

2014-08-29 06:56:03 2 7 0 38 9 9748 100 204 8 0 3006 8 34 2.00

2014-08-29 07:03:02 3 7 0 32 10 10362 100 250 29 0 3211 8 41 2.00

2014-08-29 07:10:03 2 6 0 35 8 9456 100 210 7 0 3001 8 35 2.00

2014-08-29 07:17:02 2 6 0 29 8 9443 100 206 6 0 2986 7 33 2.00

2014-08-29 07:24:02 2 7 0 44 9 9771 100 208 8 0 3003 9 35 2.00

2014-08-29 07:31:03 2 6 0 33 8 8620 100 204 7 0 2631 8 33 2.00

2014-08-29 07:38:02 2 6 0 35 8 9736 100 205 7 0 3020 8 33 2.00

2014-08-29 07:45:02 2 6 0 29 8 9342 100 201 5 0 2984 7 33 2.00

2014-08-29 07:52:02 2 7 0 37 9 9713 100 204 8 0 3018 8 34 2.00

2014-08-29 07:59:02 2 6 0 32 8 9810 100 205 7 0 3067 8 33 2.00

2014-08-29 08:06:02 3 7 0 35 10 10122 100 255 29 0 3154 8 41 2.00

2014-08-29 08:13:02 2 6 0 32 8 9420 100 205 6 0 2989 7 33 2.00

2014-08-29 08:20:03 3 6 0 31 9 9456 100 206 6 0 2986 8 33 2.00

2014-08-29 08:27:02 2 8 0 46 10 8993 100 206 8 0 2668 9 34 2.00

2014-08-29 08:34:03 2 6 0 28 8 9495 100 205 6 0 2986 7 33 2.00

2014-08-29 08:41:02 2 6 0 34 8 9638 100 204 7 0 3006 8 34 2.00

2014-08-29 08:48:02 2 6 0 30 8 9420 100 204 6 0 2974 8 33 2.00

2014-08-29 08:55:02 2 7 0 38 9 9713 100 203 8 0 2998 8 33 2.00

2014-08-29 09:02:02 2 6 0 31 8 10005 100 236 14 0 3115 8 37 2.00

2014-08-29 09:09:03 3 7 0 36 10 9807 100 224 22 0 3084 8 37 2.00

2014-08-29 09:16:02 2 6 0 29 8 9482 100 207 6 0 2986 7 34 2.00

2014-08-29 09:23:02 2 7 0 40 9 8952 100 206 8 0 2652 9 35 2.00

2014-08-29 09:30:02 2 7 0 37 9 9615 100 203 7 0 3013 8 34 2.00

2014-08-29 09:37:02 2 6 0 33 8 9596 100 204 7 0 2969 8 34 2.00

2014-08-29 09:44:03 2 6 0 31 8 9476 100 204 6 0 2972 7 33 2.00

2014-08-29 09:51:02 2 7 0 35 9 9717 100 205 7 0 3020 8 33 2.00

2014-08-29 09:58:02 2 7 0 35 9 9693 100 204 8 0 3003 8 33 2.00

2014-08-29 10:05:03 3 7 0 34 10 10196 100 252 29 0 3181 8 40 2.00

2014-08-29 10:12:02 2 6 0 34 8 9560 100 207 7 0 3010 8 33 2.00

2014-08-29 10:19:02 2 6 0 29 8 8504 100 208 6 0 2628 7 33 2.00

2014-08-29 10:26:02 2 8 0 49 10 10044 100 205 8 0 3120 9 34 2.00

2014-08-29 10:33:02 2 6 0 27 8 9420 100 206 6 0 2964 7 33 2.00

2014-08-29 10:40:02 2 6 0 34 8 9557 100 202 7 0 2989 8 33 2.00

2014-08-29 10:47:02 2 6 0 29 8 9381 100 204 5 0 2954 7 32 2.00

2014-08-29 10:53:02 2 7 0 39 9 9853 100 206 8 0 3003 8 34 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-08-29 03:47:02	2	6	29	8	9440	100	204	6	2974	7	34	2.00
2014-08-29 03:54:03	2	7	39	9	9807	100	205	8	3011	8	36	2.00
2014-08-29 04:01:02	2	6	31	8	9990	100	232	13	3118	8	37	2.00
2014-08-29 04:08:02	2	7	37	9	9947	100	227	23	3111	8	37	2.00
2014-08-29 04:15:02	2	6	29	8	9401	100	205	6	2979	7	34	2.00
2014-08-29 04:22:03	2	7	36	9	9729	100	207	7	3011	8	34	2.00
2014-08-29 04:29:02	2	7	42	9	9814	100	204	7	3020	8	33	2.00
2014-08-29 04:36:02	2	6	32	8	8679	100	205	7	2647	8	32	2.00
2014-08-29 04:43:02	2	6	31	8	9440	100	205	6	2969	8	32	3.00
2014-08-29 04:50:02	2	6	33	8	9596	100	202	6	2993	8	32	2.00
2014-08-29 04:57:02	2	7	36	9	9693	100	205	7	2998	8	33	2.00
2014-08-29 05:04:02	2	7	32	9	10337	100	251	29	3223	8	41	2.00
2014-08-29 05:11:02	2	6	35	8	9459	100	209	7	2993	8	33	2.00
2014-08-29 05:18:02	3	6	29	9	9440	100	208	6	2993	8	33	2.00
2014-08-29 05:25:03	2	7	46	9	9982	100	204	8	3011	9	34	2.00
2014-08-29 05:32:02	2	6	31	8	9541	100	204	6	2991	8	33	2.00
2014-08-29 05:39:03	2	6	34	8	8620	100	204	7	2622	8	35	2.00
2014-08-29 05:46:02	2	6	29	8	9521	100	205	5	2996	7	34	2.00
2014-08-29 05:53:02	2	7	38	9	9771	100	205	8	3003	8	36	2.00
2014-08-29 06:00:02	2	6	31	8	9830	100	203	7	3086	8	34	3.00
2014-08-29 06:07:02	2	7	36	9	10005	100	253	29	3125	8	41	2.00
2014-08-29 06:14:02	2	6	31	8	9420	100	207	6	3008	8	33	2.00
2014-08-29 06:21:02	3	6	33	9	9654	100	208	7	2993	8	33	2.00
2014-08-29 06:28:03	2	7	44	9	9573	100	205	8	2962	9	35	4.00
2014-08-29 06:35:02	2	6	30	8	8719	100	202	7	2698	8	33	2.00
2014-08-29 06:42:03	2	6	33	8	9651	100	204	7	2991	8	35	2.00
2014-08-29 06:49:02	2	6	30	8	9462	100	205	6	2986	8	36	2.00
2014-08-29 06:56:03	2	7	38	9	9748	100	204	8	3006	8	34	2.00
2014-08-29 07:03:02	3	7	32	10	10362	100	250	29	3211	8	41	2.00
2014-08-29 07:10:03	2	6	35	8	9456	100	210	7	3001	8	35	2.00
2014-08-29 07:17:02	2	6	29	8	9443	100	206	6	2986	7	33	2.00
2014-08-29 07:24:02	2	7	44	9	9771	100	208	8	3003	9	35	2.00
2014-08-29 07:31:03	2	6	33	8	8620	100	204	7	2631	8	33	2.00
2014-08-29 07:38:02	2	6	35	8	9736	100	205	7	3020	8	33	2.00
2014-08-29 07:45:02	2	6	29	8	9342	100	201	5	2984	7	33	2.00
2014-08-29 07:52:02	2	7	37	9	9713	100	204	8	3018	8	34	2.00
2014-08-29 07:59:02	2	6	32	8	9810	100	205	7	3067	8	33	2.00
2014-08-29 08:06:02	3	7	35	10	10122	100	255	29	3154	8	41	2.00
2014-08-29 08:13:02	2	6	32	8	9420	100	205	6	2989	7	33	2.00
2014-08-29 08:20:03	3	6	31	9	9456	100	206	6	2986	8	33	2.00
2014-08-29 08:27:02	2	8	46	10	8993	100	206	8	2668	9	34	2.00
2014-08-29 08:34:03	2	6	28	8	9495	100	205	6	2986	7	33	2.00
2014-08-29 08:41:02	2	6	34	8	9638	100	204	7	3006	8	34	2.00
2014-08-29 08:48:02	2	6	30	8	9420	100	204	6	2974	8	33	2.00
2014-08-29 08:55:02	2	7	38	9	9713	100	203	8	2998	8	33	2.00
2014-08-29 09:02:02	2	6	31	8	10005	100	236	14	3115	8	37	2.00
2014-08-29 09:09:03	3	7	36	10	9807	100	224	22	3084	8	37	2.00
2014-08-29 09:16:02	2	6	29	8	9482	100	207	6	2986	7	34	2.00
2014-08-29 09:23:02	2	7	40	9	8952	100	206	8	2652	9	35	2.00
2014-08-29 09:30:02	2	7	37	9	9615	100	203	7	3013	8	34	2.00
2014-08-29 09:37:02	2	6	33	8	9596	100	204	7	2969	8	34	2.00
2014-08-29 09:44:03	2	6	31	8	9476	100	204	6	2972	7	33	2.00
2014-08-29 09:51:02	2	7	35	9	9717	100	205	7	3020	8	33	2.00
2014-08-29 09:58:02	2	7	35	9	9693	100	204	8	3003	8	33	2.00
2014-08-29 10:05:03	3	7	34	10	10196	100	252	29	3181	8	40	2.00
2014-08-29 10:12:02	2	6	34	8	9560	100	207	7	3010	8	33	2.00
2014-08-29 10:19:02	2	6	29	8	8504	100	208	6	2628	7	33	2.00
2014-08-29 10:26:02	2	8	49	10	10044	100	205	8	3120	9	34	2.00
2014-08-29 10:33:02	2	6	27	8	9420	100	206	6	2964	7	33	2.00
2014-08-29 10:40:02	2	6	34	8	9557	100	202	7	2989	8	33	2.00
2014-08-29 10:47:02	2	6	29	8	9381	100	204	5	2954	7	32	2.00
2014-08-29 10:53:02	2	7	39	9	9853	100	206	8	3003	8	34	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-08-29 03:47:02 4141100.00 8192.00 7126.00 39 0 48 0 1306 3161.00 0 20 0.00 0.00 0.00

2014-08-29 03:54:03 4141105.00 8188.00 5323.00 64 0 74 0 2099 3526.00 0 3 0.00 0.00 0.00

2014-08-29 04:01:02 4141101.00 8193.00 18536.00 34 0 42 0 1129 2900.00 0 14 0.00 0.00 0.00

2014-08-29 04:08:02 4141102.00 8192.00 24641.00 23 0 32 0 799 2875.00 0 40 0.00 0.00 0.00

2014-08-29 04:15:02 4141104.00 8192.00 7873.00 106 0 116 0 3442 3249.00 0 11 0.00 0.00 0.00

2014-08-29 04:22:03 4141103.00 8195.00 7869.00 44 0 53 0 1447 3254.00 0 11 0.00 0.00 0.00

2014-08-29 04:29:02 4141110.00 8192.00 5609.00 21 0 30 0 716 3331.00 0 40 0.00 0.00 0.00

2014-08-29 04:36:02 4141111.00 8194.00 8055.00 48 0 57 0 1587 3297.00 0 14 0.00 0.00 0.00

2014-08-29 04:43:02 4141116.00 8192.00 5552.00 60 0 69 0 1977 3192.00 0 2 0.00 0.00 1.00

2014-08-29 04:50:02 4141117.00 8192.00 8412.00 49 0 58 0 1626 3467.00 0 19 0.00 0.00 0.00

2014-08-29 04:57:02 4141116.00 8193.00 2094.00 82 0 92 0 2677 3349.00 0 0 0.00 0.00 0.00

2014-08-29 05:04:02 4141121.00 8192.00 16461.00 77 0 87 0 2518 2292.00 0 19 0.00 0.00 0.00

2014-08-29 05:11:02 4141122.00 8193.00 4817.00 84 0 95 0 2779 3054.00 0 2 0.00 0.00 0.00

2014-08-29 05:18:02 4141128.00 8194.00 6014.00 118 0 127 0 3781 3241.00 0 2 0.00 0.00 0.00

2014-08-29 05:25:03 4141129.00 8193.00 9647.00 33 0 43 0 1109 3186.00 0 25 0.00 0.00 0.00

2014-08-29 05:32:02 4141133.00 8193.00 8005.00 72 0 82 0 2360 3099.00 0 6 0.00 0.00 0.00

2014-08-29 05:39:03 4141135.00 8192.00 6067.00 92 0 102 0 2994 3579.00 0 2 0.00 0.00 0.00

2014-08-29 05:46:02 4141135.00 8192.00 8811.00 73 0 82 0 2382 3180.00 0 7 0.00 0.00 0.00

2014-08-29 05:53:02 4141135.00 8192.00 10200.00 41 0 51 0 1365 3283.00 0 29 0.00 0.00 0.00

2014-08-29 06:00:02 4141137.00 8191.00 9176.00 45 0 54 0 1477 3398.00 0 21 0.00 0.00 0.00

2014-08-29 06:07:02 4141137.00 8194.00 16388.00 75 0 85 0 2447 2482.00 0 23 0.00 0.00 0.00

2014-08-29 06:14:02 4141140.00 8193.00 11112.00 42 0 51 0 1394 3102.00 0 23 0.00 0.00 0.00

2014-08-29 06:21:02 4141142.00 8193.00 13180.00 0 0 8 0 34 3310.00 0 53 0.00 0.00 0.00

2014-08-29 06:28:03 4141146.00 8192.00 12227.00 23 0 33 0 795 2887.00 0 83 0.00 0.00 1.00

2014-08-29 06:35:02 4141147.00 8192.00 10041.00 45 0 54 0 1478 3482.00 0 18 0.00 0.00 0.00

2014-08-29 06:42:03 4141146.00 8193.00 11143.00 22 0 31 0 758 2869.00 0 41 0.00 0.00 0.00

2014-08-29 06:49:02 4141148.00 8193.00 2387.00 121 0 131 0 3917 3178.00 0 11 0.00 0.00 0.00

2014-08-29 06:56:03 4141152.00 8194.00 10788.00 23 0 32 0 778 3662.00 0 29 0.00 0.00 0.00

2014-08-29 07:03:02 4141154.00 8192.00 27383.00 60 0 70 0 1989 2137.00 0 34 0.00 0.00 0.00

2014-08-29 07:10:03 4141160.00 8188.00 24327.00 23 0 32 0 795 2803.00 0 50 0.00 0.00 0.00

2014-08-29 07:17:02 4141155.00 8193.00 11500.00 126 0 136 0 4078 3645.00 0 16 0.00 0.00 0.00

2014-08-29 07:24:02 4141155.00 8193.00 13721.00 0 0 9 0 34 3020.00 0 46 0.00 0.00 0.00

2014-08-29 07:31:03 4141156.00 8192.00 8687.00 46 0 55 0 1534 3373.00 0 10 0.00 0.00 0.00

2014-08-29 07:38:02 4141158.00 8190.00 11404.00 46 0 55 0 1527 3348.00 0 22 0.00 0.00 0.00

2014-08-29 07:45:02 4141156.00 8192.00 10790.00 88 0 97 0 2869 3123.00 0 10 0.00 0.00 0.00

2014-08-29 07:52:02 4141156.00 8193.00 11712.00 60 0 70 0 1982 3519.00 0 14 0.00 0.00 0.00

2014-08-29 07:59:02 4141157.00 8193.00 7372.00 79 0 88 0 2562 2840.00 0 10 0.00 0.00 0.00

2014-08-29 08:06:02 4141156.00 8194.00 31142.00 23 0 32 0 802 2654.00 0 38 0.00 0.00 0.00

2014-08-29 08:13:02 4141158.00 8192.00 14291.00 71 0 80 0 2321 3068.00 0 53 0.00 0.00 0.00

2014-08-29 08:20:03 4141158.00 8192.00 16259.00 0 0 8 0 31 3334.00 0 82 0.00 0.00 0.00

2014-08-29 08:27:02 4141158.00 8192.00 9302.00 23 0 33 0 799 3241.00 0 83 0.00 0.00 0.00

2014-08-29 08:34:03 4141158.00 8193.00 10874.00 100 0 109 0 3239 3740.00 0 12 0.00 0.00 0.00

2014-08-29 08:41:02 4141159.00 8192.00 10350.00 63 0 72 0 2052 3165.00 0 7 0.00 0.00 0.00

2014-08-29 08:48:02 4141158.00 8193.00 11366.00 46 0 55 0 1526 3173.00 0 14 0.00 0.00 0.00

2014-08-29 08:55:02 4141158.00 8193.00 5827.00 41 0 51 0 1362 3363.00 0 1 0.00 0.00 0.00

2014-08-29 09:02:02 4141158.00 8193.00 16722.00 70 0 79 0 2291 2708.00 0 10 0.00 0.00 0.00

2014-08-29 09:09:03 4141159.00 8192.00 11316.00 71 0 81 0 2317 2776.00 0 26 0.00 0.00 0.00

2014-08-29 09:16:02 4141160.00 8194.00 12104.00 69 0 78 0 2250 3401.00 0 15 0.00 0.00 0.00

2014-08-29 09:23:02 4141165.00 8192.00 12535.00 26 0 37 0 926 2938.00 0 42 0.00 0.00 0.00

2014-08-29 09:30:02 4141166.00 8192.00 10923.00 90 0 99 0 2889 3245.00 0 14 0.00 0.00 0.00

2014-08-29 09:37:02 4141167.00 8192.00 4382.00 88 0 97 0 2857 3320.00 0 17 0.00 0.00 0.00

2014-08-29 09:44:03 4141168.00 8192.00 8575.00 110 0 120 0 3560 3128.00 0 6 0.00 0.00 0.00

2014-08-29 09:51:02 4141169.00 8191.00 12891.00 77 0 87 0 2524 3132.00 0 23 0.00 0.00 0.00

2014-08-29 09:58:02 4141166.00 8195.00 11315.00 47 0 56 0 1536 3646.00 0 14 0.00 0.00 0.00

2014-08-29 10:05:03 4141169.00 8192.00 14168.00 140 0 151 0 4538 2531.00 0 18 0.00 0.00 0.00

2014-08-29 10:12:02 4141166.00 8195.00 11111.00 89 0 99 0 2896 3200.00 0 11 0.00 0.00 0.00

2014-08-29 10:19:02 4141167.00 8194.00 8862.00 103 0 112 0 3335 2944.00 0 10 0.00 0.00 0.00

2014-08-29 10:26:02 4141168.00 8195.00 13359.00 23 0 33 0 787 3187.00 0 32 0.00 0.00 0.00

2014-08-29 10:33:02 4141171.00 8193.00 13068.00 23 0 32 0 794 3376.00 0 50 0.00 0.00 0.00

2014-08-29 10:40:02 4141172.00 8192.00 11317.00 69 0 79 0 2272 2841.00 0 13 0.00 0.00 0.00

2014-08-29 10:47:02 4141172.00 8193.00 9407.00 147 0 158 0 4761 3344.00 0 6 0.00 0.00 0.00

2014-08-29 10:53:02 4141176.00 8189.00 13177.00 27 0 36 0 901 3545.00 0 34 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-08-29 03:47:02	4141100.00	8192.00	7126.00	39	48	1306	3161.00	20	0.00
2014-08-29 03:54:03	4141105.00	8188.00	5323.00	64	74	2099	3526.00	3	0.00
2014-08-29 04:01:02	4141101.00	8193.00	18536.00	34	42	1129	2900.00	14	0.00
2014-08-29 04:08:02	4141102.00	8192.00	24641.00	23	32	799	2875.00	40	0.00
2014-08-29 04:15:02	4141104.00	8192.00	7873.00	106	116	3442	3249.00	11	0.00
2014-08-29 04:22:03	4141103.00	8195.00	7869.00	44	53	1447	3254.00	11	0.00
2014-08-29 04:29:02	4141110.00	8192.00	5609.00	21	30	716	3331.00	40	0.00
2014-08-29 04:36:02	4141111.00	8194.00	8055.00	48	57	1587	3297.00	14	0.00
2014-08-29 04:43:02	4141116.00	8192.00	5552.00	60	69	1977	3192.00	2	1.00
2014-08-29 04:50:02	4141117.00	8192.00	8412.00	49	58	1626	3467.00	19	0.00
2014-08-29 04:57:02	4141116.00	8193.00	2094.00	82	92	2677	3349.00	0	0.00
2014-08-29 05:04:02	4141121.00	8192.00	16461.00	77	87	2518	2292.00	19	0.00
2014-08-29 05:11:02	4141122.00	8193.00	4817.00	84	95	2779	3054.00	2	0.00
2014-08-29 05:18:02	4141128.00	8194.00	6014.00	118	127	3781	3241.00	2	0.00
2014-08-29 05:25:03	4141129.00	8193.00	9647.00	33	43	1109	3186.00	25	0.00
2014-08-29 05:32:02	4141133.00	8193.00	8005.00	72	82	2360	3099.00	6	0.00
2014-08-29 05:39:03	4141135.00	8192.00	6067.00	92	102	2994	3579.00	2	0.00
2014-08-29 05:46:02	4141135.00	8192.00	8811.00	73	82	2382	3180.00	7	0.00
2014-08-29 05:53:02	4141135.00	8192.00	10200.00	41	51	1365	3283.00	29	0.00
2014-08-29 06:00:02	4141137.00	8191.00	9176.00	45	54	1477	3398.00	21	0.00
2014-08-29 06:07:02	4141137.00	8194.00	16388.00	75	85	2447	2482.00	23	0.00
2014-08-29 06:14:02	4141140.00	8193.00	11112.00	42	51	1394	3102.00	23	0.00
2014-08-29 06:21:02	4141142.00	8193.00	13180.00	0	8	34	3310.00	53	0.00
2014-08-29 06:28:03	4141146.00	8192.00	12227.00	23	33	795	2887.00	83	1.00
2014-08-29 06:35:02	4141147.00	8192.00	10041.00	45	54	1478	3482.00	18	0.00
2014-08-29 06:42:03	4141146.00	8193.00	11143.00	22	31	758	2869.00	41	0.00
2014-08-29 06:49:02	4141148.00	8193.00	2387.00	121	131	3917	3178.00	11	0.00
2014-08-29 06:56:03	4141152.00	8194.00	10788.00	23	32	778	3662.00	29	0.00
2014-08-29 07:03:02	4141154.00	8192.00	27383.00	60	70	1989	2137.00	34	0.00
2014-08-29 07:10:03	4141160.00	8188.00	24327.00	23	32	795	2803.00	50	0.00
2014-08-29 07:17:02	4141155.00	8193.00	11500.00	126	136	4078	3645.00	16	0.00
2014-08-29 07:24:02	4141155.00	8193.00	13721.00	0	9	34	3020.00	46	0.00
2014-08-29 07:31:03	4141156.00	8192.00	8687.00	46	55	1534	3373.00	10	0.00
2014-08-29 07:38:02	4141158.00	8190.00	11404.00	46	55	1527	3348.00	22	0.00
2014-08-29 07:45:02	4141156.00	8192.00	10790.00	88	97	2869	3123.00	10	0.00
2014-08-29 07:52:02	4141156.00	8193.00	11712.00	60	70	1982	3519.00	14	0.00
2014-08-29 07:59:02	4141157.00	8193.00	7372.00	79	88	2562	2840.00	10	0.00
2014-08-29 08:06:02	4141156.00	8194.00	31142.00	23	32	802	2654.00	38	0.00
2014-08-29 08:13:02	4141158.00	8192.00	14291.00	71	80	2321	3068.00	53	0.00
2014-08-29 08:20:03	4141158.00	8192.00	16259.00	0	8	31	3334.00	82	0.00
2014-08-29 08:27:02	4141158.00	8192.00	9302.00	23	33	799	3241.00	83	0.00
2014-08-29 08:34:03	4141158.00	8193.00	10874.00	100	109	3239	3740.00	12	0.00
2014-08-29 08:41:02	4141159.00	8192.00	10350.00	63	72	2052	3165.00	7	0.00
2014-08-29 08:48:02	4141158.00	8193.00	11366.00	46	55	1526	3173.00	14	0.00
2014-08-29 08:55:02	4141158.00	8193.00	5827.00	41	51	1362	3363.00	1	0.00
2014-08-29 09:02:02	4141158.00	8193.00	16722.00	70	79	2291	2708.00	10	0.00
2014-08-29 09:09:03	4141159.00	8192.00	11316.00	71	81	2317	2776.00	26	0.00
2014-08-29 09:16:02	4141160.00	8194.00	12104.00	69	78	2250	3401.00	15	0.00
2014-08-29 09:23:02	4141165.00	8192.00	12535.00	26	37	926	2938.00	42	0.00
2014-08-29 09:30:02	4141166.00	8192.00	10923.00	90	99	2889	3245.00	14	0.00
2014-08-29 09:37:02	4141167.00	8192.00	4382.00	88	97	2857	3320.00	17	0.00
2014-08-29 09:44:03	4141168.00	8192.00	8575.00	110	120	3560	3128.00	6	0.00
2014-08-29 09:51:02	4141169.00	8191.00	12891.00	77	87	2524	3132.00	23	0.00
2014-08-29 09:58:02	4141166.00	8195.00	11315.00	47	56	1536	3646.00	14	0.00
2014-08-29 10:05:03	4141169.00	8192.00	14168.00	140	151	4538	2531.00	18	0.00
2014-08-29 10:12:02	4141166.00	8195.00	11111.00	89	99	2896	3200.00	11	0.00
2014-08-29 10:19:02	4141167.00	8194.00	8862.00	103	112	3335	2944.00	10	0.00
2014-08-29 10:26:02	4141168.00	8195.00	13359.00	23	33	787	3187.00	32	0.00
2014-08-29 10:33:02	4141171.00	8193.00	13068.00	23	32	794	3376.00	50	0.00
2014-08-29 10:40:02	4141172.00	8192.00	11317.00	69	79	2272	2841.00	13	0.00
2014-08-29 10:47:02	4141172.00	8193.00	9407.00	147	158	4761	3344.00	6	0.00
2014-08-29 10:53:02	4141176.00	8189.00	13177.00	27	36	901	3545.00	34	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-08-29 03:40:02 0.58 0.86 0.92

2014-08-29 03:47:02 0.81 1.00 0.96

2014-08-29 03:54:03 0.74 0.74 0.84

2014-08-29 04:01:02 0.51 0.61 0.73

2014-08-29 04:08:02 0.89 0.83 0.77

2014-08-29 04:15:02 0.80 1.10 0.94

2014-08-29 04:22:03 0.96 0.82 0.84

2014-08-29 04:29:02 2.37 1.37 1.03

2014-08-29 04:36:02 1.40 1.22 1.08

2014-08-29 04:43:02 1.36 1.04 1.03

2014-08-29 04:50:02 1.97 1.66 1.29

2014-08-29 04:57:02 1.09 1.45 1.33

2014-08-29 05:04:02 1.03 1.28 1.27

2014-08-29 05:11:02 0.52 0.86 1.08

2014-08-29 05:18:02 1.26 0.89 0.98

2014-08-29 05:25:03 0.66 0.73 0.86

2014-08-29 05:32:02 0.46 0.71 0.81

2014-08-29 05:39:03 1.09 0.77 0.77

2014-08-29 05:46:02 0.96 0.93 0.83

2014-08-29 05:53:02 1.13 0.86 0.82

2014-08-29 06:00:02 1.43 1.31 1.02

2014-08-29 06:07:02 1.56 1.25 1.07

2014-08-29 06:14:02 0.74 1.02 1.03

2014-08-29 06:21:02 1.22 0.98 0.96

2014-08-29 06:28:03 1.41 1.08 1.00

2014-08-29 06:35:02 0.74 1.14 1.08

2014-08-29 06:42:03 0.94 0.83 0.94

2014-08-29 06:49:02 1.08 0.98 0.94

2014-08-29 06:56:03 0.69 0.87 0.89

2014-08-29 07:03:02 0.83 0.99 0.94

2014-08-29 07:10:03 1.42 1.07 0.94

2014-08-29 07:17:02 1.19 1.18 1.03

2014-08-29 07:24:02 1.62 1.49 1.23

2014-08-29 07:31:03 1.16 1.20 1.19

2014-08-29 07:38:02 1.25 1.15 1.17

2014-08-29 07:45:02 1.61 1.30 1.22

2014-08-29 07:52:02 1.57 1.39 1.27

2014-08-29 07:59:02 0.95 1.12 1.19

2014-08-29 08:06:02 1.58 1.17 1.14

2014-08-29 08:13:02 0.52 0.84 1.01

2014-08-29 08:20:03 0.97 0.92 0.96

2014-08-29 08:27:02 0.75 0.83 0.89

2014-08-29 08:34:03 1.48 1.11 0.96

2014-08-29 08:41:02 0.89 0.95 0.90

2014-08-29 08:48:02 1.55 1.10 0.96

2014-08-29 08:55:02 0.97 1.23 1.08

2014-08-29 09:02:02 0.74 1.11 1.11

2014-08-29 09:09:03 0.71 0.81 0.96

2014-08-29 09:16:02 1.10 0.97 0.96

2014-08-29 09:23:02 0.98 0.97 0.96

2014-08-29 09:30:02 0.63 0.93 0.97

2014-08-29 09:37:02 0.95 0.81 0.89

2014-08-29 09:44:03 0.65 0.90 0.93

2014-08-29 09:51:02 1.25 0.83 0.84

2014-08-29 09:58:02 0.86 0.85 0.86

2014-08-29 10:05:03 0.81 1.00 0.93

2014-08-29 10:12:02 0.46 0.81 0.88

2014-08-29 10:19:02 0.97 0.89 0.88

2014-08-29 10:26:02 0.96 0.98 0.92

2014-08-29 10:33:02 1.18 0.97 0.91

2014-08-29 10:40:02 0.91 0.88 0.88

2014-08-29 10:47:02 1.05 1.14 1.00

2014-08-29 10:53:02 0.59 1.00 1.00

Snap Time	load1	load5	load15
2014-08-29 03:40:02	0.58	0.86	0.92
2014-08-29 03:47:02	0.81	1.00	0.96
2014-08-29 03:54:03	0.74	0.74	0.84
2014-08-29 04:01:02	0.51	0.61	0.73
2014-08-29 04:08:02	0.89	0.83	0.77
2014-08-29 04:15:02	0.80	1.10	0.94
2014-08-29 04:22:03	0.96	0.82	0.84
2014-08-29 04:29:02	2.37	1.37	1.03
2014-08-29 04:36:02	1.40	1.22	1.08
2014-08-29 04:43:02	1.36	1.04	1.03
2014-08-29 04:50:02	1.97	1.66	1.29
2014-08-29 04:57:02	1.09	1.45	1.33
2014-08-29 05:04:02	1.03	1.28	1.27
2014-08-29 05:11:02	0.52	0.86	1.08
2014-08-29 05:18:02	1.26	0.89	0.98
2014-08-29 05:25:03	0.66	0.73	0.86
2014-08-29 05:32:02	0.46	0.71	0.81
2014-08-29 05:39:03	1.09	0.77	0.77
2014-08-29 05:46:02	0.96	0.93	0.83
2014-08-29 05:53:02	1.13	0.86	0.82
2014-08-29 06:00:02	1.43	1.31	1.02
2014-08-29 06:07:02	1.56	1.25	1.07
2014-08-29 06:14:02	0.74	1.02	1.03
2014-08-29 06:21:02	1.22	0.98	0.96
2014-08-29 06:28:03	1.41	1.08	1.00
2014-08-29 06:35:02	0.74	1.14	1.08
2014-08-29 06:42:03	0.94	0.83	0.94
2014-08-29 06:49:02	1.08	0.98	0.94
2014-08-29 06:56:03	0.69	0.87	0.89
2014-08-29 07:03:02	0.83	0.99	0.94
2014-08-29 07:10:03	1.42	1.07	0.94
2014-08-29 07:17:02	1.19	1.18	1.03
2014-08-29 07:24:02	1.62	1.49	1.23
2014-08-29 07:31:03	1.16	1.20	1.19
2014-08-29 07:38:02	1.25	1.15	1.17
2014-08-29 07:45:02	1.61	1.30	1.22
2014-08-29 07:52:02	1.57	1.39	1.27
2014-08-29 07:59:02	0.95	1.12	1.19
2014-08-29 08:06:02	1.58	1.17	1.14
2014-08-29 08:13:02	0.52	0.84	1.01
2014-08-29 08:20:03	0.97	0.92	0.96
2014-08-29 08:27:02	0.75	0.83	0.89
2014-08-29 08:34:03	1.48	1.11	0.96
2014-08-29 08:41:02	0.89	0.95	0.90
2014-08-29 08:48:02	1.55	1.10	0.96
2014-08-29 08:55:02	0.97	1.23	1.08
2014-08-29 09:02:02	0.74	1.11	1.11
2014-08-29 09:09:03	0.71	0.81	0.96
2014-08-29 09:16:02	1.10	0.97	0.96
2014-08-29 09:23:02	0.98	0.97	0.96
2014-08-29 09:30:02	0.63	0.93	0.97
2014-08-29 09:37:02	0.95	0.81	0.89
2014-08-29 09:44:03	0.65	0.90	0.93
2014-08-29 09:51:02	1.25	0.83	0.84
2014-08-29 09:58:02	0.86	0.85	0.86
2014-08-29 10:05:03	0.81	1.00	0.93
2014-08-29 10:12:02	0.46	0.81	0.88
2014-08-29 10:19:02	0.97	0.89	0.88
2014-08-29 10:26:02	0.96	0.98	0.92
2014-08-29 10:33:02	1.18	0.97	0.91
2014-08-29 10:40:02	0.91	0.88	0.88
2014-08-29 10:47:02	1.05	1.14	1.00
2014-08-29 10:53:02	0.59	1.00	1.00

OS CPU Info

Snap Time user system idle iowait
2014-08-29 03:40:02 0.00 0.00 100.00 0.00

2014-08-29 03:47:02 0.00 0.00 100.00 0.00

2014-08-29 03:54:03 4.00 1.00 95.00 0.00

2014-08-29 04:01:02 0.00 0.00 100.00 0.00

2014-08-29 04:08:02 0.00 0.00 100.00 0.00

2014-08-29 04:15:02 2.00 0.00 97.00 0.00

2014-08-29 04:22:03 0.00 0.00 100.00 0.00

2014-08-29 04:29:02 0.00 0.00 100.00 0.00

2014-08-29 04:36:02 2.00 0.00 97.00 0.00

2014-08-29 04:43:02 1.00 0.00 99.00 0.00

2014-08-29 04:50:02 0.00 0.00 99.00 0.00

2014-08-29 04:57:02 2.00 0.00 97.00 0.00

2014-08-29 05:04:02 0.00 0.00 100.00 0.00

2014-08-29 05:11:02 0.00 0.00 99.00 0.00

2014-08-29 05:18:02 2.00 0.00 97.00 0.00

2014-08-29 05:25:03 0.00 0.00 99.00 0.00

2014-08-29 05:32:02 0.00 0.00 100.00 0.00

2014-08-29 05:39:03 2.00 0.00 97.00 0.00

2014-08-29 05:46:02 0.00 0.00 100.00 0.00

2014-08-29 05:53:02 0.00 0.00 100.00 0.00

2014-08-29 06:00:02 3.00 0.00 97.00 0.00

2014-08-29 06:07:02 0.00 0.00 100.00 0.00

2014-08-29 06:14:02 0.00 0.00 100.00 0.00

2014-08-29 06:21:02 3.00 0.00 97.00 0.00

2014-08-29 06:28:03 3.00 1.00 97.00 0.00

2014-08-29 06:35:02 0.00 0.00 100.00 0.00

2014-08-29 06:42:03 2.00 0.00 97.00 0.00

2014-08-29 06:49:02 0.00 0.00 100.00 0.00

2014-08-29 06:56:03 0.00 0.00 100.00 0.00

2014-08-29 07:03:02 3.00 0.00 97.00 0.00

2014-08-29 07:10:03 0.00 0.00 100.00 0.00

2014-08-29 07:17:02 1.00 0.00 98.00 0.00

2014-08-29 07:24:02 5.00 1.00 95.00 0.00

2014-08-29 07:31:03 0.00 0.00 100.00 0.00

2014-08-29 07:38:02 0.00 0.00 100.00 0.00

2014-08-29 07:45:02 2.00 0.00 97.00 0.00

2014-08-29 07:52:02 0.00 0.00 100.00 0.00

2014-08-29 07:59:02 0.00 0.00 100.00 0.00

2014-08-29 08:06:02 2.00 0.00 97.00 0.00

2014-08-29 08:13:02 0.00 0.00 100.00 0.00

2014-08-29 08:20:03 0.00 0.00 99.00 0.00

2014-08-29 08:27:02 3.00 0.00 96.00 0.00

2014-08-29 08:34:03 0.00 0.00 100.00 0.00

2014-08-29 08:41:02 0.00 0.00 100.00 0.00

2014-08-29 08:48:02 3.00 0.00 97.00 0.00

2014-08-29 08:55:02 0.00 0.00 100.00 0.00

2014-08-29 09:02:02 0.00 0.00 100.00 0.00

2014-08-29 09:09:03 2.00 0.00 97.00 0.00

2014-08-29 09:16:02 0.00 0.00 100.00 0.00

2014-08-29 09:23:02 1.00 0.00 99.00 0.00

2014-08-29 09:30:02 6.00 1.00 93.00 0.00

2014-08-29 09:37:02 0.00 0.00 100.00 0.00

2014-08-29 09:44:03 0.00 0.00 100.00 0.00

2014-08-29 09:51:02 3.00 0.00 97.00 0.00

2014-08-29 09:58:02 0.00 0.00 100.00 0.00

2014-08-29 10:05:03 0.00 3.00 97.00 0.00

2014-08-29 10:12:02 2.00 0.00 97.00 0.00

2014-08-29 10:19:02 0.00 0.00 100.00 0.00

2014-08-29 10:26:02 0.00 0.00 100.00 0.00

2014-08-29 10:33:02 2.00 0.00 97.00 0.00

2014-08-29 10:40:02 0.00 0.00 100.00 0.00

2014-08-29 10:47:02 0.00 0.00 100.00 0.00

2014-08-29 10:53:02 0.00 0.00 100.00 0.00

Snap Time	user	system	idle
2014-08-29 03:40:02	0.00	0.00	100.00
2014-08-29 03:47:02	0.00	0.00	100.00
2014-08-29 03:54:03	4.00	1.00	95.00
2014-08-29 04:01:02	0.00	0.00	100.00
2014-08-29 04:08:02	0.00	0.00	100.00
2014-08-29 04:15:02	2.00	0.00	97.00
2014-08-29 04:22:03	0.00	0.00	100.00
2014-08-29 04:29:02	0.00	0.00	100.00
2014-08-29 04:36:02	2.00	0.00	97.00
2014-08-29 04:43:02	1.00	0.00	99.00
2014-08-29 04:50:02	0.00	0.00	99.00
2014-08-29 04:57:02	2.00	0.00	97.00
2014-08-29 05:04:02	0.00	0.00	100.00
2014-08-29 05:11:02	0.00	0.00	99.00
2014-08-29 05:18:02	2.00	0.00	97.00
2014-08-29 05:25:03	0.00	0.00	99.00
2014-08-29 05:32:02	0.00	0.00	100.00
2014-08-29 05:39:03	2.00	0.00	97.00
2014-08-29 05:46:02	0.00	0.00	100.00
2014-08-29 05:53:02	0.00	0.00	100.00
2014-08-29 06:00:02	3.00	0.00	97.00
2014-08-29 06:07:02	0.00	0.00	100.00
2014-08-29 06:14:02	0.00	0.00	100.00
2014-08-29 06:21:02	3.00	0.00	97.00
2014-08-29 06:28:03	3.00	1.00	97.00
2014-08-29 06:35:02	0.00	0.00	100.00
2014-08-29 06:42:03	2.00	0.00	97.00
2014-08-29 06:49:02	0.00	0.00	100.00
2014-08-29 06:56:03	0.00	0.00	100.00
2014-08-29 07:03:02	3.00	0.00	97.00
2014-08-29 07:10:03	0.00	0.00	100.00
2014-08-29 07:17:02	1.00	0.00	98.00
2014-08-29 07:24:02	5.00	1.00	95.00
2014-08-29 07:31:03	0.00	0.00	100.00
2014-08-29 07:38:02	0.00	0.00	100.00
2014-08-29 07:45:02	2.00	0.00	97.00
2014-08-29 07:52:02	0.00	0.00	100.00
2014-08-29 07:59:02	0.00	0.00	100.00
2014-08-29 08:06:02	2.00	0.00	97.00
2014-08-29 08:13:02	0.00	0.00	100.00
2014-08-29 08:20:03	0.00	0.00	99.00
2014-08-29 08:27:02	3.00	0.00	96.00
2014-08-29 08:34:03	0.00	0.00	100.00
2014-08-29 08:41:02	0.00	0.00	100.00
2014-08-29 08:48:02	3.00	0.00	97.00
2014-08-29 08:55:02	0.00	0.00	100.00
2014-08-29 09:02:02	0.00	0.00	100.00
2014-08-29 09:09:03	2.00	0.00	97.00
2014-08-29 09:16:02	0.00	0.00	100.00
2014-08-29 09:23:02	1.00	0.00	99.00
2014-08-29 09:30:02	6.00	1.00	93.00
2014-08-29 09:37:02	0.00	0.00	100.00
2014-08-29 09:44:03	0.00	0.00	100.00
2014-08-29 09:51:02	3.00	0.00	97.00
2014-08-29 09:58:02	0.00	0.00	100.00
2014-08-29 10:05:03	0.00	3.00	97.00
2014-08-29 10:12:02	2.00	0.00	97.00
2014-08-29 10:19:02	0.00	0.00	100.00
2014-08-29 10:26:02	0.00	0.00	100.00
2014-08-29 10:33:02	2.00	0.00	97.00
2014-08-29 10:40:02	0.00	0.00	100.00
2014-08-29 10:47:02	0.00	0.00	100.00
2014-08-29 10:53:02	0.00	0.00	100.00

OS IO Info

Snap Time rd_ios_s wr_ios_s rkbs wkbs queue svc_t busy
2014-08-29 03:40:02 0.00 93.67 0.00 394.41 0.01 0.05 0.49

2014-08-29 03:47:02 0.00 108.51 0.00 528.73 0.01 0.05 0.49

2014-08-29 03:54:03 0.00 782.85 0.00 3420.37 0.04 0.05 3.76

2014-08-29 04:01:02 0.00 125.28 0.00 505.06 0.01 0.05 0.59

2014-08-29 04:08:02 0.00 114.43 0.00 509.00 0.01 0.06 0.69

2014-08-29 04:15:02 0.00 71.08 0.00 300.12 0.01 0.08 0.59

2014-08-29 04:22:03 0.00 118.47 0.00 698.97 0.01 0.06 0.69

2014-08-29 04:29:02 0.00 50.25 0.00 220.69 0.00 0.06 0.30

2014-08-29 04:36:02 0.00 123.51 0.00 553.31 0.01 0.06 0.69

2014-08-29 04:43:02 0.00 270.06 0.00 1135.44 0.02 0.07 1.87

2014-08-29 04:50:02 0.00 167.83 0.00 797.70 0.01 0.05 0.79

2014-08-29 04:57:02 0.00 145.99 0.00 702.34 0.01 0.05 0.69

2014-08-29 05:04:02 0.00 110.48 0.00 469.54 0.01 0.08 0.89

2014-08-29 05:11:02 0.00 841.78 0.00 23028.95 0.09 0.04 3.06

2014-08-29 05:18:02 0.00 82.79 0.00 354.83 0.01 0.08 0.69

2014-08-29 05:25:03 0.00 213.88 0.00 922.55 0.02 0.07 1.48

2014-08-29 05:32:02 0.00 85.93 0.00 343.70 0.01 0.08 0.69

2014-08-29 05:39:03 0.00 184.62 0.00 750.31 0.01 0.04 0.79

2014-08-29 05:46:02 0.00 70.04 0.00 280.15 0.00 0.01 0.10

2014-08-29 05:53:02 0.00 85.78 0.00 473.29 0.01 0.07 0.59

2014-08-29 06:00:02 0.00 123.46 0.00 651.85 0.01 0.05 0.59

2014-08-29 06:07:02 0.00 135.20 0.00 600.00 0.01 0.04 0.59

2014-08-29 06:14:02 0.00 157.96 0.00 655.53 0.01 0.06 0.99

2014-08-29 06:21:02 0.00 166.71 0.00 737.85 0.01 0.04 0.69

2014-08-29 06:28:03 0.00 326.64 0.00 1523.68 0.02 0.05 1.68

2014-08-29 06:35:02 0.00 160.00 0.00 679.51 0.02 0.08 1.28

2014-08-29 06:42:03 0.00 177.70 0.00 738.46 0.01 0.03 0.59

2014-08-29 06:49:02 0.00 168.61 0.00 725.72 0.01 0.02 0.30

2014-08-29 06:56:03 0.00 214.06 0.00 883.85 0.02 0.06 1.38

2014-08-29 07:03:02 0.00 152.40 0.00 731.50 0.01 0.05 0.69

2014-08-29 07:10:03 0.00 55.20 0.00 220.78 0.00 0.09 0.49

2014-08-29 07:17:02 0.00 400.82 0.00 1694.12 0.04 0.08 3.16

2014-08-29 07:24:02 0.00 141.64 0.00 720.00 0.01 0.04 0.59

2014-08-29 07:31:03 0.00 32.54 0.00 145.93 0.00 0.09 0.30

2014-08-29 07:38:02 0.00 111.56 0.00 584.45 0.01 0.06 0.69

2014-08-29 07:45:02 0.00 110.44 0.00 445.69 0.00 0.03 0.30

2014-08-29 07:52:02 0.00 142.05 0.00 627.37 0.02 0.12 1.78

2014-08-29 07:59:02 0.00 108.46 0.00 441.74 0.01 0.09 0.99

2014-08-29 08:06:02 0.00 144.89 0.00 662.34 0.01 0.06 0.89

2014-08-29 08:13:02 0.00 104.61 0.00 418.42 0.00 0.02 0.20

2014-08-29 08:20:03 0.00 293.45 0.00 1252.86 0.01 0.04 1.28

2014-08-29 08:27:02 0.00 559.77 0.00 2361.50 0.04 0.05 3.06

2014-08-29 08:34:03 0.00 59.16 0.00 272.14 0.00 0.08 0.49

2014-08-29 08:41:02 0.00 107.43 0.00 548.01 0.01 0.08 0.89

2014-08-29 08:48:02 0.00 218.18 0.00 904.32 0.01 0.05 1.18

2014-08-29 08:55:02 0.00 160.72 0.00 670.50 0.01 0.05 0.79

2014-08-29 09:02:02 0.00 179.31 0.00 740.89 0.01 0.05 0.89

2014-08-29 09:09:03 0.00 169.67 0.00 706.29 0.01 0.05 0.79

2014-08-29 09:16:02 0.00 82.89 0.00 430.26 0.00 0.04 0.30

2014-08-29 09:23:02 0.00 1721.76 0.00 47881.53 0.28 0.03 5.73

2014-08-29 09:30:02 0.00 166.91 0.00 833.58 0.02 0.07 1.19

2014-08-29 09:37:02 0.00 33.54 0.00 142.05 0.00 0.09 0.30

2014-08-29 09:44:03 0.00 95.72 0.00 402.63 0.00 0.04 0.39

2014-08-29 09:51:02 0.00 67.08 0.00 402.47 0.00 0.04 0.30

2014-08-29 09:58:02 0.00 84.80 0.00 347.08 0.01 0.08 0.69

2014-08-29 10:05:03 0.00 40.48 0.00 229.04 0.00 0.07 0.30

2014-08-29 10:12:02 0.00 45.39 0.00 185.53 0.01 0.11 0.49

2014-08-29 10:19:02 0.00 75.00 0.00 438.16 0.01 0.07 0.49

2014-08-29 10:26:02 0.00 147.97 0.00 619.48 0.01 0.05 0.79

2014-08-29 10:33:02 0.00 142.16 0.00 588.40 0.01 0.06 0.89

2014-08-29 10:40:02 0.00 139.09 0.00 583.97 0.01 0.06 0.89

2014-08-29 10:47:02 0.00 110.53 0.00 465.79 0.02 0.19 2.07

2014-08-29 10:53:02 0.00 96.47 0.00 511.89 0.01 0.07 0.69

Snap Time	wr_ios_s	wkbs	queue	svc_t	busy
2014-08-29 03:40:02	93.67	394.41	0.01	0.05	0.49
2014-08-29 03:47:02	108.51	528.73	0.01	0.05	0.49
2014-08-29 03:54:03	782.85	3420.37	0.04	0.05	3.76
2014-08-29 04:01:02	125.28	505.06	0.01	0.05	0.59
2014-08-29 04:08:02	114.43	509.00	0.01	0.06	0.69
2014-08-29 04:15:02	71.08	300.12	0.01	0.08	0.59
2014-08-29 04:22:03	118.47	698.97	0.01	0.06	0.69
2014-08-29 04:29:02	50.25	220.69	0.00	0.06	0.30
2014-08-29 04:36:02	123.51	553.31	0.01	0.06	0.69
2014-08-29 04:43:02	270.06	1135.44	0.02	0.07	1.87
2014-08-29 04:50:02	167.83	797.70	0.01	0.05	0.79
2014-08-29 04:57:02	145.99	702.34	0.01	0.05	0.69
2014-08-29 05:04:02	110.48	469.54	0.01	0.08	0.89
2014-08-29 05:11:02	841.78	23028.95	0.09	0.04	3.06
2014-08-29 05:18:02	82.79	354.83	0.01	0.08	0.69
2014-08-29 05:25:03	213.88	922.55	0.02	0.07	1.48
2014-08-29 05:32:02	85.93	343.70	0.01	0.08	0.69
2014-08-29 05:39:03	184.62	750.31	0.01	0.04	0.79
2014-08-29 05:46:02	70.04	280.15	0.00	0.01	0.10
2014-08-29 05:53:02	85.78	473.29	0.01	0.07	0.59
2014-08-29 06:00:02	123.46	651.85	0.01	0.05	0.59
2014-08-29 06:07:02	135.20	600.00	0.01	0.04	0.59
2014-08-29 06:14:02	157.96	655.53	0.01	0.06	0.99
2014-08-29 06:21:02	166.71	737.85	0.01	0.04	0.69
2014-08-29 06:28:03	326.64	1523.68	0.02	0.05	1.68
2014-08-29 06:35:02	160.00	679.51	0.02	0.08	1.28
2014-08-29 06:42:03	177.70	738.46	0.01	0.03	0.59
2014-08-29 06:49:02	168.61	725.72	0.01	0.02	0.30
2014-08-29 06:56:03	214.06	883.85	0.02	0.06	1.38
2014-08-29 07:03:02	152.40	731.50	0.01	0.05	0.69
2014-08-29 07:10:03	55.20	220.78	0.00	0.09	0.49
2014-08-29 07:17:02	400.82	1694.12	0.04	0.08	3.16
2014-08-29 07:24:02	141.64	720.00	0.01	0.04	0.59
2014-08-29 07:31:03	32.54	145.93	0.00	0.09	0.30
2014-08-29 07:38:02	111.56	584.45	0.01	0.06	0.69
2014-08-29 07:45:02	110.44	445.69	0.00	0.03	0.30
2014-08-29 07:52:02	142.05	627.37	0.02	0.12	1.78
2014-08-29 07:59:02	108.46	441.74	0.01	0.09	0.99
2014-08-29 08:06:02	144.89	662.34	0.01	0.06	0.89
2014-08-29 08:13:02	104.61	418.42	0.00	0.02	0.20
2014-08-29 08:20:03	293.45	1252.86	0.01	0.04	1.28
2014-08-29 08:27:02	559.77	2361.50	0.04	0.05	3.06
2014-08-29 08:34:03	59.16	272.14	0.00	0.08	0.49
2014-08-29 08:41:02	107.43	548.01	0.01	0.08	0.89
2014-08-29 08:48:02	218.18	904.32	0.01	0.05	1.18
2014-08-29 08:55:02	160.72	670.50	0.01	0.05	0.79
2014-08-29 09:02:02	179.31	740.89	0.01	0.05	0.89
2014-08-29 09:09:03	169.67	706.29	0.01	0.05	0.79
2014-08-29 09:16:02	82.89	430.26	0.00	0.04	0.30
2014-08-29 09:23:02	1721.76	47881.53	0.28	0.03	5.73
2014-08-29 09:30:02	166.91	833.58	0.02	0.07	1.19
2014-08-29 09:37:02	33.54	142.05	0.00	0.09	0.30
2014-08-29 09:44:03	95.72	402.63	0.00	0.04	0.39
2014-08-29 09:51:02	67.08	402.47	0.00	0.04	0.30
2014-08-29 09:58:02	84.80	347.08	0.01	0.08	0.69
2014-08-29 10:05:03	40.48	229.04	0.00	0.07	0.30
2014-08-29 10:12:02	45.39	185.53	0.01	0.11	0.49
2014-08-29 10:19:02	75.00	438.16	0.01	0.07	0.49
2014-08-29 10:26:02	147.97	619.48	0.01	0.05	0.79
2014-08-29 10:33:02	142.16	588.40	0.01	0.06	0.89
2014-08-29 10:40:02	139.09	583.97	0.01	0.06	0.89
2014-08-29 10:47:02	110.53	465.79	0.02	0.19	2.07
2014-08-29 10:53:02	96.47	511.89	0.01	0.07	0.69

OS Other Info

Snap Time swap_in swap_out net_recv net_send file_system total_mb used_mb used_pct mount_point
2014-08-29 03:40:02 0.00 0.00 19193.00 60030.00 /dev/sdb 2814021.00 240484.00 10.00 /storage/sas

2014-08-29 03:47:02 0.00 0.00 8289.00 25998.00 /dev/sdb 2814021.00 240500.00 10.00 /storage/sas

2014-08-29 03:54:03 0.00 0.00 238503.00 7237687.00 /dev/sdb 2814021.00 240521.00 10.00 /storage/sas

2014-08-29 04:01:02 0.00 0.00 12224.00 36681.00 /dev/sdb 2814021.00 240538.00 10.00 /storage/sas

2014-08-29 04:08:02 0.00 0.00 22684.00 60588.00 /dev/sdb 2814021.00 240556.00 10.00 /storage/sas

2014-08-29 04:15:02 0.00 0.00 50391.00 6973705.00 /dev/sdb 2814021.00 240579.00 10.00 /storage/sas

2014-08-29 04:22:03 0.00 0.00 82603.00 181729.00 /dev/sdb 2814021.00 240590.00 10.00 /storage/sas

2014-08-29 04:29:02 0.00 0.00 17011.00 40985.00 /dev/sdb 2814021.00 240605.00 10.00 /storage/sas

2014-08-29 04:36:02 0.00 0.00 64594.00 7833894.00 /dev/sdb 2814021.00 240618.00 10.00 /storage/sas

2014-08-29 04:43:02 0.00 0.00 181291.00 534839.00 /dev/sdb 2814021.00 240642.00 10.00 /storage/sas

2014-08-29 04:50:02 0.00 0.00 41983.00 81978.00 /dev/sdb 2814021.00 240662.00 10.00 /storage/sas

2014-08-29 04:57:02 0.00 0.00 87580.00 7031461.00 /dev/sdb 2814021.00 240681.00 10.00 /storage/sas

2014-08-29 05:04:02 0.00 0.00 55296.00 161204.00 /dev/sdb 2814021.00 240702.00 10.00 /storage/sas

2014-08-29 05:11:02 0.00 0.00 20748.00 51696.00 /dev/sdb 2814021.00 240719.00 10.00 /storage/sas

2014-08-29 05:18:02 0.00 0.00 67084.00 6598613.00 /dev/sdb 2814021.00 240730.00 10.00 /storage/sas

2014-08-29 05:25:03 0.00 0.00 121827.00 297454.00 /dev/sdb 2814021.00 240748.00 10.00 /storage/sas

2014-08-29 05:32:02 0.00 0.00 82954.00 2828324.00 /dev/sdb 2814021.00 240763.00 10.00 /storage/sas

2014-08-29 05:39:03 0.00 0.00 68098.00 6608260.00 /dev/sdb 2814021.00 240783.00 10.00 /storage/sas

2014-08-29 05:46:02 0.00 0.00 33779.00 85818.00 /dev/sdb 2814021.00 240807.00 10.00 /storage/sas

2014-08-29 05:53:02 0.00 0.00 41291.00 85688.00 /dev/sdb 2814021.00 240826.00 10.00 /storage/sas

2014-08-29 06:00:02 0.00 0.00 141265.00 6647625.00 /dev/sdb 2814021.00 240846.00 10.00 /storage/sas

2014-08-29 06:07:02 0.00 0.00 27102.00 73884.00 /dev/sdb 2814021.00 240872.00 10.00 /storage/sas

2014-08-29 06:14:02 0.00 0.00 37445.00 95174.00 /dev/sdb 2814021.00 240884.00 10.00 /storage/sas

2014-08-29 06:21:02 0.00 0.00 108037.00 6860832.00 /dev/sdb 2814021.00 240903.00 10.00 /storage/sas

2014-08-29 06:28:03 0.00 0.00 95592.00 3609880.00 /dev/sdb 2814021.00 240926.00 10.00 /storage/sas

2014-08-29 06:35:02 0.00 0.00 28217.00 65682.00 /dev/sdb 2814021.00 240937.00 10.00 /storage/sas

2014-08-29 06:42:03 0.00 0.00 55949.00 6678180.00 /dev/sdb 2814021.00 240957.00 10.00 /storage/sas

2014-08-29 06:49:02 0.00 0.00 29427.00 73566.00 /dev/sdb 2814021.00 240976.00 10.00 /storage/sas

2014-08-29 06:56:03 0.00 0.00 44002.00 112504.00 /dev/sdb 2814021.00 240995.00 10.00 /storage/sas

2014-08-29 07:03:02 0.00 0.00 90987.00 6950037.00 /dev/sdb 2814021.00 241014.00 10.00 /storage/sas

2014-08-29 07:10:03 0.00 0.00 21087.00 62051.00 /dev/sdb 2814021.00 241042.00 10.00 /storage/sas

2014-08-29 07:17:02 0.00 0.00 173799.00 561118.00 /dev/sdb 2814021.00 241056.00 10.00 /storage/sas

2014-08-29 07:24:02 0.00 0.00 237993.00 10281062.00 /dev/sdb 2814021.00 241072.00 10.00 /storage/sas

2014-08-29 07:31:03 0.00 0.00 27177.00 73613.00 /dev/sdb 2814021.00 241083.00 10.00 /storage/sas

2014-08-29 07:38:02 0.00 0.00 74208.00 160214.00 /dev/sdb 2814021.00 241098.00 10.00 /storage/sas

2014-08-29 07:45:02 0.00 0.00 50101.00 6760762.00 /dev/sdb 2814021.00 241109.00 10.00 /storage/sas

2014-08-29 07:52:02 0.00 0.00 31489.00 79475.00 /dev/sdb 2814021.00 241128.00 10.00 /storage/sas

2014-08-29 07:59:02 0.00 0.00 5039.00 19916.00 /dev/sdb 2814021.00 241139.00 10.00 /storage/sas

2014-08-29 08:06:02 0.00 0.00 183739.00 6904496.00 /dev/sdb 2814021.00 241153.00 10.00 /storage/sas

2014-08-29 08:13:02 0.00 0.00 16565.00 60228.00 /dev/sdb 2814021.00 241165.00 10.00 /storage/sas

2014-08-29 08:20:03 0.00 0.00 200634.00 2001938.00 /dev/sdb 2814021.00 241177.00 10.00 /storage/sas

2014-08-29 08:27:02 0.00 0.00 313790.00 7092331.00 /dev/sdb 2814021.00 241191.00 10.00 /storage/sas

2014-08-29 08:34:03 0.00 0.00 28424.00 43775.00 /dev/sdb 2814021.00 241211.00 10.00 /storage/sas

2014-08-29 08:41:02 0.00 0.00 46016.00 82638.00 /dev/sdb 2814021.00 241222.00 10.00 /storage/sas

2014-08-29 08:48:02 0.00 0.00 57819.00 6813365.00 /dev/sdb 2814021.00 241233.00 10.00 /storage/sas

2014-08-29 08:55:02 0.00 0.00 135460.00 386062.00 /dev/sdb 2814021.00 241248.00 10.00 /storage/sas

2014-08-29 09:02:02 0.00 0.00 32525.00 78344.00 /dev/sdb 2814021.00 241266.00 10.00 /storage/sas

2014-08-29 09:09:03 0.00 0.00 70667.00 6902814.00 /dev/sdb 2814021.00 241286.00 10.00 /storage/sas

2014-08-29 09:16:02 0.00 0.00 40972.00 44529.00 /dev/sdb 2814021.00 241301.00 10.00 /storage/sas

2014-08-29 09:23:02 0.00 0.00 33647.00 94295.00 /dev/sdb 2814021.00 241325.00 10.00 /storage/sas

2014-08-29 09:30:02 0.00 0.00 102104.00 6986962.00 /dev/sdb 2814021.00 241339.00 10.00 /storage/sas

2014-08-29 09:37:02 0.00 0.00 33820.00 105159.00 /dev/sdb 2814021.00 241355.00 10.00 /storage/sas

2014-08-29 09:44:03 0.00 0.00 59636.00 116610.00 /dev/sdb 2814021.00 241374.00 10.00 /storage/sas

2014-08-29 09:51:02 0.00 0.00 77325.00 6907970.00 /dev/sdb 2814021.00 241393.00 10.00 /storage/sas

2014-08-29 09:58:02 0.00 0.00 30857.00 99096.00 /dev/sdb 2814021.00 241404.00 10.00 /storage/sas

2014-08-29 10:05:03 0.00 0.00 30790.00 86549.00 /dev/sdb 2814021.00 241419.00 10.00 /storage/sas

2014-08-29 10:12:02 0.00 0.00 83076.00 6822165.00 /dev/sdb 2814021.00 241434.00 10.00 /storage/sas

2014-08-29 10:19:02 0.00 0.00 30228.00 83001.00 /dev/sdb 2814021.00 241450.00 10.00 /storage/sas

2014-08-29 10:26:02 0.00 0.00 32195.00 74159.00 /dev/sdb 2814021.00 241461.00 10.00 /storage/sas

2014-08-29 10:33:02 0.00 0.00 88706.00 6961987.00 /dev/sdb 2814021.00 241476.00 10.00 /storage/sas

2014-08-29 10:40:02 0.00 0.00 30049.00 88922.00 /dev/sdb 2814021.00 241495.00 10.00 /storage/sas

2014-08-29 10:47:02 0.00 0.00 36295.00 53624.00 /dev/sdb 2814021.00 241514.00 10.00 /storage/sas

2014-08-29 10:53:02 0.00 0.00 33340.00 94651.00 /dev/sdb 2814021.00 241533.00 10.00 /storage/sas

Snap Time	net_recv	net_send	file_system	total_mb	used_mb	used_pct	mount_point
2014-08-29 03:40:02	19193.00	60030.00	/dev/sdb	2814021.00	240484.00	10.00	/storage/sas
2014-08-29 03:47:02	8289.00	25998.00	/dev/sdb	2814021.00	240500.00	10.00	/storage/sas
2014-08-29 03:54:03	238503.00	7237687.00	/dev/sdb	2814021.00	240521.00	10.00	/storage/sas
2014-08-29 04:01:02	12224.00	36681.00	/dev/sdb	2814021.00	240538.00	10.00	/storage/sas
2014-08-29 04:08:02	22684.00	60588.00	/dev/sdb	2814021.00	240556.00	10.00	/storage/sas
2014-08-29 04:15:02	50391.00	6973705.00	/dev/sdb	2814021.00	240579.00	10.00	/storage/sas
2014-08-29 04:22:03	82603.00	181729.00	/dev/sdb	2814021.00	240590.00	10.00	/storage/sas
2014-08-29 04:29:02	17011.00	40985.00	/dev/sdb	2814021.00	240605.00	10.00	/storage/sas
2014-08-29 04:36:02	64594.00	7833894.00	/dev/sdb	2814021.00	240618.00	10.00	/storage/sas
2014-08-29 04:43:02	181291.00	534839.00	/dev/sdb	2814021.00	240642.00	10.00	/storage/sas
2014-08-29 04:50:02	41983.00	81978.00	/dev/sdb	2814021.00	240662.00	10.00	/storage/sas
2014-08-29 04:57:02	87580.00	7031461.00	/dev/sdb	2814021.00	240681.00	10.00	/storage/sas
2014-08-29 05:04:02	55296.00	161204.00	/dev/sdb	2814021.00	240702.00	10.00	/storage/sas
2014-08-29 05:11:02	20748.00	51696.00	/dev/sdb	2814021.00	240719.00	10.00	/storage/sas
2014-08-29 05:18:02	67084.00	6598613.00	/dev/sdb	2814021.00	240730.00	10.00	/storage/sas
2014-08-29 05:25:03	121827.00	297454.00	/dev/sdb	2814021.00	240748.00	10.00	/storage/sas
2014-08-29 05:32:02	82954.00	2828324.00	/dev/sdb	2814021.00	240763.00	10.00	/storage/sas
2014-08-29 05:39:03	68098.00	6608260.00	/dev/sdb	2814021.00	240783.00	10.00	/storage/sas
2014-08-29 05:46:02	33779.00	85818.00	/dev/sdb	2814021.00	240807.00	10.00	/storage/sas
2014-08-29 05:53:02	41291.00	85688.00	/dev/sdb	2814021.00	240826.00	10.00	/storage/sas
2014-08-29 06:00:02	141265.00	6647625.00	/dev/sdb	2814021.00	240846.00	10.00	/storage/sas
2014-08-29 06:07:02	27102.00	73884.00	/dev/sdb	2814021.00	240872.00	10.00	/storage/sas
2014-08-29 06:14:02	37445.00	95174.00	/dev/sdb	2814021.00	240884.00	10.00	/storage/sas
2014-08-29 06:21:02	108037.00	6860832.00	/dev/sdb	2814021.00	240903.00	10.00	/storage/sas
2014-08-29 06:28:03	95592.00	3609880.00	/dev/sdb	2814021.00	240926.00	10.00	/storage/sas
2014-08-29 06:35:02	28217.00	65682.00	/dev/sdb	2814021.00	240937.00	10.00	/storage/sas
2014-08-29 06:42:03	55949.00	6678180.00	/dev/sdb	2814021.00	240957.00	10.00	/storage/sas
2014-08-29 06:49:02	29427.00	73566.00	/dev/sdb	2814021.00	240976.00	10.00	/storage/sas
2014-08-29 06:56:03	44002.00	112504.00	/dev/sdb	2814021.00	240995.00	10.00	/storage/sas
2014-08-29 07:03:02	90987.00	6950037.00	/dev/sdb	2814021.00	241014.00	10.00	/storage/sas
2014-08-29 07:10:03	21087.00	62051.00	/dev/sdb	2814021.00	241042.00	10.00	/storage/sas
2014-08-29 07:17:02	173799.00	561118.00	/dev/sdb	2814021.00	241056.00	10.00	/storage/sas
2014-08-29 07:24:02	237993.00	10281062.00	/dev/sdb	2814021.00	241072.00	10.00	/storage/sas
2014-08-29 07:31:03	27177.00	73613.00	/dev/sdb	2814021.00	241083.00	10.00	/storage/sas
2014-08-29 07:38:02	74208.00	160214.00	/dev/sdb	2814021.00	241098.00	10.00	/storage/sas
2014-08-29 07:45:02	50101.00	6760762.00	/dev/sdb	2814021.00	241109.00	10.00	/storage/sas
2014-08-29 07:52:02	31489.00	79475.00	/dev/sdb	2814021.00	241128.00	10.00	/storage/sas
2014-08-29 07:59:02	5039.00	19916.00	/dev/sdb	2814021.00	241139.00	10.00	/storage/sas
2014-08-29 08:06:02	183739.00	6904496.00	/dev/sdb	2814021.00	241153.00	10.00	/storage/sas
2014-08-29 08:13:02	16565.00	60228.00	/dev/sdb	2814021.00	241165.00	10.00	/storage/sas
2014-08-29 08:20:03	200634.00	2001938.00	/dev/sdb	2814021.00	241177.00	10.00	/storage/sas
2014-08-29 08:27:02	313790.00	7092331.00	/dev/sdb	2814021.00	241191.00	10.00	/storage/sas
2014-08-29 08:34:03	28424.00	43775.00	/dev/sdb	2814021.00	241211.00	10.00	/storage/sas
2014-08-29 08:41:02	46016.00	82638.00	/dev/sdb	2814021.00	241222.00	10.00	/storage/sas
2014-08-29 08:48:02	57819.00	6813365.00	/dev/sdb	2814021.00	241233.00	10.00	/storage/sas
2014-08-29 08:55:02	135460.00	386062.00	/dev/sdb	2814021.00	241248.00	10.00	/storage/sas
2014-08-29 09:02:02	32525.00	78344.00	/dev/sdb	2814021.00	241266.00	10.00	/storage/sas
2014-08-29 09:09:03	70667.00	6902814.00	/dev/sdb	2814021.00	241286.00	10.00	/storage/sas
2014-08-29 09:16:02	40972.00	44529.00	/dev/sdb	2814021.00	241301.00	10.00	/storage/sas
2014-08-29 09:23:02	33647.00	94295.00	/dev/sdb	2814021.00	241325.00	10.00	/storage/sas
2014-08-29 09:30:02	102104.00	6986962.00	/dev/sdb	2814021.00	241339.00	10.00	/storage/sas
2014-08-29 09:37:02	33820.00	105159.00	/dev/sdb	2814021.00	241355.00	10.00	/storage/sas
2014-08-29 09:44:03	59636.00	116610.00	/dev/sdb	2814021.00	241374.00	10.00	/storage/sas
2014-08-29 09:51:02	77325.00	6907970.00	/dev/sdb	2814021.00	241393.00	10.00	/storage/sas
2014-08-29 09:58:02	30857.00	99096.00	/dev/sdb	2814021.00	241404.00	10.00	/storage/sas
2014-08-29 10:05:03	30790.00	86549.00	/dev/sdb	2814021.00	241419.00	10.00	/storage/sas
2014-08-29 10:12:02	83076.00	6822165.00	/dev/sdb	2814021.00	241434.00	10.00	/storage/sas
2014-08-29 10:19:02	30228.00	83001.00	/dev/sdb	2814021.00	241450.00	10.00	/storage/sas
2014-08-29 10:26:02	32195.00	74159.00	/dev/sdb	2814021.00	241461.00	10.00	/storage/sas
2014-08-29 10:33:02	88706.00	6961987.00	/dev/sdb	2814021.00	241476.00	10.00	/storage/sas
2014-08-29 10:40:02	30049.00	88922.00	/dev/sdb	2814021.00	241495.00	10.00	/storage/sas
2014-08-29 10:47:02	36295.00	53624.00	/dev/sdb	2814021.00	241514.00	10.00	/storage/sas
2014-08-29 10:53:02	33340.00	94651.00	/dev/sdb	2814021.00	241533.00	10.00	/storage/sas

TOP 20 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
13612286358010875778 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 2453 103523 183.581 1.28728 0.000287051 2453 1 select t.date,...

7559947935709052803 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 2229 73393.7 183.581 1.18724 0.000316473 8606 8.91436 select t.date,...

18097649493518330926 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 135 20829.7 685.39 0.043451 0.000348912 0 0 insert into t_stand...

1054122699803593913 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 4770 19447 5.47264 1.02734 0.000236157 0 0 insert into t_channe...

14562554133437710016 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 4749 15389.6 4.08377 1.0375 0.000260364 0 0 insert into t_agent_...

17932081409341609860 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 149 13978.2 174.839 0.014906 0.000119276 0 0 load data local infi...

12830386596672724727 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 305 12880.3 174.839 0.119818 0.000247965 305 1 select t.date,...

14242997136004316393 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 149 10954.9 107.336 0.019461 0.00014498 0 0 insert into t_bizlog...

7382243057795183594 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 149 10742 102.225 0.017214 0.000131501 0 0 delete from t_bizlog...

9136130252841431921 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 83 10339.2 124.255 0.008479 0.000119276 0 0 load data local infi...

4104295244676626346 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 149 10053.6 69.1896 0.046126 0.000332297 0 0 insert into t_low_co...

1602841323730482517 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 277 9765.06 183.581 0.154747 0.000273382 1514 28.7497 select t.date,...

354949893804037415 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 148 8698.34 97.3567 0.008762 0.0000732248 0 0 delete from t_custom...

16171946069052037078 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 460 7191.96 38.5273 0.027346 0.0000664171 0 0 delete from cust_ren...

15381351069224663258 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 330 6981.08 158.584 0.10929 0.000247965 330 1 select t.date,...

12080899912460099053 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 2044 6392.3 3.7041 1.14407 0.000725363 301035 652.752 select t.bizCode biz...

6823381848000688775 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 1819 6017.7 3.52771 0.131293 0.0000847669 0 0 load data local infi...

13877986249282993128 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 315 5977.77 158.584 0.062908 0.000287051 1170 8.91436 select t.date,...

6207365650723473125 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 188 5809.77 174.839 0.042189 0.000287051 188 1 select sum(t.p...

11963123707036900324 xxxx_crm 2014-08-20 13:00:00 2014-08-20 14:00:00 1740 5732.28 3.52771 0.113167 0.0000768861 0 0 load data local infi...

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
13612286358010875778	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	2453	103523	183.581	1.28728	0.000287051	2453	1	select t.date,...
7559947935709052803	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	2229	73393.7	183.581	1.18724	0.000316473	8606	8.91436	select t.date,...
18097649493518330926	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	135	20829.7	685.39	0.043451	0.000348912	0	0	insert into t_stand...
1054122699803593913	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	4770	19447	5.47264	1.02734	0.000236157	0	0	insert into t_channe...
14562554133437710016	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	4749	15389.6	4.08377	1.0375	0.000260364	0	0	insert into t_agent_...
17932081409341609860	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	149	13978.2	174.839	0.014906	0.000119276	0	0	load data local infi...
12830386596672724727	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	305	12880.3	174.839	0.119818	0.000247965	305	1	select t.date,...
14242997136004316393	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	149	10954.9	107.336	0.019461	0.00014498	0	0	insert into t_bizlog...
7382243057795183594	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	149	10742	102.225	0.017214	0.000131501	0	0	delete from t_bizlog...
9136130252841431921	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	83	10339.2	124.255	0.008479	0.000119276	0	0	load data local infi...
4104295244676626346	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	149	10053.6	69.1896	0.046126	0.000332297	0	0	insert into t_low_co...
1602841323730482517	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	277	9765.06	183.581	0.154747	0.000273382	1514	28.7497	select t.date,...
354949893804037415	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	148	8698.34	97.3567	0.008762	0.0000732248	0	0	delete from t_custom...
16171946069052037078	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	460	7191.96	38.5273	0.027346	0.0000664171	0	0	delete from cust_ren...
15381351069224663258	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	330	6981.08	158.584	0.10929	0.000247965	330	1	select t.date,...
12080899912460099053	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	2044	6392.3	3.7041	1.14407	0.000725363	301035	652.752	select t.bizCode biz...
6823381848000688775	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	1819	6017.7	3.52771	0.131293	0.0000847669	0	0	load data local infi...
13877986249282993128	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	315	5977.77	158.584	0.062908	0.000287051	1170	8.91436	select t.date,...
6207365650723473125	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	188	5809.77	174.839	0.042189	0.000287051	188	1	select sum(t.p...
11963123707036900324	xxxx_crm	2014-08-20 13:00:00	2014-08-20 14:00:00	1740	5732.28	3.52771	0.113167	0.0000768861	0	0	load data local infi...

TOP SQL DETAIL

checksum sql detail
13612286358010875778 select t.date,sum(t.pay)/100 cost,sum(t.a_pay+t.b_pay)/100 costAB, sum(t.c_pay)/100 costC,count(distinct t.cust_id) actives, sum(t.pay)/(count(distinct t.cust_id)*100) costPerCust,sum(t.pv)pv, sum(t.click) click,sum(t.pay)/(sum(t.click)*100) cpc from ( select distinct t.cust_id,t.date,t.pay,t.a_pay,t.b_pay,t.c_pay,t.click,t.pv from cost_cpc_cust_day_hot t join cust_dis tcd on t.cust_id=tcd.cust_id WHERE t.date between '2014-07-07' and '2014-07-13' and t.agent_id = 4804 and t.pay>0 and (tcd.agent_user_id=137409 or tcd.cha_id=137409 or tcd.dir_id=137409) )t

7559947935709052803 select t.date,sum(t.pay)/100 cost,sum(t.a_pay+t.b_pay)/100 costAB, sum(t.c_pay)/100 costC,count(distinct t.cust_id) actives, sum(t.pay)/(count(distinct t.cust_id)*100) costPerCust,sum(t.pv)pv, sum(t.click) click,sum(t.pay)/(sum(t.click)*100) cpc from ( select distinct t.cust_id,t.date,t.pay,t.a_pay,t.b_pay,t.c_pay,t.click,t.pv from cost_cpc_cust_day_hot t join cust_dis tcd on t.cust_id=tcd.cust_id WHERE t.date between '2014-07-07' and '2014-07-13' and t.agent_id = 337077 and t.pay>0 and (tcd.agent_user_id=135580 or tcd.cha_id=135580 or tcd.dir_id=135580) )t group by t.date order by t.date asc

18097649493518330926 insert into t_standard_account_month select 20140401,d.cust_id cust_id, sum(d.cpc_plan) cpc_plan, sum(d.cpc_group) cpc_group, sum(d.cpc_idea) cpc_idea,sum(d.cpc_idea/d.cpc_group) idea_per_grp ,sum(d.cpc_key) cpc_key,sum(d.cpc_broad_match) cpc_broad_match,sum(d.cpc_broad_match/d.cpc_key) match_percent, count(d.cust_id) cost_days, sum(d.is_pause) pause_days,d.agent_id agent_id, d.second_agent_id second_agent_id,case when ta.cust_id is null then 0 when ta.cust_id is not null and ta.agentNum>0 then 1 else 2 end agent_changed from t_standard_account_day d left join (select cust_id,sum(if(old_agent_id=new_agent_id,0,1)) agentNum from t_trans_agent where execute_time>'20140401' and execute_time<='20140430' group by cust_id ) ta on d.cust_id=ta.cust_id where d.date >= '20140401' and d.date <= '20140430' group by d.cust_id,d.agent_id,d.second_agent_id

1054122699803593913 insert into t_channel_stat_day select csd.date,cu.channel_id,sum(csd.cpc_pay),sum(csd.cpc_click),sum(csd.cx_pay),sum(csd.cx_click),sum(csd.pay),sum(csd.click),sum(csd.cpc_a_pay),sum(csd.cpc_b_pay),sum(csd.cpc_c_pay),sum(csd.cx_a_pay),sum(csd.cx_b_pay),sum(csd.cx_c_pay) from t_agent cu join t_cust_stat_day csd on cu.agent_id=csd.agent_id where csd.date between '20140301' and '20140331' group by csd.date,cu.channel_id

14562554133437710016 insert into t_agent_stat_day select csd.date,csd.agent_id,sum(csd.cpc_pay),sum(csd.cpc_click),sum(csd.cx_pay),sum(csd.cx_click),sum(csd.pay),sum(csd.click),sum(csd.cpc_a_pay),sum(csd.cpc_b_pay),sum(csd.cpc_c_pay),sum(csd.cx_a_pay),sum(csd.cx_b_pay),sum(csd.cx_c_pay) from t_cust_stat_day csd where csd.date between '20140601' and '20140630' group by csd.date,csd.agent_id

17932081409341609860 load data local infile '/data/actOpt/plan/20140607/keyword.txt' into table t_account_optimize_data_keyword (cust_id, data_type, plan_name, group_name, keyword, match_type, default_access_url, mobile_access_url, price, group_price)

12830386596672724727 select t.date,sum(t.pay)/100 cost,sum(t.a_pay+t.b_pay)/100 costAB, sum(t.c_pay)/100 costC,count(distinct t.cust_id) actives, sum(t.pay)/(count(distinct t.cust_id)*100) costPerCust,sum(t.pv)pv, sum(t.click) click,sum(t.pay)/(sum(t.click)*100) cpc from ( select distinct t.cust_id,t.date,t.pay,t.a_pay,t.b_pay,t.c_pay,t.click,t.pv from cost_cpc_cust_day_hot t WHERE t.date between '2014-07-07' and '2014-07-13' and t.agent_id = 276926 and t.pay>0 )t

14242997136004316393 insert into t_bizlog_history select * from t_bizlog_20140626

7382243057795183594 delete from t_bizlog_history where opt_time >= '20140626' and opt_time < '20140627'

9136130252841431921 load data local infile '/data/actOpt/plan/20140616/creative.txt' into table t_account_optimize_data_creative (cust_id, data_type, creative_id, plan_name, group_name, title, description1, description2, default_access_url, default_show_url, mobile_access_url, mobile_show_url)

4104295244676626346 insert into t_low_cost_cust select c.cust_id cust_id from t_cust_remain c where not exists (select t.cust_id from (select d.cust_id cust_id from t_cust_stat_day d where d.date between '20140620' and '20140626' and d.cpc_pay >= 10 group by d.cust_id having count(d.cust_id)>=1 )t where t.cust_id = c.cust_id )

1602841323730482517 select t.date,sum(t.pay)/100 cost,sum(t.a_pay+t.b_pay)/100 costAB, sum(t.c_pay)/100 costC,count(distinct t.cust_id) actives, sum(t.pay)/(count(distinct t.cust_id)*100) costPerCust,sum(t.pv)pv, sum(t.click) click,sum(t.pay)/(sum(t.click)*100) cpc from ( select distinct t.cust_id,t.date,t.pay,t.a_pay,t.b_pay,t.c_pay,t.click,t.pv from cost_cpc_cust_day_hot t WHERE t.date between '2014-07-07' and '2014-07-13' and t.agent_id = 7306403 and t.pay>0 )t group by t.date order by t.date asc

354949893804037415 delete from t_customer_invest where cust_id in (select cust_id from t_customer_invest_tmp) and invest_date<'20140331'

16171946069052037078 delete from cust_renewaled where cust_id in (select cust_id from t_customer_invest_tmp) and date<'20140331'

15381351069224663258 select t.date,sum(t.pay)/100 cost,sum(t.a_pay+t.b_pay)/100 costAB, sum(t.c_pay)/100 costC,count(distinct t.cust_id) actives, sum(t.pay)/(count(distinct t.cust_id)*100) costPerCust,sum(t.pv)pv, sum(t.click) click,sum(t.pay)/(sum(t.click)*100) cpc from ( select distinct t.cust_id,t.date,t.pay,t.a_pay,t.b_pay,t.c_pay,t.click,t.pv from cost_cpc_cust_day_hot t WHERE t.date between '2014-07-07' and '2014-07-13' and t.second_agent_id = 18374206 and t.pay>0 )t

12080899912460099053 select t.bizCode bizCode, t.channelName channelName, t.supportName supportName, t.agentId agentId, t.agentName agentName, t.csName csName, if(t.cpcUserName is null, '?T??��|��??��|', t.cpcUserName) cpcUserName, t.custId custId, t.custName custName, t.firstTrade firstTrade, t.secondTrade secondTrade, sum(t.cost) cost, sum(t.click) click, count(distinct t.custid) custs, sum(t.cost)/sum(t.click) cpc, sum(t.cost)/1 costPerDay, sum(t.cost)/count(distinct t.custid) costPerCust, sum(t.cost)/count(distinct t.custid)/1 costPerCustPerDay, SUM(t.costAB) costAB, SUM(t.costA) costA, SUM(t.cost2B) cost2B, SUM(t.costC) costc from ( select d.max_biz_code bizCode,uic.realname channelName,uis.realname supportName,a.agent_id agentId,a.agent_name agentName, if(aui.agent_user_name is null, '?T??��|?��t', aui.agent_user_name) csName, cu.cust_id custid,cu.is_b isb,uicu.realname cpcUserName,cu.cust_name custName,ft.first_trade_name firstTrade,st.second_trade_name secondTrade,t.pay/100 cost, (t.pay-t.cpc_c_pay-t.cx_c_pay)/100 costAB, (t.cpc_a_pay+t.cx_a_pay)/100 costA, (t.cpc_b_pay+t.cx_b_pay)/100 cost2B, (t.cpc_c_pay+t.cx_c_pay)/100 costC, t.click click from t_mis_user_auth u inner join t_customer cu on cu.cpcuser = u.user_id inner join t_cust_stat_day t on t.cust_id = cu.cust_id left join t_agent a on t.agent_id = a.agent_id left join t_channelinfo ch on a.channel_id = ch.channel_id left join t_user_info uic on uic.user_id = ch.user_id left join t_user_info uis on uis.user_id = a.support_id left join t_customer_dis dis on dis.cust_id = cu.cust_id and dis.role_id = 107 left join t_agent_user_info aui on aui.agent_user_id = dis.agent_user_id left join t_user_info uicu on uicu.user_id = cu.cpcuser left join t_first_trade ft on cu.first_trade_code=ft.first_trade_code left join t_second_trade st on cu.second_trade_code=st.second_trade_code left join t_mis_user_auth cua on cua.user_id = ch.user_id left join t_mis_department d on d.depart_id = cua.depart_id and d.if_delete = 0 where ( u.data_auth like "cbost4t11000234m%" ) and t.date='2014-06-25' and t.pay<>0 and u.if_delete=0 ) t group by custId,agentId order by custId desc,agentId desc

6823381848000688775 load data local infile "/data/hierarchy-script/realtimecost/realcost.dat" into table t_cust_stat_realtime_20140420(e_time_hour, e_time_min, cust_id, cpc_pay, cx_pay, status)

13877986249282993128 select t.date,sum(t.pay)/100 cost,sum(t.a_pay+t.b_pay)/100 costAB, sum(t.c_pay)/100 costC,count(distinct t.cust_id) actives, sum(t.pay)/(count(distinct t.cust_id)*100) costPerCust,sum(t.pv)pv, sum(t.click) click,sum(t.pay)/(sum(t.click)*100) cpc from ( select distinct t.cust_id,t.date,t.pay,t.a_pay,t.b_pay,t.c_pay,t.click,t.pv from cost_cpc_cust_day_hot t WHERE t.date between '2014-07-07' and '2014-07-13' and t.second_agent_id = 7951480 and t.pay>0 )t group by t.date order by t.date asc

6207365650723473125 select sum(t.pay)/100 cost, sum(t.a_pay+t.b_pay)/100 costAB, sum(t.c_pay)/100 costC, count(distinct t.cust_id) custs, sum(t.pay)/(count(distinct t.cust_id)*100) costPerCust, sum(t.pay)/(100*(TIMESTAMPDIFF(DAY,'2014-07-09','2014-07-09')+1)) costPerDay, sum(t.pay)/(100*count(distinct t.cust_id)*(TIMESTAMPDIFF(DAY,'2014-07-09','2014-07-09')+1)) costPerCustPerDay, sum(t.click) click, sum(t.pv) pv, sum(t.pay)/(100*sum(t.click)) cpc from ( select distinct t.cust_id,t.date,t.pay,t.a_pay,t.b_pay,t.c_pay,t.click,t.pv from cost_cpc_cust_day_hot t left join cust_dis cd on t.cust_id=cd.cust_id and cd.role_id in (107, 106) WHERE t.date between '2014-07-09' and '2014-07-09' and t.agent_id = 18171506 and t.pay>0 )t

11963123707036900324 load data local infile "/data/hierarchy-script/realtimecost/realcost.dat" into table t_cust_stat_realtime_20140307(e_time_hour, e_time_min, cust_id, cpc_pay, cx_pay)