?
Solved

Clean old records from ibdata1 mysql file

Posted on 2013-12-09
1
Medium Priority
?
586 Views
Last Modified: 2013-12-10
I have an ibdata1 file that contains old database records from a truncated table.  I need to clean up the file so those records are no longer stored on the system.

Is there any way for me to do this without taking down the database?

The server OS is Centos 6.4, the application is MariaDB 5.5.

Thank you for your time.
-Andrew
0
Comment
Question by:ninjadrew
1 Comment
 
LVL 28

Accepted Solution

by:
FishMonger earned 1500 total points
ID: 39708592
Is there any way for me to do this without taking down the database?
No.

Read the info at this link to learn about the required steps needed to do the cleanup:
Reducing ibdata1 file size
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question