…n_name, c_address, c_comment order by revenue desc LIMIT 20; In-memory workload Now … in the index record to make a lookup in the PK. Both these lookups are performed in… 1 100.00 Using where b. Good Plan id select_type table type … in the optimizer, as it is clearly a part of the optimizer’s job …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…think is best for you, which is our job). After the kickoff call, we write some notes,… looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up…performance audit, although as you’ve seen there really isn’t any such thing. Post your questions in the comments…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… is now your job. Finally, there are a number of advantages to working in the AWS …, performance can be quite acceptable or even very good. Do you have experience running MySQL in the Amazon cloud to share with other readers? I welcome your comments…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…research in part, but not perform the full and balanced disclosure that Percona would perform…job to counsel on the solution, not just an aspect of the solution in…This has proven to be a good way to gain at least …comments, I invite you to use the comment form, or if it’s not appropriate to discuss in…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…in given example. For goal driven performance optimization it is important there is enough instrumentation and production performance logging in… request ID as comment to Sphinx …performs as good as it performs during its worst times so it is very good…irregular activity (cron jobs?) is happening and…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…in our own MySQL builds and then in OurDelta builds and perhaps others as well XtraDB, which is our new high-performance…. Outside observers have commented that our development …in our own tree and making our own builds, and there is no sense in doing a halfway job… as the public good. That’s the …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…added my comments to some of the questions. HT will stand for Heikki Tuuri in the answers… of optimization. I frequently see batch jobs killing server performance overtaking buffer pool. Though full table…in less than 100 microseconds. And if you do not have, then the only way to get good performance…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
…too much load? I have done many performance tuning jobs, and my first task is to quantify the…good tool for this. Can you explain what you mean with : “In all of the above cases, the additional information in… bad queries? Let me know by posting in the comments.” (1) I look at the cardinality (…
