… R720 (16 cores/32 cpu threads) All… applicability is quite limited. Namely, it … is probably a bit closer to real…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…two-year old HT’ed XEONs to 32 GB, 4x quad-core AMD Opterons….this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL…on to quantify what are the limits of different operations for different levels…help you to automate it a bit. I also like to keep tables small…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…32 bit we cannot turn up the innodb_buffer_pool…innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool_size=20M innodb…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…size drops below this limit, merging it to a neighbor is tried */ #define BTR_CUR_PAGE_COMPRESS_LIMIT (UNIV_PAGE_SIZE / 2) Q5: When Innodb…its 32 ‘fragment …bit more work. Now it is allocated permanently in the system tablespace when an InnoDB instance is created. PZ: Sequential “dump” of buffer pool…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… clflush size : 64 cache_alignment : 64 address sizes : 38 bits physical, 48 bits …bit CPU. From this and what I saw earlier I can see whether someone installed a 32-bit OS on 64-bit…hard to read. If the InnoDB buffer pool is set to 22GB, …The stock MySQL server’s limitation of one-second granularity …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… of threads, and data size increases how does …server resources are rather limited but I thought…the smaller buffer pool struggled ( why a smaller buffer pool? …Tyrant may stumble a bit. Bottom line given… were run with 32 Threads, Tyrant was…256M allocated to the innodb buffer unless otherwise noted. …
