Data Deletion in MySQL

2012-08-05  Source: Original Site  Category:MySQL  Views:0 

Advertisement

I am having a mid-size database of 20GB. The database uses InnoDB storage engine. Now I need to implement purging solution. Initialy I presumed that, whenever I delete data from my database, size of the database file would be reduced proportionately, if not there would be some tools using which I can resize (reduce) my data file. But after going through various literatures posted in Internet, I do get a different picture. Datafile size increases whenever data is deleted from the database and there is no way operating system gets back the freed up space resulted out of delete operation. if that is true, how can I control growth of my database? how can I shrink it? what tools are available which can be used? in such a scenario purging has no meaning, other than the fact the actual data within the file is of lesser size after purging. I am really worried. not sure how to cope up with such a situation.

Waiting for some suggestions....

Related articles
  • Data Deletion in MySQL 2012-08-05

    I am having a mid-size database of 20GB. The database uses InnoDB storage engine. Now I need to implement purging solution. Initialy I presumed that, whenever I delete data from my database, size of the database file would be reduced proportionately,

  • MySQL Checkbox Multiple data Delete? 2013-07-17

    to everyone I’m wondering how to make some simple checkbox for multiple data delete from mysql I found some tutorial on net but don’t work. I tested it without changing anything and doesn’t work. I’m wondering did programmer test it before he posted

  • checkbox multiple delete in mysql rows 2012-12-08

    i hope some of you'll be able to find an answer to my problem ok i've a table that generates a list of table rows (including my table key) and populates them with data from a mysql table (by a simple select) each row has a checkbox next to them to al

  • Multiple checkbox delete with MySQL 2013-01-27

    I have a table that generates a list of table rows and populates them with data from a MySQL table. Each of the table rows has a checkbox next to them to allow for multiple row deletions from the database. How do I get the values for $id so I can del

  • 1267 Illegal mix of collations on a date field in MySQL 2013-02-10

    mysql-users and -developers we came across a strange behaviour of mysql with collations on a DATE-Field. I postet a structured form of this question in my developer blog: http://blog.sky-bizz.com/2011/05/29/1267-illegal-mix-of-collations-on-a-date-fi

  • What are the possible ways to insert data into a MySql database from a webpage? 2012-01-11

    I need to insert a data into mysql database when submit button is pressed and I must return the status in a message box. I use php. The sad thing is on page load the code to insert data executes, which must not happen. I have written the php code on

  • From an html form in https:// url save the credit card data in a mysql database tabl 2012-02-14

    Can you tell me the code tricks involved in : From an html form in https:// url save the credit card data in a mysql database table SECURELY ? Then retreive them securely at https:// url ? I know all the code to store data, and retreive from DB/TABLE

  • The best way to get a drop down field to show data from a MySQL database 2012-02-20

    I'm a little new to PHP and server side programming in general. But I was looking for some advice of what is the best way to get multiple drop down fields from within a search form display data from a MySQL database. And once the user has selected fr

  • looking to transfer the structure (not the data) of my mySQL database 2012-04-18

    I'm looking to transfer the structure (not the data) of my mySQL database to another server (to a mySQL database). I'm going to be making copies of a website. Can anyone point me in the right direction for how I would learn to do this? I use phpmyadm

  • problem in extracting data from the mysql using php 2012-05-21

    I'm a beginner in php/mysql . i did a basic extracting of data from the mysql structurally almost identical to add.php function with the difference that it pre-fills the form with the data that is already in the database; the record number is indicat

  • Date: Calling up date format from mySQL 2012-05-23

    I'm creating a system where users can post future events. They can choose an event date, which enters into the mySQL database in the form YYYY-MM-DD (the default date form in mySQL). I'm trying to grab these dates from mySQL using php, and display it

  • Change date format from MySQL 2012-05-31

    I am getting a date from a MySQL with a 'select' statement. The date is received in this format: 'yyyy-mm-dd'. I will like to change the format to 'd. mmm yyy' (like 26. feb. 2003) before posting it to the screen with an 'echo' statement. Any suggest

  • Formatting all date columns in MySQL 2012-06-05

    I am looking for a way to format all date columns in MySQL. I currently have something like this:SELECT DATE_FORMAT(`findamatch`.`dateentered`, '%b %e, %Y') AS `dateentered`, DATE_FORMAT(`findamatch`.`datetoday`, '%b %e, %Y') AS `datetoday`, DATE_FOR

  • Data Warehouse Solutions MySQL PHP 2012-07-11

    dear professionals! I'm newbie to data warehouse and looking for GPL solutions for ETL, reporting and even OLAP. I have read short article about this "Building Data Warehouses with MySQL" http://www.radwin.org/michael/blog/2003/07/building_data_wareh

  • Oracle How do I reclaim the unused space after a huge data delete- very urgent 2012-08-10

    How do I reclaim the unused space after a huge data delete? alter table "ODB"."BLOB_TABLE" shrink space; This couldn't execute with ora 10662 error. Could you please help

  • PHP Date Format Problem & changing data type in MySQL database 2012-10-07

    Two issues: 1.) I have a php script pulling data from a Mysql database. It is displaying the date 2006-12-01 , the default. I need it to display as 01-12-06. This is the code in the php script pulling the data from the MySQL database. I don't know ho

  • difficulty inserting data to local mysql server? 2012-11-18

    all. I got a simple vb6 form that has a dropdowtn box and a text box and a button . Initially the drop down box is empty and i allow to user to enter value in drop down box and text box and click submit. The problem is once i try compile my project i

  • Trying to perfomr update on data selected by mysql drop down list 2012-12-15

    I am trying to allow a user to select data from a mysql table and then update that data. I need two selection criteria for - date and student_id, but I can's seem to get either to display the data after I perform the selection. My code is below and I

  • I do data migration from mysql to Oracle 2012-12-20

    I do data migration from mysql to Oracle. MySQL with 2gb data, oracle on 80 gb disk space is maximized. Why so much disk space is kept.?

  • date stored in mysql as 0000-00-00 2013-02-16

    Can someone help me entering a date "manually" in MySQL thanks here's my code it's currently entering 0000-00-00 in my databse THE HTML <html><head><title>..</title><body><form action="work1.php" method="post">Valu