Hi to 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?
I have ext3 filesystem.

The 4G is the limit size of your filesystem.

but on a phisical table i can set max size over 4 GB, so it's not fs problem

What do you mean by phisical table
A table in MyIsam has 3 files:
Index
Data
FRM

You says that the data file (MYD) is larger than 4GB ?
Perhaps are you using INNODB ?

yes, it's possible to override 4GB data limit by increase MAX_ROWS on MyISAM table, but disk tmp tables MySQL creates automatically and I can't find settings for them