MySQL Forums
Forum List  »  Optimizer & Parser

Defragmentation and Database Optimizing Tool in the Background
Posted by: Mathias Bischoff
Date: January 26, 2006 10:53AM

Hello together,

I have a database project that collects a lot of data, and stores it in a MYSQL database. So over a year we get up to 200 GB of data. Well we recognized that the database was getting slower and slower.
So my first question is: Are there any tools existing that optimize mysql Databases Tables in the background (online), because we have several hundred tables with more then one GB of data??? No Matter if it is slow.

Well I know the usual optimize statement but this statement blocks the table (no possible write access). And this is my problem.

The next issue I want to ask for is about online Defragmention:

Is there any tool existing that does online Defragmentation of MySQL Data???

Thanks in advance for any helpful response.

Options: ReplyQuote

Written By
Defragmentation and Database Optimizing Tool in the Background
January 26, 2006 10:53AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.