# 300ms user time, 20ms system time, 23.81M rss, 82.80M vsz
# Current date: Thu Feb 14 13:26:41 2013
# Hostname: mp-shellserver003
# Files: slow.log
# Overall: 1 total, 1 unique, 0 QPS, 0x concurrency ______________________
# Time range: all events occurred at 2013-02-14 06:40:12
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time          238ms   238ms   238ms   238ms   238ms       0   238ms
# Lock time           85us    85us    85us    85us    85us       0    85us
# Rows sent              0       0       0       0       0       0       0
# Rows examine           1       1       1       1       1       0       1
# Rows affecte           1       1       1       1       1       0       1
# Rows read              1       1       1       1       1       0       1
# Bytes sent            52      52      52      52      52       0      52
# Merge passes           0       0       0       0       0       0       0
# Tmp tables             0       0       0       0       0       0       0
# Tmp disk tbl           0       0       0       0       0       0       0
# Tmp tbl size           0       0       0       0       0       0       0
# Query size           151     151     151     151     151       0     151
# InnoDB:
# IO r bytes             0       0       0       0       0       0       0
# IO r ops               0       0       0       0       0       0       0
# IO r wait              0       0       0       0       0       0       0
# pages distin           4       4       4       4       4       0       4
# queue wait             0       0       0       0       0       0       0
# rec lock wai       238ms   238ms   238ms   238ms   238ms       0   238ms

# Profile
# Rank Query ID           Response time Calls R/Call Apdx V/M   Item
# ==== ================== ============= ===== ====== ==== ===== ==========
#    1 0xD8E09C2D681D12F7 0.2384 100.0%     1 0.2384 1.00  0.00 UPDATE com.java table_name

# Query 1: 0 QPS, 0x concurrency, ID 0xD8E09C2D681D12F7 at byte 0 ________
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0]*, V/M = 0.00
# Query_time sparkline: |     ^  |
# Time range: all events occurred at 2013-02-14 06:40:12
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count        100       1
# Exec time    100   238ms   238ms   238ms   238ms   238ms       0   238ms
# Lock time    100    85us    85us    85us    85us    85us       0    85us
# Rows sent      0       0       0       0       0       0       0       0
# Rows examine 100       1       1       1       1       1       0       1
# Rows affecte 100       1       1       1       1       1       0       1
# Rows read    100       1       1       1       1       1       0       1
# Bytes sent   100      52      52      52      52      52       0      52
# Merge passes   0       0       0       0       0       0       0       0
# Tmp tables     0       0       0       0       0       0       0       0
# Tmp disk tbl   0       0       0       0       0       0       0       0
# Tmp tbl size   0       0       0       0       0       0       0       0
# Query size   100     151     151     151     151     151       0     151
# InnoDB:
# IO r bytes     0       0       0       0       0       0       0       0
# IO r ops       0       0       0       0       0       0       0       0
# IO r wait      0       0       0       0       0       0       0       0
# pages distin 100       4       4       4       4       4       0       4
# queue wait     0       0       0       0       0       0       0       0
# rec lock wai 100   238ms   238ms   238ms   238ms   238ms       0   238ms
# String:
# Databases    nl_mp
# Hosts
# InnoDB trxID E437CD2D
# Last errno   0
# Users        db_username
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `com` LIKE 'java'\G
#    SHOW CREATE TABLE `com`.`java`\G
#    SHOW TABLE STATUS FROM `nl_mp` LIKE 'table_name'\G
#    SHOW CREATE TABLE `nl_mp`.`table_name`\G
/* update com.java.application.data.MethodDo */ update table_name set column_1=0, column_2='afa0a367064f7d196aa3692557fca0c0' where pk_column=645195141\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select  column_1=0, column_2='afa0a367064f7d196aa3692557fca0c0' from com.java.application.data.MethodDo */ update table_name where  pk_column=645195141\G