…to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql…innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…setting, which basically controls how important is the file cache for Linux. Basically, with InnoDB…to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb buffer pool…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 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…. It 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: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…INNODB_PAGES_READ | 191570 | | INNODB_ROWS_READ | 910844 | +—————————————+—————-+ 10 rows in set (0.01 sec) mysql> select sq.*, pages / ((@@innodb_buffer_pool_size / 16384)) * 100 pct_buffer_pool…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… innodb_buffer_pool_size was set to anything more than 62 GB. I decided to try it with 76 GB. The error message was an assert due to… pattern of requested allocations I added a debugging fprintf() to tell me how much was being allocated and whether it was successful… is in proportion to the setting of innodb_buffer_pool_size for the blocks array. The exact proportions will probably vary from version to version, but roughly…
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 12 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 5 Comments
… a queue and wait to continue execution. InnoDB doesn’t provide us a way in which to determine how many concurrency tickets… –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…to the MySQL queries would make them even slower, I’m sure. Indeed, the result set…to increase innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM FT index, I reallocated that memory to into key_buffer_size…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…about testing writing to many files and seeing how this affects sequential read performance. I was very interested to see how it shows …to random tables. I used default MySQL settings for MyISAM (table_cache=64) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2 innodb_log_file_size…
