Re: InnoDB File Size

2002-02-12 Thread Gurupartap Davis
it. Thus 4 G files should be available also on 4.0.1. Best regards, Heikki Tuuri Innobase Oy Gurupartap Davis wrote in message ... I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB data files, but mysql is telling me that the files must be = 4096MB

Re: InnoDB File Size

2002-02-08 Thread Gurupartap Davis
it. Thus 4 G files should be available also on 4.0.1. Best regards, Heikki Tuuri Innobase Oy Gurupartap Davis wrote in message ... I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB data files, but mysql is telling me that the files must be = 4096MB

InnoDB File Size

2002-02-06 Thread Gurupartap Davis
I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB data files, but mysql is telling me that the files must be = 4096MB This is on a RedHat 7.2 box with redhat's 2.4.9-13 enterprise kernel on a reiserfs filesystem... I don't think there should be such a low limit...I

innodb vs myisam optimizations

2001-12-04 Thread Gurupartap Davis
I'm converting a table to innodb from myisam in mysql 4.0 and I was wondering why it takes sooo long to do a SELECT COUNT(*) In the old MyISAM table, it's quick: mysql select count(*) from forecast; +---+ | count(*) | +---+ | 194698187 | +---+ 1 row in set (0.00 sec) In