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 …
Comment: 7 Reasons why MySQL Quality will never be the same
December 11, 2008 By 15 Comments
… replication doesn’t cause problems like it used to. The good old days weren’t perfect. In MySQL 4.0, a… it should be. Documentation and comments are missing for implementations and interfaces. There are few architectural comments in the code or external documents. There is too much code that does a bad job of reinventing…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: 1 row in set (0.02 sec) The table…next. Lets see if situation is dramatically different. The good news though is even though performance advantages of buffered…a minor item – Database Scientists will never have their job complete…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… questions out of this. I had added my comments to some of the questions. HT will stand …Another possible area of optimization. I frequently see batch jobs killing server performance overtaking buffer pool. Though full… not have, then the only way to get good performance is to set innodb_flush_log_at_…
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: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
… jobs, and my first task is to quantify the problems: Figures vs gut-feelings. Maatkit’s mk-query-digest is a good… detecting bad queries? Let me know by posting in the comments.” (1) I look at the cardinality (number of records) visited…
Comment: Guidance for MySQL Optimizer Developers
September 23, 2009 By 4 Comments
… not work, this is debatable. I will not comment on the relative quality of Oracle/MySQL/PostgreSQL … DBA is an invaluable tool to get the job done, especially for large databases, in a high …Results of a query optimizer can only be as good as the collected statistics, which are sometimes quite …
