… Innodb Buffer Pool 10% less than your database size you would not loose…size on the big boxes, though it can be even less than that. Besides Operating System needs you also have MySQL… Note it is not enough to block OS from swapping – as I …hurts – when you do not have RAID with BBU and your workload …
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
…RAID 10 + BBU is probably the most common and natural choice for write stressed servers (ps: I asked about RAM size… would allow exposing this to consumers (although MySQL offers INSERT DELAYED). Back to the subject,…spreads writes to emulate some randomness (wrt block device layout) or is it more of …
Post: Innodb Double Write
August 4, 2006 By 24 Comments
… use 4K block sizes by default so 16K could use more than one fragment. Also if software RAID is… buffer. How much does double write buffer affect MySQL Performance ? Even though double write requires each page… general I would expect no more than 5-10% performance loss due to use of doublewrite. Can…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… MySQL C API and the server side prepared statement. The server has 8core CPU and RAID storage …storage. main common settings innodb_buffer_pool_size = 2048M innodb_thread_concurrency = 0 innodb_…10)Â * Usual value innodb_buf_flush_burst (default 100) * Burst value These control the number of blocks…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…while to understand if MySQL goes through more …RAID level for write intensive database systems, you will have 2 hard drives to pick reading any block. RAID controller (and even software RAID…block on 1TB hard drive you will have 10 seeks condensed in 1/10… various seriolization, stripe sizes, cache …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… An InnoDB extent is a contiguous block of 64 pages, 16 kB …larger than 16K – is exact size allocated or also segment based …do 1 write than flush 10 non sequential pages from it …innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_… do not have RAID with BBU. With good RAID with BBU you…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
…–oltp-range-size=0 –mysql-table-engine=innodb –mysql-user=root –max-requests=0 –max-time=60 –mysql-db=test… this is not RAID controller related we repeated the run on the in memory block device and got…sec with sync-binlog=0 which is about 10% overhead. EXT2 filesystem also behaves similar to …
