upgrade "innodb_log_file_size" at maximum

Collapse

Unconfigured Ad Widget

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • admin
    Administrator
    • Mar 2007
    • 36

    upgrade "innodb_log_file_size" at maximum

    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