Mysql Configuration File
Hello,
I am using this configuration in my.cnf file.. I would like you to please correct this if there is any correction..
local-infile=0
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=50000
innodb_buffer_pool_size=134217728
I have heard many servers got issues after some months and innodb corrupted.
-
Hello :), I will suggest you try to optimize your mysql server with the MySQLTuner-perl by major scripts. Might be your mysql is not shutting down properly and due to that you are facing this issues with innodb. 0 -
Hello, You may also find this thread helpful: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you. 0
Please sign in to leave a comment.
Comments
2 comments