… n_name, c_address, c_phone, c_comment from customer, orders, lineitem, nation where c_… to perform the index record read and then to perform the MRR range scan on the… 1 100.00 Using where b. Good Plan id select_type table type …clearly a part of the optimizer’s job to select the best query execution …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… are at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? We … think is best for you, which is our job). After the kickoff call, we write some notes,… know.” That’s also why I’ll comment on things that seem good. Clients need to know that I’…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
…comment on it. I’m sure their funders would like us to evaluate them on a paid basis and report to our readers on…course, is that the sysadmin work is now your job. Finally, there are a number of advantages to… a lot of I/O, performance can be quite acceptable or even very good. Do you have experience…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…be done by adding request ID as comment to Sphinx log so you can…cause the most impact and focus on optimizing them. There are multiple ways … performs as good as it performs during its worst times so it is very good to… there is some irregular activity (cron jobs?) is happening and it affects Sphinx …
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…XtraDB, which is our new high-performance transactional storage engine Maatkit, which is…released yet. The general public. People comment on our blog posts, or send us … is us contributing towards the public good) and we maintain the feature in… no sense in doing a halfway job of it. So that removes …
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…we performed paid evaluations or that we were given free hardware to test. If another vendor brings a good solution…is disclosed to the prospect. It is our job to counsel on the solution, not just an aspect of … If you have any questions or comments, I invite you to use the comment form, or if it’s …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… this. I had added my comments to some of the questions….expect serious improvements are possible especially on high IO pressure workloads. Q7:…. I frequently see batch jobs killing server performance overtaking buffer pool. Though…then the only way to get good performance is to set innodb_flush…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
… have a big impact on the database ( responsetime times frequency… I have done many performance tuning jobs, and my first task is to quantify the problems: Figures vs gut-feelings. Maatkit’s mk-query-digest is a good…know by posting in the comments.” (1) I look at the…
