Mysql WorkLoad Report


Host NameIp addrPortDb roleVersionUptime
a1-dba-tech01.hz10.128.6.21 3309 master 5.6.17 0y 2m 21d 20h 5mi 6s

Platformcorescpussocketsmemory
Linux x86_64 12 24 2 126 GB

Snap IdSnap TimeThreads_connectedThreads_running
Begin Snap:135702014-08-29 03:40:0255.00 2.00
End Snap:140032014-08-29 10:53:0256.00 2.00
Elapsed: 25980 (seconds)

Start snap value and end snap value

BeginEndDiff
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.00104983756800.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.00522683936.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


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


Top 10 Timed Events

event_namewait time(picsecond)wait count
idle27493394198710000003095558
wait/io/table/sql/handler361158492515975111193666
wait/io/file/innodb/innodb_log_file87786043460885436951
wait/io/file/innodb/innodb_data_file693276346266351657383
wait/io/file/sql/binlog59725654595530981919
wait/io/file/myisam/dfile3937235958001519995031
wait/io/file/myisam/kfile3527027446250417765
wait/lock/table/sql/handler18248606918852900663
wait/io/file/sql/dbopt251618012803243
wait/io/file/sql/slow_log485234288042

Top 10 read file Events

event_nameread bytesread count
wait/io/file/myisam/dfile197115040110391148
wait/io/file/sql/binlog215152949583622
wait/io/file/myisam/kfile705062125098
wait/io/file/sql/map00
wait/io/file/myisam/data_tmp00
wait/io/file/sql/trigger00
wait/io/file/sql/relay_log_info00
wait/io/file/sql/master_info00
wait/io/file/sql/global_ddl_log00
wait/io/file/innodb/innodb_log_file00

Top 10 write file Events

event_nameread bytesread count
wait/io/file/innodb/innodb_data_file521096232961600257
wait/io/file/myisam/dfile11475980884314766
wait/io/file/innodb/innodb_log_file926151168218472
wait/io/file/sql/binlog215152949208027
wait/io/file/myisam/kfile8238045304824
wait/io/file/sql/slow_log13727
wait/io/file/sql/map00
wait/io/file/myisam/data_tmp00
wait/io/file/sql/trigger00
wait/io/file/sql/relay_log_info00


Innodb activity(1)

Snap TimeCom_insCom_updCom_delCom_selTPSBuf_read_reqHit%Innodb_rows_insInnodb_rows_updInnodb_rows_delInnodb_rows_readInnodb_log_fsyncsInnodb_log_wrn(k/s)Threads_running
2014-08-29 03:47:0226029894401002046029747342.00
2014-08-29 03:54:0327039998071002058030118362.00
2014-08-29 04:01:02260318999010023213031188372.00
2014-08-29 04:08:02270379994710022723031118372.00
2014-08-29 04:15:0226029894011002056029797342.00
2014-08-29 04:22:0327036997291002077030118342.00
2014-08-29 04:29:0227042998141002047030208332.00
2014-08-29 04:36:0226032886791002057026478322.00
2014-08-29 04:43:0226031894401002056029698323.00
2014-08-29 04:50:0226033895961002026029938322.00
2014-08-29 04:57:0227036996931002057029988332.00
2014-08-29 05:04:022703291033710025129032238412.00
2014-08-29 05:11:0226035894591002097029938332.00
2014-08-29 05:18:0236029994401002086029938332.00
2014-08-29 05:25:0327046999821002048030119342.00
2014-08-29 05:32:0226031895411002046029918332.00
2014-08-29 05:39:0326034886201002047026228352.00
2014-08-29 05:46:0226029895211002055029967342.00
2014-08-29 05:53:0227038997711002058030038362.00
2014-08-29 06:00:0226031898301002037030868343.00
2014-08-29 06:07:022703691000510025329031258412.00
2014-08-29 06:14:0226031894201002076030088332.00
2014-08-29 06:21:0236033996541002087029938332.00
2014-08-29 06:28:0327044995731002058029629354.00
2014-08-29 06:35:0226030887191002027026988332.00
2014-08-29 06:42:0326033896511002047029918352.00
2014-08-29 06:49:0226030894621002056029868362.00
2014-08-29 06:56:0327038997481002048030068342.00
2014-08-29 07:03:0237032101036210025029032118412.00
2014-08-29 07:10:0326035894561002107030018352.00
2014-08-29 07:17:0226029894431002066029867332.00
2014-08-29 07:24:0227044997711002088030039352.00
2014-08-29 07:31:0326033886201002047026318332.00
2014-08-29 07:38:0226035897361002057030208332.00
2014-08-29 07:45:0226029893421002015029847332.00
2014-08-29 07:52:0227037997131002048030188342.00
2014-08-29 07:59:0226032898101002057030678332.00
2014-08-29 08:06:0237035101012210025529031548412.00
2014-08-29 08:13:0226032894201002056029897332.00
2014-08-29 08:20:0336031994561002066029868332.00
2014-08-29 08:27:02280461089931002068026689342.00
2014-08-29 08:34:0326028894951002056029867332.00
2014-08-29 08:41:0226034896381002047030068342.00
2014-08-29 08:48:0226030894201002046029748332.00
2014-08-29 08:55:0227038997131002038029988332.00
2014-08-29 09:02:022603181000510023614031158372.00
2014-08-29 09:09:033703610980710022422030848372.00
2014-08-29 09:16:0226029894821002076029867342.00
2014-08-29 09:23:0227040989521002068026529352.00
2014-08-29 09:30:0227037996151002037030138342.00
2014-08-29 09:37:0226033895961002047029698342.00
2014-08-29 09:44:0326031894761002046029727332.00
2014-08-29 09:51:0227035997171002057030208332.00
2014-08-29 09:58:0227035996931002048030038332.00
2014-08-29 10:05:0337034101019610025229031818402.00
2014-08-29 10:12:0226034895601002077030108332.00
2014-08-29 10:19:0226029885041002086026287332.00
2014-08-29 10:26:022804910100441002058031209342.00
2014-08-29 10:33:0226027894201002066029647332.00
2014-08-29 10:40:0226034895571002027029898332.00
2014-08-29 10:47:0226029893811002045029547322.00
2014-08-29 10:53:0227039998531002068030038342.00

Innodb activity(2)

Snap TimeIndb_pdataIndb_pfreeIndb_pdirtyIndb_pflushIndb_dreadsIndb_dwritesIndb_dread(k/s)Indb_dwritten(k/s)his_listInlog_uflushInlog_uckptqueries_insidequeries_queuedread_views
2014-08-29 03:47:024141100.008192.007126.0039048013063161.000200.000.000.00
2014-08-29 03:54:034141105.008188.005323.0064074020993526.00030.000.000.00
2014-08-29 04:01:024141101.008193.0018536.0034042011292900.000140.000.000.00
2014-08-29 04:08:024141102.008192.0024641.002303207992875.000400.000.000.00
2014-08-29 04:15:024141104.008192.007873.001060116034423249.000110.000.000.00
2014-08-29 04:22:034141103.008195.007869.0044053014473254.000110.000.000.00
2014-08-29 04:29:024141110.008192.005609.002103007163331.000400.000.000.00
2014-08-29 04:36:024141111.008194.008055.0048057015873297.000140.000.000.00
2014-08-29 04:43:024141116.008192.005552.0060069019773192.00020.000.001.00
2014-08-29 04:50:024141117.008192.008412.0049058016263467.000190.000.000.00
2014-08-29 04:57:024141116.008193.002094.0082092026773349.00000.000.000.00
2014-08-29 05:04:024141121.008192.0016461.0077087025182292.000190.000.000.00
2014-08-29 05:11:024141122.008193.004817.0084095027793054.00020.000.000.00
2014-08-29 05:18:024141128.008194.006014.001180127037813241.00020.000.000.00
2014-08-29 05:25:034141129.008193.009647.0033043011093186.000250.000.000.00
2014-08-29 05:32:024141133.008193.008005.0072082023603099.00060.000.000.00
2014-08-29 05:39:034141135.008192.006067.00920102029943579.00020.000.000.00
2014-08-29 05:46:024141135.008192.008811.0073082023823180.00070.000.000.00
2014-08-29 05:53:024141135.008192.0010200.0041051013653283.000290.000.000.00
2014-08-29 06:00:024141137.008191.009176.0045054014773398.000210.000.000.00
2014-08-29 06:07:024141137.008194.0016388.0075085024472482.000230.000.000.00
2014-08-29 06:14:024141140.008193.0011112.0042051013943102.000230.000.000.00
2014-08-29 06:21:024141142.008193.0013180.000080343310.000530.000.000.00
2014-08-29 06:28:034141146.008192.0012227.002303307952887.000830.000.001.00
2014-08-29 06:35:024141147.008192.0010041.0045054014783482.000180.000.000.00
2014-08-29 06:42:034141146.008193.0011143.002203107582869.000410.000.000.00
2014-08-29 06:49:024141148.008193.002387.001210131039173178.000110.000.000.00
2014-08-29 06:56:034141152.008194.0010788.002303207783662.000290.000.000.00
2014-08-29 07:03:024141154.008192.0027383.0060070019892137.000340.000.000.00
2014-08-29 07:10:034141160.008188.0024327.002303207952803.000500.000.000.00
2014-08-29 07:17:024141155.008193.0011500.001260136040783645.000160.000.000.00
2014-08-29 07:24:024141155.008193.0013721.000090343020.000460.000.000.00
2014-08-29 07:31:034141156.008192.008687.0046055015343373.000100.000.000.00
2014-08-29 07:38:024141158.008190.0011404.0046055015273348.000220.000.000.00
2014-08-29 07:45:024141156.008192.0010790.0088097028693123.000100.000.000.00
2014-08-29 07:52:024141156.008193.0011712.0060070019823519.000140.000.000.00
2014-08-29 07:59:024141157.008193.007372.0079088025622840.000100.000.000.00
2014-08-29 08:06:024141156.008194.0031142.002303208022654.000380.000.000.00
2014-08-29 08:13:024141158.008192.0014291.0071080023213068.000530.000.000.00
2014-08-29 08:20:034141158.008192.0016259.000080313334.000820.000.000.00
2014-08-29 08:27:024141158.008192.009302.002303307993241.000830.000.000.00
2014-08-29 08:34:034141158.008193.0010874.001000109032393740.000120.000.000.00
2014-08-29 08:41:024141159.008192.0010350.0063072020523165.00070.000.000.00
2014-08-29 08:48:024141158.008193.0011366.0046055015263173.000140.000.000.00
2014-08-29 08:55:024141158.008193.005827.0041051013623363.00010.000.000.00
2014-08-29 09:02:024141158.008193.0016722.0070079022912708.000100.000.000.00
2014-08-29 09:09:034141159.008192.0011316.0071081023172776.000260.000.000.00
2014-08-29 09:16:024141160.008194.0012104.0069078022503401.000150.000.000.00
2014-08-29 09:23:024141165.008192.0012535.002603709262938.000420.000.000.00
2014-08-29 09:30:024141166.008192.0010923.0090099028893245.000140.000.000.00
2014-08-29 09:37:024141167.008192.004382.0088097028573320.000170.000.000.00
2014-08-29 09:44:034141168.008192.008575.001100120035603128.00060.000.000.00
2014-08-29 09:51:024141169.008191.0012891.0077087025243132.000230.000.000.00
2014-08-29 09:58:024141166.008195.0011315.0047056015363646.000140.000.000.00
2014-08-29 10:05:034141169.008192.0014168.001400151045382531.000180.000.000.00
2014-08-29 10:12:024141166.008195.0011111.0089099028963200.000110.000.000.00
2014-08-29 10:19:024141167.008194.008862.001030112033352944.000100.000.000.00
2014-08-29 10:26:024141168.008195.0013359.002303307873187.000320.000.000.00
2014-08-29 10:33:024141171.008193.0013068.002303207943376.000500.000.000.00
2014-08-29 10:40:024141172.008192.0011317.0069079022722841.000130.000.000.00
2014-08-29 10:47:024141172.008193.009407.001470158047613344.00060.000.000.00
2014-08-29 10:53:024141176.008189.0013177.002703609013545.000340.000.000.00


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

Snap IDSnap Timeusersystemidleiowait load1load5 Threads_connectedThreads_runninglock_waits


OS Load Info

Snap Timeload1load5load15
2014-08-29 03:40:020.580.860.92
2014-08-29 03:47:020.811.000.96
2014-08-29 03:54:030.740.740.84
2014-08-29 04:01:020.510.610.73
2014-08-29 04:08:020.890.830.77
2014-08-29 04:15:020.801.100.94
2014-08-29 04:22:030.960.820.84
2014-08-29 04:29:022.371.371.03
2014-08-29 04:36:021.401.221.08
2014-08-29 04:43:021.361.041.03
2014-08-29 04:50:021.971.661.29
2014-08-29 04:57:021.091.451.33
2014-08-29 05:04:021.031.281.27
2014-08-29 05:11:020.520.861.08
2014-08-29 05:18:021.260.890.98
2014-08-29 05:25:030.660.730.86
2014-08-29 05:32:020.460.710.81
2014-08-29 05:39:031.090.770.77
2014-08-29 05:46:020.960.930.83
2014-08-29 05:53:021.130.860.82
2014-08-29 06:00:021.431.311.02
2014-08-29 06:07:021.561.251.07
2014-08-29 06:14:020.741.021.03
2014-08-29 06:21:021.220.980.96
2014-08-29 06:28:031.411.081.00
2014-08-29 06:35:020.741.141.08
2014-08-29 06:42:030.940.830.94
2014-08-29 06:49:021.080.980.94
2014-08-29 06:56:030.690.870.89
2014-08-29 07:03:020.830.990.94
2014-08-29 07:10:031.421.070.94
2014-08-29 07:17:021.191.181.03
2014-08-29 07:24:021.621.491.23
2014-08-29 07:31:031.161.201.19
2014-08-29 07:38:021.251.151.17
2014-08-29 07:45:021.611.301.22
2014-08-29 07:52:021.571.391.27
2014-08-29 07:59:020.951.121.19
2014-08-29 08:06:021.581.171.14
2014-08-29 08:13:020.520.841.01
2014-08-29 08:20:030.970.920.96
2014-08-29 08:27:020.750.830.89
2014-08-29 08:34:031.481.110.96
2014-08-29 08:41:020.890.950.90
2014-08-29 08:48:021.551.100.96
2014-08-29 08:55:020.971.231.08
2014-08-29 09:02:020.741.111.11
2014-08-29 09:09:030.710.810.96
2014-08-29 09:16:021.100.970.96
2014-08-29 09:23:020.980.970.96
2014-08-29 09:30:020.630.930.97
2014-08-29 09:37:020.950.810.89
2014-08-29 09:44:030.650.900.93
2014-08-29 09:51:021.250.830.84
2014-08-29 09:58:020.860.850.86
2014-08-29 10:05:030.811.000.93
2014-08-29 10:12:020.460.810.88
2014-08-29 10:19:020.970.890.88
2014-08-29 10:26:020.960.980.92
2014-08-29 10:33:021.180.970.91
2014-08-29 10:40:020.910.880.88
2014-08-29 10:47:021.051.141.00
2014-08-29 10:53:020.591.001.00

OS CPU Info

Snap Timeusersystemidleiowait
2014-08-29 03:40:020.000.00100.000.00
2014-08-29 03:47:020.000.00100.000.00
2014-08-29 03:54:034.001.0095.000.00
2014-08-29 04:01:020.000.00100.000.00
2014-08-29 04:08:020.000.00100.000.00
2014-08-29 04:15:022.000.0097.000.00
2014-08-29 04:22:030.000.00100.000.00
2014-08-29 04:29:020.000.00100.000.00
2014-08-29 04:36:022.000.0097.000.00
2014-08-29 04:43:021.000.0099.000.00
2014-08-29 04:50:020.000.0099.000.00
2014-08-29 04:57:022.000.0097.000.00
2014-08-29 05:04:020.000.00100.000.00
2014-08-29 05:11:020.000.0099.000.00
2014-08-29 05:18:022.000.0097.000.00
2014-08-29 05:25:030.000.0099.000.00
2014-08-29 05:32:020.000.00100.000.00
2014-08-29 05:39:032.000.0097.000.00
2014-08-29 05:46:020.000.00100.000.00
2014-08-29 05:53:020.000.00100.000.00
2014-08-29 06:00:023.000.0097.000.00
2014-08-29 06:07:020.000.00100.000.00
2014-08-29 06:14:020.000.00100.000.00
2014-08-29 06:21:023.000.0097.000.00
2014-08-29 06:28:033.001.0097.000.00
2014-08-29 06:35:020.000.00100.000.00
2014-08-29 06:42:032.000.0097.000.00
2014-08-29 06:49:020.000.00100.000.00
2014-08-29 06:56:030.000.00100.000.00
2014-08-29 07:03:023.000.0097.000.00
2014-08-29 07:10:030.000.00100.000.00
2014-08-29 07:17:021.000.0098.000.00
2014-08-29 07:24:025.001.0095.000.00
2014-08-29 07:31:030.000.00100.000.00
2014-08-29 07:38:020.000.00100.000.00
2014-08-29 07:45:022.000.0097.000.00
2014-08-29 07:52:020.000.00100.000.00
2014-08-29 07:59:020.000.00100.000.00
2014-08-29 08:06:022.000.0097.000.00
2014-08-29 08:13:020.000.00100.000.00
2014-08-29 08:20:030.000.0099.000.00
2014-08-29 08:27:023.000.0096.000.00
2014-08-29 08:34:030.000.00100.000.00
2014-08-29 08:41:020.000.00100.000.00
2014-08-29 08:48:023.000.0097.000.00
2014-08-29 08:55:020.000.00100.000.00
2014-08-29 09:02:020.000.00100.000.00
2014-08-29 09:09:032.000.0097.000.00
2014-08-29 09:16:020.000.00100.000.00
2014-08-29 09:23:021.000.0099.000.00
2014-08-29 09:30:026.001.0093.000.00
2014-08-29 09:37:020.000.00100.000.00
2014-08-29 09:44:030.000.00100.000.00
2014-08-29 09:51:023.000.0097.000.00
2014-08-29 09:58:020.000.00100.000.00
2014-08-29 10:05:030.003.0097.000.00
2014-08-29 10:12:022.000.0097.000.00
2014-08-29 10:19:020.000.00100.000.00
2014-08-29 10:26:020.000.00100.000.00
2014-08-29 10:33:022.000.0097.000.00
2014-08-29 10:40:020.000.00100.000.00
2014-08-29 10:47:020.000.00100.000.00
2014-08-29 10:53:020.000.00100.000.00

OS IO Info

Snap Timerd_ios_swr_ios_srkbswkbsqueuesvc_tbusy
2014-08-29 03:40:020.0093.670.00394.410.010.050.49
2014-08-29 03:47:020.00108.510.00528.730.010.050.49
2014-08-29 03:54:030.00782.850.003420.370.040.053.76
2014-08-29 04:01:020.00125.280.00505.060.010.050.59
2014-08-29 04:08:020.00114.430.00509.000.010.060.69
2014-08-29 04:15:020.0071.080.00300.120.010.080.59
2014-08-29 04:22:030.00118.470.00698.970.010.060.69
2014-08-29 04:29:020.0050.250.00220.690.000.060.30
2014-08-29 04:36:020.00123.510.00553.310.010.060.69
2014-08-29 04:43:020.00270.060.001135.440.020.071.87
2014-08-29 04:50:020.00167.830.00797.700.010.050.79
2014-08-29 04:57:020.00145.990.00702.340.010.050.69
2014-08-29 05:04:020.00110.480.00469.540.010.080.89
2014-08-29 05:11:020.00841.780.0023028.950.090.043.06
2014-08-29 05:18:020.0082.790.00354.830.010.080.69
2014-08-29 05:25:030.00213.880.00922.550.020.071.48
2014-08-29 05:32:020.0085.930.00343.700.010.080.69
2014-08-29 05:39:030.00184.620.00750.310.010.040.79
2014-08-29 05:46:020.0070.040.00280.150.000.010.10
2014-08-29 05:53:020.0085.780.00473.290.010.070.59
2014-08-29 06:00:020.00123.460.00651.850.010.050.59
2014-08-29 06:07:020.00135.200.00600.000.010.040.59
2014-08-29 06:14:020.00157.960.00655.530.010.060.99
2014-08-29 06:21:020.00166.710.00737.850.010.040.69
2014-08-29 06:28:030.00326.640.001523.680.020.051.68
2014-08-29 06:35:020.00160.000.00679.510.020.081.28
2014-08-29 06:42:030.00177.700.00738.460.010.030.59
2014-08-29 06:49:020.00168.610.00725.720.010.020.30
2014-08-29 06:56:030.00214.060.00883.850.020.061.38
2014-08-29 07:03:020.00152.400.00731.500.010.050.69
2014-08-29 07:10:030.0055.200.00220.780.000.090.49
2014-08-29 07:17:020.00400.820.001694.120.040.083.16
2014-08-29 07:24:020.00141.640.00720.000.010.040.59
2014-08-29 07:31:030.0032.540.00145.930.000.090.30
2014-08-29 07:38:020.00111.560.00584.450.010.060.69
2014-08-29 07:45:020.00110.440.00445.690.000.030.30
2014-08-29 07:52:020.00142.050.00627.370.020.121.78
2014-08-29 07:59:020.00108.460.00441.740.010.090.99
2014-08-29 08:06:020.00144.890.00662.340.010.060.89
2014-08-29 08:13:020.00104.610.00418.420.000.020.20
2014-08-29 08:20:030.00293.450.001252.860.010.041.28
2014-08-29 08:27:020.00559.770.002361.500.040.053.06
2014-08-29 08:34:030.0059.160.00272.140.000.080.49
2014-08-29 08:41:020.00107.430.00548.010.010.080.89
2014-08-29 08:48:020.00218.180.00904.320.010.051.18
2014-08-29 08:55:020.00160.720.00670.500.010.050.79
2014-08-29 09:02:020.00179.310.00740.890.010.050.89
2014-08-29 09:09:030.00169.670.00706.290.010.050.79
2014-08-29 09:16:020.0082.890.00430.260.000.040.30
2014-08-29 09:23:020.001721.760.0047881.530.280.035.73
2014-08-29 09:30:020.00166.910.00833.580.020.071.19
2014-08-29 09:37:020.0033.540.00142.050.000.090.30
2014-08-29 09:44:030.0095.720.00402.630.000.040.39
2014-08-29 09:51:020.0067.080.00402.470.000.040.30
2014-08-29 09:58:020.0084.800.00347.080.010.080.69
2014-08-29 10:05:030.0040.480.00229.040.000.070.30
2014-08-29 10:12:020.0045.390.00185.530.010.110.49
2014-08-29 10:19:020.0075.000.00438.160.010.070.49
2014-08-29 10:26:020.00147.970.00619.480.010.050.79
2014-08-29 10:33:020.00142.160.00588.400.010.060.89
2014-08-29 10:40:020.00139.090.00583.970.010.060.89
2014-08-29 10:47:020.00110.530.00465.790.020.192.07
2014-08-29 10:53:020.0096.470.00511.890.010.070.69

OS Other Info

Snap Timeswap_inswap_outnet_recvnet_sendfile_systemtotal_mbused_mbused_pctmount_point
2014-08-29 03:40:020.000.0019193.0060030.00/dev/sdb2814021.00240484.0010.00/storage/sas
2014-08-29 03:47:020.000.008289.0025998.00/dev/sdb2814021.00240500.0010.00/storage/sas
2014-08-29 03:54:030.000.00238503.007237687.00/dev/sdb2814021.00240521.0010.00/storage/sas
2014-08-29 04:01:020.000.0012224.0036681.00/dev/sdb2814021.00240538.0010.00/storage/sas
2014-08-29 04:08:020.000.0022684.0060588.00/dev/sdb2814021.00240556.0010.00/storage/sas
2014-08-29 04:15:020.000.0050391.006973705.00/dev/sdb2814021.00240579.0010.00/storage/sas
2014-08-29 04:22:030.000.0082603.00181729.00/dev/sdb2814021.00240590.0010.00/storage/sas
2014-08-29 04:29:020.000.0017011.0040985.00/dev/sdb2814021.00240605.0010.00/storage/sas
2014-08-29 04:36:020.000.0064594.007833894.00/dev/sdb2814021.00240618.0010.00/storage/sas
2014-08-29 04:43:020.000.00181291.00534839.00/dev/sdb2814021.00240642.0010.00/storage/sas
2014-08-29 04:50:020.000.0041983.0081978.00/dev/sdb2814021.00240662.0010.00/storage/sas
2014-08-29 04:57:020.000.0087580.007031461.00/dev/sdb2814021.00240681.0010.00/storage/sas
2014-08-29 05:04:020.000.0055296.00161204.00/dev/sdb2814021.00240702.0010.00/storage/sas
2014-08-29 05:11:020.000.0020748.0051696.00/dev/sdb2814021.00240719.0010.00/storage/sas
2014-08-29 05:18:020.000.0067084.006598613.00/dev/sdb2814021.00240730.0010.00/storage/sas
2014-08-29 05:25:030.000.00121827.00297454.00/dev/sdb2814021.00240748.0010.00/storage/sas
2014-08-29 05:32:020.000.0082954.002828324.00/dev/sdb2814021.00240763.0010.00/storage/sas
2014-08-29 05:39:030.000.0068098.006608260.00/dev/sdb2814021.00240783.0010.00/storage/sas
2014-08-29 05:46:020.000.0033779.0085818.00/dev/sdb2814021.00240807.0010.00/storage/sas
2014-08-29 05:53:020.000.0041291.0085688.00/dev/sdb2814021.00240826.0010.00/storage/sas
2014-08-29 06:00:020.000.00141265.006647625.00/dev/sdb2814021.00240846.0010.00/storage/sas
2014-08-29 06:07:020.000.0027102.0073884.00/dev/sdb2814021.00240872.0010.00/storage/sas
2014-08-29 06:14:020.000.0037445.0095174.00/dev/sdb2814021.00240884.0010.00/storage/sas
2014-08-29 06:21:020.000.00108037.006860832.00/dev/sdb2814021.00240903.0010.00/storage/sas
2014-08-29 06:28:030.000.0095592.003609880.00/dev/sdb2814021.00240926.0010.00/storage/sas
2014-08-29 06:35:020.000.0028217.0065682.00/dev/sdb2814021.00240937.0010.00/storage/sas
2014-08-29 06:42:030.000.0055949.006678180.00/dev/sdb2814021.00240957.0010.00/storage/sas
2014-08-29 06:49:020.000.0029427.0073566.00/dev/sdb2814021.00240976.0010.00/storage/sas
2014-08-29 06:56:030.000.0044002.00112504.00/dev/sdb2814021.00240995.0010.00/storage/sas
2014-08-29 07:03:020.000.0090987.006950037.00/dev/sdb2814021.00241014.0010.00/storage/sas
2014-08-29 07:10:030.000.0021087.0062051.00/dev/sdb2814021.00241042.0010.00/storage/sas
2014-08-29 07:17:020.000.00173799.00561118.00/dev/sdb2814021.00241056.0010.00/storage/sas
2014-08-29 07:24:020.000.00237993.0010281062.00/dev/sdb2814021.00241072.0010.00/storage/sas
2014-08-29 07:31:030.000.0027177.0073613.00/dev/sdb2814021.00241083.0010.00/storage/sas
2014-08-29 07:38:020.000.0074208.00160214.00/dev/sdb2814021.00241098.0010.00/storage/sas
2014-08-29 07:45:020.000.0050101.006760762.00/dev/sdb2814021.00241109.0010.00/storage/sas
2014-08-29 07:52:020.000.0031489.0079475.00/dev/sdb2814021.00241128.0010.00/storage/sas
2014-08-29 07:59:020.000.005039.0019916.00/dev/sdb2814021.00241139.0010.00/storage/sas
2014-08-29 08:06:020.000.00183739.006904496.00/dev/sdb2814021.00241153.0010.00/storage/sas
2014-08-29 08:13:020.000.0016565.0060228.00/dev/sdb2814021.00241165.0010.00/storage/sas
2014-08-29 08:20:030.000.00200634.002001938.00/dev/sdb2814021.00241177.0010.00/storage/sas
2014-08-29 08:27:020.000.00313790.007092331.00/dev/sdb2814021.00241191.0010.00/storage/sas
2014-08-29 08:34:030.000.0028424.0043775.00/dev/sdb2814021.00241211.0010.00/storage/sas
2014-08-29 08:41:020.000.0046016.0082638.00/dev/sdb2814021.00241222.0010.00/storage/sas
2014-08-29 08:48:020.000.0057819.006813365.00/dev/sdb2814021.00241233.0010.00/storage/sas
2014-08-29 08:55:020.000.00135460.00386062.00/dev/sdb2814021.00241248.0010.00/storage/sas
2014-08-29 09:02:020.000.0032525.0078344.00/dev/sdb2814021.00241266.0010.00/storage/sas
2014-08-29 09:09:030.000.0070667.006902814.00/dev/sdb2814021.00241286.0010.00/storage/sas
2014-08-29 09:16:020.000.0040972.0044529.00/dev/sdb2814021.00241301.0010.00/storage/sas
2014-08-29 09:23:020.000.0033647.0094295.00/dev/sdb2814021.00241325.0010.00/storage/sas
2014-08-29 09:30:020.000.00102104.006986962.00/dev/sdb2814021.00241339.0010.00/storage/sas
2014-08-29 09:37:020.000.0033820.00105159.00/dev/sdb2814021.00241355.0010.00/storage/sas
2014-08-29 09:44:030.000.0059636.00116610.00/dev/sdb2814021.00241374.0010.00/storage/sas
2014-08-29 09:51:020.000.0077325.006907970.00/dev/sdb2814021.00241393.0010.00/storage/sas
2014-08-29 09:58:020.000.0030857.0099096.00/dev/sdb2814021.00241404.0010.00/storage/sas
2014-08-29 10:05:030.000.0030790.0086549.00/dev/sdb2814021.00241419.0010.00/storage/sas
2014-08-29 10:12:020.000.0083076.006822165.00/dev/sdb2814021.00241434.0010.00/storage/sas
2014-08-29 10:19:020.000.0030228.0083001.00/dev/sdb2814021.00241450.0010.00/storage/sas
2014-08-29 10:26:020.000.0032195.0074159.00/dev/sdb2814021.00241461.0010.00/storage/sas
2014-08-29 10:33:020.000.0088706.006961987.00/dev/sdb2814021.00241476.0010.00/storage/sas
2014-08-29 10:40:020.000.0030049.0088922.00/dev/sdb2814021.00241495.0010.00/storage/sas
2014-08-29 10:47:020.000.0036295.0053624.00/dev/sdb2814021.00241514.0010.00/storage/sas
2014-08-29 10:53:020.000.0033340.0094651.00/dev/sdb2814021.00241533.0010.00/storage/sas


TOP 20 SQL

checksumdb namets_mints_maxts_cntQuery_time_sumQuery_time_pct_95Lock_time_sumLock_time_pct_95Rows_sent_sumRows_sent_pct_95sample
13612286358010875778xxxx_crm2014-08-20 13:00:002014-08-20 14:00:002453103523183.5811.287280.00028705124531select t.date,...
7559947935709052803xxxx_crm2014-08-20 13:00:002014-08-20 14:00:00222973393.7183.5811.187240.00031647386068.91436select t.date,...
18097649493518330926xxxx_crm2014-08-20 13:00:002014-08-20 14:00:0013520829.7685.390.0434510.00034891200insert into t_stand...
1054122699803593913xxxx_crm2014-08-20 13:00:002014-08-20 14:00:004770194475.472641.027340.00023615700insert into t_channe...
14562554133437710016xxxx_crm2014-08-20 13:00:002014-08-20 14:00:00474915389.64.083771.03750.00026036400insert into t_agent_...
17932081409341609860xxxx_crm2014-08-20 13:00:002014-08-20 14:00:0014913978.2174.8390.0149060.00011927600load data local infi...
12830386596672724727xxxx_crm2014-08-20 13:00:002014-08-20 14:00:0030512880.3174.8390.1198180.0002479653051select t.date,...
14242997136004316393xxxx_crm2014-08-20 13:00:002014-08-20 14:00:0014910954.9107.3360.0194610.0001449800insert into t_bizlog...
7382243057795183594xxxx_crm2014-08-20 13:00:002014-08-20 14:00:0014910742102.2250.0172140.00013150100delete from t_bizlog...
9136130252841431921xxxx_crm2014-08-20 13:00:002014-08-20 14:00:008310339.2124.2550.0084790.00011927600load data local infi...
4104295244676626346xxxx_crm2014-08-20 13:00:002014-08-20 14:00:0014910053.669.18960.0461260.00033229700insert into t_low_co...
1602841323730482517xxxx_crm2014-08-20 13:00:002014-08-20 14:00:002779765.06183.5810.1547470.000273382151428.7497select t.date,...
354949893804037415xxxx_crm2014-08-20 13:00:002014-08-20 14:00:001488698.3497.35670.0087620.000073224800delete from t_custom...
16171946069052037078xxxx_crm2014-08-20 13:00:002014-08-20 14:00:004607191.9638.52730.0273460.000066417100delete from cust_ren...
15381351069224663258xxxx_crm2014-08-20 13:00:002014-08-20 14:00:003306981.08158.5840.109290.0002479653301select t.date,...
12080899912460099053xxxx_crm2014-08-20 13:00:002014-08-20 14:00:0020446392.33.70411.144070.000725363301035652.752select t.bizCode biz...
6823381848000688775xxxx_crm2014-08-20 13:00:002014-08-20 14:00:0018196017.73.527710.1312930.000084766900load data local infi...
13877986249282993128xxxx_crm2014-08-20 13:00:002014-08-20 14:00:003155977.77158.5840.0629080.00028705111708.91436select t.date,...
6207365650723473125xxxx_crm2014-08-20 13:00:002014-08-20 14:00:001885809.77174.8390.0421890.0002870511881select sum(t.p...
11963123707036900324xxxx_crm2014-08-20 13:00:002014-08-20 14:00:0017405732.283.527710.1131670.000076886100load data local infi...

TOP SQL DETAIL

checksumsql detail
13612286358010875778select 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
7559947935709052803select 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
18097649493518330926insert 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
1054122699803593913insert 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
14562554133437710016insert 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
17932081409341609860load 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)
12830386596672724727select 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
14242997136004316393insert into t_bizlog_history select * from t_bizlog_20140626
7382243057795183594delete from t_bizlog_history where opt_time >= '20140626' and opt_time < '20140627'
9136130252841431921load 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)
4104295244676626346insert 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 )
1602841323730482517select 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
354949893804037415delete from t_customer_invest where cust_id in (select cust_id from t_customer_invest_tmp) and invest_date<'20140331'
16171946069052037078delete from cust_renewaled where cust_id in (select cust_id from t_customer_invest_tmp) and date<'20140331'
15381351069224663258select 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
12080899912460099053select 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
6823381848000688775load 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)
13877986249282993128select 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
6207365650723473125select 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
11963123707036900324load 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)

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