Changing innodb log file size - errors?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • fuzzybr80
    #1

    Changing innodb log file size - errors?

    Hi,

    I am using MySQL version 5.0 on Linux Fedora Core 4.

    I recently got this error message:

    060609 11:06:29 InnoDB: ERROR: the age of the last checkpoint is
    9433557,
    InnoDB: which exceeds the log group capacity 9433498.
    InnoDB: If you are using big BLOB or TEXT rows, you must set the
    InnoDB: combined size of log files at least 10 times bigger than the
    InnoDB: largest such row.

    which I interpreted as my log files at /var/lib/mysql/ib_logfile0 and
    /var/lib/mysql/ib_logfile1 being too small (still at default at 5M). I
    looked up some resources and they recommended setting the log file size
    to about 25% of my buffer size, which I had set to 256MB.

    So I added the line in /etc/my.cnf :
    innodb_log_file _size=50M

    But on restart i get the error:
    InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880
    bytes
    InnoDB: than specified in the .cnf file 0 52428800 bytes!

    and my queries started failing too:
    060609 12:05:39 [ERROR] /usr/sbin/mysqld: Incorrect information in
    file: './db/available.frm'
    060609 12:05:39 [ERROR] /usr/sbin/mysqld: Incorrect information in
    file: './db/available.frm'
    060609 12:05:39 [ERROR] /usr/sbin/mysqld: Incorrect information in
    file: './db/site_info.frm'

    I reverted my config back to a default log file size, and everything
    went back to normal. Is there a proper procedure that I should follow
    for changing the log file size?

    Tags: None
    • Heikki Tuuri
      #2
      Re: Changing innodb log file size - errors?

      Fuzzy,

      "fuzzybr80" <fuzzybr80@gmai l.com> kirjoitti
      viestissä:11498 27231.252786.18 8170@y43g2000cw c.googlegroups. com...[color=blue]
      > Hi,
      >
      > I am using MySQL version 5.0 on Linux Fedora Core 4.
      >
      > I recently got this error message:
      >
      > 060609 11:06:29 InnoDB: ERROR: the age of the last checkpoint is
      > 9433557,
      > InnoDB: which exceeds the log group capacity 9433498.
      > InnoDB: If you are using big BLOB or TEXT rows, you must set the
      > InnoDB: combined size of log files at least 10 times bigger than the
      > InnoDB: largest such row.
      >
      > which I interpreted as my log files at /var/lib/mysql/ib_logfile0 and
      > /var/lib/mysql/ib_logfile1 being too small (still at default at 5M). I
      > looked up some resources and they recommended setting the log file size
      > to about 25% of my buffer size, which I had set to 256MB.
      >
      > So I added the line in /etc/my.cnf :
      > innodb_log_file _size=50M
      >
      > But on restart i get the error:
      > InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880
      > bytes
      > InnoDB: than specified in the .cnf file 0 52428800 bytes!
      >
      > and my queries started failing too:
      > 060609 12:05:39 [ERROR] /usr/sbin/mysqld: Incorrect information in
      > file: './db/available.frm'
      > 060609 12:05:39 [ERROR] /usr/sbin/mysqld: Incorrect information in
      > file: './db/available.frm'
      > 060609 12:05:39 [ERROR] /usr/sbin/mysqld: Incorrect information in
      > file: './db/site_info.frm'
      >
      > I reverted my config back to a default log file size, and everything
      > went back to normal. Is there a proper procedure that I should follow
      > for changing the log file size?[/color]

      yes, please see:

      http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html


      Best regards,

      Heikki

      Oracle Corp./Innobase Oy
      InnoDB - transactions, row level locking, and foreign keys for MySQL

      InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
      tables
      http://www.innodb.com/order.php



        Comment

        Previous template Next
        Working...