…comments, response time is way more important metric to compare. I want to pretend that we pioneered (not invented, but started to use widely) a…to answer on questions like: – When we add additional node to a cluster (e.g. XtraDB Cluster), how…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… us how we do a performance audit (it’s our most popular service). I thought I should write a blog post that will both answer… why I’ll comment on things that seem good. Clients need to know that I’m being thorough. Once upon a time, a Percona consultant… isn’t any such thing. Post your questions in the comments, and I’ll try to answer them as time permits.
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…a performance…to have. What was the query, for example? With the text of the SQL in hand, we might be able to answer…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…a month since I promised Heikki Tuuri to answer Innodb Questions. Heikki is a busy man so I got answers to…comments to some of the questions. HT will stand for Heikki Tuuri in the answers…performed in the Unix version with a single thread. Only one read-ahead can be happening on Unix at a time. On…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… provide my comments for some of the answers under PZ and will use HT for original Heikkis answer. Q26: You also say on Unix… purpose, and how much performance gain there might be. HT: I guess the log writes themselves are much more a problem to the SDD… performance testing going on to quantify what are the limits of different operations for different levels of concurrency, specifically around mutexes and contention? How…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…that you expose to us determines how knowledgeable we …a product to perform very well on a specific benchmark, and you want us to…to speak. The answer is that vendors might not be ready with their product. We aren’t here to…comments, I invite you to use the comment form, or if it’s not appropriate to…
Comment: What to tune in MySQL Server after installation
July 27, 2008 By 116 Comments
…a problem is: commondreams.org Each time I try to EDIT one of my posts, I am allowed (once) to perform…comment_content, comment_author_IP, comment_date_gmt FROM wp_comments WHERE comment_ID = You aren’t allowed to edit this comment…a “tech-type”, so please try not to answer…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…comments. Let me start by giving some short answers which I’m sure will lead to…a lock, which is unthinkable from a performance perspective. So Falcon keeps a…to fit on a page or change size and no longer fit. We could move a record to a…
Comment: COUNT(*) vs COUNT(col)
April 11, 2007 By 41 Comments
… the performance of counting all the rows in a table. This discussion is a good example of Peter’s other comments today … simple answers are… is a good idea to have a more complete understanding of the technology, so you can make the best decisions on how to apply it to your…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…to have releases of Percona Server/XtraDB based on the MySQL 5.5 code line. The answer…to having several buffer pool instances that are supposed to fix the buffer pool scalability issue. Let’s see how MySQL performance… pool scalability in a different way. UPDATE By request from commenter I put …
