Yes, if you are using a dynamic table which means it has varchar's, text, or blobs the limit is 2 gigs. If you are using a fixed table which uses chars only, then there is no limit that I have seen.
Donny > -----Original Message----- > From: J S [mailto:[EMAIL PROTECTED] > Sent: Friday, June 25, 2004 9:38 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: error 27 > > Could this problem be due to the size of my tables? Is there a limit on > how > big the table can be? > I'm using mysql-standard-4.0.20. > > -rw-rw---- 1 mysql mysql 2147483647 Jun 25 01:49 > internet_usage.MYD > -rw-rw---- 1 mysql mysql 622724096 Jun 25 01:49 internet_usage.MYI > > > > >Hi, > > > >I got an error 27. > > > >DBD::mysql::st execute failed: Got error 27 from table handler at > >/home/u752359/logfile.pl line 144, <PS_F> line 3079464. > > > >The FAQs say: > > > >Check whether you have hit 2 Gb limit. > >If that is not the case, shutdown MySQL server and repair a table with > >(my)isamchk. > > > >How do I check if I have a 2GB limit? I logged on to mysql and ran a > select > >from the table successfully. Do I still need to run myisamchk ? > > > >Thanks, > > > >js. > > > >_________________________________________________________________ > >Want to block unwanted pop-ups? Download the free MSN Toolbar now! > >http://toolbar.msn.co.uk/ > > > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > _________________________________________________________________ > Stay in touch with absent friends - get MSN Messenger > http://www.msn.co.uk/messenger > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
