The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Configuring my.cnf for new server

Discussion in 'Workarounds and Optimization' started by nourjabi, Sep 23, 2013.

  1. nourjabi

    nourjabi Active Member

    Joined:
    Jun 24, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    Hi cPanel Community,

    I have recently moved all my clients domains from shared reseller hosting to my own Dedicated Server.

    The Server's Specs as Follow:

    I have not yet set any custom My.Cnf config, means it's still WHM's Default values.

    I currently have over 500 Client website, but mostly MySQL Usage is : CPU %5 MEM %4 .

    I would like to have suggestions to start tuning SQL my.cnf so I can always keep my SQL in top shape for this sever.



    Here's my SQL Tuner report:


    Code:
    -------- 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: 0B (Tables: 24)
    [!!] Total fragmented tables: 250
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 5m 47s (11K q [33.841 qps], 191 conn, TX: 16M, RX: 955K)
    [--] 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% (0/11K)
    [OK] Highest usage of available connections: 3% (6/151)
    [!!] Key buffer size / total MyISAM indexes: 8.0M/1.5G
    [!!] Key buffer hit rate: 88.4% (140K cached / 16K reads)
    [!!] Query cache is disabled
    [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1K sorts)
    [!!] Joins performed without indexes: 28
    [OK] Temporary tables created on disk: 20% (72 on disk / 358 total)
    [!!] Thread cache is disabled
    [!!] Table cache hit rate: 0% (64 open / 37K opened)
    [OK] Open file limit used: 0% (128/31K)
    [OK] Table locks acquired immediately: 100% (7K immediate / 7K locks)
    [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
        Set thread_cache_size to 4 as a starting value
        Increase table_cache gradually to avoid file descriptor limits
    Variables to adjust:
        key_buffer_size (> 1.5G)
        query_cache_size (>= 8M)
        join_buffer_size (> 128.0K, or always use indexes with joins)
        thread_cache_size (start at 4)
        table_cache (> 64)
    
     
  2. Aaron.Edwards

    Aaron.Edwards Active Member

    Joined:
    Sep 21, 2013
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    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 ?
     
  3. nourjabi

    nourjabi Active Member

    Joined:
    Jun 24, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    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:


    Code:
    -------- 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)
    
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  5. nourjabi

    nourjabi Active Member

    Joined:
    Jun 24, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    thank you, i will wait until its up for 24 hr :)
     
  6. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    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
     
  7. nourjabi

    nourjabi Active Member

    Joined:
    Jun 24, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    I have added your configurations, and restarted MySQL.

    will wait 24 hour and post results with mysqltuner . :)
     
  8. nourjabi

    nourjabi Active Member

    Joined:
    Jun 24, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    Here's my results after 24 Hour, I noticed a bit of RAM consumption. MySQL Used to only take 1% not over 7%.


    Code:
    -------- 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][COLOR="#FF0000"]-BDB -Federated[/COLOR] [COLOR="#00FF00"]+InnoDB[/COLOR] [COLOR="#FF0000"]-ISAM -NDBCluster[/COLOR]
    [--] 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)
    
     
  9. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    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 http://percona.com/get/pt-query-digest
    chmod +x pt-query-digest

    ./pt-query-digest /var/lib/mysql/mysql-slow.log > slow.txt

    run that to review your slow queries
     
  10. nourjabi

    nourjabi Active Member

    Joined:
    Jun 24, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    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:

    Code:
    # 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 <br />Jabal Ali FZ<br />Dubai, UAE\";s:12:\"header_phone\";s:62:\"Phone :0097155259650<br>Fax: 0097155259650<br>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 <br />Jabal Ali FZ<br />Dubai, UAE\";s:12:\"header_phone\";s:62:\"Phone :0097155259650<br>Fax: 0097155259650<br>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:

    Code:
    -------- 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)
     
  11. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    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
     
  12. talk2prakash

    talk2prakash Member

    Joined:
    Sep 29, 2013
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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.
     
  13. nourjabi

    nourjabi Active Member

    Joined:
    Jun 24, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    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. :)
     
Loading...

Share This Page