[PHP-DB] 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
RE: [PHP-DB] Optimizing Tables
I would say no, due to the overhead. What I would recommned is setting that up as a cron task and running it on a scheduled basis, usually when the server is liightly loaded. Monitor the server and pick an optimal time. This is the same for all server mainenance type situations like index monitoring etc. hth Bastien From: Anna V [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Optimizing Tables Date: Sun, 1 Apr 2007 14:35:51 -0500 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 _ http://local.live.com/?mkt=en-ca/?v=2cid=A6D6BDB4586E357F!420 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Optimizing Tables
On 4/1/07, Bastien Koert [EMAIL PROTECTED] wrote: I would say no, due to the overhead. What I would recommned is setting that up as a cron task and running it on a scheduled basis, usually when the server is liightly loaded. Monitor the server and pick an optimal time. This is the same for all server mainenance type situations like index monitoring etc. That sounds reasonable. Thanks alot for your quick response.
[PHP-DB] RE: Optimizing Tables
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:[EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php