Yep, modify the uid from a varchar to a char. It will make your table bigger, because char uses all 10 characters. But it will allow you to get past the 2 gig limit. It will take a while for the table to be modified though. But it's definitely worth the wait.
Also personally I would change the ip from a bigint to an int, if that is really an IP address like it seems. Just my opinion. No matter what I would make a backup of your data before making any changes. Donny > -----Original Message----- > From: J S [mailto:[EMAIL PROTECTED] > Sent: Friday, June 25, 2004 1:17 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: error 27 > > I don't really understand the difference (I need to read up a bit more). > My > (default mysql) table internet_usage has the following columns: > > uid varchar (10) > ip bigint > time datetime > urlid int > size int > > Is there something I can do to this to fix it so that it can grow larger > than 2 GB? The 'uid' is a mix of chars and ints, e.g u752352. > > > > > > >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] > > > > _________________________________________________________________ > It's fast, it's easy and it's free. Get MSN Messenger today! > 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]
