How to best optimize for MyIsam
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.
[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-
Hello :) You can run a tuner script by following the instructions in the following thread: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you. 0
Please sign in to leave a comment.
Comments
1 comment