Announcement

Collapse
No announcement yet.

upgrade "innodb_log_file_size" at maximum

Collapse

Ads on showthread pages

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • upgrade "innodb_log_file_size" at maximum

    WordPress Hosting on SSD Servers
    If for any reason you need to change the size of Innodb log file size, follow the steps below mentioned

    Solution:


    It is advisable not to change the size of log file for innodb, because it crashes MySQL database.
    1.Take a backup of my.cnf in same directory as backupmy.cnf
    2.Rename log file log0, log1
    3.Restart MySQL service by - service mysql start
    4.Check status of MySQL service - service mysql status


    Park B
    Accuwebhosting.com
    Last edited by admin; 07-31-2015, 10:28 AM.
Working...
X
Sign up for a News Letter Click here to sign up