…! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 120502….sock’ port: 3306 Source distribution Also, I don’t see how MySQL could be using any other conf file other than… [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M [root@tstlx1 mysql]#
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so that the relevant pages were already loaded in the buffer pool. …how effective are the join optimizations when the workload is IO bound. For the purpose of benchmarking IO bound workload, the InnoDB buffer pool size…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… how effective is MRR when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to… see how effective is MRR when the workload is IO bound. For the purpose of benchmarking IO bound workload, the InnoDB buffer pool size is set to…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc…set (0.00 sec) Innodb Memory Usage Finally it is often helpful to check how much memory Innodb… Dictionary memory allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1 …
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: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… your Innodb Buffer Pool 10% less than your database size you would not loose much anyway. You also may choose to set buffer pool as if your database size… is usually much better to simply check it. Start MySQL With 10GB Innodb buffer pool for example and see how large RSS and VSZ get…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…Innodb talks and during consulting engagements. It is well known to get better performance you should normally set innodb_log_file_size…to recover longer. Buffer Pool Size This affects recovery time from two parts aspects – first if you have small buffer pool…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 11 Comments
…size, 2) fit_pct FROM (SELECT index_id, COUNT(*) cnt, SUM(dirty = 1) dirty, SUM(hashed = 1) hashed FROM innodb_buffer_pool…set (0.04 sec) This query shows information about how many pages are in buffer pool for given table (cnt), how…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
… a queue and wait to continue execution. InnoDB doesn’t provide us a way in which to determine how many concurrency tickets …settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…to the first file in the log file group? HT: InnoDB writes the checkpoint information to the first file. Q31: How…set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer pool. For this, you need to… innodb_buffer_pool_size…
