… The ping RTT latency between these nodes was right around 100ms. All environments used Percona Server or … contained the tuning: wsrep_provider_options = “gcs.fc_limit = 256; gcs.fc_factor = 0.99; gcs….optimizing the PXC 2-colo result, but I intend to do so soon. I would not be surprised to get…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
Comment: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… between hard parse (find out how to get the data – explain plan) and soft parse (check …avoid future hard parsing and weight on the optimizer engine? Your discussion above about “smart query matching…well. As I recall there is some limitations in MySQL around cursors, and that the parse, execute …
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… than it can write to disks. Eventually it gets into an “async” state, where InnoDB tries to …InnoDB is looking in an area of 128 pages around page P, and flushes all the pages in …have a throttling mechanism that will limit the rate of changes in memory. Optimize the flushing of sequential neighbor …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… the end for most users – you do not get to deal with recovering tables on the crash …this is deliberate choice with system being optimized to deal with MyISAM limits, for example there is a dedicated … stopper for them move until it is worked around. Operations What is good for MyISAM kills Innodb, …
Comment: ORDER BY ... LIMIT Performance Optimization
February 17, 2011 By 100 Comments
… running into issues with wrapping my head around this whole MySQL optimization stuff. Anyways, I get the jist of it, however, I run… anybody to write me anything, I’m just looking to get a better understanding of this: SELECT `id`, … more *necessary* columns… AND `city` = 35859 AND `visible` = 1 ORDER BY `price` ASC LIMIT 0, 10 Now, `category` numbers represent different listing types, ie…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…optimize and execute queries; mysqld creates internal structures for the query plan, for example, and keeps it around… (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | +—————–+ | 1 | …some things that have no defined limits. It’s not something that’s…
