Jump to content


Photo

Optimising


  • Please log in to reply
1 reply to this topic

#1 Sephiriz

Sephiriz
  • Members
  • PipPip
  • Member
  • 20 posts
  • LocationNew York

Posted 05 November 2003 - 03:06 AM

Occasionally, when I optimize a table, I cannot even access the table anymore, and I need to delete it, because it doesn\'t work. Can someone tell me why this happens?
Check out the X Community
PHP Manual | Learn XML | Safe PHP Scripting | Regular Expression Help

Current Project(s):
I. phpRetrograde - PHP5 to PHP4.
II. str_replace_count - Replace a string specified amount of times. III. WordStem - Extract word-stems from strings.

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 07 November 2003 - 05:43 AM

Have you read these

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, BLOB, or TEXT columns).  Deleted records are maintained in a linked list and subsequent INSERT operations reuse old record positions. You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the datafile.


OPTIMIZE TABLE works the following way:  

·If the table has deleted or split rows, repair the table.
·If the index pages are not sorted, sort them.
·If the statistics are not up to date (and the repair couldn\'t be done by sorting the index), update them.


Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users