Hi Folks, Being relatively new to InnoDB I have read the books etc. but can't find anything about regular maintenance that may or may not need to be performed on the tablespaces. With other databases I have worked on, a regular dump and load of a database is generally required, on a semi-regular basis, in order to consolidate the data pages and to remove deleted record space thereby improving performance and disk usage.
Does InnoDB require something similar? Thanks David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax