As per the subject, I'm receiving an error on an InnoDB table: "table is full" when it reached 4GB the filesystem is far from being full so the only thing that I'm thinking right now is that the issue is with the fact that the MySQL installation is a 32-bit.

Can this be the case even if we are in a linux environment?

  • See 1114 (HY000): The table is full – Filburt Mar 25 at 10:36
  • If data amount is far from file size then execute OPTIMIZE TABLE and compact it. – Akina Mar 25 at 10:53
  • 1
    32 bits are still 32 bits, whether on Windows, on Linux, or on Mars. – mustaccio Mar 25 at 12:44
  • Please run SELECT @@global.innodb_file_per_table; and tell us if this is 0 or 1. – RolandoMySQLDBA Mar 25 at 15:57
  • 4GB is the largest file size addressable by a 32-bit file pointer. I recommend that you upgrade your software to the 64-bit version if you need larger files. – Bill Karwin Mar 25 at 16:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy