June 19, 2013

Post: How fast can you sort data with MySQL ?

August 18, 2007 By 26 Comments

…table as I used for MySQL Group by Performance Tests to see how …a variable as my data set fits in memory anyway and decided to…does not optimize “get top N sorted rows” very well it takes just 2.5 times longer than full table…merge_passes are not that bad. Setting your sort_buffer_size large enough so…

Filed Under: Benchmarks, Insight for DBAs Tagged With:

Post: Statistics of InnoDB tables and indexes available in xtrabackup

September 14, 2009 By 6 Comments

… feature goes to a well known Social Network who…that running statistics on your backup database does not need to …how it works. I have one table with size 13Gb what was filled during about 2.5 years. The table is: CREATE TABLE…fitting data into pages) is quite good – 91%. But it was expected, as table…

Filed Under: Percona Software Tagged With: , ,

Comment: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1

October 16, 2009 By 16 Comments

… you have to go to the database which does not have it in the cache so read … to SS tables can be used in MySQL as well. Replace your data to the “daily” small table which fits in ram while select from both small and large table. Do merge in the background. And there is yet another one. How…

Filed Under: Benchmarks, Cloud and NoSQL, MySQL Tagged With: , ,

Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1

October 15, 2009 By 16 Comments

…faced by almost everyone how do you maintain your performance in …mean and lean and performs well. The issue is even … or Cassandra. My Application does the following: A.) read… Seems simple enough right? My two tables each contain 5M rows of…itself. No matter how much you want it to fit, somethings may…

Filed Under: Benchmarks, Cloud and NoSQL, MySQL Tagged With: , ,

Post: A case for MariaDB's Hash Joins

May 31, 2012 By Leave a Comment

… a value of 1024*128*10, which means that your effective join_buffer_size is not bigger than this… query on IO bound workload so that it could fit well in the chart, in actuality the query took 32077… is PK in one table and left-most part of the PK in the second table. How does optimizer work with the…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , ,

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

… them are Innodb specific and it well can affect your workload. So benchmark to be sure. … of concurrency, specifically around mutexes and contention? How does this fit into the development process? HT: Contention …rebuilds the whole table, it may last way too long for your 150 GB table! If you have …

Filed Under: Insight for Developers Tagged With:

Post: Predicting Performance improvements from memory increase

August 7, 2008 By 6 Comments

… set – for example if your main queries do full table scan of 100GB table it does not matter if you… have to be careful and understand how data is used in your application. If you say have data… return it back if it does not fit your needs. This approach especially works well if you have many slaves …

Filed Under: Insight for DBAs Tagged With:

Post: Implementing efficient counters with MySQL

July 1, 2007 By 16 Comments

…your durability requirements this is best thing to do if not you would either use MyISAM table as counter table (can well…tables for this purpose, how do you deal with Table…does but it does not have to do it for the same table…

Filed Under: Insight for Developers Tagged With: ,

Post: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

…that way very early on. If your sphinx index does not fit to one machine, you would…Well, guess what – you can actually utilize this feature to your advantage even if your data can easily fit…table in MySQL to define those ranges, mixing it with sql_query_range or something else, depending on how your…

Filed Under: MySQL Tagged With: , , ,

Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

March 21, 2012 By 10 Comments

… query executed on the InnoDB table: SELECT non_key_column FROM… might be low depending on your scenario. You can read more…’s see how effective is MRR when the workload fits entirely in …be incremented by TWO. It does not actually mean that …of secondary key lookups as well. But this works only with…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , , , , , , , , , , ,
« Older Posts
Newer Posts »