The latest version of High Performance MySQL (3rd ed.) recommends that one:
…place an upper limit on the tablespace's size to keep it from growing
very large, because once it grows, it doesn't shrink.
They give the example of:
...ibdata3:1G:autoextend:max:2G
But it isn't clear to me what happens if your dataset keeps growing and hits this maximum. Unfortunately the MySQL docs aren't much help either.
Can someone shed some light on this? It seems like this advice is kind of dangerous on the face of it.
Thanks!
Best Answer
To answer the question what will happen, an error
1114 (ER_RECORD_FILE_FULL)
will be generated when you try to insert new record. I've learned this by accident, while converting large MyISAM table to InnoDB, and there was a max setting left.