Patrick,
people have created files at least up to 500 GB using InnoDB's auto-extend
feature.
What does:
ulimit -a
say about the 'file size' of the user running mysqld?
Have you put some disk space quotas on the directories of the MySQL datadir?
Please correct me if I am wrong, but I think
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
Since I have some performance troubles with table-locking in a multi-user
environment (when one of them performs a complex query all the other have to
wait up to 1 minute, which is not very nice...), I would like to
Hi,
I think you should change the tmpdir variable value to a directory which
have enough room to create your temp big table (by default, it points
to /tmp dir).
Regards,
Jocelyn
Patrick Herber a écrit :
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
Thanks a lot for your answer!
However, when I used the option innodb_file_per_table I saw that the temp
file (#sql...) was created in my DB directory and on this partition I still
have plenty of space (more than 200GB).
Do you think I CAN'T use this option for such a big table and I have to use