Does mySQL have a 4GB/32-bit file size limit? 1

[DBAwhosaysNIE]

I have 2 tables w/~8M rows each.&nbsp;&nbsp;The data (ISD) files are 500-550M each but the index (ISM) files are just barely (exactly 1KB/1024 bytes) under 4GB.&nbsp;&nbsp;I can't insert into them and OPTIMIZE TABLE has failed three times on each.<br><br>We are running mySQL 3.22.23b on an E4500 w/Solaris 2.7 & Veritas file systems.<br><br>Also, can anyone reccomend a good book for someone with an Oracle background who's been handed mySQL responsibility (hypothetically, of course ?

 

[rycamor]

Yes, unfortunately versions 3.22.xx of MySQL have a 4 GB table size limit, but the new version, 3.23.21, has a MUCH greater size limit. <br><br>See:<br><br><A HREF="

http://www.mysql.com/documentation/mysql/commented/manual.php?section=Table_size"

TARGET="_new">

http://www.mysql.com/documentation/mysql/commented/manual.php?section=Table_size</A><br><br>The

best book on MySQL at present is &quot;MySQL&quot; by Paul DuBois. <A HREF="

http://www2.newriders.com/cfm/prod_book.cfm?RecordID=584"

TARGET="_new">

http://www2.newriders.com/cfm/prod_book.cfm?RecordID=584</A>

 

[ElgisRamon]

And MySQL is limited to the OS limits

 

[Guest_imported]

No, MySQL doesn't. OS have. Read the manual about this topic.