Unix Technical Forum

innodb_log_file_size variable makes the server crash

This is a discussion on innodb_log_file_size variable makes the server crash within the MySQL forums, part of the Database Server Software category; --> Hello, I have a problem when setting the innodb_log_file_size variable in my.cnf (MySQL 5.0 with Ubuntu 7.04, 2GB RAM). ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 11:28 AM
ctobini
 
Posts: n/a
Default innodb_log_file_size variable makes the server crash

Hello,

I have a problem when setting the innodb_log_file_size variable in
my.cnf (MySQL 5.0 with Ubuntu 7.04, 2GB RAM).

When I start MySQL I have a 'failed' error status.

Here is the InnoDB variables I fixed in the conf file :

innodb_data_file_path = ibdata1:1000M:autoextend
innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 256M
innodb_log_buffer_size = 8M

I commented line by line the InnoDB variables, only
innodb_log_file_size makes the server crash at startup.

Could you see what the problem could be ?

Thanks,

C. Tobini

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 11:29 AM
lark
 
Posts: n/a
Default Re: innodb_log_file_size variable makes the server crash

ctobini wrote:
> Hello,
>
> I have a problem when setting the innodb_log_file_size variable in
> my.cnf (MySQL 5.0 with Ubuntu 7.04, 2GB RAM).
>
> When I start MySQL I have a 'failed' error status.
>
> Here is the InnoDB variables I fixed in the conf file :
>
> innodb_data_file_path = ibdata1:1000M:autoextend
> innodb_buffer_pool_size = 1024M
> innodb_additional_mem_pool_size = 20M
> innodb_log_file_size = 256M
> innodb_log_buffer_size = 8M
>
> I commented line by line the InnoDB variables, only
> innodb_log_file_size makes the server crash at startup.
>
> Could you see what the problem could be ?
>
> Thanks,
>
> C. Tobini
>


can you post the section of error log that pertains to this error?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:39 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com