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.

MySQL optimization for hosting 32gb RAM

Discussion in 'Workarounds and Optimization' started by alexistkd, Dec 13, 2013.

  1. alexistkd

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,
    I have a E3-1240 v3 dedicated server, with 32GB RAM, running CENTOS 6.5 x86_64 standard and WHM 11.40.1 (build 1)

    Total processors: 8

    Processor #1

    Vendor
    GenuineIntel

    Name
    Intel(R) Xeon(R) CPU E3-1240 v3 @ 3.40GHz

    Speed
    3392.256 MHz

    Cache
    8192 KB

    I would like to optimize it the best to use correctly my 32gb here is my my.cnf:
    Code:
    # Example MySQL config file for very large systems.
    #
    # This is for a large system with memory of 1G-2G where the system runs mainly
    # MySQL.
    #
    # MySQL programs look for option files in a set of
    # locations which depend on the deployment platform.
    # You can copy this option file to one of those
    # locations. For information about these locations, see:
    # [url=http://dev.mysql.com/doc/mysql/en/option-files.html]MySQL :: MySQL 5.6 Reference Manual :: 4.2.3.3 Using Option Files[/url]
    #
    # In this file, you can use all long options that a program supports.
    # If you want to know which options a program supports, run the program
    # with the "--help" option.
    
    # The following options will be passed to all MySQL clients
    [client]
    #password	= your_password
    port            = 3306
    socket          = /var/lib/mysql/mysql.sock
    
    # Here follows entries for some specific programs
    
    # The MySQL server
    [mysqld]
    port            = 3306
    socket          = /var/lib/mysql/mysql.sock
    skip-external-locking
    key_buffer_size = 384M
    max_allowed_packet = 32M
    table_open_cache = 5096
    sort_buffer_size = 2M
    read_buffer_size = 2M
    read_rnd_buffer_size = 8M
    myisam_sort_buffer_size = 64M
    thread_cache_size = 8
    query_cache_size = 64M
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency = 8
    log-slow-queries
    local-infile=0
    innodb_file_per_table=1
    
    # Don't listen on a TCP/IP port at all. This can be a security enhancement,
    # if all processes that need to connect to mysqld run on the same host.
    # All interaction with mysqld must be made via Unix sockets or named pipes.
    # Note that using this option without enabling named pipes on Windows
    # (via the "enable-named-pipe" option) will render mysqld useless!
    #
    #skip-networking
    
    # Replication Master Server (default)
    # binary logging is required for replication
    #log-bin=mysql-bin
    
    # required unique id between 1 and 2^32 - 1
    # defaults to 1 if master-host is not set
    # but will not function as a master if omitted
    server-id	= 1
    max_connections = 400
    open_files_limit=11354
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates
    
    [myisamchk]
    key_buffer_size = 256M
    sort_buffer_size = 256M
    read_buffer = 2M
    write_buffer = 2M
    
    [mysqlhotcopy]
    interactive-timeout
    and the mysqltuner report:

    Code:
    >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.5.34-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 903M (Tables: 1231)
    [--] Data in InnoDB tables: 114M (Tables: 854)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 0B (Tables: 26)
    [!!] Total fragmented tables: 83
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 1h 42m 0s (566K q [92.557 qps], 17K conn, TX: 1B, RX: 68M)
    [--] Reads / Writes: 71% / 29%
    [--] Total buffers: 608.0M global + 12.4M per thread (400 max threads)
    [OK] Maximum possible memory usage: 5.4G (17% of installed RAM)
    [OK] Slow queries: 0% (4/566K)
    [OK] Highest usage of available connections: 26% (105/400)
    [OK] Key buffer size / total MyISAM indexes: 384.0M/72.1M
    [OK] Key buffer hit rate: 99.5% (3M cached / 16K reads)
    [OK] Query cache efficiency: 71.9% (302K cached / 420K selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)
    [!!] Joins performed without indexes: 214
    [!!] Temporary tables created on disk: 47% (19K on disk / 41K total)
    [OK] Thread cache hit rate: 96% (674 created / 17K connections)
    [OK] Table cache hit rate: 97% (2K open / 2K opened)
    [OK] Open file limit used: 23% (2K/11K)
    [OK] Table locks acquired immediately: 99% (172K immediate / 173K locks)
    [OK] InnoDB data size / buffer pool: 114.4M/128.0M
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        MySQL started within last 24 hours - recommendations may be inaccurate
        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
    Variables to adjust:
        join_buffer_size (> 128.0K, or always use indexes with joins)
        tmp_table_size (> 16M)
        max_heap_table_size (> 16M)
    thank you very much.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. alexistkd

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    thank u very much, now my server have more than 24 hours and i got these results from mysqltuner:

    Code:
    root@panama [~]# ./mysqltuner.pl
    
     >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.5.34-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 892M (Tables: 1231)
    [--] Data in InnoDB tables: 114M (Tables: 853)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 0B (Tables: 26)
    [!!] Total fragmented tables: 48
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 1d 0h 52m 33s (4M q [52.971 qps], 150K conn, TX: 13B, RX: 554M)
    [--] Reads / Writes: 76% / 24%
    [--] Total buffers: 608.0M global + 12.4M per thread (400 max threads)
    [OK] Maximum possible memory usage: 5.4G (17% of installed RAM)
    [OK] Slow queries: 0% (8/4M)
    [OK] Highest usage of available connections: 26% (105/400)
    [OK] Key buffer size / total MyISAM indexes: 384.0M/68.1M
    [OK] Key buffer hit rate: 99.6% (32M cached / 129K reads)
    [OK] Query cache efficiency: 68.6% (2M cached / 3M selects)
    [!!] Query cache prunes per day: 5436
    [OK] Sorts requiring temporary tables: 0% (2 temp sorts / 49K sorts)
    [!!] Joins performed without indexes: 2540
    [!!] Temporary tables created on disk: 41% (77K on disk / 187K total)
    [OK] Thread cache hit rate: 96% (5K created / 150K connections)
    [OK] Table cache hit rate: 46% (4K open / 9K opened)
    [OK] Open file limit used: 33% (3K/11K)
    [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)
    [OK] InnoDB data size / buffer pool: 114.8M/128.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
    Variables to adjust:
        query_cache_size (> 64M)
        join_buffer_size (> 128.0K, or always use indexes with joins)
        tmp_table_size (> 16M)
        max_heap_table_size (> 16M)
    at the beginning is my my.cnf also, i would like to optimize my server to use better the 32gb and have websites load more faster.

    thank you.
     
  4. alexistkd

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    thank u very much, now my server have more than 24 hours and i got these results from mysqltuner:

    Code:
    root@panama [~]# ./mysqltuner.pl
    
     >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.5.34-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 892M (Tables: 1231)
    [--] Data in InnoDB tables: 114M (Tables: 853)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 0B (Tables: 26)
    [!!] Total fragmented tables: 48
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 1d 0h 52m 33s (4M q [52.971 qps], 150K conn, TX: 13B, RX: 554M)
    [--] Reads / Writes: 76% / 24%
    [--] Total buffers: 608.0M global + 12.4M per thread (400 max threads)
    [OK] Maximum possible memory usage: 5.4G (17% of installed RAM)
    [OK] Slow queries: 0% (8/4M)
    [OK] Highest usage of available connections: 26% (105/400)
    [OK] Key buffer size / total MyISAM indexes: 384.0M/68.1M
    [OK] Key buffer hit rate: 99.6% (32M cached / 129K reads)
    [OK] Query cache efficiency: 68.6% (2M cached / 3M selects)
    [!!] Query cache prunes per day: 5436
    [OK] Sorts requiring temporary tables: 0% (2 temp sorts / 49K sorts)
    [!!] Joins performed without indexes: 2540
    [!!] Temporary tables created on disk: 41% (77K on disk / 187K total)
    [OK] Thread cache hit rate: 96% (5K created / 150K connections)
    [OK] Table cache hit rate: 46% (4K open / 9K opened)
    [OK] Open file limit used: 33% (3K/11K)
    [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)
    [OK] InnoDB data size / buffer pool: 114.8M/128.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
    Variables to adjust:
        query_cache_size (> 64M)
        join_buffer_size (> 128.0K, or always use indexes with joins)
        tmp_table_size (> 16M)
        max_heap_table_size (> 16M)
    at the beginning is my my.cnf also, i would like to optimize my server to use better the 32gb and have websites load more faster.

    thank you.
     
  5. alexistkd

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    i just run the tool again

    - - - Updated - - -

    got this:

    Code:
    root@panama [~]# ./mysqltuner.pl
    
     >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.5.34-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 894M (Tables: 1231)
    [--] Data in InnoDB tables: 114M (Tables: 853)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 0B (Tables: 26)
    [!!] Total fragmented tables: 52
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 2d 1h 54m 34s (9M q [52.125 qps], 283K conn, TX: 28B, RX: 1B)
    [--] Reads / Writes: 78% / 22%
    [--] Total buffers: 608.0M global + 12.4M per thread (400 max threads)
    [OK] Maximum possible memory usage: 5.4G (17% of installed RAM)
    [OK] Slow queries: 0% (25/9M)
    [OK] Highest usage of available connections: 83% (334/400)
    [OK] Key buffer size / total MyISAM indexes: 384.0M/70.9M
    [OK] Key buffer hit rate: 99.8% (66M cached / 137K reads)
    [OK] Query cache efficiency: 68.3% (4M cached / 7M selects)
    [!!] Query cache prunes per day: 9085
    [OK] Sorts requiring temporary tables: 0% (4 temp sorts / 98K sorts)
    [!!] Joins performed without indexes: 5067
    [!!] Temporary tables created on disk: 39% (129K on disk / 328K total)
    [OK] Thread cache hit rate: 95% (12K created / 283K connections)
    [OK] Table cache hit rate: 41% (4K open / 10K opened)
    [OK] Open file limit used: 33% (3K/11K)
    [OK] Table locks acquired immediately: 99% (3M immediate / 3M locks)
    [OK] InnoDB data size / buffer pool: 114.8M/128.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
    Variables to adjust:
        query_cache_size (> 64M)
        join_buffer_size (> 128.0K, or always use indexes with joins)
        tmp_table_size (> 16M)
        max_heap_table_size (> 16M)
     
  6. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    please adjust those
    sort_buffer_size = 256K
    read_buffer_size = 128K
    read_rnd_buffer_size = 256K

    table_open_cache = 2000

    thread_concurrency = 8 - remove that

    add
    innodb_buffer_pool_size = 300M

    join_buffer_size = 512K
    tmp_table_size = 50M
    max_heap_table_size = 50M

    anyway that won't make big difference, since
    [!!] Temporary tables created on disk: 39% (129K on disk / 328K total)

    the problem here is bad queries that uses temporary tables on disk, which doesn't scale
    if you are using popular CMS, then third party plugins would most likely have such bad queries
    or any not optimized custom code

    you can track slow queries like that in my.cnf:

    slow_query_log_file=mysql-slow.log
    long_query_time=0.1

    then you can review it and see which queries takes most CPU time

    to review it run pt-query-digest like that

    cd /root
    wget http://percona.com/get/pt-query-digest
    chmod +x pt-query-digest

    ./pt-query-digest /var/lib/mysql/mysql-slow.log > slow.txt
    and review slow.txt
     
  7. alexistkd

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    u recommend me to track slow queries?

    - - - Updated - - -

    i got this:

    Code:
     >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.5.34-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 1G (Tables: 1231)
    [--] Data in InnoDB tables: 114M (Tables: 857)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 0B (Tables: 26)
    [!!] Total fragmented tables: 69
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 8d 5h 0m 27s (49M q [69.437 qps], 1M conn, TX: 145B, RX: 5B)
    [--] Reads / Writes: 76% / 24%
    [--] Total buffers: 1.4G global + 4.9M per thread (2000 max threads)
    [OK] Maximum possible memory usage: 11.0G (35% of installed RAM)
    [OK] Slow queries: 0% (17/49M)
    [OK] Highest usage of available connections: 25% (507/2000)
    [OK] Key buffer size / total MyISAM indexes: 384.0M/153.8M
    [OK] Key buffer hit rate: 100.0% (315M cached / 82K reads)
    [OK] Query cache efficiency: 71.7% (27M cached / 38M selects)
    [!!] Query cache prunes per day: 1514
    [OK] Sorts requiring temporary tables: 0% (2K temp sorts / 443K sorts)
    [!!] Joins performed without indexes: 24107
    [!!] Temporary tables created on disk: 40% (626K on disk / 1M total)
    [OK] Thread cache hit rate: 99% (7K created / 1M connections)
    [!!] Table cache hit rate: 9% (3K open / 31K opened)
    [OK] Open file limit used: 25% (2K/11K)
    [OK] Table locks acquired immediately: 99% (15M immediate / 15M locks)
    [OK] InnoDB data size / buffer pool: 115.0M/300.0M
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        Increasing the query_cache size over 128M may reduce performance
        Adjust your join queries to always utilize indexes
        Temporary table size is already large - reduce result set size
        Reduce your SELECT DISTINCT queries without LIMIT clauses
        Increase table_cache gradually to avoid file descriptor limits
    Variables to adjust:
        query_cache_size (> 256M) [see warning above]
        join_buffer_size (> 4.0M, or always use indexes with joins)
        table_cache (> 3000)
     
  8. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    did you add this long_query_time=0.1 ?
     
  9. alexistkd

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    should i leave it running 24 hours right and then run the tool? because now im getting

    # No events processed.

    i just restarted the mysql server few minutes ago
     
  10. alexistkd

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    ok now is working i got this in slow.txt:

    Code:
    # 100ms user time, 10ms system time, 24.68M rss, 201.43M vsz
    # Current date: Thu Jan  2 22:49:19 2014
    # Hostname: panama.dbspma.com
    # Files: /var/lib/mysql/mysql-slow.log
    # Overall: 4 total, 4 unique, 0.02 QPS, 0.01x concurrency ________________
    # Time range: 2014-01-02 22:43:36 to 22:46:39
    # Attribute          total     min     max     avg     95%  stddev  median
    # ============     ======= ======= ======= ======= ======= ======= =======
    # Exec time          992ms   153ms   487ms   248ms   477ms   136ms   329ms
    # Lock time          139us    17us    62us    34us    60us    16us    48us
    # Rows sent              1	 0	 1    0.25    0.99    0.43	 0
    # Rows examine     138.29k	 0 138.29k  34.57k 136.54k  59.12k    0.99
    # Query size           348	56     125	87  124.25   26.45  108.49
    
    # Profile
    # Rank Query ID           Response time Calls R/Call V/M   Item
    # ==== ================== ============= ===== ====== ===== ===============
    #    1 0xFBC33BE3D16F31B6  0.4868 49.1%     1 0.4868  0.00 SELECT u?lgq_k?_comments
    #    2 0x65792F8C7D00F1DA  0.1830 18.4%     1 0.1830  0.00 INSERT mvkhb_session
    #    3 0x11F8C8E8FCD8E300  0.1693 17.1%     1 0.1693  0.00 UPDATE session
    #    4 0x566718AE69A06133  0.1526 15.4%     1 0.1526  0.00 DELETE mvkhb_session
    
    # Query 1: 0 QPS, 0x concurrency, ID 0xFBC33BE3D16F31B6 at byte 0 ________
    # This item is included in the report because it matches --limit.
    # Scores: V/M = 0.00
    # Time range: all events occurred at 2014-01-02 22:43:36
    # Attribute    pct   total     min     max     avg     95%  stddev  median
    # ============ === ======= ======= ======= ======= ======= ======= =======
    # Count         25	 1
    # Exec time     49   487ms   487ms   487ms   487ms   487ms	 0   487ms
    # Lock time     44    62us    62us    62us    62us    62us	 0    62us
    # Rows sent    100	 1	 1	 1	 1	 1	 0	 1
    # Rows examine  99 138.29k 138.29k 138.29k 138.29k 138.29k	 0 138.29k
    # Query size    20	70	70	70	70	70	 0	70
    # String:
    # Databases    dbspma_innova
    # Hosts        localhost
    # Users        dbspma_innova
    # Query_time distribution
    #   1us
    #  10us
    # 100us
    #   1ms
    #  10ms
    # 100ms  ################################################################
    #    1s
    #  10s+
    # Tables
    #    SHOW TABLE STATUS FROM `dbspma_innova` LIKE 'u9lgq_k2_comments'\G
    #    SHOW CREATE TABLE `dbspma_innova`.`u9lgq_k2_comments`\G
    # EXPLAIN /*!50100 PARTITIONS*/
    SELECT COUNT(*) FROM u9lgq_k2_comments WHERE itemID=28 AND published=1\G
    
    # Query 2: 0 QPS, 0x concurrency, ID 0x65792F8C7D00F1DA at byte 1637 _____
    # This item is included in the report because it matches --limit.
    # Scores: V/M = 0.00
    # Time range: all events occurred at 2014-01-02 22:45:36
    # Attribute    pct   total     min     max     avg     95%  stddev  median
    # ============ === ======= ======= ======= ======= ======= ======= =======
    # Count         25	 1
    # Exec time     18   183ms   183ms   183ms   183ms   183ms	 0   183ms
    # Lock time     16    23us    23us    23us    23us    23us	 0    23us
    # Rows sent	 0	 0	 0	 0	 0	 0	 0	 0
    # Rows examine   0	 0	 0	 0	 0	 0	 0	 0
    # Query size    35     125     125     125     125     125	 0     125
    # String:
    # Databases    panasyst_nueva
    # Hosts        localhost
    # Users        panasyst_2013
    # Query_time distribution
    #   1us
    #  10us
    # 100us
    #   1ms
    #  10ms
    # 100ms  ################################################################
    #    1s
    #  10s+
    # Tables
    #    SHOW TABLE STATUS FROM `panasyst_nueva` LIKE 'mvkhb_session'\G
    #    SHOW CREATE TABLE `panasyst_nueva`.`mvkhb_session`\G
    INSERT INTO `mvkhb_session`
    (`session_id`, `client_id`, `time`) VALUES
    ('586328a696b7f16a79f87fc15d1caec7', 1, '1388720736')\G
    
    # Query 3: 0 QPS, 0x concurrency, ID 0x11F8C8E8FCD8E300 at byte 1946 _____
    # This item is included in the report because it matches --limit.
    # Scores: V/M = 0.00
    # Time range: all events occurred at 2014-01-02 22:46:39
    # Attribute    pct   total     min     max     avg     95%  stddev  median
    # ============ === ======= ======= ======= ======= ======= ======= =======
    # Count         25	 1
    # Exec time     17   169ms   169ms   169ms   169ms   169ms	 0   169ms
    # Lock time     26    37us    37us    37us    37us    37us	 0    37us
    # Rows sent	 0	 0	 0	 0	 0	 0	 0	 0
    # Rows examine   0	 1	 1	 1	 1	 1	 0	 1
    # Query size    27	97	97	97	97	97	 0	97
    # String:
    # Databases    roundcube
    # Hosts        localhost
    # Users        roundcube
    # Query_time distribution
    #   1us
    #  10us
    # 100us
    #   1ms
    #  10ms
    # 100ms  ################################################################
    #    1s
    #  10s+
    # Tables
    #    SHOW TABLE STATUS FROM `roundcube` LIKE 'session'\G
    #    SHOW CREATE TABLE `roundcube`.`session`\G
    UPDATE session SET changed='2014-01-02 22:46:38' WHERE sess_id='e4ea4cffe4c4a98a977be4626997b6b6'\G
    # Converted for EXPLAIN
    # EXPLAIN /*!50100 PARTITIONS*/
    select  changed='2014-01-02 22:46:38' from session where  sess_id='e4ea4cffe4c4a98a977be4626997b6b6'\G
    
    # Query 4: 0 QPS, 0x concurrency, ID 0x566718AE69A06133 at byte 1377 _____
    # This item is included in the report because it matches --limit.
    # Scores: V/M = 0.00
    # Time range: all events occurred at 2014-01-02 22:43:37
    # Attribute    pct   total     min     max     avg     95%  stddev  median
    # ============ === ======= ======= ======= ======= ======= ======= =======
    # Count         25	 1
    # Exec time     15   153ms   153ms   153ms   153ms   153ms	 0   153ms
    # Lock time     12    17us    17us    17us    17us    17us	 0    17us
    # Rows sent      0       0       0       0       0       0       0       0
    # Rows examine   0	 1	 1	 1	 1	 1	 0	 1
    # Query size    16	56	56	56	56	56	 0	56
    # String:
    # Databases    panasyst_nueva
    # Hosts        localhost
    # Users        panasyst_2013
    # Query_time distribution
    #   1us
    #  10us
    # 100us
    #   1ms
    #  10ms
    # 100ms  ################################################################
    #    1s
    #  10s+
    # Tables
    #    SHOW TABLE STATUS FROM `panasyst_nueva` LIKE 'mvkhb_session'\G
    #    SHOW CREATE TABLE `panasyst_nueva`.`mvkhb_session`\G
    DELETE
    FROM `mvkhb_session`
    WHERE `time` < '1388719717'\G
    # Converted for EXPLAIN
    # EXPLAIN /*!50100 PARTITIONS*/
    select * from  `mvkhb_session`
    WHERE `time` < '1388719717'\G
     
  11. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    You need to run it after at least several hours, the best would be 24h, then generate result
     
  12. alexistkd

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    i got a big file:

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

    alexistkd Active Member

    Joined:
    Dec 13, 2013
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    should i add this

    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)

    ? i dont see that in my config right now is missing what do u recommend me to do
     
  14. euro-space

    euro-space Member

    Joined:
    Mar 24, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    This is my settings on the one of 32GB RAM, 2xSAS 15k HDD and 8 CPU cores server, hosting over 200 domains:

    [mysqld]
    innodb_file_per_table=1
    open_files_limit=40000
    max_allowed_packet = 32M
    max_connections = 1024
    local-infile=0

    large-pages
    innodb_use_sys_malloc = 0
    innodb_buffer_pool_size=2G
    large_pages = true

    query_cache_size=32M
    join_buffer_size=1024K
    tmp_table_size=48M
    max_heap_table_size=48M
    key_buffer=64M
    thread_cache_size=32
    table_cache=2000
    table_definition_cache = 1024

    this made significant improvement in performance and balanced overall load. However, I can't guarantee you'll experience same, as settings usually depend on many factors on the server.
     
Loading...

Share This Page