Mysql WorkLoad Report


Host NameIp addrPortDb roleVersionUptime
db2.11192.168.2.11 3306 master 5.5.27 0y 2m 2d 7h 55mi 33s

Snap IdSnap TimeThreads_connectedThreads_running
Begin Snap:12013-05-21 14:12:02481.00 3.00
End Snap:5892013-05-22 00:00:02450.00 2.00
Elapsed: 35280 (seconds)


Start snap value and end snap value

BeginEnd
query_cache_size :536870912.00 536870912.00
thread_cache_size :8.00 8.00
table_definition_cache :400.00 400.00
max_connections :1000.00 1000.00
table_open_cache :512.00 512.00
slow_launch_time :2.00 2.00
max_heap_table_size :16777216.00 16777216.00
tmp_table_size :67108864.00 67108864.00
open_files_limit :131072.00 131072.00
Max_used_connections :546.00 546.00
Threads_connected :481.00 450.00
Threads_cached :7.00 7.00
Threads_created :69201.00 70825.00
Threads_running :3.00 2.00
Connections :354956.00 360120.00
key_buffer_size :4294967296.00 4294967296.00
join_buffer_size :131072.00 131072.00
sort_buffer_size :2097152.00 2097152.00
Key_blocks_not_flushed :0.00 0.00
Key_blocks_unused :2375290.00 2375230.00
Key_blocks_used :1969607.00 1969607.00
Key_read_requests :3487777792.00 3534557184.00
Key_reads :1707226.00 1707233.00
Key_write_requests :146567904.00 146596912.00
Key_writes :68096480.00 68112368.00
Questions :2205072128.00 2221643520.00
Com_select :296839808.00 301102016.00
Com_insert :1641965312.00 1653826688.00
Com_update :222941536.00 223330160.00
Com_delete :379099.00 400600.00
Bytes_received :1289763160064.00 1299087491072.00
Bytes_sent :2367515000832.00 2383360819200.00
Qcache_hits :189425152.00 189425152.00
Qcache_inserts :13178355.00 13178355.00
Select_full_join :115250.00 115250.00
Select_scan :79686792.00 79825888.00
Slow_queries :78863800.00 79023552.00
Com_commit :1026895.00 1028760.00
Com_rollback :43041.00 43293.00
Open_files :270.00 269.00
Open_table_definitions :266.00 267.00
Open_tables :512.00 512.00
Opened_files :9150943.00 9270557.00
Opened_table_definitions :1002.00 1004.00
Opened_tables :8417.00 8429.00
Created_tmp_disk_tables :1984868.00 2014532.00
Created_tmp_files :149046.00 149955.00
Created_tmp_tables :3449305.00 3488825.00
Binlog_cache_disk_use :10621.00 10627.00
Binlog_cache_use :1658462336.00 1670670848.00
Aborted_clients :6962.00 7029.00
Sort_merge_passes :627265.00 628456.00
Sort_range :24359336.00 24971876.00
Sort_rows :76120592.00 76849456.00
Sort_scan :302621.00 305819.00
Table_locks_immediate :75422326784.00 75864784896.00
Table_locks_waited :4291.00 29649.00
Handler_read_first :78804400.00 78925768.00
Handler_read_key :5417383936.00 5433953792.00
Handler_read_last :5363.00 5440.00
Handler_read_next :29760935936.00 29854246912.00
Handler_read_prev :224503360.00 224840768.00
Handler_read_rnd :1990567296.00 1991156480.00
Handler_read_rnd_next :577819115520.00 582355714048.00
Innodb_rows_inserted :1687403904.00 1699259392.00
Innodb_rows_updated :81918272.00 82447104.00
Innodb_rows_deleted :414019.00 436102.00
Innodb_rows_read :566820798464.00 570683752448.00
Innodb_buffer_pool_read_requests:173554647040.00174656290816.00
Innodb_buffer_pool_reads :2949612.00 3018912.00
Innodb_buffer_pool_pages_data :2583711.00 2573302.00
Innodb_buffer_pool_pages_free :0.00 0.00
Innodb_buffer_pool_pages_dirty :18480.00 18114.00
Innodb_buffer_pool_pages_flushed:76138168.0076705496.00
Innodb_data_reads :8187181.00 8266072.00
Innodb_data_writes :3397593856.00 3422599424.00
Innodb_data_read :134015893504.00 135308443648.00
Innodb_data_written :5456696705024.00 5497065308160.00
Innodb_os_log_fsyncs :5927693.00 5968877.00
Innodb_os_log_written :2961621385216.00 2983398735872.00
history_list :1204.00 3359.00
log_bytes_written :3579557183488.00 3588847042560.00
log_bytes_flushed :3579556921344.00 3588847042560.00
last_checkpoint :3579222163456.00 3588507041792.00
queries_inside :0.00 0.00
queries_queued :0.00 0.00
read_views :1.00 1.00
innodb_open_files :300.00 300.00
innodb_log_waits :0.00 0.00


Some Key Load Info

Per Second
TPS: 347
Com_select(s): 120
Com_insert(s): 336
Com_update(s): 11
Com_delete(s): 0
Innodb t_row PS: 351
Innodb_rows_inserted(s):336
Innodb_rows_updated(s): 14
Innodb_rows_deleted(s): 0
Innodb_rows_read(/s): 109494
Innodb_data_reads(s): 2
Innodb_data_writes(s): 708
Innodb_data_read(kb/s):35
Innodb_data_written(kb/s):1117
Innodb_os_log_fsyncs(s):1
Innodb_os_log_written(kb/s):602


Some Key Hits

Percentage
key_buffer_read_hits %:99.99
key_buffer_write_hits %:45.22
Innodb_buffer_read_hits %:99.99
Query_cache_hits %:0
Thread_cache_hits %:68.55


Top 10 Timed Events

event_namewait time(picsecond)wait count
wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond3463610325536195711871685
wait/synch/cond/mysys/my_thread_var::suspend700866693198015325357
wait/io/file/myisam/dfile32411175566482564230709979
wait/io/file/innodb/innodb_log_file40523299436163924434707
wait/io/file/sql/binlog33219726099371748314620
wait/synch/mutex/mysys/THR_LOCK::mutex216558956818824883945858
wait/io/file/innodb/innodb_data_file174810511964073776877
wait/synch/rwlock/innodb/index_tree_rw_lock11589534435314118558610
wait/synch/mutex/sql/LOG::LOCK_log10052107363453897564100
wait/synch/mutex/innodb/log_sys_mutex39056470050048150783962

Top 10 read file Events

event_nameread bytesread count
wait/io/file/myisam/dfile961118350552474810480
wait/io/file/sql/binlog733831331336062679
wait/io/file/innodb/innodb_data_file129255014478891
wait/io/file/myisam/kfile1343170059328
wait/io/file/sql/FRM609814
wait/io/file/sql/log_event_info00
wait/io/file/archive/metadata00
wait/io/file/csv/update00
wait/io/file/sql/dbopt00
wait/io/file/sql/init00

Top 10 write file Events

event_nameread bytesread count
wait/io/file/innodb/innodb_data_file24677580800611919
wait/io/file/innodb/innodb_log_file2177936384024393556
wait/io/file/sql/binlog733831332012251921
wait/io/file/myisam/dfile1056829067718535
wait/io/file/sql/slow_log38778959159751
wait/io/file/myisam/kfile14356888440529
wait/io/file/sql/FRM714584
wait/io/file/sql/binlog_index2037
wait/io/file/sql/log_event_info00
wait/io/file/archive/metadata00


OS Load Info

Snap Timeload1load5load15
2013-05-21 14:12:020.080.070.07
2013-05-21 14:22:021.160.870.45
2013-05-21 14:32:020.060.430.47
2013-05-21 14:42:020.020.090.25
2013-05-21 14:52:020.030.090.16
2013-05-21 15:02:030.050.050.09
2013-05-21 15:12:020.050.030.06
2013-05-21 15:22:020.100.090.06
2013-05-21 15:32:020.110.120.09
2013-05-21 15:42:030.000.020.05
2013-05-21 15:52:020.010.050.04
2013-05-21 16:02:020.170.100.05
2013-05-21 16:12:020.120.140.09
2013-05-21 16:22:030.310.130.10
2013-05-21 16:32:020.130.080.08
2013-05-21 16:42:020.100.090.08
2013-05-21 16:52:020.100.140.13
2013-05-21 17:02:030.090.060.08
2013-05-21 17:12:020.200.090.07
2013-05-21 17:22:020.150.090.06
2013-05-21 17:32:020.040.060.04
2013-05-21 17:42:020.000.030.02
2013-05-21 17:52:020.050.060.02
2013-05-21 18:02:021.030.540.20
2013-05-21 18:12:022.011.811.04
2013-05-21 18:22:021.121.271.11
2013-05-21 18:32:021.021.081.08
2013-05-21 18:42:021.031.061.07
2013-05-21 18:52:021.171.141.10
2013-05-21 19:02:021.001.031.05
2013-05-21 19:12:030.951.051.06
2013-05-21 19:22:020.000.230.63
2013-05-21 19:32:020.000.050.33
2013-05-21 19:42:030.170.080.19
2013-05-21 19:52:020.030.060.11
2013-05-21 20:02:020.350.140.10
2013-05-21 20:12:020.050.070.07
2013-05-21 20:22:020.010.030.03
2013-05-21 20:32:020.010.030.00
2013-05-21 20:42:020.060.020.00
2013-05-21 20:52:020.330.080.02
2013-05-21 21:02:020.140.110.03
2013-05-21 21:12:020.060.060.01
2013-05-21 21:22:021.391.180.54
2013-05-21 21:32:030.150.570.56
2013-05-21 21:42:020.050.120.31
2013-05-21 21:52:020.160.110.19
2013-05-21 22:02:020.150.130.16
2013-05-21 22:12:020.080.130.13
2013-05-21 22:22:020.110.100.09
2013-05-21 22:32:020.030.090.08
2013-05-21 22:42:020.020.040.06
2013-05-21 22:52:020.050.050.04
2013-05-21 23:02:020.160.120.07
2013-05-21 23:12:030.000.030.04
2013-05-21 23:22:020.080.040.02
2013-05-21 23:32:020.030.030.00
2013-05-21 23:42:020.280.130.04
2013-05-21 23:52:020.100.110.06
2013-05-22 00:00:020.020.040.03

OS CPU Info

Snap Timeusersystemidleiowait
2013-05-21 14:12:021.000.0099.000.00
2013-05-21 14:22:027.001.0093.000.00
2013-05-21 14:32:021.000.0099.000.00
2013-05-21 14:42:021.000.0099.000.00
2013-05-21 14:52:021.000.0098.000.00
2013-05-21 15:02:031.000.0098.000.00
2013-05-21 15:12:021.000.0099.000.00
2013-05-21 15:22:021.000.0099.000.00
2013-05-21 15:32:021.000.0099.000.00
2013-05-21 15:42:031.000.0099.000.00
2013-05-21 15:52:021.000.0099.000.00
2013-05-21 16:02:021.000.0099.000.00
2013-05-21 16:12:021.000.0098.000.00
2013-05-21 16:22:031.000.0099.000.00
2013-05-21 16:32:021.000.0099.000.00
2013-05-21 16:42:021.000.0098.000.00
2013-05-21 16:52:021.000.0099.000.00
2013-05-21 17:02:031.000.0099.000.00
2013-05-21 17:12:021.000.0099.000.00
2013-05-21 17:22:021.000.0099.000.00
2013-05-21 17:32:021.000.0099.000.00
2013-05-21 17:42:021.000.0099.000.00
2013-05-21 17:52:021.000.0099.000.00
2013-05-21 18:02:022.003.0095.000.00
2013-05-21 18:12:026.003.0091.000.00
2013-05-21 18:22:022.003.0095.000.00
2013-05-21 18:32:022.002.0095.000.00
2013-05-21 18:42:022.003.0095.000.00
2013-05-21 18:52:023.003.0094.000.00
2013-05-21 19:02:023.003.0094.000.00
2013-05-21 19:12:032.003.0095.000.00
2013-05-21 19:22:021.000.0099.000.00
2013-05-21 19:32:021.000.0099.000.00
2013-05-21 19:42:031.000.0099.000.00
2013-05-21 19:52:021.000.0099.000.00
2013-05-21 20:02:021.000.0099.000.00
2013-05-21 20:12:021.000.0099.000.00
2013-05-21 20:22:021.000.0099.000.00
2013-05-21 20:32:021.000.0099.000.00
2013-05-21 20:42:021.000.0099.000.00
2013-05-21 20:52:021.000.0099.000.00
2013-05-21 21:02:021.000.0099.000.00
2013-05-21 21:12:021.000.0099.000.00
2013-05-21 21:22:024.000.0095.000.00
2013-05-21 21:32:031.000.0099.000.00
2013-05-21 21:42:021.000.0099.000.00
2013-05-21 21:52:021.000.0099.000.00
2013-05-21 22:02:021.000.0099.000.00
2013-05-21 22:12:021.000.0099.000.00
2013-05-21 22:22:024.000.0096.000.00
2013-05-21 22:32:020.000.0099.000.00
2013-05-21 22:42:021.000.0099.000.00
2013-05-21 22:52:024.000.0096.000.00
2013-05-21 23:02:021.000.0099.000.00
2013-05-21 23:12:031.000.0099.000.00
2013-05-21 23:22:021.000.0099.000.00
2013-05-21 23:32:021.000.0099.000.00
2013-05-21 23:42:020.000.0099.000.00
2013-05-21 23:52:021.000.0099.000.00
2013-05-22 00:00:021.000.0099.000.00

OS IO Info

Snap Timerd_ios_swr_ios_srkbswkbsqueuesvc_tbusy
2013-05-21 14:12:020.0010.790.00758.940.000.170.18
2013-05-21 14:22:028.0113.01896.751092.910.020.952.00
2013-05-21 14:32:020.0021.340.001135.440.010.150.32
2013-05-21 14:42:020.0013.070.00699.790.000.080.10
2013-05-21 14:52:020.0030.000.001008.750.000.060.19
2013-05-21 15:02:030.0016.640.001201.310.000.160.26
2013-05-21 15:12:020.0021.500.00827.770.000.040.09
2013-05-21 15:22:020.0016.390.00952.290.000.180.29
2013-05-21 15:32:020.0015.800.00709.870.000.240.37
2013-05-21 15:42:030.0017.940.001012.120.010.160.28
2013-05-21 15:52:020.0024.480.001317.810.010.120.31
2013-05-21 16:02:020.0029.180.001068.690.000.060.18
2013-05-21 16:12:020.0027.660.001453.090.010.170.46
2013-05-21 16:22:030.0026.090.00898.300.010.090.23
2013-05-21 16:32:020.0025.170.00944.900.000.120.29
2013-05-21 16:42:020.0025.670.001100.900.000.080.21
2013-05-21 16:52:020.0028.240.00952.470.000.030.09
2013-05-21 17:02:030.0025.240.001060.120.010.380.95
2013-05-21 17:12:020.9712.583.87789.680.010.710.97
2013-05-21 17:22:020.0028.080.001460.180.010.160.44
2013-05-21 17:32:020.0021.690.00860.560.000.040.09
2013-05-21 17:42:020.0012.080.00929.810.000.080.10
2013-05-21 17:52:020.0042.770.001078.160.010.120.50
2013-05-21 18:02:020.0031.880.00791.250.000.060.19
2013-05-21 18:12:020.0036.650.00669.070.000.080.28
2013-05-21 18:22:020.0024.410.00713.620.000.120.28
2013-05-21 18:32:020.0036.650.001369.390.000.070.27
2013-05-21 18:42:020.0053.480.001568.730.010.090.47
2013-05-21 18:52:020.0030.540.001166.830.010.100.32
2013-05-21 19:02:020.0029.990.00711.700.000.070.20
2013-05-21 19:12:030.0039.720.00835.100.020.050.18
2013-05-21 19:22:020.0015.350.00818.760.000.070.10
2013-05-21 19:32:020.0012.400.00694.160.000.150.19
2013-05-21 19:42:030.0012.120.00758.130.000.270.33
2013-05-21 19:52:020.0022.420.001588.170.000.120.28
2013-05-21 20:02:020.0024.780.00800.990.000.080.20
2013-05-21 20:12:020.008.870.00692.050.000.100.09
2013-05-21 20:22:020.0011.810.00687.250.000.000.00
2013-05-21 20:32:020.0013.930.00679.250.000.060.09
2013-05-21 20:42:020.0011.180.00708.350.000.080.09
2013-05-21 20:52:020.0011.560.00704.980.000.080.10
2013-05-21 21:02:020.0025.960.00797.220.000.040.09
2013-05-21 21:12:020.0033.670.001442.300.000.080.27
2013-05-21 21:22:020.0022.880.00724.670.000.170.38
2013-05-21 21:32:030.0024.500.00840.520.000.040.09
2013-05-21 21:42:020.009.620.00708.260.000.000.00
2013-05-21 21:52:020.0012.120.001006.600.000.150.19
2013-05-21 22:02:020.0014.120.00988.720.000.080.12
2013-05-21 22:12:020.0012.410.00794.480.010.250.31
2013-05-21 22:22:020.0013.330.00693.330.000.130.18
2013-05-21 22:32:020.0025.120.001142.220.000.070.17
2013-05-21 22:42:020.0022.320.00684.500.000.050.11
2013-05-21 22:52:020.0010.280.00706.270.000.180.19
2013-05-21 23:02:020.0017.730.00617.070.000.100.18
2013-05-21 23:12:030.0016.070.001072.920.000.000.00
2013-05-21 23:22:020.0018.520.00802.400.000.110.21
2013-05-21 23:32:020.0018.640.001168.410.010.170.31
2013-05-21 23:42:020.0022.020.00660.550.000.080.18
2013-05-21 23:52:020.0026.910.001877.740.010.150.40
2013-05-22 00:00:020.0056.860.001250.840.010.120.66

OS Other Info

Snap Timeswap_inswap_outnet_recvnet_sendfile_systemtotal_mbused_mbused_pctmount_point
2013-05-21 14:12:020.000.00676864.002111744.00/dev/sdb11967606.001621472.0087.00/data
2013-05-21 14:22:020.000.002247584.005089303.00/dev/sdb11967606.001621705.0087.00/data
2013-05-21 14:32:020.000.001494519.005022274.00/dev/sdb11967606.001621941.0087.00/data
2013-05-21 14:42:020.000.00445235.00399025.00/dev/sdb11967606.001622174.0087.00/data
2013-05-21 14:52:020.000.00869100.001750227.00/dev/sdb11967606.001622424.0087.00/data
2013-05-21 15:02:030.000.001028981.003944281.00/dev/sdb11967606.001622659.0087.00/data
2013-05-21 15:12:020.000.00707387.00748465.00/dev/sdb11967606.001622892.0087.00/data
2013-05-21 15:22:028.000.00678920.00622935.00/dev/sdb11967606.001623142.0087.00/data
2013-05-21 15:32:020.000.00506476.00459623.00/dev/sdb11967606.001623375.0087.00/data
2013-05-21 15:42:030.000.00527133.00565192.00/dev/sdb11967606.001623609.0087.00/data
2013-05-21 15:52:020.000.00678439.00624455.00/dev/sdb11967606.001623861.0087.00/data
2013-05-21 16:02:022.000.00725471.001549546.00/dev/sdb11967606.001624121.0087.00/data
2013-05-21 16:12:020.000.001075014.003930267.00/dev/sdb11967606.001624369.0087.00/data
2013-05-21 16:22:030.000.00857507.002321507.00/dev/sdb11967606.001624622.0087.00/data
2013-05-21 16:32:020.000.00679753.00628464.00/dev/sdb11967606.001624868.0088.00/data
2013-05-21 16:42:020.000.00812187.001416445.00/dev/sdb11967606.001625115.0088.00/data
2013-05-21 16:52:025.000.00559153.00511832.00/dev/sdb11967606.001625359.0088.00/data
2013-05-21 17:02:030.000.00601014.00550670.00/dev/sdb11967606.001625588.0088.00/data
2013-05-21 17:12:020.000.00569139.00709423.00/dev/sdb11967606.001625824.0088.00/data
2013-05-21 17:22:020.000.00612136.00561918.00/dev/sdb11967606.001626066.0088.00/data
2013-05-21 17:32:020.000.00722392.00719460.00/dev/sdb11967606.001626321.0088.00/data
2013-05-21 17:42:020.000.00775741.002252267.00/dev/sdb11967606.001626548.0088.00/data
2013-05-21 17:52:020.000.001008192.003360773.00/dev/sdb11967606.001626777.0088.00/data
2013-05-21 18:02:020.000.00514139.00477544.00/dev/sdb11967606.001626999.0088.00/data
2013-05-21 18:12:020.000.00384897.00356495.00/dev/sdb11967606.001627220.0088.00/data
2013-05-21 18:22:020.000.00504705.00466993.00/dev/sdb11967606.001627419.0088.00/data
2013-05-21 18:32:020.000.00446308.00411714.00/dev/sdb11967606.001627619.0088.00/data
2013-05-21 18:42:020.000.00525266.00488981.00/dev/sdb11967606.001627823.0088.00/data
2013-05-21 18:52:020.000.00636915.00596432.00/dev/sdb11967606.001628053.0088.00/data
2013-05-21 19:02:020.001.00597816.002079870.00/dev/sdb11967606.001628255.0088.00/data
2013-05-21 19:12:030.000.00544558.00510752.00/dev/sdb11967606.001628478.0088.00/data
2013-05-21 19:22:020.000.00441585.00398257.00/dev/sdb11967606.001628687.0088.00/data
2013-05-21 19:32:020.000.00416017.00369934.00/dev/sdb11967606.001628878.0088.00/data
2013-05-21 19:42:030.000.00413446.00378489.00/dev/sdb11967606.001629081.0088.00/data
2013-05-21 19:52:020.000.00658825.00665914.00/dev/sdb11967606.001629289.0088.00/data
2013-05-21 20:02:020.000.00618088.001368997.00/dev/sdb11967606.001629505.0088.00/data
2013-05-21 20:12:020.000.00494640.00449590.00/dev/sdb11967606.001629701.0088.00/data
2013-05-21 20:22:020.000.00434987.00401775.00/dev/sdb11967606.001629902.0088.00/data
2013-05-21 20:32:020.000.00719177.002208004.00/dev/sdb11967606.001630079.0088.00/data
2013-05-21 20:42:020.000.00544593.00494996.00/dev/sdb11967606.001630267.0088.00/data
2013-05-21 20:52:020.000.00627816.00940006.00/dev/sdb11967606.001630488.0088.00/data
2013-05-21 21:02:020.000.00410082.00370759.00/dev/sdb11967606.001630663.0088.00/data
2013-05-21 21:12:020.000.00487333.00444037.00/dev/sdb11967606.001630856.0088.00/data
2013-05-21 21:22:020.000.00425702.00400337.00/dev/sdb11967606.001631065.0088.00/data
2013-05-21 21:32:030.000.00597705.00541170.00/dev/sdb11967606.001631253.0088.00/data
2013-05-21 21:42:020.000.00484211.00440031.00/dev/sdb11967606.001631449.0088.00/data
2013-05-21 21:52:020.000.00651420.00682513.00/dev/sdb11967606.001631696.0088.00/data
2013-05-21 22:02:020.000.00531016.00481571.00/dev/sdb11967606.001631895.0088.00/data
2013-05-21 22:12:020.000.00406891.00364716.00/dev/sdb11967606.001632103.0088.00/data
2013-05-21 22:22:020.000.00379475.00412177.00/dev/sdb11967606.001632302.0088.00/data
2013-05-21 22:32:020.000.00454113.00410740.00/dev/sdb11967606.001632500.0088.00/data
2013-05-21 22:42:020.000.00461560.00788269.00/dev/sdb11967606.001632689.0088.00/data
2013-05-21 22:52:020.001.00630641.00660117.00/dev/sdb11967606.001632903.0088.00/data
2013-05-21 23:02:020.000.00460634.00418825.00/dev/sdb11967606.001633089.0088.00/data
2013-05-21 23:12:030.000.001015481.004152029.00/dev/sdb11967606.001633301.0088.00/data
2013-05-21 23:22:020.000.00432938.00391443.00/dev/sdb11967606.001633499.0088.00/data
2013-05-21 23:32:020.000.00624282.00575975.00/dev/sdb11967606.001633683.0088.00/data
2013-05-21 23:42:020.000.00408901.00372704.00/dev/sdb11967606.001633909.0088.00/data
2013-05-21 23:52:020.000.00616048.00625541.00/dev/sdb11967606.001634151.0088.00/data
2013-05-22 00:00:024.000.00417361.00381697.00/dev/sdb11967606.001634326.0088.00/data


TOP 20 SQL

checksumdb namets_mints_maxts_cntQuery_time_sumQuery_time_pct_95Lock_time_sumLock_time_pct_95Rows_sent_sumRows_sent_pct_95sample
17518085470290754732test2013-05-21 09:32:562013-05-21 19:14:403170511346.30.5261516573.050.3561200update xxxx_test ...
8783231904896245142test2013-05-21 08:55:122013-05-21 21:27:498945128.986.984630.0444420.00006325448941SELECT count(id) as ...
3360175983660887134test2013-05-21 08:54:542013-05-21 21:27:231511861.8715.24660.0077390.00006973791511SELECT count(id) as ...
13309653179631320993test2013-05-21 21:48:262013-05-21 23:15:39293265.6820.9921370.0312670.000119276145903487.094SELECT b.id, b...
14565464025717298162test2013-05-21 01:48:452013-05-21 21:48:3520239.17816.80940.004560.00031647300INSERT INTO AAAA_A...
13312995569039381386test2013-05-21 00:03:312013-05-21 23:59:5632116665.31120.00020400219.45660.00008073043211661select last_insert_i...
10354574056648609809test2013-05-21 18:19:212013-05-21 18:19:21141.087941.08790.000110.000112020SELECT ID, MI...
497734220985120500test2013-05-21 00:05:202013-05-21 23:51:39191317.19190.04161670.2024650.000131501185989.82808select * from ( s...
9637830689706458981test2013-05-21 23:39:242013-05-22 00:01:16768.107880.1409290.0080220.00011927638000500SELECT b.id, b...
14126161800600546731test2013-05-21 21:47:482013-05-21 21:47:4814.763754.763750.0001050.00010500Update test. bat...
17471270398124473757test2013-05-21 23:39:042013-05-21 23:39:0412.353012.353010.0000770.00007700Update test.exce...
16832470833228384350test2013-05-21 10:09:002013-05-21 18:27:46252.111040.1342180.0050740.0002142021547.70056select t.operator_i...
13191748705407557481test2013-05-21 09:54:072013-05-21 21:21:21511.183540.02433240.010470.000069737970.992137select t.ID,...
12670572290300457907test2013-05-21 01:48:532013-05-21 23:49:091950.9077690.004863380.0159950.00009345551610.992137select * from liv...
7307725764902681358test2013-05-21 09:55:482013-05-21 21:21:21410.8885540.02317370.0020630.000066417170.992137select t.ID,...
441461047919072052test2013-05-21 09:55:152013-05-21 21:21:21320.7070330.02317370.0017940.000063254470.992137select t.ID,...
5959496469465290778test2013-05-21 00:16:172013-05-21 23:58:4224530.6272880.0002733820.1513390.000076886122980.992137SELECT id,t.hits FRO...
7840036358297485213information_schema2013-05-21 14:12:022013-05-22 00:01:025900.3853290.0007997130.0330360.0000632544131570223select * from perfor...
1667592239102617093test2013-05-21 09:39:352013-05-21 17:58:50130.3068610.04817650.0008690.0000732248131SELECT MIN(PUBLISH_T...
4588707098242522987information_schema2013-05-21 14:12:022013-05-22 00:01:025900.294070.0005683410.0540930.0001135965901select VARIABLE_VALU...

TOP SQL DETAIL

checksumsql detail
17518085470290754732update test set plag = 2, uptime = now(), opid = 1 where ordid = 116459410
8783231904896245142SELECT count(id) as count FROM zzz_log where code='200001' and ccdoe='100001'
3360175983660887134SELECT count(id) as count FROM zzzz where code='200001'
4588707098242522987select VARIABLE_VALUE from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME='PERFORMANCE_SCHEMA'
.......more..............................................more................................

--------The End -----------