newtontech4
asked on
how to shrink MySQL DB
I have a MySQL database running on Windows 2003. It is rapidly occupying space on my server. What is the best way to manage MySQL in order to purge data in order to reclaim space. It should be noted that this MySQL is running InnoDB inside and therefore the standard 14 day purging of data does not reclaim any space since it puts all tables into one table space. Thank you in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi giltjr - ibdata1 is growing the most. I think this is due to the fact that InnoDB is being used. This is a MySQL in my lab so i have not developed a back-up process yet.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If it is the actual tablespace files you should be able to reclaim space by doing reorgs regularly.