Hello.
If you're not using per-file tablespace, the OPTIMIZing of the table
most probably won't decrease the size of ibdata files. See:
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
about how to decrease the size of the tablespace. OPTIMIZE table
is mapped to ALTER TABLE for I
Hello.
We had an INNoDB table of very large size of 47 GB. Recently we deleted a
lot of rows from the table in order to reduce the size. The number of rows
now stands at 164,000+, however, the disk usage remains the same. I tried
OPTIMIZEing the table; but the optimize fails after running for abou
