temporary table is full

[XadmozX]

Hi all,

During executing SELECT query, MySQL creates disk temporary table.
After the tabe exceeds 4GB I get table is full error.
How can I change settings to remove 4 GB bareer from disk tmp tables?
It is easy to set in phisical MyISAM table by increase MAX_ROWS.
I have ext3 filesystem

[Bill Karwin]

Re: temporary table is full

XadmozX wrote:
[color=blue]
> Hi all,
>
> During executing SELECT query, MySQL creates disk temporary table.
> After the tabe exceeds 4GB I get table is full error.
> How can I change settings to remove 4 GB bareer from disk tmp tables?
> It is easy to set in phisical MyISAM table by increase MAX_ROWS.
> I have ext3 filesystem[/color]

ext3 filesystems can store files larger than 4GB, but the application
reading/writing the file (mysqld in this case) must support file
pointers that can address large files.

The myisam_data_poi nter_size system variable controls this (supported as
of MySQL 4.1.2).

See http://dev.mysql.com/doc/mysql/en/Se...variables.html
(search for myisam_data_poi nter),
and http://dev.mysql.com/doc/mysql/en/Full_table.html

Regards,
Bill K.