innodb log file size

mahdy_sharifi

• April 16, 2015 15:26

Hello : I have over 90G database data on my server (MyISAM + innodb) is it enough 5 meg of size for innodb_log file ? or need increase more ? Regards

• 

  24x7ss

  • April 20, 2015 11:12

  Hello, It depends on how much of your databases use InnoDB engine. But as you have large database size, I would suggest you to increase it.

  0
• 

  cPanelMichael

  • April 21, 2015 15:32

  Hello, The following third-party URL should help answer this question (it's from Percona but it would also apply to MySQL):

  0
• 

  mahdy_sharifi

  • April 22, 2015 07:39

  Hello : increase innodb log file safe ? or mybe any problem occur ?

  0
• 

  cPanelMichael

  • April 22, 2015 17:12

  It won't result in data loss, but you should read the URL in my previous post regarding choosing the right size. Thank you.

  0

Please sign in to leave a comment.