Results 1 to 2 of 2
  1. #1

    Improving MySQL Server Load

    I have just ran and it has shown me the following recommendations:

    PHP Code:
    -------- General Statistics --------------------------------------------------
    Skipped version check for MySQLTuner script
    [OKCurrently running supported MySQL version 5.0.92-community-log
    [!!] Switch to 64-bit OS MySQL cannot currently use all of your RAM

    -------- Storage Engine Statistics -------------------------------------------
    Status: +Archive -BDB +Federated +InnoDB -ISAM -NDBCluster 
    [--] Data in MyISAM tables2G (Tables27276)
    Data in InnoDB tables859M (Tables11313)
    Data in MEMORY tables1M (Tables536)
    Total fragmented tables1898

    -------- Security Recommendations  -------------------------------------------
    OKAll database users have passwords assigned

    -------- Performance Metrics -------------------------------------------------
    Up for: 1d 0h 41m 51s (5M q [56.897 qps], 162K connTX39MRX1B)
    Reads Writes77% / 23%
    Total buffers240.0M global + 2.7M per thread (500 max threads)
    OKMaximum possible memory usage1.5G (19of installed RAM)
    OKSlow queries0% (12/5M)
    OKHighest usage of available connections3% (16/500)
    OKKey buffer size total MyISAM indexes128.0M/739.6M
    [OKKey buffer hit rate98.7% (125M cached 1M reads)
    OKQuery cache efficiency64.5% (2M cached 4M selects)
    Query cache prunes per day638869
    [OKSorts requiring temporary tables0% (17 temp sorts 237K sorts)
    Joins performed without indexes3977
    [!!] Temporary tables created on disk39% (107K on disk 270K total)
    OKThread cache hit rate97% (4K created 162K connections)
    Table cache hit rate0% (128 open 687K opened)
    OKOpen file limit used4% (101/2K)
    OKTable locks acquired immediately99% (2M immediate 2M locks)
    InnoDB data size buffer pool859.9M/30.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 (> 40M)
    join_buffer_size (> 128.0K, or always use indexes with joins)
    tmp_table_size (> 40M)
    max_heap_table_size (> 40M)
    table_cache (> 128)
    innodb_buffer_pool_size (>= 859M
    Can someone let me know how I complete the first recommendation "RUN OPTIMIZE TABLE"?

  2. #2
    Join Date
    Feb 2004

    A quick google of "mysql optimize all tables",...896#msg-218896

    What kind of load are you seeing ?


Similar Threads

  1. mysql server over load
    By zedadiboy in forum Hosting Security and Technology
    Replies: 16
    Last Post: 01-03-2011, 06:20 PM
  2. Replies: 8
    Last Post: 10-02-2007, 06:02 PM
  3. Improving load time
    By joshusa in forum Hosting Security and Technology
    Replies: 1
    Last Post: 12-17-2006, 02:38 PM
  4. Improving MySQL Performace
    By openXS in forum Hosting Security and Technology
    Replies: 14
    Last Post: 11-23-2004, 08:37 AM
  5. Improving performance for Mysql
    By ENH Jonathan in forum Hosting Security and Technology
    Replies: 10
    Last Post: 01-06-2004, 03:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts