# 5.2s user time, 70ms system time, 41.83M rss, 195.15M vsz
# Current date: Fri Sep 27 19:26:51 2013
# Hostname: server2.noblesintl.com
# Files: /var/lib/mysql/mysql-slow.log
# Overall: 19.71k total, 557 unique, 0.09 QPS, 0.04x concurrency _________
# Time range: 2013-09-25 07:38:56 to 2013-09-27 19:26:48
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 8069s 100ms 125s 409ms 900ms 2s 171ms
# Lock time 45s 0 1s 2ms 366us 29ms 52us
# Rows sent 6.99M 0 1.08M 371.76 0.99 13.13k 0.99
# Rows examine 2.70G 0 1.08M 143.38k 345.04k 121.65k 117.95k
# Query size 9.33M 13 1017.15k 496.16 420.77 11.91k 97.36
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== =============== ===== ====== ===== =============
# 1 0x09E72E2204EBF0C3 2167.2854 26.9% 5289 0.4098 0.02 SELECT visits_stats
# 2 0xF228C91161D1EC7C 1925.7761 23.9% 709 2.7162 5.18 SELECT tables
# 3 0xB39A215557304DB1 1297.8184 16.1% 8118 0.1599 0.01 SELECT visits_stats
# 4 0x6BD8A3405809FF88 351.5403 4.4% 851 0.4131 0.03 SELECT visits_stats
# 5 0x19452FECFDC5E794 298.6716 3.7% 113 2.6431 10... INSERT failures
# 6 0x9174EDDB77190BB8 255.8789 3.2% 179 1.4295 7.49 DELETE failures
# 7 0xCF9A2CB516C43E53 236.3422 2.9% 100 2.3634 78.05 INSERT sends
# 8 0x67A347A2812914DF 181.9827 2.3% 228 0.7982 16.89 SELECT ?images_comments
# 9 0x028D50B38C88D6B2 170.6957 2.1% 89 1.9179 11.52 SELECT tables
# 10 0x29D7227C66362892 76.8918 1.0% 246 0.3126 0.35 UPDATE gbs_session
# 11 0x7481BC1F9F3D893B 62.8518 0.8% 164 0.3832 1.17 INSERT jos_session
# 12 0x50B012B84A236154 59.8370 0.7% 281 0.2129 0.09 UPDATE jos_session
# 13 0xF1C9AD78849CCC54 51.2942 0.6% 150 0.3420 0.17 INSERT gbs_session
# 14 0xA242801E36807045 50.1065 0.6% 152 0.3296 0.21 DELETE sends
# 15 0x7194135125B38CDE 37.1730 0.5% 15 2.4782 0.09 SELECT information_schema.tables
# 16 0xCDAEB2723EFA7AC0 33.1414 0.4% 93 0.3564 0.24 DELETE defers
# 17 0xB0AB4CC438F2D0C0 31.7228 0.4% 102 0.3110 0.24 UPDATE gbs_content
# 18 0x2055D6C58DE6C2E2 29.3358 0.4% 94 0.3121 0.21 DELETE smtp
# 19 0x94350EA2AB8AAC34 28.0018 0.3% 117 0.2393 0.08 UPDATE SELECT wp_options
# 20 0x4DA40852208338A8 27.1998 0.3% 202 0.1347 0.00 UPDATE smtp sends
# 21 0x05872ECC22546540 25.7943 0.3% 63 0.4094 0.30 DELETE jos_session
# 31 0xAFF3DF040B975A33 12.3887 0.2% 36 0.3441 0.37 UPDATE xoopsen_banner
# 35 0xB24A88E43B46F1F4 8.8393 0.1% 18 0.4911 0.81 UPDATE categories_details
# 37 0xA9FCAAB4262DF33C 8.3631 0.1% 13 0.6433 0.48 SHOW TABLE STATUS
# 52 0xF6094CBC2D7DFE16 4.9497 0.1% 12 0.4125 0.45 SELECT pages
# MISC 0xMISC 634.6544 7.9% 2276 0.2788 0.0 <532 ITEMS>
# Query 1: 0.02 QPS, 0.01x concurrency, ID 0x09E72E2204EBF0C3 at byte 13300731
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.02
# Time range: 2013-09-25 07:39:50 to 2013-09-27 19:26:48
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 26 5289
# Exec time 26 2167s 101ms 1s 410ms 477ms 100ms 433ms
# Lock time 6 3s 38us 235ms 515us 103us 8ms 84us
# Rows sent 0 5.17k 1 1 1 1 0 1
# Rows examine 57 1.55G 28.43k 355.94k 306.34k 345.04k 72.45k 345.04k
# Query size 6 617.71k 117 123 119.59 118.34 2.73 118.34
# String:
# Databases syriainv_syriainvestmentmap
# Hosts localhost
# Users syriainv_syria
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `syriainv_syriainvestmentmap` LIKE 'visits_stats'\G
# SHOW CREATE TABLE `syriainv_syriainvestmentmap`.`visits_stats`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT count(*) as c FROM visits_stats WHERE service=5 AND ip='5.10.83.97' AND time>=1380292206 AND page=0 AND lang=1\G
# Query 2: 0.00 QPS, 0.01x concurrency, ID 0xF228C91161D1EC7C at byte 10609728
# This item is included in the report because it matches --limit.
# Scores: V/M = 5.18
# Time range: 2013-09-25 07:40:07 to 2013-09-27 19:25:08
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 709
# Exec time 23 1926s 1s 56s 3s 3s 4s 2s
# Lock time 0 62ms 43us 128us 86us 108us 12us 84us
# Rows sent 0 709 1 1 1 1 0 1
# Rows examine 0 359.35k 519 519 519 519 0 519
# Query size 0 41.54k 60 60 60 60 0 60
# String:
# Databases information_schema
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+ #
# Tables
# SHOW TABLE STATUS FROM `information_schema` LIKE 'tables'\G
# SHOW CREATE TABLE `information_schema`.`tables`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT data_free FROM tables WHERE ENGINE = 'InnoDB' LIMIT 1\G
# Query 3: 0.04 QPS, 0.01x concurrency, ID 0xB39A215557304DB1 at byte 9634804
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2013-09-25 07:38:56 to 2013-09-27 19:26:00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 41 8118
# Exec time 16 1298s 104ms 1s 160ms 171ms 29ms 163ms
# Lock time 6 3s 28us 900ms 356us 84us 13ms 40us
# Rows sent 0 7.93k 1 1 1 1 0 1
# Rows examine 32 889.72M 51.91k 122.89k 112.23k 117.95k 10.75k 117.95k
# Query size 8 768.44k 94 100 96.93 97.36 2.06 92.72
# String:
# Databases syriainv_syriainvestmentmap
# Hosts localhost
# Users syriainv_syria
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `syriainv_syriainvestmentmap` LIKE 'visits_stats'\G
# SHOW CREATE TABLE `syriainv_syriainvestmentmap`.`visits_stats`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT count(*) as c FROM visits_stats WHERE service=3 AND ip='5.135.165.126' AND time>=1380199807\G
# Query 4: 0.00 QPS, 0.00x concurrency, ID 0x6BD8A3405809FF88 at byte 13494709
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.03
# Time range: 2013-09-25 08:01:55 to 2013-09-27 19:25:51
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 851
# Exec time 4 352s 358ms 1s 413ms 580ms 111ms 374ms
# Lock time 0 35ms 30us 689us 41us 47us 25us 38us
# Rows sent 0 851 1 1 1 1 0 1
# Rows examine 9 259.04M 311.30k 312.09k 311.70k 298.06k 0 298.06k
# Query size 0 91.64k 107 113 110.27 107.34 1.42 107.34
# String:
# Databases syriainv_syriainvestmentmap
# Hosts localhost
# Users syriainv_syria
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `syriainv_syriainvestmentmap` LIKE 'visits_stats'\G
# SHOW CREATE TABLE `syriainv_syriainvestmentmap`.`visits_stats`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT count(*) as c FROM visits_stats WHERE service=4 AND ip='182.118.21.238' AND time>=1380295159 AND page=767\G
# Query 5: 0.00 QPS, 0.00x concurrency, ID 0x19452FECFDC5E794 at byte 11576198
# This item is included in the report because it matches --limit.
# Scores: V/M = 100.94
# Time range: 2013-09-25 10:24:45 to 2013-09-27 18:22:25
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 113
# Exec time 3 299s 100ms 125s 3s 1s 16s 293ms
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 31.42k 272 453 284.71 284.79 18.01 271.23
# 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
INSERT DELAYED INTO failures (mailtime,msgid,email,transport_method,message,host,ip,router,deliveryuser,deliverydomain) VALUES(FROM_UNIXTIME('1380249003'),'1VPNoh-0000jE-hJ','[email protected]','**rejected**','Sender verify failed','ppxtwv','115.230.124.35','reject','','sohu.com')\G
# Query 6: 0.00 QPS, 0.00x concurrency, ID 0x9174EDDB77190BB8 at byte 4346637
# This item is included in the report because it matches --limit.
# Scores: V/M = 7.49
# Time range: 2013-09-25 07:44:38 to 2013-09-27 19:12:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 179
# Exec time 3 256s 105ms 31s 1s 4s 3s 539ms
# Lock time 0 78ms 131us 949us 435us 725us 205us 490us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 636.19k 282 22.06k 3.55k 8.06k 2.57k 2.89k
# Query size 0 14.33k 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 7: 0.00 QPS, 0.00x concurrency, ID 0xCF9A2CB516C43E53 at byte 11659473
# This item is included in the report because it matches --limit.
# Scores: V/M = 78.05
# Time range: 2013-09-26 02:28:52 to 2013-09-27 17:18:06
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 100
# Exec time 2 236s 101ms 100s 2s 857ms 14s 279ms
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 24.33k 241 282 249.18 271.23 9.49 246.02
# 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 'sends'\G
# SHOW CREATE TABLE `eximstats`.`sends`\G
INSERT DELAYED INTO sends (mailtime,msgid,processed,domain,email,user,size,host,ip,auth,localsender) VALUES(FROM_UNIXTIME('1380249314'),'1VPNti-0001F8-hJ','0','','[email protected]','-remote-','0','kcc','115.230.124.35','unauthorized','0')\G
# Query 8: 0.00 QPS, 0.00x concurrency, ID 0x67A347A2812914DF at byte 3903303
# This item is included in the report because it matches --limit.
# Scores: V/M = 16.89
# Time range: 2013-09-25 07:40:51 to 2013-09-27 07:43:07
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 228
# Exec time 2 182s 100ms 45s 798ms 3s 4s 163ms
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 98 6.87M 0 1.08M 30.85k 65.68k 118.31k 104.78
# Rows examine 0 8.04M 1 1.08M 36.12k 65.68k 117.24k 17.59k
# Query size 0 20.27k 44 425 91.05 212.52 71.59 51.63
# String:
# Databases horde (73/32%), yallatas_v... (23/10%)... 64 more
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ###
# 10s+ #
# Tables
# SHOW TABLE STATUS FROM `hasanbek_images` LIKE '4images_comments'\G
# SHOW CREATE TABLE `hasanbek_images`.`4images_comments`\G
SELECT /*!40001 SQL_NO_CACHE */ * FROM `4images_comments`\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /*!40001 SQL_NO_CACHE */ * FROM `4images_comments`\G
# Query 9: 0.00 QPS, 0.00x concurrency, ID 0x028D50B38C88D6B2 at byte 11393714
# This item is included in the report because it matches --limit.
# Scores: V/M = 11.52
# Time range: 2013-09-25 07:40:06 to 2013-09-27 18:10:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 89
# Exec time 2 171s 100ms 23s 2s 15s 5s 125ms
# Lock time 0 7ms 45us 118us 83us 103us 11us 80us
# Rows sent 0 89 1 1 1 1 0 1
# Rows examine 0 445.76k 4.97k 5.17k 5.01k 4.95k 0 4.95k
# Query size 0 4.43k 51 51 51 51 0 51
# String:
# Databases information_schema
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ####
# 10s+ #######
# Tables
# SHOW TABLE STATUS FROM `information_schema` LIKE 'tables'\G
# SHOW CREATE TABLE `information_schema`.`tables`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT count(*) FROM tables WHERE ENGINE = 'InnoDB'\G
# Query 10: 0.00 QPS, 0.00x concurrency, ID 0x29D7227C66362892 at byte 8877568
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.35
# Time range: 2013-09-25 10:19:41 to 2013-09-27 19:16:35
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 246
# Exec time 0 77s 100ms 3s 313ms 609ms 331ms 230ms
# Lock time 0 28ms 53us 418us 114us 138us 33us 103us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 246 1 1 1 1 0 1
# Query size 3 334.83k 1.10k 2.50k 1.36k 2.38k 432.52 1.20k
# String:
# Databases gbs-syr_joomla
# Hosts localhost
# Users gbs-syr_superuse
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `gbs-syr_joomla` LIKE 'gbs_session'\G
# SHOW CREATE TABLE `gbs-syr_joomla`.`gbs_session`\G
UPDATE `gbs_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:20;s:19:\"session.timer.start\";i:1380183841;s:18:\"session.timer.last\";i:1380193576;s:17:\"session.timer.now\";i:1380193584;s:24:\"session.client.forwarded\";s:10:\"5.0.234.27\";s:22:\"session.client.browser\";s:101:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.76 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:11:\"com_modules\";O:8:\"stdClass\":3:{s:4:\"edit\";O:8:\"stdClass\":1:{s:6:\"module\";O:8:\"stdClass\":2:{s:2:\"id\";a:1:{i:0;i:91;}s:4:\"data\";N;}}s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}s:3:\"add\";O:8:\"stdClass\":1:{s:6:\"module\";O:8:\"stdClass\":2:{s:12:\"extension_id\";N;s:6:\"params\";N;}}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"994\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:11:\"samer_32928\";s:5:\"email\";s:21:\"[email protected]\";s:8:\"password\";s:65:\"1d4da2320189779a4e0f7ea7f6c8f715:nugzi7JKOm6qqI382OSp7sPEokdZpwC7\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-03-07 17:43:46\";s:13:\"lastvisitDate\";s:19:\"2013-09-24 08:43:16\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}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:\"4ac141039d1286d79bcda13852afc59f\";}'
, `time` = '1380193585'
WHERE `session_id` = '9e0bad279bc3bbc50f29cb7fc2bd2a0f'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `data` = '__default|a:9:{s:15:\"session.counter\";i:20;s:19:\"session.timer.start\";i:1380183841;s:18:\"session.timer.last\";i:1380193576;s:17:\"session.timer.now\";i:1380193584;s:24:\"session.client.forwarded\";s:10:\"5.0.234.27\";s:22:\"session.client.browser\";s:101:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.76 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:11:\"com_modules\";O:8:\"stdClass\":3:{s:4:\"edit\";O:8:\"stdClass\":1:{s:6:\"module\";O:8:\"stdClass\":2:{s:2:\"id\";a:1:{i:0;i:91;}s:4:\"data\";N;}}s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}s:3:\"add\";O:8:\"stdClass\":1:{s:6:\"module\";O:8:\"stdClass\":2:{s:12:\"extension_id\";N;s:6:\"params\";N;}}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"994\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:11:\"samer_32928\";s:5:\"email\";s:21:\"[email protected]\";s:8:\"password\";s:65:\"1d4da2320189779a4e0f7ea7f6c8f715:nugzi7JKOm6qqI382OSp7sPEokdZpwC7\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-03-07 17:43:46\";s:13:\"lastvisitDate\";s:19:\"2013-09-24 08:43:16\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}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:\"4ac141039d1286d79bcda13852afc59f\";}'
, `time` = '1380193585' from `gbs_session` where `session_id` = '9e0bad279bc3bbc50f29cb7fc2bd2a0f'\G
# Query 11: 0.00 QPS, 0.00x concurrency, ID 0x7481BC1F9F3D893B at byte 4264441
# This item is included in the report because it matches --limit.
# Scores: V/M = 1.17
# Time range: 2013-09-25 09:51:14 to 2013-09-27 19:00:47
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 164
# Exec time 0 63s 100ms 8s 383ms 945ms 670ms 189ms
# Lock time 6 3s 25us 1s 18ms 69us 121ms 35us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 25.62k 160 160 160 160 0 160
# String:
# Databases shamfutu_2... (89/54%), nashawy_de... (74/45%)... 1 more
# Hosts localhost
# Users shamfutu_2... (89/54%), nashawy_ro... (74/45%)... 1 more
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ###
# 10s+
# Tables
# SHOW TABLE STATUS FROM `nashawy_dental` LIKE 'jos_session'\G
# SHOW CREATE TABLE `nashawy_dental`.`jos_session`\G
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'd13ec6b23c4dd53e4ab9d7f7f098ef07','1380162687','','0','1','0' )\G
# Query 12: 0.00 QPS, 0.00x concurrency, ID 0x50B012B84A236154 at byte 11428505
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.09
# Time range: 2013-09-25 09:38:33 to 2013-09-27 19:13:32
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 281
# Exec time 0 60s 100ms 1s 213ms 455ms 141ms 163ms
# Lock time 0 297ms 57us 122ms 1ms 93us 9ms 66us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 281 1 1 1 1 0 1
# Query size 4 431.79k 1.36k 1.85k 1.54k 1.69k 87.90 1.46k
# String:
# Databases shamfutu_2... (215/76%), nashawy_de... (66/23%)
# Hosts localhost
# Users shamfutu_2... (215/76%), nashawy_ro... (66/23%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `shamfutu_2011` LIKE 'jos_session'\G
# SHOW CREATE TABLE `shamfutu_2011`.`jos_session`\G
UPDATE `jos_session` SET `time`='1380244576',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1380244564;s:18:\"session.timer.last\";i:1380244573;s:17:\"session.timer.now\";i:1380244576;s:22:\"session.client.browser\";s:77:\"Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:11.0) Gecko/20120313 Firefox/11.0\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:10:\"com_search\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:5:\"limit\";i:10;}}}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:66:\"/home/shamfutu/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:{}}s:13:\"session.token\";s:32:\"b6901284d4b5eb1ae6a8a0a96c5be082\";}' WHERE session_id='7a3f82c6f0ddbf2e54877e460266d341'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `time`='1380244576',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1380244564;s:18:\"session.timer.last\";i:1380244573;s:17:\"session.timer.now\";i:1380244576;s:22:\"session.client.browser\";s:77:\"Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:11.0) Gecko/20120313 Firefox/11.0\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:10:\"com_search\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:5:\"limit\";i:10;}}}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:66:\"/home/shamfutu/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:{}}s:13:\"session.token\";s:32:\"b6901284d4b5eb1ae6a8a0a96c5be082\";}' from `jos_session` where session_id='7a3f82c6f0ddbf2e54877e460266d341'\G
# Query 13: 0.00 QPS, 0.00x concurrency, ID 0xF1C9AD78849CCC54 at byte 1034571
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.17
# Time range: 2013-09-25 09:37:12 to 2013-09-27 19:16:34
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 150
# Exec time 0 51s 104ms 2s 342ms 609ms 238ms 293ms
# Lock time 0 6ms 23us 1ms 42us 54us 109us 28us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 18.02k 123 123 123 123 0 123
# String:
# Databases gbs-syr_joomla
# Hosts localhost
# Users gbs-syr_superuse
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `gbs-syr_joomla` LIKE 'gbs_session'\G
# SHOW CREATE TABLE `gbs-syr_joomla`.`gbs_session`\G
INSERT INTO `gbs_session`
(`session_id`, `client_id`, `time`) VALUES
('a5d61878cf18007e400d6e623ffc808c', 0, '1380110877')\G
# Query 14: 0.00 QPS, 0.00x concurrency, ID 0xA242801E36807045 at byte 12100131
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.21
# Time range: 2013-09-25 07:44:22 to 2013-09-27 19:12:18
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 152
# Exec time 0 50s 103ms 2s 330ms 857ms 265ms 230ms
# Lock time 1 540ms 21us 531ms 4ms 93us 43ms 66us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 608.15k 345 22.46k 4.00k 8.46k 2.68k 3.35k
# Query size 0 11.73k 79 79 79 79 0 79
# 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 'sends'\G
# SHOW CREATE TABLE `eximstats`.`sends`\G
delete from sends where FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-2592000) > mailtime\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from sends where FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-2592000) > mailtime\G
# Query 15: 0.00 QPS, 0.00x concurrency, ID 0x7194135125B38CDE at byte 10560623
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.09
# Time range: 2013-09-25 08:30:04 to 2013-09-27 16:30:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 15
# Exec time 0 37s 2s 4s 2s 3s 475ms 2s
# Lock time 0 2ms 86us 139us 100us 108us 13us 93us
# Rows sent 0 4.29k 291 302 292.60 284.79 3.55 284.79
# Rows examine 0 83.32k 5.53k 5.76k 5.55k 5.45k 69.67 5.45k
# Query size 0 1.85k 126 126 126 126 0 126
# String:
# Databases mysql
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `information_schema` LIKE 'tables'\G
# SHOW CREATE TABLE `information_schema`.`tables`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA\G
# Query 16: 0.00 QPS, 0.00x concurrency, ID 0xCDAEB2723EFA7AC0 at byte 10639549
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.24
# Time range: 2013-09-25 15:58:21 to 2013-09-27 19:12:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 93
# Exec time 0 33s 104ms 2s 356ms 945ms 295ms 219ms
# Lock time 0 52ms 60us 974us 563us 761us 217us 596us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 5.17k 8 388 56.95 158.58 60.64 33.28
# Query size 0 7.27k 80 80 80 80 0 80
# 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 'defers'\G
# SHOW CREATE TABLE `eximstats`.`defers`\G
delete from defers where FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-2592000) > mailtime\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from defers where FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-2592000) > mailtime\G
# Query 17: 0.00 QPS, 0.00x concurrency, ID 0xB0AB4CC438F2D0C0 at byte 882257
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.24
# Time range: 2013-09-25 10:19:43 to 2013-09-27 18:41:57
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 102
# Exec time 0 32s 100ms 2s 311ms 777ms 271ms 189ms
# Lock time 0 5ms 28us 407us 47us 66us 37us 38us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 102 1 1 1 1 0 1
# Query size 0 5.12k 51 52 51.43 51.63 0.50 49.17
# String:
# Databases gbs-syr_joomla
# Hosts localhost
# Users gbs-syr_superuse
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ###
# 10s+
# Tables
# SHOW TABLE STATUS FROM `gbs-syr_joomla` LIKE 'gbs_content'\G
# SHOW CREATE TABLE `gbs-syr_joomla`.`gbs_content`\G
UPDATE gbs_content SET hits = hits + 1 WHERE id = 11\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select hits = hits + 1 from gbs_content where id = 11\G
# Query 18: 0.00 QPS, 0.00x concurrency, ID 0x2055D6C58DE6C2E2 at byte 9571848
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.21
# Time range: 2013-09-25 07:44:21 to 2013-09-27 19:12:18
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 94
# Exec time 0 29s 101ms 2s 312ms 672ms 256ms 208ms
# Lock time 0 23ms 26us 15ms 242us 93us 2ms 76us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 17.66k 51 988 192.34 381.65 134.24 151.03
# Query size 0 7.16k 78 78 78 78 0 78
# 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 'smtp'\G
# SHOW CREATE TABLE `eximstats`.`smtp`\G
delete from smtp where FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-2592000) > mailtime\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from smtp where FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-2592000) > mailtime\G
# Query 19: 0.00 QPS, 0.00x concurrency, ID 0x94350EA2AB8AAC34 at byte 1824310
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.08
# Time range: 2013-09-25 07:57:52 to 2013-09-27 15:29:06
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 117
# Exec time 0 28s 100ms 808ms 239ms 552ms 141ms 180ms
# Lock time 0 11ms 44us 715us 93us 113us 86us 76us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 117 1 1 1 1 0 1
# Query size 2 197.63k 96 30.42k 1.69k 1.86k 3.77k 1.09k
# String:
# Databases whest_wp1 (80/68%), whest_wp2 (37/31%)
# Hosts localhost
# Users whest_wp2 (80/68%), whest_wp3 (37/31%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `whest_wp1` LIKE 'wp_options'\G
# SHOW CREATE TABLE `whest_wp1`.`wp_options`\G
UPDATE `wp_options` SET `option_value` = 'a:113:{s:11:\"custom_logo\";s:63:\"http://whest.net/index/wp-content/uploads/2013/09/log2013V2.png\";s:17:\"custom_login_logo\";s:62:\"http://whest.net/index/wp-content/uploads/2013/09/log20131.png\";s:24:\"custom_login_logo_height\";s:2:\"87\";s:14:\"custom_favicon\";s:0:\"\";s:12:\"callout_text\";s:5:\"Login\";s:12:\"callout_link\";s:35:\"http://whest.net/index/wp-login.php\";s:14:\"callout_target\";s:5:\"blank\";s:18:\"header_top_padding\";s:1:\"0\";s:21:\"header_bottom_padding\";s:1:\"0\";s:16:\"header_aside_top\";s:1:\"0\";s:14:\"header_address\";s:45:\"EMove Fzco <br />Jabal Ali FZ<br />Dubai, UAE\";s:12:\"header_phone\";s:62:\"Phone :0097155259650<br>Fax: 0097155259650<br>[email protected]\";s:14:\"disable_search\";s:7:\"disable\";s:15:\"tracking_header\";s:0:\"\";s:15:\"tracking_footer\";s:0:\"\";s:10:\"custom_css\";s:0:\"\";s:9:\"custom_bg\";s:77:\"http://whest.net/index/wp-content/themes/Moderno2/Moderno/images/bg/bg_15.png\";s:16:\"thumb_overlay_bg\";s:93:\"http://whest.net/index/wp-content/themes/Moderno2/Moderno/images/thumb-overlays/0_bg_none.png\";s:21:\"thumb_overlay_opacity\";s:0:\"\";s:14:\"entry_hover_bg\";s:0:\"\";s:16:\"background_color\";s:7:\"#ededed\";s:15:\"main_link_color\";s:0:\"\";s:18:\"sidebar_link_color\";s:0:\"\";s:11:\"toplinks_bg\";s:0:\"\";s:19:\"toplinks_link_color\";s:0:\"\";s:10:\"callout_bg\";s:7:\"#e00303\";s:18:\"callout_link_color\";s:0:\"\";s:16:\"callout_hover_bg\";s:7:\"#9c9999\";s:24:\"callout_hover_link_color\";s:0:\"\";s:12:\"nav_bg_color\";s:7:\"#000000\";s:15:\"nav_hover_color\";s:7:\"#ebebeb\";s:28:\"nav_current_background_color\";s:7:\"#db0909\";s:22:\"nav_current_link_color\";s:7:\"#ffffff\";s:16:\"nav_border_color\";s:0:\"\";s:14:\"nav_link_color\";s:0:\"\";s:20:\"nav_link_hover_color\";s:0:\"\";s:19:\"nav_drop_background\";s:0:\"\";s:19:\"nav_drop_link_color\";s:0:\"\";s:26:\"nav_drop_link_border_color\";s:0:\"\";s:30:\"nav_drop_link_hover_background\";s:0:\"\";s:25:\"nav_drop_link_hover_color\";s:0:\"\";s:23:\"home_tagline_background\";s:7:\"#e6e6e6\";s:18:\"home_tagline_color\";s:0:\"\";s:23:\"home_tagline_link_color\";s:0:\"\";s:17:\"footer_background\";s:0:\"\";s:21:\"footer_headings_color\";s:0:\"\";s:17:\"footer_text_color\";s:0:\"\";s:17:\"footer_link_color\";s:0:\"\";s:20:\"footer_borders_color\";s:0:\"\";s:17:\"backup_background\";s:0:\"\";s:12:\"backup_color\";s:0:\"\";s:23:\"backup_hover_background\";s:0:\"\";s:18:\"backup_hover_color\";s:0:\"\";s:14:\"tag_background\";s:0:\"\";s:9:\"tag_color\";s:0:\"\";s:20:\"tag_hover_background\";s:0:\"\";s:15:\"tag_hover_color\";s:0:\"\";s:20:\"read_more_background\";s:0:\"\";s:15:\"read_more_color\";s:0:\"\";s:26:\"read_more_hover_background\";s:0:\"\";s:21:\"read_more_hover_color\";s:0:\"\";s:29:\"slider_arrow_hover_background\";s:7:\"#d9d9d9\";s:24:\"slider_arrow_hover_color\";s:0:\"\";s:14:\"main_font_size\";s:6:\"Select\";s:9:\"body_font\";s:6:\"Select\";s:13:\"headings_font\";s:6:\"Select\";s:20:\"headings_font_weight\";s:6:\"Select\";s:12:\"callout_font\";s:6:\"Select\";s:19:\"callout_font_weight\";s:6:\"Select\";s:17:\"home_tagline_font\";s:6:\"Select\";s:24:\"home_tagline_font_weight\";s:6:\"Select\";s:19:\"slider_caption_font\";s:5:\"Arial\";s:26:\"slider_caption_font_weight\";s:4:\"bold\";s:15:\"navigation_font\";s:6:\"Select\";s:22:\"navigation_font_weight\";s:6:\"Select\";s:15:\"homepage_blocks\";a:2:{s:7:\"enabled\";a:7:{s:7:\"placebo\";s:7:\"placebo\";s:12:\"home_tagline\";s:7:\"Tagline\";s:14:\"home_portfolio\";s:15:\"Portfolio Items\";s:10:\"home_video\";s:5:\"Video\";s:15:\"home_highlights\";s:10:\"Highlights\";s:9:\"home_blog\";s:10:\"Blog Posts\";s:13:\"home_services\";s:8:\"Services\";}s:8:\"disabled\";a:2:{s:7:\"placebo\";s:7:\"placebo\";s:16:\"home_static_page\";s:11:\"Static Page\";}}s:15:\"home_img_slider\";s:8:\"homepage\";s:12:\"home_tagline\";s:132:\"نقدم أفضل الخدمات على مستوى الشرق الأوسط في مجال الشحن و التخليص الجمركي\";s:21:\"home_highlights_title\";s:10:\"What We Do\";s:16:\"home_video_title\";s:5:\"Video\";s:10:\"home_video\";s:0:\"\";s:20:\"home_portfolio_title\";s:13:\"Featured Work\";s:18:\"home_portfolio_cat\";s:6:\"Select\";s:20:\"home_portfolio_count\";s:1:\"4\";s:15:\"home_blog_title\";s:13:\"From The Blog\";s:13:\"home_blog_cat\";s:6:\"Select\";s:15:\"home_blog_count\";s:1:\"8\";s:19:\"home_services_title\";s:12:\"Our Services\";s:17:\"home_services_cat\";s:6:\"Select\";s:16:\"home_static_page\";s:14:\"Select a page:\";s:20:\"portfolio_pagination\";s:2:\"12\";s:24:\"portfolio_cat_pagination\";s:1:\"2\";s:20:\"disable_related_port\";s:6:\"enable\";s:16:\"enable_full_blog\";s:7:\"disable\";s:12:\"blog_excerpt\";s:2:\"60\";s:25:\"enable_disable_post_image\";s:6:\"enable\";s:21:\"enable_disable_social\";s:6:\"enable\";s:7:\"twitter\";s:18:\"http://emovefz.com\";s:8:\"dribbble\";s:0:\"\";s:6:\"forrst\";s:0:\"\";s:6:\"flickr\";s:0:\"\";s:8:\"facebook\";s:18:\"http://emovefz.com\";s:8:\"linkedin\";s:79:\"http://www.linkedin.com/company/3301720?trk=tyah&trkInfo=tas%3Aemove%20shipping\";s:10:\"googleplus\";s:0:\"\";s:6:\"google\";s:0:\"\";s:7:\"youtube\";s:0:\"\";s:5:\"vimeo\";s:0:\"\";s:3:\"rss\";s:0:\"\";s:7:\"support\";s:0:\"\";s:4:\"mail\";s:25:\"mailto:[email protected]\";s:28:\"enable_disable_page_comments\";s:7:\"disable\";s:28:\"enable_disable_blog_comments\";s:6:\"enable\";s:33:\"enable_disable_portfolio_comments\";s:6:\"enable\";}' WHERE `option_name` = 'moderno(sharedonwww.mafiashare.net)_options'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `option_value` = 'a:113:{s:11:\"custom_logo\";s:63:\"http://whest.net/index/wp-content/uploads/2013/09/log2013V2.png\";s:17:\"custom_login_logo\";s:62:\"http://whest.net/index/wp-content/uploads/2013/09/log20131.png\";s:24:\"custom_login_logo_height\";s:2:\"87\";s:14:\"custom_favicon\";s:0:\"\";s:12:\"callout_text\";s:5:\"Login\";s:12:\"callout_link\";s:35:\"http://whest.net/index/wp-login.php\";s:14:\"callout_target\";s:5:\"blank\";s:18:\"header_top_padding\";s:1:\"0\";s:21:\"header_bottom_padding\";s:1:\"0\";s:16:\"header_aside_top\";s:1:\"0\";s:14:\"header_address\";s:45:\"EMove Fzco <br />Jabal Ali FZ<br />Dubai, UAE\";s:12:\"header_phone\";s:62:\"Phone :0097155259650<br>Fax: 0097155259650<br>[email protected]\";s:14:\"disable_search\";s:7:\"disable\";s:15:\"tracking_header\";s:0:\"\";s:15:\"tracking_footer\";s:0:\"\";s:10:\"custom_css\";s:0:\"\";s:9:\"custom_bg\";s:77:\"http://whest.net/index/wp-content/themes/Moderno2/Moderno/images/bg/bg_15.png\";s:16:\"thumb_overlay_bg\";s:93:\"http://whest.net/index/wp-content/themes/Moderno2/Moderno/images/thumb-overlays/0_bg_none.png\";s:21:\"thumb_overlay_opacity\";s:0:\"\";s:14:\"entry_hover_bg\";s:0:\"\";s:16:\"background_color\";s:7:\"#ededed\";s:15:\"main_link_color\";s:0:\"\";s:18:\"sidebar_link_color\";s:0:\"\";s:11:\"toplinks_bg\";s:0:\"\";s:19:\"toplinks_link_color\";s:0:\"\";s:10:\"callout_bg\";s:7:\"#e00303\";s:18:\"callout_link_color\";s:0:\"\";s:16:\"callout_hover_bg\";s:7:\"#9c9999\";s:24:\"callout_hover_link_color\";s:0:\"\";s:12:\"nav_bg_color\";s:7:\"#000000\";s:15:\"nav_hover_color\";s:7:\"#ebebeb\";s:28:\"nav_current_background_color\";s:7:\"#db0909\";s:22:\"nav_current_link_color\";s:7:\"#ffffff\";s:16:\"nav_border_color\";s:0:\"\";s:14:\"nav_link_color\";s:0:\"\";s:20:\"nav_link_hover_color\";s:0:\"\";s:19:\"nav_drop_background\";s:0:\"\";s:19:\"nav_drop_link_color\";s:0:\"\";s:26:\"nav_drop_link_border_color\";s:0:\"\";s:30:\"nav_drop_link_hover_background\";s:0:\"\";s:25:\"nav_drop_link_hover_color\";s:0:\"\";s:23:\"home_tagline_background\";s:7:\"#e6e6e6\";s:18:\"home_tagline_color\";s:0:\"\";s:23:\"home_tagline_link_color\";s:0:\"\";s:17:\"footer_background\";s:0:\"\";s:21:\"footer_headings_color\";s:0:\"\";s:17:\"footer_text_color\";s:0:\"\";s:17:\"footer_link_color\";s:0:\"\";s:20:\"footer_borders_color\";s:0:\"\";s:17:\"backup_background\";s:0:\"\";s:12:\"backup_color\";s:0:\"\";s:23:\"backup_hover_background\";s:0:\"\";s:18:\"backup_hover_color\";s:0:\"\";s:14:\"tag_background\";s:0:\"\";s:9:\"tag_color\";s:0:\"\";s:20:\"tag_hover_background\";s:0:\"\";s:15:\"tag_hover_color\";s:0:\"\";s:20:\"read_more_background\";s:0:\"\";s:15:\"read_more_color\";s:0:\"\";s:26:\"read_more_hover_background\";s:0:\"\";s:21:\"read_more_hover_color\";s:0:\"\";s:29:\"slider_arrow_hover_background\";s:7:\"#d9d9d9\";s:24:\"slider_arrow_hover_color\";s:0:\"\";s:14:\"main_font_size\";s:6:\"Select\";s:9:\"body_font\";s:6:\"Select\";s:13:\"headings_font\";s:6:\"Select\";s:20:\"headings_font_weight\";s:6:\"Select\";s:12:\"callout_font\";s:6:\"Select\";s:19:\"callout_font_weight\";s:6:\"Select\";s:17:\"home_tagline_font\";s:6:\"Select\";s:24:\"home_tagline_font_weight\";s:6:\"Select\";s:19:\"slider_caption_font\";s:5:\"Arial\";s:26:\"slider_caption_font_weight\";s:4:\"bold\";s:15:\"navigation_font\";s:6:\"Select\";s:22:\"navigation_font_weight\";s:6:\"Select\";s:15:\"homepage_blocks\";a:2:{s:7:\"enabled\";a:7:{s:7:\"placebo\";s:7:\"placebo\";s:12:\"home_tagline\";s:7:\"Tagline\";s:14:\"home_portfolio\";s:15:\"Portfolio Items\";s:10:\"home_video\";s:5:\"Video\";s:15:\"home_highlights\";s:10:\"Highlights\";s:9:\"home_blog\";s:10:\"Blog Posts\";s:13:\"home_services\";s:8:\"Services\";}s:8:\"disabled\";a:2:{s:7:\"placebo\";s:7:\"placebo\";s:16:\"home_static_page\";s:11:\"Static Page\";}}s:15:\"home_img_slider\";s:8:\"homepage\";s:12:\"home_tagline\";s:132:\"نقدم أفضل الخدمات على مستوى الشرق الأوسط في مجال الشحن و التخليص الجمركي\";s:21:\"home_highlights_title\";s:10:\"What We Do\";s:16:\"home_video_title\";s:5:\"Video\";s:10:\"home_video\";s:0:\"\";s:20:\"home_portfolio_title\";s:13:\"Featured Work\";s:18:\"home_portfolio_cat\";s:6:\"Select\";s:20:\"home_portfolio_count\";s:1:\"4\";s:15:\"home_blog_title\";s:13:\"From The Blog\";s:13:\"home_blog_cat\";s:6:\"Select\";s:15:\"home_blog_count\";s:1:\"8\";s:19:\"home_services_title\";s:12:\"Our Services\";s:17:\"home_services_cat\";s:6:\"Select\";s:16:\"home_static_page\";s:14:\"Select a page:\";s:20:\"portfolio_pagination\";s:2:\"12\";s:24:\"portfolio_cat_pagination\";s:1:\"2\";s:20:\"disable_related_port\";s:6:\"enable\";s:16:\"enable_full_blog\";s:7:\"disable\";s:12:\"blog_excerpt\";s:2:\"60\";s:25:\"enable_disable_post_image\";s:6:\"enable\";s:21:\"enable_disable_social\";s:6:\"enable\";s:7:\"twitter\";s:18:\"http://emovefz.com\";s:8:\"dribbble\";s:0:\"\";s:6:\"forrst\";s:0:\"\";s:6:\"flickr\";s:0:\"\";s:8:\"facebook\";s:18:\"http://emovefz.com\";s:8:\"linkedin\";s:79:\"http://www.linkedin.com/company/3301720?trk=tyah&trkInfo=tas%3Aemove%20shipping\";s:10:\"googleplus\";s:0:\"\";s:6:\"google\";s:0:\"\";s:7:\"youtube\";s:0:\"\";s:5:\"vimeo\";s:0:\"\";s:3:\"rss\";s:0:\"\";s:7:\"support\";s:0:\"\";s:4:\"mail\";s:25:\"mailto:[email protected]\";s:28:\"enable_disable_page_comments\";s:7:\"disable\";s:28:\"enable_disable_blog_comments\";s:6:\"enable\";s:33:\"enable_disable_portfolio_comments\";s:6:\"enable\";}' from `wp_options` where `option_name` = 'moderno(sharedonwww.mafiashare.net)_options'\G
# Query 20: 0.00 QPS, 0.00x concurrency, ID 0x4DA40852208338A8 at byte 4306587
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2013-09-25 07:44:20 to 2013-09-27 19:12:18
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 202
# Exec time 0 27s 120ms 354ms 135ms 134ms 19ms 128ms
# Lock time 0 179ms 93us 42ms 886us 881us 3ms 657us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 9.60M 42.83k 49.34k 48.67k 49.01k 1.59k 46.68k
# Query size 0 35.31k 179 179 179 179 0 179
# 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 'smtp'\G
# SHOW CREATE TABLE `eximstats`.`smtp`\G
# SHOW TABLE STATUS FROM `eximstats` LIKE 'sends'\G
# SHOW CREATE TABLE `eximstats`.`sends`\G
update smtp INNER JOIN sends ON (sends.msgid=smtp.msgid) set smtp.processed=3 where smtp.transport_is_remote=1 and sends.user IN ('-remote-','root','mailman') and smtp.processed=0\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select smtp.processed=3 from smtp INNER JOIN sends ON (sends.msgid=smtp.msgid) where smtp.transport_is_remote=1 and sends.user IN ('-remote-','root','mailman') and smtp.processed=0\G
# Query 21: 0.00 QPS, 0.00x concurrency, ID 0x05872ECC22546540 at byte 9502561
# This item is included in the report because it matches --outliers.
# Scores: V/M = 0.30
# Time range: 2013-09-25 10:20:01 to 2013-09-27 19:21:51
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 63
# Exec time 0 26s 102ms 2s 409ms 1s 349ms 266ms
# Lock time 1 805ms 21us 636ms 13ms 403us 77ms 22us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 431 0 257 6.84 5.75 31.30 0.99
# Query size 0 3.26k 53 53 53 53 0 53
# String:
# Databases shamfutu_2... (47/74%), nashawy_de... (15/23%)... 1 more
# Hosts localhost
# Users shamfutu_2... (47/74%), nashawy_ro... (15/23%)... 1 more
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #####
# 10s+
# Tables
# SHOW TABLE STATUS FROM `shamfutu_2011` LIKE 'jos_session'\G
# SHOW CREATE TABLE `shamfutu_2011`.`jos_session`\G
DELETE FROM jos_session WHERE ( time < '1380197348' )\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from jos_session WHERE ( time < '1380197348' )\G
# Query 31: 0.00 QPS, 0.00x concurrency, ID 0xAFF3DF040B975A33 at byte 3867307
# This item is included in the report because it matches --outliers.
# Scores: V/M = 0.37
# Time range: 2013-09-25 10:20:37 to 2013-09-27 18:55:46
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 36
# Exec time 0 12s 107ms 2s 344ms 1s 358ms 189ms
# Lock time 0 360ms 17us 269ms 10ms 33ms 44ms 26us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 36 1 1 1 1 0 1
# Query size 0 2.07k 59 59 59 59 0 59
# String:
# Databases tharaorg_enthara
# Hosts localhost
# Users tharaorg_semaan
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #####
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tharaorg_enthara` LIKE 'xoopsen_banner'\G
# SHOW CREATE TABLE `tharaorg_enthara`.`xoopsen_banner`\G
UPDATE xoopsen_banner SET impmade = impmade+1 WHERE bid = 3\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select impmade = impmade+1 from xoopsen_banner where bid = 3\G
# Query 35: 0.00 QPS, 0.00x concurrency, ID 0xB24A88E43B46F1F4 at byte 4270622
# This item is included in the report because it matches --outliers.
# Scores: V/M = 0.81
# Time range: 2013-09-25 10:05:24 to 2013-09-27 14:05:35
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 18
# Exec time 0 9s 108ms 3s 491ms 1s 631ms 308ms
# Lock time 0 661us 25us 80us 36us 54us 12us 31us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 18 1 1 1 1 0 1
# Query size 0 1.10k 62 64 62.83 62.76 1 62.76
# String:
# Databases alnazaf_da... (5/27%), auccsyri_a... (4/22%)... 8 more
# Hosts localhost
# Users alnazaf_us... (5/27%), auccsyri_a... (4/22%)... 8 more
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ########
# 10s+
# Tables
# SHOW TABLE STATUS FROM `haramtra_haram` LIKE 'categories_details'\G
# SHOW CREATE TABLE `haramtra_haram`.`categories_details`\G
update categories_details set num_read=num_read+1 where id='2'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select num_read=num_read+1 from categories_details where id='2'\G
# Query 37: 0.00 QPS, 0.00x concurrency, ID 0xA9FCAAB4262DF33C at byte 3848586
# This item is included in the report because it matches --outliers.
# Scores: V/M = 0.48
# Time range: 2013-09-26 02:55:18 to 2013-09-27 07:40:23
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 13
# Exec time 0 8s 149ms 2s 643ms 2s 556ms 384ms
# Lock time 0 1ms 71us 103us 90us 98us 7us 89us
# Rows sent 0 624 48 48 48 48 0 48
# Rows examine 0 624 48 48 48 48 0 48
# Query size 0 364 28 28 28 28 0 28
# String:
# Databases mysql
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ###########
# 10s+
SHOW TABLE STATUS IN `horde`\G
# Query 52: 0.00 QPS, 0.00x concurrency, ID 0xF6094CBC2D7DFE16 at byte 10857172
# This item is included in the report because it matches --outliers.
# Scores: V/M = 0.45
# Time range: 2013-09-25 13:40:39 to 2013-09-27 07:46:46
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 12
# Exec time 0 5s 106ms 2s 412ms 1s 432ms 219ms
# Lock time 0 610us 29us 86us 50us 80us 20us 38us
# Rows sent 0 12 1 1 1 1 0 1
# Rows examine 0 3.87k 330 330 330 330 0 330
# Query size 0 720 60 60 60 60 0 60
# String:
# Databases mghanoum_ghanoum
# Hosts localhost
# Users mghanoum_root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ############
# 10s+
# Tables
# SHOW TABLE STATUS FROM `mghanoum_ghanoum` LIKE 'pages'\G
# SHOW CREATE TABLE `mghanoum_ghanoum`.`pages`\G
# EXPLAIN /*!50100 PARTITIONS*/
select * from pages where home='yes' order by rand() limit 1\G
