… Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database administration… select the queries you should try to improve to get optimal response times pt-archiver, to efficiently purge purge data from… MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of tools that can help serious MySQL administrators perform…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode….g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but nothing unexpected. So… cause much confusion. Even though the read-only transactions optimization in MySQL 5.6 virtually eliminates contention on the mutex protecting the…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
…you can use MySQL 5.6 built-in methods to analyze them for optimal query efficiency. The discussion will cover optimizer reports, query profiling, and session status to measure performance. The query patterns…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases… can spend a lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup now avoids loading non-relevant… #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters… configuration C appeared to produce the most optimal results, I moved on to reviewing FlashCache performance versus that of vCache, and I…
Post: MySQL Performance - eliminating ORDER BY function
October 17, 2007 By 6 Comments
One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants or order … phase can be skipped all together. Note in this case MySQL Optimizer is rather smart and is able to do this even… functions are different MySQL is not able to do this optimization even in cases when this would be possible: mysql> explain select * from…
Post: Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
March 13, 2012 By 5 Comments
… MySQL Performance Using Flash Storage” (From Virident side: Shridar Subramanian and Shirish Jamthe). Running MySQL…performance advantages (ROI) when flash storage is used appropriately for MySQL workloads Approaches for scaling MySQL instances on fewer servers while delivering optimal performance…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…which has the highest performance optimization potential. But let us get back to the Server Side Optimization. Lets assume our performance goal applies to…mysql_time/wtime) mysql_ratio ,avg(sphinx_time/wtime) sphinx_ratio, avg((wtime-mysql_time-sphinx_time-utime)/wtime) lost_ratio from performance_…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…. That would clearly save indexing space. Is this a reasonable performance optimization. (Keep in mind that the prefix adaptive hashing would fail… key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary key… “`id` = 5″ and “`id` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert id IN (5…
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
… MySQL Performance Optimization and so MySQL Optimizer is quite important to me. For probably last 10 years I chased first Monty and later Igor with Optimizer… CPU and IO cost. Focus on Execution Methods Performance problems can be due to optimizer picking the wrong plan, such as doing…
