Thanks a lot!
js.
What FAQ are you talking about?
The manual <http://dev.mysql.com/doc/mysql/en/Table_size.html> seems quite clear that there is no such limitation in MySQL, regardless of column type. The default max size of a MyISAM table is 4 Gb, but this can be increased either in the original CREATE TABLE statement or with a subsequent ALTER TABLE statement using the AVG_ROW_LENGTH and MAX_ROWS table options, up to MySQL's maximum table size of 8 million terabytes. If you are hitting a limit at 2Gb, it is almost certainly a limitation of your OS/filesystem. If you are already hitting an OS/filesystem limit of 2 Gb, you won't be able to change a VARCHAR(10) to CHAR(10), as that would require making the table bigger.
Michael
Donny Simonton wrote:
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 aselect from the table successfully. Do I still need to run myisamchk ?
Thanks,
js.
-- 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]
