MySQL Forums
Forum List  »  InnoDB

optimizing compression
Posted by: Jens Bijell
Date: September 26, 2013 08:23AM

Hi,

I'm currently in the process of compressing a rather big database and there are 2 tables which last pretty long.

One is of size in FS:
# ls -lh *campa_placementidlist1*
-rw-rw---- 1 mysql mysql 8.5K Sep 11 11:54 campa_placementidlist1.frm
-rw-rw---- 1 mysql mysql 288G Sep 24 12:05 campa_placementidlist1.ibd

It currently runs since over 47 hours although we have a pretty strong server:
Mem: 148267056k with 24 cores
# innodb parameters
innodb_data_home_dir=/mysqldb/data
innodb_file_per_table
innodb_file_format=BARRACUDA
innodb_data_file_path = ibdata1:100M:autoextend
innodb_buffer_pool_size=112640M
# innodb_buffer_pool_instances=8
innodb_log_file_size=1024M
innodb_log_buffer_size=10M
innodb_thread_concurrency=16

I also can't find any temporary table on disk, so I assume it's handled completely in the cache.
That's why I'm thinkinf of defining a high temp_table_size of 8GB or more.
But I first want to let it complete. There is one gt 900 GB table left to compress ...

Is there a way to improve this? Any timps or comments on this are welcome.

Best Regards,
Jens

Options: ReplyQuote


Subject
Views
Written By
Posted
optimizing compression
2141
September 26, 2013 08:23AM
758
September 27, 2013 07:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.