Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » ibdata1 file size
ibdata1 file size [message #826] Tue, 27 February 2007 11:37 Go to next message
vrkris is currently offline vrkris
Messages: 6
Registered: August 2006
Junior Member
Hi,

I have configured an Innodb whose ibdata1 file size has grown to about a 100G but when I purged about 90% of the table data the ibdata1 file size still remained the same. Am I missing something here or is the tablespace designed that way? Any tips to help me reduce the ibdata1 file size please.
Report message to a moderator
Re: ibdata1 file size [message #830 is a reply to message #826 ] Tue, 27 February 2007 13:18 Go to previous message
aronrosenberg
Messages: 16
Registered: September 2006
Junior Member
The InnoDB table space file will never get smaller even if you purge data.
Report message to a moderator
Previous Topic:ORDER BY … LIMIT Performance Optimization
Next Topic:Figuring out the slowest queries in db.
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Sun Jul 5 17:24:24 EDT 2009

Total time taken to generate the page: 0.02331 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.