List:General Discussion« Previous MessageNext Message »
From:Hiu Yen Onn Date:October 16 2005 11:39pm
Subject:Re: default table type = innodb is stable??
View as plain text  
Is that stable if i started mysql server by defining default_table_type 
= INNODB at the my.cnf file? from which by default my.cnf is defining 
MYISAM table to be the defaulted.

Richard Dale wrote:

>>this is my error log file.
>>    
>>
>
>  
>
>>InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
>>InnoDB: than specified in the .cnf file 0  268435456 bytes!
>>    
>>
>
>Your problem here is that you must have started MySQL when you had a 5MB
>transaction log file specified, but you then put a new config file online
>with a different log file size (256MB), InnoDB complains and dies.
>
>You need to delete your old transaction log files (ib_logfile0) then start
>MySQL and all should be fine.
>
>Note: You should only delete your log files when you are absolutely sure
>MySQL has shut down OK.
>
>Best regards,
>Richard Dale.
>Norgate Investor Services
>- Premium quality Stock, Futures and Foreign Exchange Data for
>  markets in Australia, Asia, Canada, Europe, UK & USA -
>www.premiumdata.net 
>
>
>  
>

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