Max data size seems fixed to 2.0GB?

[wmacura]

Hi,

I have a decently sized table which stores profiling results. MySQL
claims that max_data_length is ~.3 petabytes and that I have ~2.5GB of
data in it:

mysql> SHOW TABLE STATUS LIKE 'profilings'\G
*************************** 1. row ***************************
Name: profilings
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 4934427
Avg_row_length: 509
Data_length: 2513208976
Max_data_length: 281474976710655
Index_length: 221850624
Data_free: 0
Auto_increment: NULL
Create_time: 2009-08-16 17:39:04
Update_time: 2009-08-16 18:40:47
Check_time: 2009-08-16 17:46:46
Collation: latin1_swedish_ci
Checksum: NULL
Create_options: max_rows=4294967295 avg_row_length=500
Comment: the gigantic table of profiling results
1 row in set (0.00 sec)


Yet SequelPro says max data size is 2GB and that I have 2GB of data in
the table. The console implies that SequelPro is in fact looking at
the above output:
/* MySQL 17:58:15 */ SHOW TABLE STATUS LIKE 'profilings';

So I guess something has gone wrong with the parsing?

Wiktor

PS. Thanks for an awesome product!

[Wiktor Macura]

And here is a screenshot.

Thanks again.

[David Logan]

I have noted this 2GB "limit" also, with tables that are correctly
uploaded from CSV files that are 10s of GBs.
David

On Aug 16, 7:50 pm, Wiktor Macura <wmac...@gmail.com> wrote:
> And here is a screenshot.
> Thanks again.
>

>  (MySQL 5.0.67-0ubuntu6) massprofiler [user]-massprofiler-profilings.png
> 312KViewDownload

[Rowan Beentje]

Thanks all for the reports of this - the correct number was being
retrieved, it was just being stored in a variable for display purposes
which was only 32 bits long, and so was maxing out at 2GB. This has
been fixed in r1298 and will be included in 0.9.7 for those who aren't
using (or can't use!) the nightlies.

Cheers,
Rowan

[Peter Mars]

Jim,

Saturday at 2:00 at Suzanne's

And Kurt told Kevin anyone coming to the graduation should get there
by 7:00 tomorrow to get a seat!!!!

STAY HOME!!! We'll see you on saturday!!