Skip to content

Instantly share code, notes, and snippets.

@vidluther

vidluther/my.cnf Secret

Created April 23, 2014 05:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vidluther/12c24c666d16a7f6072c to your computer and use it in GitHub Desktop.
Save vidluther/12c24c666d16a7f6072c to your computer and use it in GitHub Desktop.
014-04-23 00:01:05 7f5ab45f3740 InnoDB: Error: page 304 log sequence number 6130555460432
InnoDB: is in the future! Current system log sequence number 536961579532.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2014-04-23 00:01:05 7f5ab45f3740 InnoDB: Error: page 305 log sequence number 6130555449508
InnoDB: is in the future! Current system log sequence number 536961579532.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1 row operations to undo
InnoDB: Trx id counter is 35138298880
# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 1
innodb-log-file-size = 2G
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 70G
innodb_data_home_dir = /mysql/data
innodb_log_group_home_dir = /mysql/logs
log_bin = /mysql/logs/bin-log
sync_binlog = 1
expire_logs_days = 2
max_binlog_size = 1G
log_error = /var/log/mysql/mysqld.log
slow_query_log = OFF
long_query_time = 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment