Mysql Configuration File

efuzone

• July 13, 2016 01:18

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.

• 

  24x7server

  • July 13, 2016 12:00

  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
• 

  cPanelMichael

  • July 13, 2016 16:04

  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.