Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Gavin Towey (gtoweyffn.com)
Date: Thu Nov 19 2009 - 02:52:50 CST
Assuming you're using either myisam tables, or innodb with file-per-table option turned on, then dropping a whole partition at a time will allow you to reclaim disk space.
If you're using innodb with a single tablespace currently, then unfortunately, you would have to export all your data, shutdown mysql, change you're my.cnf & delete the tablespace & ib_log files, then restart and re-import all your data. If you need to do this, you should probably seek a bit more information about from this list or other sources.
From: Krishna Chandra Prajapati [mailto:prajapatikcgmail.com]
Sent: Thursday, November 19, 2009 12:13 AM
Subject: DELETE DATA FROM TABLE
I have a crm table where 12 millions records inserted/day. We are running
report queries on this table and using partitioning features for faster
results. we have to maintain 45 days data means 540million records. As per
my calculation 540 records will use 1.8 TB of disk space. Total disk space
available is 2.3TB.
Deleting data doesn't free up the disk space. So, I was thinking of rotating
the table. But doesn't have enough disk space.
Any Idea, how this task can be performed.
Any idea or suggestion is highly appreciated.
Thanks & Regards,
Krishna Ch. Prajapati
The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql