Skip to main content

Configuring my.cnf for new server

Comments

12 comments

  • Aaron.Edwards
    What will be your expected webserver hits ? Approx. Number of MyISAM Tables in the MySQL Database ? Approx. Number of InnoDB Tables in the MySQL Database ? Expected MySQL Server's Max Connections ?
    0
  • nourjabi
    Hi, I'm not sure about Web-server hits, but I might say I have over 500 Clients and might have over 1000 next year, so I would expect a big number. (AS in my SQLTuner Data). For MyISAM Tables, I currently have 5040 Table For InnoDB Tables, I have around 171 Tables. Lastly, for connections I'd say I never had more than 100 connection . ( I Usually set it to 300 max connections in My.CNF). Here's a Fresh MySQLTuner result after 24 Hour: -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.1.70-cll [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 8G (Tables: 5040) [--] Data in InnoDB tables: 5M (Tables: 171) [--] Data in MEMORY tables: 496K (Tables: 24) [!!] Total fragmented tables: 252 -------- Performance Metrics ------------------------------------------------- [--] Up for: 11h 50m 20s (1M q [35.877 qps], 28K conn, TX: 5B, RX: 141M) [--] Reads / Writes: 95% / 5% [--] Total buffers: 34.0M global + 2.7M per thread (151 max threads) [OK] Maximum possible memory usage: 449.2M (1% of installed RAM) [OK] Slow queries: 0% (47/1M) [OK] Highest usage of available connections: 19% (30/151) [!!] Key buffer size / total MyISAM indexes: 8.0M/1.5G [!!] Key buffer hit rate: 91.0% (34M cached / 3M reads) [!!] Query cache is disabled [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 211K sorts) [!!] Joins performed without indexes: 2748 [!!] Temporary tables created on disk: 30% (57K on disk / 187K total) [!!] Thread cache is disabled [!!] Table cache hit rate: 0% (64 open / 1M opened) [OK] Open file limit used: 0% (128/31K) [OK] Table locks acquired immediately: 99% (938K immediate / 938K locks) [!!] Connections aborted: 7% [OK] InnoDB data size / buffer pool: 5.8M/8.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries Adjust your join queries to always utilize indexes When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries without LIMIT clauses Set thread_cache_size to 4 as a starting value Increase table_cache gradually to avoid file descriptor limits Your applications are not closing MySQL connections properly Variables to adjust: key_buffer_size (> 1.5G) query_cache_size (>= 8M) join_buffer_size (> 128.0K, or always use indexes with joins) tmp_table_size (> 16M) max_heap_table_size (> 16M) thread_cache_size (start at 4) table_cache (> 64)
    0
  • cPanelMichael
    Hello :) Try to ensure MySQL is running for at least 24 hours before running the tuner script to ensure the most accurate results. Thank you.
    0
  • nourjabi
    thank you, i will wait until its up for 24 hr :)
    0
  • thinkbot
    add myisam_use_mmap=1 key_buffer_size = 3000M join_buffer_size=4M query_cache_type = 1 query_cache_size = 50M query_cache_limit = 1M table_cache = 3000 thread_cache_size = 50 max_heap_table_size = 100M tmp_table_size = 100M slow_query_log=1 slow_query_log_file=mysql-slow.log long_query_time=0.1 and restart
    0
  • nourjabi
    I have added your configurations, and restarted MySQL. will wait 24 hour and post results with mysqltuner . :)
    0
  • nourjabi
    Here's my results after 24 Hour, I noticed a bit of RAM consumption. MySQL Used to only take 1% not over 7%. -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.1.70-cll [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status:[COLOR="#00FF00"> +Archive [COLOR="#FF0000">-BDB -Federated [COLOR="#00FF00">+InnoDB [COLOR="#FF0000">-ISAM -NDBCluster [--] Data in MyISAM tables: 7G (Tables: 4839) [--] Data in InnoDB tables: 5M (Tables: 171) [--] Data in MEMORY tables: 620K (Tables: 24) [!!] Total fragmented tables: 250 -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 3h 57m 50s (3M q [33.857 qps], 67K conn, TX: 10B, RX: 317M) [--] Reads / Writes: 58% / 42% [--] Total buffers: 3.1G global + 6.6M per thread (151 max threads) [OK] Maximum possible memory usage: 4.1G (12% of installed RAM) [OK] Slow queries: 0% (10K/3M) [OK] Highest usage of available connections: 15% (23/151) [OK] Key buffer size / total MyISAM indexes: 2.9G/1.0G [OK] Key buffer hit rate: 97.1% (122M cached / 3M reads) [OK] Query cache efficiency: 83.0% (1M cached / 1M selects) [!!] Query cache prunes per day: 62250 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 116K sorts) [!!] Joins performed without indexes: 2162 [!!] Temporary tables created on disk: 28% (68K on disk / 239K total) [OK] Thread cache hit rate: 99% (23 created / 67K connections) [!!] Table cache hit rate: 0% (3K open / 3M opened) [OK] Open file limit used: 18% (5K/31K) [OK] Table locks acquired immediately: 99% (546K immediate / 546K locks) [OK] InnoDB data size / buffer pool: 5.5M/8.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Adjust your join queries to always utilize indexes When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries without LIMIT clauses Increase table_cache gradually to avoid file descriptor limits Variables to adjust: query_cache_size (> 50M) join_buffer_size (> 4.0M, or always use indexes with joins) tmp_table_size (> 100M) max_heap_table_size (> 100M) table_cache (> 3000)
    0
  • thinkbot
    all your values are smaller, only max possible value for key cache increased, so the extra memory is cache/buffers, used only when needed; they can be freed by kernel, when other apps needs RAM you need to work on optimizing your code, couse you got a lot of temporary tables, and even ones that store temp table on disk mkdir -p /root/install cd /root/install wget
    0
  • nourjabi
    I Agree, but the problem is that my clients have websites back to 6 years old ++ so i cannot manage them all (as i have over 500 website). I will try to optimise the most troublesome ones first thought. heres my slow query log: # 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','zljob07@sohu.com','**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','','wadih@aptech-syria.com','-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:\"surveyors@gbs-syr.org\";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:\"surveyors@gbs-syr.org\";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
    Jabal Ali FZ
    Dubai, UAE\";s:12:\"header_phone\";s:62:\"Phone :0097155259650
    Fax: 0097155259650
    info@emovefz.com\";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:info@emovefzco.com\";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
    Jabal Ali FZ
    Dubai, UAE\";s:12:\"header_phone\";s:62:\"Phone :0097155259650
    Fax: 0097155259650
    info@emovefz.com\";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:info@emovefzco.com\";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

    and this is a fresh sqltuner report: -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.1.70-cll [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 6G (Tables: 4839) [--] Data in InnoDB tables: 5M (Tables: 171) [--] Data in MEMORY tables: 620K (Tables: 24) [!!] Total fragmented tables: 250 -------- Performance Metrics ------------------------------------------------- [--] Up for: 2d 11h 48m 42s (7M q [34.062 qps], 147K conn, TX: 41B, RX: 807M) [--] Reads / Writes: 51% / 49% [--] Total buffers: 3.1G global + 6.6M per thread (151 max threads) [OK] Maximum possible memory usage: 4.1G (12% of installed RAM) [OK] Slow queries: 0% (19K/7M) [OK] Highest usage of available connections: 15% (23/151) [OK] Key buffer size / total MyISAM indexes: 2.9G/968.2M [OK] Key buffer hit rate: 97.6% (304M cached / 7M reads) [OK] Query cache efficiency: 82.6% (3M cached / 3M selects) [!!] Query cache prunes per day: 61155 [OK] Sorts requiring temporary tables: 0% (1 temp sorts / 249K sorts) [!!] Joins performed without indexes: 4735 [!!] Temporary tables created on disk: 28% (137K on disk / 489K total) [OK] Thread cache hit rate: 99% (23 created / 147K connections) [!!] Table cache hit rate: 0% (3K open / 7M opened) [OK] Open file limit used: 18% (5K/31K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) [OK] InnoDB data size / buffer pool: 5.6M/8.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Adjust your join queries to always utilize indexes When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries without LIMIT clauses Increase table_cache gradually to avoid file descriptor limits Variables to adjust: query_cache_size (> 50M) join_buffer_size (> 4.0M, or always use indexes with joins) tmp_table_size (> 100M) max_heap_table_size (> 100M) table_cache (> 3000)
    0
  • thinkbot
    add to my.cnf innodb_stats_on_metadata=0 syriainv_syriainvestmentmap 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 SELECT count(*) as c FROM visits_stats WHERE service=3 AND ip='5.135.165.126' AND time>=1380199807\G check if there are indexes on table visits_stats if not, add one on IP column then remove current mysql-slow.log from /var/lib/mysql and restart mysql to run all again after some time run pt-query-digest and mysqltuner/mysqlreport again
    0
  • talk2prakash
    [quote="thinkbot, post: 1468742">add myisam_use_mmap=1 key_buffer_size = 3000M join_buffer_size=4M query_cache_type = 1 query_cache_size = 50M query_cache_limit = 1M table_cache = 3000 thread_cache_size = 50 max_heap_table_size = 100M tmp_table_size = 100M slow_query_log=1 slow_query_log_file=mysql-slow.log long_query_time=0.1 and restart
    I'm Afraid, just copy and paste with other my.cnf may make issues, as my.cnf should be tuned based on your database query hits and your available server memory. my.cnf copied from other server might have different hw specifications and hits received which might be the wrong entry in the server which should be tweaked.
    0
  • nourjabi
    Hi, What you say is true, but as I have mentioned earlier, I'm tweaking default My.CNF on a new server, which have only 2-3 commands. I believe thinkbot have acquired the mentioned tweaks from my SQLTuner results + my server specs to be honest. :)
    0

Please sign in to leave a comment.