# 1.1s user time, 30ms system time, 28.72M rss, 208.85M vsz
# Current date: Sun Jan 5 21:11:13 2014
# Hostname: panama.dbspma.com
# Files: /var/lib/mysql/mysql-slow.log
# Overall: 6.79k total, 138 unique, 0.03 QPS, 0.01x concurrency __________
# Time range: 2014-01-02 22:43:36 to 2014-01-05 21:10:40
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 1781s 100ms 20s 262ms 477ms 609ms 148ms
# Lock time 13s 0 370ms 2ms 63us 22ms 33us
# Rows sent 1.97M 0 427.84k 304.93 0.99 9.43k 0
# Rows examine 51.90M 0 427.84k 7.83k 59.57k 26.09k 0.99
# Query size 4.28M 31 4.46k 661.06 2.06k 745.67 124.25
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============== ===== ====== ===== ==============
# 1 0xFBC33BE3D16F31B6 375.0039 21.1% 803 0.4670 0.07 SELECT u?lgq_k?_comments
# 2 0x1E21092605FA81DF 282.2854 15.9% 1529 0.1846 0.78 UPDATE mvkhb_session
# 3 0x65792F8C7D00F1DA 211.4516 11.9% 767 0.2757 3.33 INSERT mvkhb_session
# 4 0x11F8C8E8FCD8E300 200.9503 11.3% 1112 0.1807 0.54 UPDATE session
# 5 0x566718AE69A06133 163.0799 9.2% 601 0.2713 2.49 DELETE mvkhb_session
# 6 0x55563D0553F47299 106.1432 6.0% 640 0.1658 0.06 UPDATE session
# 7 0x50B012B84A236154 68.0200 3.8% 255 0.2667 0.31 UPDATE jos_session
# 8 0xA916BBE720639679 61.4734 3.5% 77 0.7984 3.90 UPDATE jos_docman
# 9 0x9AB0AEA4D3D3F693 40.7853 2.3% 19 2.1466 7.04 INSERT u?lgq_session
# 10 0xB1CEA974F1B8D5C4 30.3524 1.7% 161 0.1885 1.06 UPDATE ayk?j_session
# 11 0x67A347A2812914DF 22.3469 1.3% 42 0.5321 2.61 SELECT u?lgq_k?_comments
# 12 0x05872ECC22546540 21.7591 1.2% 70 0.3108 0.54 DELETE jos_session
# 13 0x7481BC1F9F3D893B 17.3968 1.0% 70 0.2485 0.19 INSERT jos_session
# 14 0xED95278A39C3E403 13.5517 0.8% 36 0.3764 0.03 SELECT lw?_session
# 15 0x31935481E67173E2 12.7890 0.7% 4 3.1973 7.06 UPDATE jos_content
# 16 0x25ED0A308EBE4C16 11.3791 0.6% 39 0.2918 0.69 UPDATE lw?_session
# 17 0xC7491367E5334C98 10.2735 0.6% 24 0.4281 1.30 INSERT lw?_session
# 18 0x9174EDDB77190BB8 9.7877 0.5% 6 1.6313 3.33 DELETE failures
# 19 0x029F750F15BAF08D 8.4225 0.5% 5 1.6845 3.07 UPDATE u?lgq_k?_items
# 20 0x8857E60478FD78A9 7.4776 0.4% 40 0.1869 0.04 INSERT ayk?j_session
# MISC 0xMISC 105.9628 6.0% 490 0.2163 0.0 <118 ITEMS>
# Query 1: 0.00 QPS, 0.00x concurrency, ID 0xFBC33BE3D16F31B6 at byte 3547866
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.07
# Time range: 2014-01-02 22:43:36 to 2014-01-05 21:09:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 11 803
# Exec time 21 375s 432ms 6s 467ms 477ms 183ms 433ms
# Lock time 0 22ms 19us 88us 27us 36us 6us 25us
# Rows sent 0 803 1 1 1 1 0 1
# Rows examine 93 48.49M 21.28k 138.29k 61.84k 136.54k 41.12k 59.57k
# Query size 1 54.89k 70 70 70 70 0 70
# String:
# Databases dbspma_innova
# Hosts localhost
# Users dbspma_innova
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `dbspma_innova` LIKE 'u9lgq_k2_comments'\G
# SHOW CREATE TABLE `dbspma_innova`.`u9lgq_k2_comments`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM u9lgq_k2_comments WHERE itemID=25 AND published=1\G
# Query 2: 0.01 QPS, 0.00x concurrency, ID 0x1E21092605FA81DF at byte 3219453
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.78
# Time range: 2014-01-02 22:59:01 to 2014-01-05 21:09:50
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 22 1529
# Exec time 15 282s 100ms 12s 185ms 339ms 381ms 122ms
# Lock time 0 62ms 27us 137us 40us 54us 9us 36us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 1.49k 1 1 1 1 0 1
# Query size 42 1.83M 1.10k 1.47k 1.22k 1.39k 81.54 1.14k
# String:
# Databases panasyst_nueva
# Hosts localhost
# Users panasyst_2013
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+ #
# Tables
# SHOW TABLE STATUS FROM `panasyst_nueva` LIKE 'mvkhb_session'\G
# SHOW CREATE TABLE `panasyst_nueva`.`mvkhb_session`\G
UPDATE `mvkhb_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1388823472;s:18:\"session.timer.last\";i:1388823472;s:17:\"session.timer.now\";i:1388823472;s:22:\"session.client.browser\";s:63:\"Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.8.131 Version/11.10\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;i:1;}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"8515db20aa0c3ba6fc181aaf20bfccea\";}'
, `time` = '1388823473'
WHERE `session_id` = '2ec3506232560615d0c01eba65d25589'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1388823472;s:18:\"session.timer.last\";i:1388823472;s:17:\"session.timer.now\";i:1388823472;s:22:\"session.client.browser\";s:63:\"Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.8.131 Version/11.10\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;i:1;}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"8515db20aa0c3ba6fc181aaf20bfccea\";}'
, `time` = '1388823473' from `mvkhb_session` where `session_id` = '2ec3506232560615d0c01eba65d25589'\G
# Query 3: 0.00 QPS, 0.00x concurrency, ID 0x65792F8C7D00F1DA at byte 4858248
# This item is included in the report because it matches --limit.
# Scores: V/M = 3.33
# Time range: 2014-01-02 22:45:36 to 2014-01-05 21:09:50
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 11 767
# Exec time 11 211s 100ms 20s 276ms 455ms 958ms 134ms
# Lock time 0 15ms 11us 35us 19us 23us 2us 18us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 2 93.63k 125 125 125 125 0 125
# String:
# Databases panasyst_nueva
# Hosts localhost
# Users panasyst_2013
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+ #
# Tables
# SHOW TABLE STATUS FROM `panasyst_nueva` LIKE 'mvkhb_session'\G
# SHOW CREATE TABLE `panasyst_nueva`.`mvkhb_session`\G
INSERT INTO `mvkhb_session`
(`session_id`, `client_id`, `time`) VALUES
('2b6851b69e972389ed66b9150cc86a31', 1, '1388909855')\G
# Query 4: 0.00 QPS, 0.00x concurrency, ID 0x11F8C8E8FCD8E300 at byte 530866
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.54
# Time range: 2014-01-02 22:46:39 to 2014-01-05 21:09:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 16 1112
# Exec time 11 201s 100ms 7s 181ms 293ms 313ms 134ms
# Lock time 0 45ms 21us 84us 40us 47us 5us 38us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 1.09k 1 1 1 1 0 1
# Query size 2 105.34k 97 97 97 97 0 97
# String:
# Databases roundcube
# Hosts localhost
# Users roundcube
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `roundcube` LIKE 'session'\G
# SHOW CREATE TABLE `roundcube`.`session`\G
UPDATE session SET changed='2014-01-03 03:28:40' WHERE sess_id='e4ea4cffe4c4a98a977be4626997b6b6'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select changed='2014-01-03 03:28:40' from session where sess_id='e4ea4cffe4c4a98a977be4626997b6b6'\G
# Query 5: 0.00 QPS, 0.00x concurrency, ID 0x566718AE69A06133 at byte 417279
# This item is included in the report because it matches --limit.
# Scores: V/M = 2.49
# Time range: 2014-01-02 22:43:37 to 2014-01-05 20:59:15
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 8 601
# Exec time 9 163s 100ms 15s 271ms 455ms 821ms 141ms
# Lock time 0 10ms 10us 49us 16us 19us 2us 15us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 861 1 22 1.43 2.90 1.01 0.99
# Query size 0 32.87k 56 56 56 56 0 56
# String:
# Databases panasyst_nueva
# Hosts localhost
# Users panasyst_2013
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+ #
# Tables
# SHOW TABLE STATUS FROM `panasyst_nueva` LIKE 'mvkhb_session'\G
# SHOW CREATE TABLE `panasyst_nueva`.`mvkhb_session`\G
DELETE
FROM `mvkhb_session`
WHERE `time` < '1388735299'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from `mvkhb_session`
WHERE `time` < '1388735299'\G
# Query 6: 0.00 QPS, 0.00x concurrency, ID 0x55563D0553F47299 at byte 3809058
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.06
# Time range: 2014-01-03 07:41:57 to 2014-01-05 18:44:59
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 9 640
# Exec time 5 106s 100ms 1s 166ms 308ms 96ms 141ms
# Lock time 0 36ms 27us 93us 56us 69us 9us 54us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 640 1 1 1 1 0 1
# Query size 30 1.30M 1.15k 4.46k 2.08k 3.19k 583.02 1.86k
# String:
# Databases roundcube
# Hosts localhost
# Users roundcube
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `roundcube` LIKE 'session'\G
# SHOW CREATE TABLE `roundcube`.`session`\G
UPDATE session SET vars='bGFuZ3VhZ2V8czo1OiJlc19FUyI7c2tpbnxzOjU6ImxhcnJ5IjtpbWFwX25hbWVzcGFjZXxhOjQ6e3M6ODoicGVyc29uYWwiO2E6MTp7aTowO2E6Mjp7aTowO3M6NjoiSU5CT1guIjtpOjE7czoxOiIuIjt9fXM6NToib3RoZXIiO047czo2OiJzaGFyZWQiO047czo2OiJwcmVmaXgiO3M6NjoiSU5CT1guIjt9aW1hcF9kZWxpbWl0ZXJ8czoxOiIuIjt1c2VyX2lkfHM6MjoiMzciO3VzZXJuYW1lfHM6MTc6ImdwaXR0aUB0dmJsYXN0LnR2IjtzdG9yYWdlX2hvc3R8czo5OiJsb2NhbGhvc3QiO3N0b3JhZ2VfcG9ydHxpOjE0MztzdG9yYWdlX3NzbHxOO3Bhc3N3b3JkfHM6NDQ6ImVVZFpJOFlIcEtGTmhpdmM3WEhqVjQwcEhzbkFtNEwxb25hUG96cDdhUzA9Ijtsb2dpbl90aW1lfGk6MTM4ODg1MDA4ODt0YXNrfHM6NDoibWFpbCI7aW1hcF9ob3N0fHM6OToibG9jYWxob3N0IjttYm94fHM6NToiSU5CT1giO3NvcnRfY29sfHM6NzoiYXJyaXZhbCI7c29ydF9vcmRlcnxzOjQ6IkRFU0MiO1NUT1JBR0VfVEhSRUFEfGE6Mzp7aTowO3M6MTA6IlJFRkVSRU5DRVMiO2k6MTtzOjQ6IlJFRlMiO2k6MjtzOjE0OiJPUkRFUkVEU1VCSkVDVCI7fVNUT1JBR0VfUVVPVEF8YjoxO1NUT1JBR0VfTElTVC1FWFRFTkRFRHxiOjE7cXVvdGFfZGlzcGxheXxzOjQ6InRleHQiO2xpc3RfYXR0cmlifGE6NTp7czo0OiJuYW1lIjtzOjg6Im1lc3NhZ2VzIjtzOjI6ImlkIjtzOjExOiJtZXNzYWdlbGlzdCI7czo1OiJjbGFzcyI7czoyNDoicmVjb3Jkcy10YWJsZSBzb3J0aGVhZGVyIjtzOjE1OiJvcHRpb25zbWVudWljb24iO3M6NDoidHJ1ZSI7czo3OiJjb2x1bW5zIjthOjM6e2k6MDtzOjc6InRocmVhZHMiO2k6MTtzOjc6InN1YmplY3QiO2k6MjtzOjQ6ImRhdGUiO319c2tpbl9wYXRofHM6MTE6InNraW5zL2xhcnJ5Ijtmb2xkZXJzfGE6MTp7czo1OiJJTkJPWCI7YToyOntzOjM6ImNudCI7aToxNDEzO3M6NjoibWF4dWlkIjtpOjE0MjE7fX1TVE9SQUdFX1NPUlR8YjoxO3Vuc2Vlbl9jb3VudHxhOjE6e3M6NToiSU5CT1giO2k6MDt9U1RPUkFHRV9BQ0x8YjowO3BsdWdpbnN8YToxOntzOjIyOiJmaWxlc3lzdGVtX2F0dGFjaG1lbnRzIjthOjA6e319', changed='2014-01-04 10:44:41' WHERE sess_id='168e572aed915730a65674ff809ce30b'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select vars='bGFuZ3VhZ2V8czo1OiJlc19FUyI7c2tpbnxzOjU6ImxhcnJ5IjtpbWFwX25hbWVzcGFjZXxhOjQ6e3M6ODoicGVyc29uYWwiO2E6MTp7aTowO2E6Mjp7aTowO3M6NjoiSU5CT1guIjtpOjE7czoxOiIuIjt9fXM6NToib3RoZXIiO047czo2OiJzaGFyZWQiO047czo2OiJwcmVmaXgiO3M6NjoiSU5CT1guIjt9aW1hcF9kZWxpbWl0ZXJ8czoxOiIuIjt1c2VyX2lkfHM6MjoiMzciO3VzZXJuYW1lfHM6MTc6ImdwaXR0aUB0dmJsYXN0LnR2IjtzdG9yYWdlX2hvc3R8czo5OiJsb2NhbGhvc3QiO3N0b3JhZ2VfcG9ydHxpOjE0MztzdG9yYWdlX3NzbHxOO3Bhc3N3b3JkfHM6NDQ6ImVVZFpJOFlIcEtGTmhpdmM3WEhqVjQwcEhzbkFtNEwxb25hUG96cDdhUzA9Ijtsb2dpbl90aW1lfGk6MTM4ODg1MDA4ODt0YXNrfHM6NDoibWFpbCI7aW1hcF9ob3N0fHM6OToibG9jYWxob3N0IjttYm94fHM6NToiSU5CT1giO3NvcnRfY29sfHM6NzoiYXJyaXZhbCI7c29ydF9vcmRlcnxzOjQ6IkRFU0MiO1NUT1JBR0VfVEhSRUFEfGE6Mzp7aTowO3M6MTA6IlJFRkVSRU5DRVMiO2k6MTtzOjQ6IlJFRlMiO2k6MjtzOjE0OiJPUkRFUkVEU1VCSkVDVCI7fVNUT1JBR0VfUVVPVEF8YjoxO1NUT1JBR0VfTElTVC1FWFRFTkRFRHxiOjE7cXVvdGFfZGlzcGxheXxzOjQ6InRleHQiO2xpc3RfYXR0cmlifGE6NTp7czo0OiJuYW1lIjtzOjg6Im1lc3NhZ2VzIjtzOjI6ImlkIjtzOjExOiJtZXNzYWdlbGlzdCI7czo1OiJjbGFzcyI7czoyNDoicmVjb3Jkcy10YWJsZSBzb3J0aGVhZGVyIjtzOjE1OiJvcHRpb25zbWVudWljb24iO3M6NDoidHJ1ZSI7czo3OiJjb2x1bW5zIjthOjM6e2k6MDtzOjc6InRocmVhZHMiO2k6MTtzOjc6InN1YmplY3QiO2k6MjtzOjQ6ImRhdGUiO319c2tpbl9wYXRofHM6MTE6InNraW5zL2xhcnJ5Ijtmb2xkZXJzfGE6MTp7czo1OiJJTkJPWCI7YToyOntzOjM6ImNudCI7aToxNDEzO3M6NjoibWF4dWlkIjtpOjE0MjE7fX1TVE9SQUdFX1NPUlR8YjoxO3Vuc2Vlbl9jb3VudHxhOjE6e3M6NToiSU5CT1giO2k6MDt9U1RPUkFHRV9BQ0x8YjowO3BsdWdpbnN8YToxOntzOjIyOiJmaWxlc3lzdGVtX2F0dGFjaG1lbnRzIjthOjA6e319', changed='2014-01-04 10:44:41' from session where sess_id='168e572aed915730a65674ff809ce30b'\G
# Query 7: 0.00 QPS, 0.00x concurrency, ID 0x50B012B84A236154 at byte 4815293
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.31
# Time range: 2014-01-02 23:03:14 to 2014-01-05 21:10:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 255
# Exec time 3 68s 100ms 4s 267ms 526ms 287ms 198ms
# Lock time 0 10ms 27us 101us 39us 54us 8us 36us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 255 1 1 1 1 0 1
# Query size 9 422.81k 497 2.17k 1.66k 2.06k 346.72 1.39k
# String:
# Databases phr_web
# Hosts localhost
# Users phr_web
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `phr_web` LIKE 'jos_session'\G
# SHOW CREATE TABLE `phr_web`.`jos_session`\G
UPDATE `jos_session` SET `time`='1388908327',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1388907485;s:18:\"session.timer.last\";i:1388908220;s:17:\"session.timer.now\";i:1388908248;s:22:\"session.client.browser\";s:128:\"Mozilla/5.0 (Linux; Android 4.2.2; SM-T311 Build/JDQ39) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.59 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:61:\"/home/phr/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}' WHERE session_id='c16a2001cbc646289f4a78d13906ca94'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `time`='1388908327',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1388907485;s:18:\"session.timer.last\";i:1388908220;s:17:\"session.timer.now\";i:1388908248;s:22:\"session.client.browser\";s:128:\"Mozilla/5.0 (Linux; Android 4.2.2; SM-T311 Build/JDQ39) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.59 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:61:\"/home/phr/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}' from `jos_session` where session_id='c16a2001cbc646289f4a78d13906ca94'\G
# Query 8: 0.00 QPS, 0.00x concurrency, ID 0xA916BBE720639679 at byte 175533
# This item is included in the report because it matches --limit.
# Scores: V/M = 3.90
# Time range: 2014-01-03 02:05:58 to 2014-01-05 21:04:20
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 77
# Exec time 3 61s 107ms 11s 798ms 3s 2s 230ms
# Lock time 0 2ms 16us 49us 26us 38us 7us 22us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 77 1 1 1 1 0 1
# Query size 0 4.28k 56 57 56.94 56.92 0.50 56.92
# String:
# Databases phr_web
# Hosts localhost
# Users phr_web
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ######
# 10s+ #
# Tables
# SHOW TABLE STATUS FROM `phr_web` LIKE 'jos_docman'\G
# SHOW CREATE TABLE `phr_web`.`jos_docman`\G
UPDATE jos_docman SET dmcounter=dmcounter+1 WHERE id=945\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select dmcounter=dmcounter+1 from jos_docman where id=945\G
# Query 9: 0.00 QPS, 0.00x concurrency, ID 0x9AB0AEA4D3D3F693 at byte 3218309
# This item is included in the report because it matches --limit.
# Scores: V/M = 7.04
# Time range: 2014-01-03 10:21:24 to 2014-01-05 02:35:13
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 19
# Exec time 2 41s 110ms 15s 2s 10s 4s 266ms
# Lock time 0 386us 14us 44us 20us 25us 6us 18us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 2.32k 125 125 125 125 0 125
# String:
# Databases dbspma_innova
# Hosts localhost
# Users dbspma_innova
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #############
# 10s+ #########
# Tables
# SHOW TABLE STATUS FROM `dbspma_innova` LIKE 'u9lgq_session'\G
# SHOW CREATE TABLE `dbspma_innova`.`u9lgq_session`\G
INSERT INTO `u9lgq_session`
(`session_id`, `client_id`, `time`) VALUES
('b7fdeedad8ef279bcc236aa985b8cb56', 0, '1388823422')\G
# Query 10: 0.00 QPS, 0.00x concurrency, ID 0xB1CEA974F1B8D5C4 at byte 368303
# This item is included in the report because it matches --limit.
# Scores: V/M = 1.06
# Time range: 2014-01-03 02:03:20 to 2014-01-05 20:53:53
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 161
# Exec time 1 30s 100ms 6s 189ms 339ms 448ms 116ms
# Lock time 0 7ms 29us 73us 42us 60us 10us 36us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 161 1 1 1 1 0 1
# Query size 4 210.35k 1.11k 1.58k 1.31k 1.39k 106.75 1.20k
# String:
# Databases hogarma_2013
# Hosts localhost
# Users hogarma_jorge
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `hogarma_2013` LIKE 'ayk3j_session'\G
# SHOW CREATE TABLE `hogarma_2013`.`ayk3j_session`\G
UPDATE `ayk3j_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1388735402;s:18:\"session.timer.last\";i:1388735402;s:17:\"session.timer.now\";i:1388735406;s:22:\"session.client.browser\";s:63:\"Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.8.131 Version/11.10\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"3ee293abb106436575850bfb13cdbf76\";}'
, `time` = '1388735406'
WHERE `session_id` = '0d0b38c0bb8e695270000432976a69c4'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1388735402;s:18:\"session.timer.last\";i:1388735402;s:17:\"session.timer.now\";i:1388735406;s:22:\"session.client.browser\";s:63:\"Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.8.131 Version/11.10\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"3ee293abb106436575850bfb13cdbf76\";}'
, `time` = '1388735406' from `ayk3j_session` where `session_id` = '0d0b38c0bb8e695270000432976a69c4'\G
# Query 11: 0.00 QPS, 0.00x concurrency, ID 0x67A347A2812914DF at byte 4722204
# This item is included in the report because it matches --limit.
# Scores: V/M = 2.61
# Time range: 2014-01-03 02:04:07 to 2014-01-05 04:14:54
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 42
# Exec time 1 22s 102ms 5s 532ms 945ms 1s 141ms
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 98 1.95M 2 427.84k 47.64k 233.54k 110.46k 1.09k
# Rows examine 3 1.95M 2 427.84k 47.64k 233.54k 110.46k 1.09k
# Query size 0 2.25k 47 71 54.76 65.89 5.95 51.63
# String:
# Databases dxcrewco_2... (15/35%), computer_d... (8/19%)... 7 more
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ####
# 10s+
# Tables
# SHOW TABLE STATUS FROM `dbspma_innova` LIKE 'u9lgq_k2_comments'\G
# SHOW CREATE TABLE `dbspma_innova`.`u9lgq_k2_comments`\G
SELECT /*!40001 SQL_NO_CACHE */ * FROM `u9lgq_k2_comments`\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /*!40001 SQL_NO_CACHE */ * FROM `u9lgq_k2_comments`\G
# Query 12: 0.00 QPS, 0.00x concurrency, ID 0x05872ECC22546540 at byte 3239612
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.54
# Time range: 2014-01-03 02:10:11 to 2014-01-05 21:04:00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 70
# Exec time 1 22s 102ms 2s 311ms 945ms 408ms 163ms
# Lock time 0 1ms 13us 25us 16us 20us 1us 16us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 127 1 8 1.81 3.89 1.29 0.99
# Query size 0 3.62k 53 53 53 53 0 53
# String:
# Databases phr_web
# Hosts localhost
# Users phr_web
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ###
# 10s+
# Tables
# SHOW TABLE STATUS FROM `phr_web` LIKE 'jos_session'\G
# SHOW CREATE TABLE `phr_web`.`jos_session`\G
DELETE FROM jos_session WHERE ( time < '1388823115' )\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from jos_session WHERE ( time < '1388823115' )\G
# Query 13: 0.00 QPS, 0.00x concurrency, ID 0x7481BC1F9F3D893B at byte 4505264
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.19
# Time range: 2014-01-03 00:55:15 to 2014-01-05 20:49:26
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 70
# Exec time 0 17s 100ms 2s 249ms 433ms 220ms 198ms
# Lock time 1 158ms 15us 157ms 2ms 31us 18ms 20us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 10.94k 160 160 160 160 0 160
# String:
# Databases phr_web
# Hosts localhost
# Users phr_web
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `phr_web` LIKE 'jos_session'\G
# SHOW CREATE TABLE `phr_web`.`jos_session`\G
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '4d825234dd2d487cb75175c89d6dcb84','1388889379','','0','1','0' )\G
# Query 14: 0.00 QPS, 0.00x concurrency, ID 0xED95278A39C3E403 at byte 3751720
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.03
# Time range: 2014-01-04 10:10:57 to 2014-01-05 11:13:31
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 36
# Exec time 0 14s 158ms 506ms 376ms 477ms 109ms 412ms
# Lock time 75 9s 56ms 370ms 261ms 356ms 101ms 293ms
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 3.16k 90 90 90 90 0 90
# String:
# Databases dxcrewco_2013
# Hosts localhost
# Users dxcrewco_marco
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `dxcrewco_2013` LIKE 'lw532_session'\G
# SHOW CREATE TABLE `dxcrewco_2013`.`lw532_session`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `data`
FROM `lw532_session`
WHERE `session_id` = 'ee4393cd5b63cbc988eb35dd3af2a670'\G
# Query 15: 0.00 QPS, 0.00x concurrency, ID 0x31935481E67173E2 at byte 175775
# This item is included in the report because it matches --limit.
# Scores: V/M = 7.06
# Time range: 2014-01-03 02:05:58 to 2014-01-05 12:57:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 4
# Exec time 0 13s 207ms 11s 3s 11s 5s 6s
# Lock time 0 98us 20us 32us 24us 31us 4us 22us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 4 1 1 1 1 0 1
# Query size 0 229 56 58 57.25 56.92 1 56.92
# String:
# Databases phr_web
# Hosts localhost
# Users phr_web
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+ #####################
# Tables
# SHOW TABLE STATUS FROM `phr_web` LIKE 'jos_content'\G
# SHOW CREATE TABLE `phr_web`.`jos_content`\G
UPDATE jos_content SET hits = ( hits + 1 ) WHERE id='240'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select hits = ( hits + 1 ) from jos_content where id='240'\G
# Query 16: 0.00 QPS, 0.00x concurrency, ID 0x25ED0A308EBE4C16 at byte 4503155
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.69
# Time range: 2014-01-02 23:03:39 to 2014-01-05 11:05:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 39
# Exec time 0 11s 100ms 2s 292ms 816ms 449ms 155ms
# Lock time 0 90ms 23us 54ms 2ms 84us 10ms 52us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 39 1 1 1 1 0 1
# Query size 1 53.94k 1.06k 1.88k 1.38k 1.86k 251.11 1.39k
# String:
# Databases dxcrewco_2013
# Hosts localhost
# Users dxcrewco_marco
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ###
# 10s+
# Tables
# SHOW TABLE STATUS FROM `dxcrewco_2013` LIKE 'lw532_session'\G
# SHOW CREATE TABLE `dxcrewco_2013`.`lw532_session`\G
UPDATE `lw532_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1388889359;s:18:\"session.timer.last\";i:1388889359;s:17:\"session.timer.now\";i:1388889359;s:24:\"session.client.forwarded\";s:27:\"216.46.175.37, 10.160.107.8\";s:22:\"session.client.browser\";s:40:\"Google-HTTP-Java-Client/1.17.0-rc (gzip)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:3:{s:40:\"5e6f08c8332066551fce5eaba2cfb099a6dabd81\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/72-crysis-3-s-multiplayer-hunters-mode\";s:6:\"expiry\";i:1388889360;}s:40:\"f6adf5b0ccff78743bceffdf9702361438c195c4\";O:8:\"stdClass\":2:{s:4:\"link\";s:100:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/71-final-fantasy-xiii-2\";s:6:\"expiry\";i:1388889360;}s:40:\"0106175a76338d72f176af1c6fa14fb9bf809021\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/67-little-big-planet-2-sackboy-returns\";s:6:\"expiry\";i:1388889360;}}}'
, `time` = '1388889378'
WHERE `session_id` = '5bcb45f186f687d7cadb8bcb5b18170a'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1388889359;s:18:\"session.timer.last\";i:1388889359;s:17:\"session.timer.now\";i:1388889359;s:24:\"session.client.forwarded\";s:27:\"216.46.175.37, 10.160.107.8\";s:22:\"session.client.browser\";s:40:\"Google-HTTP-Java-Client/1.17.0-rc (gzip)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:3:{s:40:\"5e6f08c8332066551fce5eaba2cfb099a6dabd81\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/72-crysis-3-s-multiplayer-hunters-mode\";s:6:\"expiry\";i:1388889360;}s:40:\"f6adf5b0ccff78743bceffdf9702361438c195c4\";O:8:\"stdClass\":2:{s:4:\"link\";s:100:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/71-final-fantasy-xiii-2\";s:6:\"expiry\";i:1388889360;}s:40:\"0106175a76338d72f176af1c6fa14fb9bf809021\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/67-little-big-planet-2-sackboy-returns\";s:6:\"expiry\";i:1388889360;}}}'
, `time` = '1388889378' from `lw532_session` where `session_id` = '5bcb45f186f687d7cadb8bcb5b18170a'\G
# Query 17: 0.00 QPS, 0.00x concurrency, ID 0xC7491367E5334C98 at byte 4723187
# This item is included in the report because it matches --limit.
# Scores: V/M = 1.30
# Time range: 2014-01-04 09:18:50 to 2014-01-05 21:01:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 24
# Exec time 0 10s 113ms 4s 428ms 455ms 745ms 241ms
# Lock time 2 358ms 15us 357ms 15ms 30us 71ms 19us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 2.93k 125 125 125 125 0 125
# String:
# Databases dxcrewco_2013
# Hosts localhost
# Users dxcrewco_marco
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #####
# 10s+
# Tables
# SHOW TABLE STATUS FROM `dxcrewco_2013` LIKE 'lw532_session'\G
# SHOW CREATE TABLE `dxcrewco_2013`.`lw532_session`\G
INSERT INTO `lw532_session`
(`session_id`, `client_id`, `time`) VALUES
('9ea929a199c47e48648203a6233eaf34', 0, '1388905635')\G
# Query 18: 0.00 QPS, 0.00x concurrency, ID 0x9174EDDB77190BB8 at byte 4789132
# This item is included in the report because it matches --limit.
# Scores: V/M = 3.33
# Time range: 2014-01-03 12:29:51 to 2014-01-05 03:15:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 6
# Exec time 0 10s 109ms 7s 2s 7s 2s 1s
# Lock time 0 216us 18us 53us 36us 52us 16us 50us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 356 1 182 59.33 174.84 77.70 81.24
# Query size 0 492 82 82 82 82 0 82
# String:
# Databases eximstats
# Hosts localhost
# Users eximstats
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `eximstats` LIKE 'failures'\G
# SHOW CREATE TABLE `eximstats`.`failures`\G
delete from failures where FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-2592000) > mailtime\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from failures where FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-2592000) > mailtime\G
# Query 19: 0.00 QPS, 0.00x concurrency, ID 0x029F750F15BAF08D at byte 3194699
# This item is included in the report because it matches --limit.
# Scores: V/M = 3.07
# Time range: 2014-01-04 02:57:23 to 13:51:59
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 5
# Exec time 0 8s 101ms 6s 2s 6s 2s 230ms
# Lock time 0 141us 25us 34us 28us 33us 3us 26us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 5 1 1 1 1 0 1
# Query size 0 315 63 63 63 63 0 63
# String:
# Databases dbspma_innova
# Hosts localhost
# Users dbspma_innova
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ##########################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `dbspma_innova` LIKE 'u9lgq_k2_items'\G
# SHOW CREATE TABLE `dbspma_innova`.`u9lgq_k2_items`\G
UPDATE u9lgq_k2_items
SET `hits` = (`hits` + 1)
WHERE id = '28'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `hits` = (`hits` + 1) from u9lgq_k2_items where id = '28'\G
# Query 20: 0.00 QPS, 0.00x concurrency, ID 0x8857E60478FD78A9 at byte 426870
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.04
# Time range: 2014-01-03 00:47:43 to 2014-01-05 18:55:26
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 40
# Exec time 0 7s 102ms 529ms 187ms 374ms 90ms 148ms
# Lock time 0 752us 14us 26us 18us 21us 2us 18us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 4.88k 125 125 125 125 0 125
# String:
# Databases hogarma_2013
# Hosts localhost
# Users hogarma_jorge
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `hogarma_2013` LIKE 'ayk3j_session'\G
# SHOW CREATE TABLE `hogarma_2013`.`ayk3j_session`\G
INSERT INTO `ayk3j_session`
(`session_id`, `client_id`, `time`) VALUES
('efbc24d544b64850279466b735871b20', 1, '1388736312')\G