Jump to content

change the default storage from Innodb to MyISAM


Recommended Posts

HI, I hope you are doing well, Just I would like to ask, that I want to change the :  /etc/my.cnf  as below but I'm not sure it will be correct or need amendment ?? kindly reviwe the my.cnf file and  advice me. because I need to optimze the DB and would like to use mySIM as a default storage.

 

#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]
[mysqld]
default_storage_engine = MyISAM
max_connections = 30000
max_user_connections=10000
innodb_lock_wait_timeout=120
max_heap_table_size = 1G
tmp_table_size = 1024M
thread_cache_size = 128
innodb_buffer_pool_size = 2G
innodb_log_file_size = 2G
innodb_buffer_pool_instances = 10
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
table_open_cache = 5000
wait_timeout = 28800
interactive_timeout = 28800
long_query_time = 25
max_allowed_packet = 512M
performance_schema = OFF
open_files_limit = 220000
key_buffer_size = 64M
join_buffer_size = 5M
sort_buffer_size = 5M
read_buffer_size = 2048k
read_rnd_buffer_size = 2048k
query_cache_type = 1
query_cache_size = 250M
query_cache_limit = 64M
max_connect_errors = 10
tmp_table_size = 550M
max_heap_table_size = 500M
innodb_file_per_table=1
#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d

regards.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...