Error
Error Code:
3500
MySQL Error 3500: Unsupported Temporary Table Compression
Description
Error 3500 occurs when you attempt to create a `TEMPORARY TABLE` in MySQL using storage options that are incompatible with temporary tables, specifically `ROW_FORMAT=COMPRESSED` or `KEY_BLOCK_SIZE`. MySQL does not support these advanced compression and block size settings for temporary tables, leading to a failure of the `CREATE TEMPORARY TABLE` statement.
Error Message
CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
Known Causes
4 known causesExplicit Compressed Row Format
The `CREATE TEMPORARY TABLE` statement explicitly included the `ROW_FORMAT=COMPRESSED` option.
Explicit Key Block Size
The `CREATE TEMPORARY TABLE` statement explicitly included the `KEY_BLOCK_SIZE` option, which is not permitted for temporary tables.
Inherited Session/Global Defaults
Session or global default table creation options (e.g., `innodb_default_row_format`) are set to a compressed format, which implicitly applies to temporary tables.
Application-Generated SQL
An application, ORM, or script is generating `CREATE TEMPORARY TABLE` statements that include the unsupported compression or block size options.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service