var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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:
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
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors