RE: Optimizing Tables
| From: | Buesching, Logan J | Date: | Sun, 01 Apr 2007 22:37:47 +0000 |
| Subject: | RE: Optimizing Tables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43393@lists.php.net to get a copy of this message | ||
From the MySQL manual:
---
OPTIMIZE TABLE should be used if you have deleted a large part of a
table or if you have made many changes to a table with variable-length
rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns).
Deleted rows are maintained in a linked list and subsequent INSERT
operations reuse old row positions. You can use OPTIMIZE TABLE to
reclaim the unused space and to defragment the data file.
---
So, no, do not optimize table after each row deletion.
-----Original Message-----
From: Anna V [mailto:aserev@gmail.com]
Sent: Sunday, April 01, 2007 3:36 PM
To: php-db@lists.php.net
Subject: Optimizing Tables
Hello group,
I just have a quick question for you all. Here is it... Is it advisable
to
run optimize table after each deletion of a record?
Thanks in advance,
Anna Vester