… that I used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb… innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the… concerned with write performance is using partitioning to reduce the size of the B+tree, having multiple buffer pool instances to…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… to 128M, which does not 100% accurately reflect log file size x 4 factor. But I can change that options at… to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite difficult….g instead of 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full…: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full…/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M [root@tstlx1 mysql]#
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… seem to be able to able to change the logfile size in a 5.0.95 MySQL database running on RHEL… to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb_log_file_size = 64MB Then: /sbin/service mysqld stop Then…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… RAM, Inno would hit a memory wall. Given that Memory sizes are perhaps 10 times bigger than they were 4 years…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
… 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929, query…
Comment: Testing Fusion-io ioDrive
May 4, 2012 By 1 Comment
Vadim, Do you have response time distribution for writes ? Also what Model/size of ioDrive is this ?
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… i originally posted, the log files were created with the size i specified. I wonder how many other configuration values have…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
… the configuration go for example default_storage_engine, query_cache_size, e.t.c…. Is it something built in or we…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… ~300s while when both the join_buffer_size and the read_rnd_buffer_size/mrr_buffer_size were set to 6M, the query…/ join_buffer_size=6M & mrr_buffer_size=6M MariaDB 5.5 Hash Join Disabled w/ join_buffer_size=4M & mrr_buffer_size=4M Created… BKA relies on both the join_buffer_size and the read_rnd_buffer_size/mrr_buffer_size and both of these buffers should…
