…something else (i.e. xfs) should be used. Traditionally our recommendation is xfs, and it comes to known …STEC for providing drives). What I see, that ext4 still has problem with O_DIRECT. There are results for “…. This is to another question I was asked, namely: “If MySQL 5.5 uses async IO, is …
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
… to implement, and you are not comfortable with our report, then we may not allow you to mention our name at all. If a…. Our willingness to protect the integrity of our name through such direct action serves as a strong deterrent to most misuse. If you are… have no formal partnership or other relationship, but we have what you could call an “informational” partnership. For example, we sometimes…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… to fetch every distinct KEY_COLUMN_USAGE.CONSTRAINT_NAME where the REFERENCED_* columns are non-null. From that information, we can generate… about foreign key constraints from the INFORMATION_SCHEMA, but what if our database includes relationships for which we never declared foreign key…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…is the desire for “real-time” analysis. Our customers often want their systems to provide …with anything, it’s a cost-benefit equation. What are your priorities? Choose the solution that meets them… build “flexible schemas” with tables that contain name-value pairs or something similar. The thought …
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… application level. So, first of all, a few words about our data set we’ve used for this benchmark. We have… KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM; All cities_* tables have 1,5M records each and records are distributed among 29 different… from those 1000 runs. So, our first benchmark is simple: we need to get 5 names of cities, located in Minnesota and…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…. We don’t involve the community very much in our decisions about what features to include, or how they should get built…-source are not a potluck dinner where everyone brings something and puts it on the table. These builds are stamped with our name and are downloadable from our website. They’re a core part of our offering to customers (and…
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By 1 Comment
… to the release of our new MySQL monitoring plugins on Friday, one commenter asked…variable names is the other one, of course). Now, somewhere along the line “you should cache when you are monitoring…I see actually have multiple people running innotop or what have you, once a second! Second, if your …
Post: Progress with ClickAider project
October 24, 2007 By 21 Comments
… down. We get some 600 tracking events per second on our lighttpd tracking servers which currently works well and there is… what are the most popular click directions for US audience compared to general audience or track performance for referrals from given domain name… Adds on that site. If you have any other ideas what would you like to see implemented in ClickAider, let us…
Comment: Why MySQL's binlog-do-db option is dangerous
May 14, 2009 By 12 Comments
… exactly what you are doing at the application level. We use this feature for Tungsten Replicator catalogs–replicating them would break our application. We have very flexible filters both on the master as well as the slave but our experience has been exactly what Baron found, namely that filtering on the slave is best…
Post: What does Using filesort mean in MySQL?
March 5, 2009 By 27 Comments
…if they are too big, but EXPLAIN doesn’t show that. (If I interview you, I might ask you what “too big…tables go to disk!) The truth is, filesort is badly named. Anytime a sort can’t be performed from an …executes ORDER BY. You can also read about it in our book, but if you read Sergey’s article you …
