Hi! Would on the mailing list anyone know anything about LVM and fsync? Jamie, do you know who has made that LVM? Heikki >Unfortunately I don't have an ordinary disk on that box. I'm thinking that >InnoDB is having a major problem with LVM not ReiserFS. I tried it on an >e2fs portion of the server and it still had problems. > >Do you know of anyone successfully using InnoDB with just LVM? > >Jamie > >-----Original Message----- >From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, May 16, 2001 11:24 AM >To: Jamie Krasnoo; [EMAIL PROTECTED] >Subject: RE: InnoDB problem > > >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
