…, c_acctbal, n_name, c_address, c_phone, c_comment from customer, orders, lineitem, nation where c_custkey = o_….orders.o_orderkey 1 100.00 Using where b. Good Plan id select_type table type possible_keys key…as it is clearly a part of the optimizer’s job to select the best query execution plan. I had…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
…With over a thousand people, the event made a good comeback after last year’s event, but more … everyone felt the energy and enthusiasm. The positive comments on the Internet certainly seem to point that … and James Briggs said that “Percona did a great job.” We appreciate all the kind words, but even…
Comment: MySQL File System Fragmentation Benchmarks
March 23, 2008 By 28 Comments
… tried to point out in my previous comment. Though maybe I didn’t do a good job expressing myself 
The point I was… factor (which by default is 8M I believe) is a good balance.
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… what we think is best for you, which is our job). After the kickoff call, we write some notes, and then… to know.” That’s also why I’ll comment on things that seem good. Clients need to know that I’m being… SHOW INNODB STATUS\G and see if there’s anything worth commenting on there. Depending on the workload, there might be a…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… plug into this post’s comments. I haven’t evaluated their technology, so I can’t comment on it. I’m sure…, of course, is that the sysadmin work is now your job. Finally, there are a number of advantages to working in… very good. Do you have experience running MySQL in the Amazon cloud to share with other readers? I welcome your comments, as…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…name is disclosed to the prospect. It is our job to counsel on the solution, not just an aspect…very educational conversations. This has proven to be a good way to gain at least surface-level familiarity with…. If you have any questions or comments, I invite you to use the comment form, or if it’s not…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…significant time into these projects. Outside observers have commented that our development process doesn’t seem very…discount; it is us contributing towards the public good) and we maintain the feature in subsequent … there is no sense in doing a halfway job of it. So that removes the motivation …
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… time rather than “all queries”. It is surely good all search queries complete in one seconds but … this can be done by adding request ID as comment to Sphinx log so you can profile it …This tells us there is some irregular activity (cron jobs?) is happening and it affects Sphinx layer significantly. …
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
Willem, those are good heuristics, thanks. I think I can respond to the rest of your comment by an anecdotal story. I… they are good — my intent with this article was to show where mk-query-digest is doing an incomplete job and ask… do more of that. Perhaps if it weren’t so good, you wouldn’t say that finding bad queries is “the…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
…previous post I got number number of comments saying if MySQL would not have multiple storage engine… architecture offers but about boring stuff of being good enough database for lower costs. You will find … just looking for database which just has the job done, has quick learning curve is robust and …
