• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2760
  • Last Modified:

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
0
newtontech4
Asked:
newtontech4
  • 2
2 Solutions
 
jojuezCommented:
You may need to truncate your BIN logs. Are you backing up this server?
0
 
giltjrCommented:
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.
0
 
newtontech4Author Commented:
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.
0
 
giltjrCommented:
O.K.  Do a reorg is your  best bet for reclaiming space.  This is assuming that data is being purged/deleted.  If no data is being purged/delete, only added, then there is nothing you can do.  It will continue to get bigger and bigger.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now