Hi,
My my.cnf is
innodb_log_file_size = 100M
And
mysql> SHOW GLOBAL VARIABLES LIKE ‘innodb_log_file_size’;
±---------------------±----------+
| Variable_name | Value |
±---------------------±----------+
| innodb_log_file_size | 104857600 |
±---------------------±----------+
1 row in set (0.02 sec)
Also /var/lib/mysql
-rw-rw---- 1 mysql mysql 104857600 Nov 6 12:03 ib_logfile0
-rw-rw---- 1 mysql mysql 104857600 May 21 2012 ib_logfile1
I understand the log file is reached its maximum allocated size. I want to know if i delete it simply by “rm -rf ib_logfile0” and "rm -rf “ib_logfile0” will be any impact to the mysql functionality. Kindly advice.
I am very new to mysql, stuck with one issue, our sos berlin jobscheduler is not running due to mysql issue. Please help me.
Thanks in Advance!
Bala…