… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… faster. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This is fine as long as you…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… performance possible. At Percona we surely will be doing fine tuning for our Percona Server for MySQL version 5.6 release. Another thing to remember about MySQL 5.6 is – it comes with Performance Schema…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 | 836 | | PERFORMANCE…should help many small sorts for which allocation of 2M for sort buffer was very … one of the component of purging fine tuning in MySQL 5.6 innodb_file_per_…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
…fine tune our customers’ MySQL 5.6 test and production environments, and address any performance issues that might arise. Our MySQL…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… proper indexes or tuning couple of MySQL settings. When low hanging fruits are fixed you end up with either fine tuning which gives little… hardware size. For example right now you can get 8 core x86-64 box with 32G with good price/performance value while… on he market offering services around MySQL and LAMP and MySQL is one of them. Plus for large companies it may make sense…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… with systems that are at any level of tuning, from completely untuned to a system that’s … the MySQL server. I mean, let’s just assume the physical hardware and the machine setup is fine, …this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done …
Page: Consulting for MySQL
July 31, 2006 By
…performance issues ? We can help. Full Text Search applications. Need help with implementing Full Text Search solution ? We can help with fine tuning MySQL…needs. Platform advice and support for MySQL Need choosing Hardware and OS for MySQL ? Performing configuration and troubleshooting platform …
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… Text Search solutions and compare their performance. Even if you missed the webinar, you can register for it, and you’ll be…, and two SSD drives: one for the Windows partition, and one for the MySQL data partition. I performed all the tests on this machine… equivalent with MySQL and it wouldn’t be as flexible and customizable as Solr. With Solr, I was able to fine tune search…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… I wrote about four fundamental metrics for system performance analysis. These are throughput, residence time,… bit longer. This is common in MySQL servers I work with when … “static”, sort of like de-tuning the radio just a little bit…and as you slice it more finely, you see jagged edges. Most servers…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…for me to look at a…Performance Overhead Checking whether the connection is active typically involves a call to the ‘ping’ or ‘statistics’ command at the MySQL…query times down, and some highly tuned apps are worried when their … works fine in the lab, and even in the field, until performance really …
