…writes. Why log? Since InnoDB tries to keep the working set in memory (InnoDB Buffer Pool), therefore the …has much faster access than the underlying disk(s). How are the REDO records applied? InnoDB processes the … much larger logs beyond the InnoDB limit of 4G. As a side effect of logging there is …
Post: How long is recovery from 8G innodb_log_file
December 22, 2010 By 11 Comments
… Percona Server is support of innodb_log_file_size > 4G. This test was done using Percona Server 5.5…. InnoDB-plugin and MySQL 5.5. The valid question how long is recovery in this case, so let’s … tachIOn card and killed mysqld after 30 mins of work. The recovery time after start is: for 52GB innodb_…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… a 4G buffer pool, which is larger than the data. Very little tuning was done. The goal was to see how MySQL… IO cost significantly) And finally, testing with a 4G buffer pool shows how the system performs when the data fits completely into… small buffer pool (the buffer pool is smaller than the working set) having innodb_old_blocks_time=1000 appears to cause…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… Join. This join algorithm only works with equi-joins. Now let me briefly explain how hash join algorithm works. Suppose you have two…. This step is known as probe step. This join algorithm works best for highly selective queries, and obviously when the first… 12889 335080 14067 13384 Innodb_data_read 5G 5.4G 2.2G 5.4G 2.2G 2.2G Innodb_data_reads 329115…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… give a high level picture of how Lazy Drop Table works and how the new DROP Table works in MySQL >= 5.5.23. After….5.23 work, I would like to mention quickly, that how drop table in MySQL < 5.5.23 used to work. When dropping… at 90, while the InnoDB log files were sized at 4G. The configuration and dataset sizes were chosen, so that the…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
…case. First, some facts about the system and how data was lost: MySQL had a dedicated … partition was scanned in like 5 minutes and all 4G of innodb pages were successfully written to …sequences against all pages. Note however that only works for text in uncompressed text columns (varchar, char, …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… it was installed with default settings. I’m surprised how many people fail to provide any reasonable answer …not rare to see key_buffer being set to 4G while combined size of .MYI files is just 1GB…transactions. If you have update activity spikes however or work with blobs a lot you might want to …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…start to respond slowly and the first task which was working quite well has a very poor insertion rate now. …80% of your computer’s memory innodb_buffer_pool_size=4G innodb_additional_mem_pool_size=20M # Set the log …me “if you don’t know how to do it, hire a guy that know how to do it…” Thanks a …
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
…that changes. The biggest thing that changes is just how you pay your bill. Having said that, there’… Most High Availability tools (like MMM or DRBD+Heartbeat) work on the principal of having a floating IP …store, it costs $2094 to upgrade an R900 from 4G memory to 64G (or $4378 to upgrade to 128G…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… MySQL like my-large.cnf, my-innodb-heavy-4G.cnf and so on have the thread_concurrency….com/bug.php?id=55001 2- It only works on old Solaris versions < 9 The idea of ..._concurrency: http://www.mysqlperformanceblog.com/2011/07/28/how-innodb-contention-may-manifest-itself/ http://www.mysqlperformanceblog…
