… those are good and I recommend them after reading about how they work. I’m currently preparing our recommendations for a baseline… them to get those settings in place with as little work and study as possible. That still won’t replace an… improve the general quality of configuration overall. Views are my own. For an official Oracle view, consult a PR person. James Day…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… – Meaning it does not work for subselects, inline views, parts of the UNION. This is also common missunderstanding. Works on packet level – This… as a lot depends on statement complexity as well as how much work is saved by query cache. Now lets speak a… can’t change how it works with MySQL to add caching but you can enable query cache so it works faster. Low load…
Post: Just do the math!
July 6, 2009 By 4 Comments
… page views a day you few days of history the queries there instant which gave you a confidence this approach will work… the whole year worth of data you find things not working any more with response times for individual queries taking half… (or say apply mathematical model) you really need to understand how things work. I like to call it having X-Ray vision…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…’s the culprit. This doesn’t always work, and I hate things that sometimes work. They teach you to assume that it… queries in an easy-to-view format, rather than aggregating the worst queries together. This has worked for me a few times… is still open and I am still stumped as to how a SELECT-only transaction can possibly have undo log records…
Post: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
… busy doing MySQL Consulting. Arjen has great writers experience – he worked on MySQL Documentation for many years as well as contributed… on how to make material understandable to the people. Arjen also did fair amount of MySQL Support and Consulting while working for MySQL so he can offer us another competent point of view. Baron has a experience…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…_concurrency_tickets. I’ll try to explain how it works. MySQL has pluginable architecture which divides work between mysql common code (parser, optimizer) and storage engine. From storage engine’s point of view it works how (very simplified…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… understand things affecting recovery time you better to understand how Innodb recovery works. When Innodb recovers from logs it finds the last… the cache and so having pretty scattered updates instead updating view counter for popular movie hundreds of times per second. Database… on systems with large number of hard drives. So how do you estimate how long it takes Innodb to Recover ? Now you…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
…. It also might be more cost advantageous for you to work with us to implement the extra features from MySQL Enterprise… settings. Using Percona MySQL Server Development Services to do this work will ensure you get an optimal and tested build. We… is a lot you can gain by taking a broad view of your MySQL server needs. Chances are custom MySQL server…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… want to give a quick preview, then explain exactly how Shard-Query works.Yes, Shard-Query scales very well at 20 nodes… based systems work well but still, these systems are much farther from optimal than working directly with relational algebra. Materialized views techniques applied… same. All of the fastest incremental materialized view optimizations can be applied. Shard-Query works only on sets Shard-Query takes relational…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…, this is how it needs to work and you don’t suffer critical problem when you have enough nodes. But how can we… [Warning] WSREP: Ignoring possible split-brain (allowed by configuration) from view: view(view_id(REG,7e6d285b-d56d-11e1-0800-2491595e99bb,2) memb { 7e6d285b…-f7c4916d8330, } joined { 7e6d285b-d56d-11e1-0800-2491595e99bb, } left { } partitioned { }) to view: view(view_id(TRANS,7e6d285b-d56d-11e1-0800-2491595e99bb,2) memb { 86928728…
