Resize ib_logfile*

<Check Existing ib_logfile Size>
[root@ip- ~]# du -sh /u02/mysqldata/practice/data/ib_*
1.1G    /u02/mysqldata/practice/data/ib_logfile0
1.1G    /u02/mysqldata/practice/data/ib_logfile1

<Check innodb_log_file_size parameter value>
[root@ip- ~]# cat /u01/app/mysql/practice/etc/my.cnf | grep -i innodb_log_file_size
innodb_log_file_size=1024M

<Check DB is up and running>
[root@ip- ~]# mysqladmin -uroot -proot status
Warning: Using a password on the command line interface can be insecure.
Uptime: 92  Threads: 2  Questions: 20  Slow queries: 0  Opens: 70  Flush tables: 1  Open tables: 63  Queries per second avg: 0.217

<Stop Database>
[root@ip- ~]# /etc/init.d/CS.mysql-practice stop
/u01/app/mysql/product/5.6.16 3316
Shutting down MySQL.. SUCCESS!

<Edit innodb_log_file_size parameter and change it to 512M>
[root@ip- ~]# vi /u01/app/mysql/practice/etc/my.cnf

<Check innodb_log_file_size parameter value>
[root@ip- ~]# cat /u01/app/mysql/practice/etc/my.cnf | grep -i innodb_log_file_size
innodb_log_file_size=512M

<Start Database>
[root@ip- ~]# /etc/init.d/CS.mysql-practice start
/u01/app/mysql/product/5.6.16 3316
Starting MySQL........... SUCCESS!

<Content of DB Error Log File>
2016-08-12 02:24:59 7620 [Note] InnoDB: Setting log file /u02/mysqldata/practice/data/ib_logfile101 size to 512 MB
InnoDB: Progress in MB: 100 200 300 400 500
2016-08-12 02:25:03 7620 [Note] InnoDB: Setting log file /u02/mysqldata/practice/data/ib_logfile1 size to 512 MB
InnoDB: Progress in MB: 100 200 300 400 500

<Check Updated ib_logfile Size>
[root@ip- ~]# du -sh /u02/mysqldata/practice/data/ib_*
512M    /u02/mysqldata/practice/data/ib_logfile0
512M    /u02/mysqldata/practice/data/ib_logfile1