I have innodb tables in my production database and i have set files_… abc engine=innodb and re-executed SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), ‘MB’) DATA, CONCAT(ROUND(data_free… not be defragmented. is there any other way to defragment innodb tables? thanks Kuldeep
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb… so that we can see the impact of growth in data-set on the insert rate. We can see that adding…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it…). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to work if you… was: I could only use mysqldump to import all the data into a clean/fresh innodb system! Good luck! Thomas
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… replication thread. For example if I need to delete old data instead of DELETE FROM TBL WHERE ts
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… afford to loose 1 second worth of data, hence I did not test with innodb_flush_log_at_trx_commit=1. I would also not recommend running on EBS with innodb_flush_log_at_trx_commit=1, because IO times on…
Comment: SHOW INNODB STATUS walk through
May 15, 2012 By 40 Comments
… the different tables for the innodb (Standard, Lock,Tablespace,Table) and the server doesn’t report the data as described every 15…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… 13384 Innodb_data_read 5G 5.4G 2.2G 5.4G 2.2G 2.2G Innodb_data_reads 329115 355323 143808 335526 16164 15506 Innodb_pages_read 329115 355323 143808 358308 144798 144881 Innodb_rows_read… values for Innodb_buffer_pool_reads and Innodb_data_read. We can see that with appropriately sized buffers less no. of Innodb_buffer_pool…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… param for InnoDB are [root@ng-lg-mdb1 ~]# cat /etc/my.cnf|grep innodb innodb_data_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional…
