… is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many people fail to provide any reasonable answer to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to… of tuning, from completely untuned to…to look at MySQL Assuming I don’t see anything noteworthy here, I’ll move on to the MySQL server…to be found. The real gold mine is yet to come. After…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…how we can get a word out where and how to generate leads. In fact we did not have to…indexes and tuning MySQL Server settings. It is more the question of knowing there to change…after we brought Andrew Aksyonoff to the team. Projects Leaving MySQL we wanted not only to work as consultants but also to…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… it’s time to take off the gloves. I claim that somewhere around of 99% of advice about tuning MySQL‘s key cache… know how long of an interval I used to measure the statistics on those two servers. Maybe I measured the first server immediately after starting… measure. How to choose a key_buffer_size Let’s recap. So far I’ve shown you the fallacy of tuning by ratio…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… following results: As you see with Percona Server we have stable and predictable lines. Now, how to compare these results ? If we draw…, jitter (after initial warmup 1800 sec) So, in the conclusion, you can see that with a proper tuning, Percona Server/XtraDB outperforms MySQL, and…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…how to compute up to this point. You can calculate the standard deviation, the median, any desired percentile (depending on how…longer. This is common in MySQL servers I work with when …isn’t really true, but after you see the plots, …to find the place where we get some “static”, sort of like de-tuning…
Post: How to estimate query completion time in MySQL
April 22, 2008 By 14 Comments
… of the simplest is to estimate how many rows the query needs to examine, measure how fast it’s working,…very large, and after some tuning (I’ll write more about that later) I convinced MySQL to perform the query…lot of activity on the server, I wouldn’t have been able to say with confidence that SHOW…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…it hard to understand how exactly MySQL Query Cache…populating the cache after table update invalidated …tunings to prioritize which queries are more important to…to Query Cache to make it cool again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 16 Comments
…happens with regular MySQL replication if you imprudently write to the wrong server. This is…s see how it works. With our Cluster you can write to any …as it happens in the background after the response on certification. The …many parallel threads, and you can tune it by variable wsrep_slave_threads…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… CPU to spare. We’re using Percona Server …mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock prepare Running Sysbench and MySQLDump. Note we run them in the loop to see how…we run them concurrently after system reaches steady …advanced tuning you might also look into changing how …
