Currently I have three InnoDB log files, whose size is 256MB and main memory is 2GB. Since I use 1GB of InnoDB buffer pool, I think log files'd better get bigger to some extent; possibly 1GB. You know, only changing the value in my.cnf cause mysqld not to start due to error. I'm wondering if deleting log files after mysqld is stopped and starting mysqld is safe. I tried this and got some look-so-serious error(or warning?) messages like following:
030121 10:18:49 mysqld ended 030121 10:27:07 mysqld started 030121 10:27:11 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 1024 MB InnoDB: Database physically writes the file full: wait... 030121 10:28:05 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 1024 MB InnoDB: Database physically writes the file full: wait... 030121 10:29:02 InnoDB: Log file ./ib_logfile2 did not exist: new to be created InnoDB: Setting log file ./ib_logfile2 size to 1024 MB InnoDB: Database physically writes the file full: wait... 030121 10:29:58 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 3205932556 InnoDB: Doing recovery: scanned up to log sequence number 0 3205932556 InnoDB: Last MySQL binlog file position 0 13846, file name ./lacrimosa- bin.003 030121 10:29:58 InnoDB: Flushing modified pages from the buffer pool... 030121 10:29:59 InnoDB: Started /austin/local/mysql/bin/mysqld: ready for connections query. sql -- Chung Ha-nyung <alita@[neowiz.com|kldp.org]> Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
