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.

you need to remove this line and paste as it is

default_storage_engine = MyISAM

On 7/9/2024 at 7:44 PM, Sandeep B. said:

you need to remove this line and paste as it is

default_storage_engine = MyISAM

HI, Dear Mr Sandeep I hope you and your honor family are safe and rounded by Gold bless.

I have two question about my.cnf

 

what if I add this line into my.cnf: 

init-connect='SET NAMES utf8'

Because I would to support fully UTF8???

 

second ad you advice I have to remove this line:

default_storage_engine = MyISAM

or just remove MyISAM from the end of the line??? or I have to remove completely the line???

 

thank you very much for you answer in advance

 

regards.