Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the 5242880 bytes problem in InnoDB". In the daily operation, I believe many people have doubts about how to solve the 5242880 bytes problem in InnoDB. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt of "how to solve the 5242880 bytes problem in InnoDB"! Next, please follow the editor to study!

[root@zhanglin bin] # / xtrabackup-- defaults-file=/etc/my.cnf-- backup-- log-stream-- target-dir=/mysqlbak/xtrabackup/delta

. / xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86 / 64) (revision id:)

Xtrabackup: uses posix_fadvise ().

Xtrabackup: cd to / usr/local/mysql/data

Xtrabackup: open files limit requested 0, set to 1024

Xtrabackup: using the following InnoDB configuration:

Xtrabackup: innodb_data_home_dir =. /

Xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend

Xtrabackup: innodb_log_group_home_dir =. /

Xtrabackup: innodb_log_files_in_group = 2

Xtrabackup: innodb_log_file_size = 50331648

InnoDB: Error: logfile. / ib_logfile0 is of different size 5242880 bytes

InnoDB: than specified in the .cnf file 50331648 bytes!

For using the default my.cnf (general tutorials will teach you to use support-files/my-medium.cnf)

If innodb is used in the middle, the default log file size for innodb is 56m

Solution:

1. Close the database, delete the log file (or move to another directory in case MySQL doesn't work), and restart the database.

2. If the same error is reported in the above situation, then modify the configuration file to set the log file size to the configuration size of the backup database (much larger than the current one is OK).

Modify the parameters as follows:

Innodb_log_file_size = 1G

At this point, the study on "how to solve the 5242880 bytes problem in InnoDB" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.