Link to home
Start Free TrialLog in
Avatar of newtontech4
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
Avatar of jojuez
jojuez
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of giltjr
Can you identify what is exactly using the space?  Is it logs or is it the actual database/tablespace files?

If it is the actual tablespace files you should be able to reclaim space by doing reorgs regularly.
Avatar of newtontech4
newtontech4

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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial