Announcement

Announcement Module
Collapse
No announcement yet.

InnoDB issue with auto-generated config file

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • InnoDB issue with auto-generated config file

    Hi,
    I see a strange looking issue after applying the auto generated my.cnf to the fresh installed Percona server.

    Here is the config file:

    [mysql]

    # CLIENT #
    port = 3306
    socket = /var/run/mysqld/mysqld.sock

    [mysqld]

    # GENERAL #
    user = mysql
    default_storage_engine = InnoDB
    socket = /var/run/mysqld/mysqld.sock
    pid_file = /var/lib/mysql/ys-wa01.pid

    # MyISAM #
    key_buffer_size = 32M
    myisam_recover = FORCE,BACKUP

    # SAFETY #
    max_allowed_packet = 16M
    max_connect_errors = 1000000
    innodb = FORCE

    # DATA STORAGE #
    datadir = /var/lib/mysql/data/

    # CACHES AND LIMITS #
    tmp_table_size = 32M
    max_heap_table_size = 32M
    query_cache_type = 0
    query_cache_size = 0
    max_connections = 500
    thread_cache_size = 50
    open_files_limit = 65535
    table_definition_cache = 4096
    table_open_cache = 4096

    # INNODB #
    innodb_flush_method = O_DIRECT
    innodb_log_files_in_group = 2
    innodb_log_file_size = 256M
    innodb_flush_log_at_trx_commit = 2
    innodb_file_per_table = 1
    innodb_buffer_pool_size = 5G

    # LOGGING #
    log_error = /var/lib/mysql/data/mysql-error.log
    log_queries_not_using_indexes = 1
    slow_query_log = 1
    slow_query_log_file = /var/lib/mysql/data/mysql-slow.log



    Here is the result of my attempt to restart the server:

    tail /var/log/mysql/mysql-error.log
    InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
    InnoDB: than specified in the .cnf file 0 268435456 bytes!
    130627 16:46:05 [ERROR] Plugin 'InnoDB' init function returned error.
    130627 16:46:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    130627 16:46:05 [ERROR] Failed to initialize plugins.
    130627 16:46:05 [ERROR] Aborting

    130627 16:46:05 [Note] /usr/sbin/mysqld: Shutdown complete

    130627 16:46:05 mysqld_safe mysqld from pid file /var/lib/mysql//ys-wa01.pid ended
    root@ys-wa01:/var/lib/mysql/mysql#


    if I remove the cnf file - everything is working file, I'm able to restart the server with no errors.

    Thanks for your guys help!



  • #2
    Looks like your existing log file size (ib_logfile* in your data directory) are a different size (5MB) than what is now specified in your new configuration file (innodb_log_file_size = 256M). You can either adjust that variable in the config file to match your existing log file sizes, or you can remove / move your existing log files (ib_logfile*) and allow MySQL to recreate them at the newly specified size.

    Comment

    Working...
    X