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]
