MySQL 5.5: "Free space" reserved for table?
On the same MySQL (v. 5.5) service i have multiple database.
One of this databases has a table with 29'000'000 records (3.3 GiB).
When i delete some records, MySQL seems reserve the free space only for the current table. I see into table inspector (MySQL Workbench): Data Free 1.4 GiB.
I'm wrong or the space used by a table is never reused by other table or other database?
Unlike some other engines, InnoDB does not generally reclaim free space, meaning your tables, once at a certain size, remain there pretty much perpetually. One way to recover this space is the somewhat painful OPTIMIZE TABLE command which can rebuild and reindex the table, freeing that up.
This does lock the table for the duration and on large tables can take hours, so use carefully.
- How do I set the default schema for a user in MySQL?
- How to output geoJSON file from mysql spatial table?
- PHPMyAdmin Configuration not working because of MySQL user password?
- The best way of storing many to many hierarchical data in sql
- JDBC connection without database definition
- Can Magento Connect to Another MySQL database?
- PHP isset() with multiple parameters
- bootstrap table doesnot display data
- CakePHP-2.0: Refactor my code editing faster sql query, need a faster sql query
- ERROR 2006 (HY000): MySQL server has gone away
- Problems selecting multiple column
- Order rows based on another table?
- MySQL Workbench edit data
- brew start and brew restart wont start service
- Sort MySQL query result by calculated average DESC
- PHP MYSQL Array and sort
- Use queryset result as a parameter to a raw SQL in Django
- Getting multiple values for a date for Google Charts
- is there any way to check with cumulative way to get month based on the amount fields
- How to compare using bcrypt in a db query using node.js and express
- SQL query to check if a name begins and ends with a vowel
- MySQL JSON_OBJECT() datetime format
- Why is MySQL Sorting by mp.id in This Query Execution Plan?
- PHPExcel download not working properly
- MySqlCommand().ExecuteReader().GetString() does not work
- how to sum rows together but also leave the original rows in the results?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- Java - Having a huge ArrayList (1 million +), how to create a String of it in a acceptable amount of time?
- SQL filter for same values in different columns
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it