June 18, 2013

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

…=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max… query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…

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

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

April 8, 2013 By 5 Comments

…for generating reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM…288+ n_length+int_length+com_length > 65535L || int_count > 255) { my_message(ER_TOO_MANY_FIELDS, ER(…length. This isn’t the normal meaning of the word interval, we can only guess that it’s …

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

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

… MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench ­­–num­-threads=32 ­­–test=tests/db/oltp.lua ­­–oltp_tables_count…­-time=7200 ­­–max­-requests=0 ­­–percentile=95 ­­\ –mysql­-user=root –mysql­-socket=/tmp/mysql.sock ­­–mysql­-table­-engine=innodb ­­\ –oltp­-read­-only=off run… 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: , , , , , , ,

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

… am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just….commanual ft_boolean_syntaxblogpercona.commanual ft_max_word_lenblogpercona.commanual ft_min_word_lenblogpercona.commanual ft_query_expansion_limitblogpercona.commanual …

Filed Under: Insight for DBAs, MySQL

Post: Be productive with the MySQL command line

December 21, 2012 By 14 Comments

… SQL words. Instead of manually editing the statement, which will be boring, you simply call edit: mysql> edit…Database changed mysql> select count(*) from sakila; ERROR 1146 (42S02): Table ‘sakila.sakila’ doesn’t exist mysql> select count(*) from film; +———-+ | count(*) | +———-+ | 1000 |…

Filed Under: Insight for DBAs, MySQL

Post: MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

…worse then “WHERE a IN (2,3,4)”? Another word is range for IN clause better than BETWEEN? A… fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal … more. Would doing a SELECT competition_id, COUNT(user_id) AS user_count FROM user_competition_entry GROUP BY …

Filed Under: Insight for DBAs, MySQL

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

May 16, 2011 By 5 Comments

… version as run by the native database interface (MySQL): mysql> select word, md5(word), md5(reverse(word)), count(*) from words2 group by 1,2,3 order… 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 `words2` GROUP…

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_STOPWORDS.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 …limit | 180 | | synced_doc_id | 1028261 | | last_optimized_word | | | deleted_doc_count | 0 | | total_word_count | | | optimize_start_time | | | optimize_end_time | | | stopword_…

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

Post: The two even more fundamental performance metrics

May 5, 2011 By 6 Comments

… are exponentially distributed. This is typical. In other words, there will be a steady but variable “white noise…, maybe a bit longer. This is common in MySQL servers I work with when they’re running … between seconds will be small. So if we count the arrivals and completions in each second, and …

Filed Under: MySQL

Post: Introducing tpce-like workload for MySQL

February 8, 2010 By 6 Comments

… with TPC-E License Agreement, which in human words is: You can’t name results as “TPC… and/or compare with available Storage Engines for MySQL. The workload in tpce is quite different from tpcc…Failed: 0 41.7342 TpsE where you can see count of successful TR (TradeResult) transactions, and the summary…

Filed Under: Benchmarks, MySQL Tagged With:
« Older Posts