…16 cores/32 cpu…a bit …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…mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to 32…the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core …data manageable. MySQL Master Master Manager can help you to automate it a bit. I …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…memory available but since we run on 32 bit we cannot turn up the innodb_buffer_pool higher than 1.8G right? …mysql 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: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…bit CPU. From this and what I saw earlier I can see whether someone installed a 32-bit OS on 64-bit…InnoDB buffer pool…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…. Aside from MySQL Cluster, which is…innodb_buffer_pool_content group by 1, 2, 3 into outfile ‘/tmp/buffer-pool…–execute h=passive After a bit I CTRL-… 5.73 1.32 . 3.13…pool. Same table, same size of data doesn’t mean same buffer pool contents. An insert-only workload will probably fill the buffer pool…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 Comments
… in InnoDB with MySQL 5 and RHEL 5. Its a 32 bit machine with 12 Gb RAM. The imp param for InnoDB are …:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… also it can release individual pages from its 32 ‘fragment extent’ pages. PZ: This is the …”often” a bit stikes me here. I thought it would be always single read, typically 1MB in size. I…out not buffer pool but some other important parts of MySQL process. Q20: We’ve migrated to using INNODB so…
Comment: Choosing innodb_buffer_pool_size
January 10, 2012 By 39 Comments
…from the people writing the software. Normal 32-bit applications can only “see” 32-bits worth of system RAM, regardless of …bit in prod). I set my buffer_pool size to 40000M on a box with 55G. I was expecting to see MySQL … you be so kind as to elaborate on how innodb preallocates buffer space? Best,…
