Re: InnoDB File Size

2002-02-12 Thread Gurupartap Davis
t; 4 GB data files in those file systems that allow 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

Re: InnoDB File Size

2002-02-08 Thread Gurupartap Davis
t; 4 GB data files in those file systems that allow 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

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 acci

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