Ananda Kumar schrieb:
Hi All,
I am using mysql 5.0.41 on debain.
I have 8 processor, 8 GB RAM.
I have atable with 95 Million records, each day there will be about 1.5
Million records deleted, and around 3.5 Million records added using "LOAD
FILE" script.
Since there would daily deletes happening, there would be lot of
fragmention, so i used the
analyze table <table_name>; command to defragment it, it took close to 12
hrs. Is there any better and faster way to analyze or optimize the table to
defragmentation.
having a fixed row length will prevent tale fragmentation
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
