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.

How to best optimize for MyIsam

Discussion in 'Workarounds and Optimization' started by Gauravk, Jul 3, 2014.

  1. Gauravk

    Gauravk Well-Known Member

    Joined:
    Jan 23, 2012
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    My vps with 2 GB ram was doing good with Innodb in the past. Now I migrated to new software that run MyIsam and I like to optimize the database for same.

    This server doesn't have any other (major) stuff than this MyIsam that need allocated resources. Approx current size of database is about 100 mb and page load is coming to 8-10 seconds. Need your expertise to bring it down to 2-4 secs...?

    My first try with my.cnf that didnt do good so far.

    Code:
    [mysqld]
    
    
    #default_storage_engine=InnoDB
    default-storage-engine=MyISAM
    
    max_connections=50
    
    key_buffer_size = 256M
    max_allowed_packet=268435456
    
    query_cache_size=128M
    query_cache_limit=2M
    tmp_table_size=64M
    thread_cache_size = 128
    
    
    myisam_sort_buffer_size=128M
    
    
    table_cache = 2048
    table_definition_cache =4096
    
    slow_query_log
    slow_query_log_file=mysql-slow.log
    long_query_time=1
    #log-queries-not-using-indexes
    
    #### Per connection configuration ####
    sort_buffer_size = 1M
    read_buffer_size = 1M
    read_rnd_buffer_size = 2M
    
    ##### INNODB Specific Options ######
    innodb_buffer_pool_size=32M
    innodb_log_file_size = 50M
    innodb_flush_log_at_trx_commit=0
    innodb_log_buffer_size=8M
    innodb_flush_method=O_DSYNC
    #innodb_old_blocks_time=1000
    innodb_open_files=2000
    
    innodb_file_per_table=1
    open_files_limit=20062
     
    #1 Gauravk, Jul 3, 2014
    Last edited: Jul 3, 2014
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page