List:General Discussion« Previous MessageNext Message »
From:Hiu Yen Onn Date:October 16 2005 1:49am
Subject:Re: default table type = innodb is stable??
View as plain text  
Jigal van Hemert wrote:

>----- Original Message ----- 
>From: "Hiu Yen Onn" <yohiu@stripped>
>
>
>  
>
>>if i uncomment it, then mysql server wont start at all. if i comment it,
>>then, that's ok. please advise. thanks again
>>    
>>
>
>If the mysql server does not start it will probably leave a lot of messages
>in the error log. If you send the section of the error log about such a
>failed start to the list people here can most likely help you find the
>problem with your server.
>
>Regards, Jigal.
>
>
>  
>
this is my error log file.

A mysqld process already exists at  Sun Oct 16 09:33:39 BNT 2005
051016  9:36:14 [Note] /usr/sbin/mysqld: Normal shutdown

051016  9:36:14  InnoDB: Starting shutdown...
051016  9:36:17  InnoDB: Shutdown completed; log sequence number 0 43977
051016  9:36:17 [Note] /usr/sbin/mysqld: Shutdown complete

051016 09:36:17  mysqld ended

051016 09:36:17  mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
051016  9:36:18 [ERROR] Can't init databases
051016  9:36:18 [ERROR] Aborting

051016  9:36:18 [Note] /usr/sbin/mysqld: Shutdown complete

051016 09:36:18  mysqld ended

051016 09:37:41  mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
051016  9:37:41 [ERROR] Can't init databases
051016  9:37:41 [ERROR] Aborting

051016  9:37:41 [Note] /usr/sbin/mysqld: Shutdown complete

051016 09:37:41  mysqld ended

051016 09:39:02  mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
051016  9:39:03 [ERROR] Can't init databases
051016  9:39:03 [ERROR] Aborting

051016  9:39:03 [Note] /usr/sbin/mysqld: Shutdown complete

051016 09:39:03  mysqld ended


Thread
default table type = innodb is stable??Hiu Yen Onn14 Oct
  • Re: default table type = innodb is stable??Ady Wicaksono14 Oct
    • Re: default table type = innodb is stable??Hiu Yen Onn15 Oct
      • Re: default table type = innodb is stable??Hiu Yen Onn15 Oct
  • Re: default table type = innodb is stable??Jigal van Hemert15 Oct
    • Re: default table type = innodb is stable??Hiu Yen Onn16 Oct
      • RE: default table type = innodb is stable??Richard Dale16 Oct
        • Re: default table type = innodb is stable??Hiu Yen Onn17 Oct
  • Re: default table type = innodb is stable??Gleb Paharenko15 Oct