June 18, 2013

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

May 31, 2013 By Leave a Comment

… the exact column definition in the same order. In other words, it checks for duplicate keys, but not redundant ones. What…

Filed Under: Insight for DBAs, MySQL, On Ground Training, Percona Toolkit, Training Tagged With: , , , , , , , , ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… it will produce all good amount of reads. A few words about the hardware: I am going to use new the… query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

… query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M server…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Comment: Open Source, the MySQL market (and TokuDB in particular)

May 10, 2013 By 13 Comments

… any user can easily get your software installed. In other words, it’s all the surrounding costs, not the creative fun…

Filed Under: MySQL Tagged With: , , , , , , ,

Comment: How to start a Percona XtraDB Cluster

April 27, 2013 By 10 Comments

…_safe call and insert a new line containing the single word shift in the line directly above that. The “shift” will…

Filed Under: Percona Software, XtraDB Cluster

Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)

April 17, 2013 By 10 Comments

… SSHing to localhost and then doing the restart. In other words, log out and then log back in, and then do…

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

Post: Understanding the maximum number of columns in a MySQL table

April 8, 2013 By 5 Comments

… interval length. This isn’t the normal meaning of the word interval, we can only guess that it’s called this…

Filed Under: MySQL Tagged With: , , , , , , , ,

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

March 25, 2013 By 2 Comments

… series, 2.2 features are not yet finalized. In other words, we may change things like the pt-query-digest –output…

Filed Under: Percona Software, Percona Toolkit Tagged With: , , , , ,

Post: Using any general purpose computer as a special purpose SIMD computer

May 16, 2011 By 5 Comments

… TO SHARDS: Array ( [0] => SELECT word AS `word`,md5(word) AS `md5(word)`,md5(reverse(word)) AS `md5(reverse(word))`,COUNT(*) AS `count(*)` FROM words2 AS… TO SHARDS: Array ( [0] => SELECT word AS `word`,md5(word) AS `md5(word)`,md5(reverse(word)) AS `md5(reverse(word))`,COUNT(*) AS `count(*)` FROM words2 AS…

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… we might expect to get back multiple matches containing the words “James” and “Peterson”, and we should expect the record from…_name | score | +———+——————+——-+ | 1310720 | Terry Lynn Suter | 0 | +———+——————+——-+ In the immortal words of Homer J. Simpson, “D’OH!!” Why is MyISAM able…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts