Jamie,
really strange. Now I start to suspect the file system. InnoDB should create
and write a file of size 2000 MB like you specified in my.cnf.
InnoDB does the initial file write in 1 MB chunks using pwrite,
calling fsync in between.
When you restart MySQL, InnoDB checks if the data file is of the size
specified in my.cnf. It does the check using lseek from the end of file.
That should not affect the file size. If the file size has changed
in that lseek, it really makes the file system suspect!
You could try with an ordinary disk.
Regards,
Heikki
At 10:32 AM 5/16/01 -0700, you wrote:
>I had the same parameters as the startup options page for windows since I
>only have 256 megs of ram. However I have 3 30 Gig Hard Drives pasted
>together with LVM and it has ReiserFS as a partition type.
>
>[mysqld]
>innodb_data_home_dir = /
>innodb_data_file_path = web/mysql/data/ibdata1:2000M
>set-variable = innodb_mirrored_log_groups=1
>innodb_log_group_home_dir = /web/mysql/iblogs
>set-variable = innodb_log_files_in_group=3
>set-variable = innodb_log_file_size=30M
>set-variable = innodb_log_buffer_size=8M
>innodb_flush_log_at_trx_commit=1
>innodb_log_arch_dir = /web/mysql/iblogs
>innodb_log_archive=0
>set-variable = innodb_buffer_pool_size=80M
>set-variable = innodb_additional_mem_pool_size=10M
>set-variable = innodb_file_io_threads=4
>set-variable = innodb_lock_wait_timeout=50
>
>When started it created the file ibdata1 with these properties.
>
>-rw-rw---- 1 mysql mysql 32505856 May 16 09:16 ibdata1
>
>So I rebooted to see if it would start on boot. It didn't. Got this err
>again:
>
>010516 09:21:00 mysqld started
>InnoDB: Error: data file /web/mysql/data/ibdata1 is of different size
>InnoDB: than specified in the .cnf file!
>InnoDB: Could not open data files
>010516 9:21:02 Can't init databases
>010516 09:21:02 mysqld ended
>
>funny thing was that the file size had changed. Really odd.
>
>-rw-rw---- 1 mysql mysql 513802240 May 16 09:18 ibdata1
>
>Thanks,
>
>Jamie
>
>
>
>
>-----Original Message-----
>From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, May 16, 2001 4:46 AM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Subject: Re:InnoDB problem
>
>
>Jamie,
>
>I do not think it is the Reiser file system. Could you show what parameters
>you have in my.cnf and what is the size of the file ibdata1 (when looked
>with ls -l)?
>
>Regards,
>
>Heikki
>http://www.innobase.fi
>
>>I complied MySQL as a max binary. However when I gave all the variables for
>>InnoDB in the my.cnf startup file it seems that InnoDB gets initialized for
>>the first time only. With mysqld going fine, I try to connect using the
>>client and the server with it on really seems sluggish. I put in the
>>password and then it just seems to hang there. I'm not put in to the client
>>prompt at all. If I reboot the server and safe_mysqld tries to bring the
>>database back up, the error:
>>
>>InnoDB: Error: data file /web/mysql/data/ibdata1 is of different size
>>InnoDB: than specified in the .cnf file!
>>InnoDB: Could not open data files
>>010515 19:39:10 Can't init databases
>>010515 19:39:10 mysqld ended
>>
>>crops up and as you see, the database dies. The database files are residing
>>on a LVM ReiserFS. Could this be the problem? Is InnoDB not compatible with
>>LVM or ReiserFS? If it helps the kernel build is 2.4.2. Until then I'm
>stuck
>>using BDB.
>>
>>Thanks,
>>
>>Jamie Krasnoo
>>[EMAIL PROTECTED]
>>
>>
>
>
>---------------------------------------------------------------------
>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
>
>
---------------------------------------------------------------------
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
