… it can read queries from MySQL query-log and MySQL tcpdump files and run them on other MySQL server. With Percona Playback you… change can affect the overall performance of your MySQL database server. Percona Playback for MySQL can also help evaluate new server versions, patches and… been implemented that can be used for dispatching queries to MySQL database servers. This feature introduces new –thread-pool-threads-count…
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… usability was one of the evaluation points and combine that with the fact that the best vCache performance results were obtained with…
Post: Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
March 13, 2012 By 5 Comments
… to Turbocharge Your MySQL Performance Using Flash Storage” (From Virident side: Shridar Subramanian and Shirish Jamthe). Running MySQL on SSD… MySQL environments Evaluation criteria and techniques for selecting the suitable flash-storage technology for the relevant MySQL workloads Price/performance …
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This… a plug into this post’s comments. I haven’t evaluated their technology, so I can’t comment on it. I…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… different memory allocators and what difference we will see in MySQL performance in this scenario? Let me share a conclusion first: If… more than 8 cores – you should try/evaluate alternative allocators; it can notably boost your MySQL server at no cost. Also, an… not by MySQL. Notes regarding jemalloc version I’ve used in my tests: I’ve noted notable impact on MySQL performance after version…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
…’d expect folks interested in efficient schema design for high performance to get a lot of out of Rick’s talk… when this was not the case at a MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to solve… you’re stuck trying to choose an HA solution, then “Evaluating MySQL High Availability alternatives” (3 hr) is for you. Full disclosure…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… overview of several Full Text Search solutions and compare their performance. Even if you missed the webinar, you can register for…: one for the Windows partition, and one for the MySQL data partition. I performed all the tests on this machine. I realize… on the blog post where I announced the webinar: We evaluated MySQL vs Solr. I was able to index all the data…
Post: Clustrix benchmarks under tpcc-mysql workload
October 26, 2011 By 9 Comments
… time on the evaluation of Clustrix product, and this is the report on performance characteristics of Clustrix under tpcc-mysql workload. I tested… comparison. Standard dislaimer: this post is part of paid evaluation we perform for Clustrix, but is totally independent and fully reflects our…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… entirely (we may suggest caching, or tell the customer to evaluate Sphinx, or something like that.) In the common case, though…
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… do what you’re implying here. 2-4 will be evaluated as math expression and the result will be IN(-2… “`id` = 5″ and “`id` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert id IN (5…
