Showing entries 1 to 1
Displaying posts with tag: multiple tablespaces (reset)
Jun
16
2009
InnoDB tablespace, single Vs. multiple, and InnoDB defragment
Posted by Mohammad Lahlouh on Tue 16 Jun 2009 09:58 UTC
Tags:

The ibdata file is too big 10GB, and actually we've only about 2GB (data+index) in innodb storage engine.How we can defragment this file and reduce it?How is this happened?By default the ibdata file created initially by (innodb_data_file_path = ibdata1:10M:autoextend) and auto extended by (innodb_autoextend_increment = 8MB) when it’s needed, and this file (tablespace) contain all innodb tables (

Showing entries 1 to 1