June 19, 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…_size = 1000 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: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

…­-time=7200 ­­–max­-requests=0 ­­–percentile=95 ­­\ –mysql­-user=root –mysql­-socket=/tmp/mysql.sock ­­–mysql­-table­-engine=innodb ­­\ –oltp­-read­-only=off run…_size = 1000 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

… referring to the amazing MySQL manual, especially the option and variable reference table….checksblogpercona.commanual ft_boolean_syntaxblogpercona.commanual ft_max_word_lenblogpercona.commanual ft_min_word_lenblogpercona.commanual ft_query_expansion_limitblogpercona.commanual ft_stopword_…

Filed Under: Insight for DBAs, MySQL

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

March 4, 2013 By 7 Comments

… set innodb_ft_min_token_size to 4 (rather than the default of 3) so that it matches MyISAM’s default ft_min_word_length. First, MyISAM, with MySQL 5.5, on the SEO data set: mysql: SELECT id, title, MATCH… raise the question of why it works with MyISAM when ft_min_word_length defaults to 4, but that is a topic for…

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

Post: MySQL Full Text Search in Action

February 7, 2008 By 9 Comments

… MySQL but unlike craigslist it looks like they are shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word…. At the same time we can find V40 which means ft_min_word_len was adjusted from default value of 4 which probably…, which we’re often using with MySQL – Sphinx Search we still tend to use stop word list for performance reasons, but it…

Filed Under: Insight for Developers Tagged With:

Post: MySQL Server Variables - SQL layer or Storage Engine specific.

June 8, 2006 By 14 Comments

… disk tables and HEAP for in memory tables. So first MySQL versions did not bother naming variables with storage engines prefix… really. You still have some tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables… make sure data hits the disk ft_boolean_syntax, ft_max_word_len, ft_min_word_len, ft_query_expansion_limit, ft_stopword_file FullText search related variables…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL 5.6.7-RC in tpcc-mysql benchmark

October 8, 2012 By 22 Comments

… two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at… change the result significantly, especially in intensive IO workloads. In MySQL 5.6 it is finally possible to achieve stable throughput…_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M server…

Filed Under: Benchmarks, MySQL

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

February 26, 2013 By 1 Comment

… sec) mysql> select * from information_schema.innodb_ft_config; +—————————+———+ | KEY | VALUE | +—————————+———+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 1032677 | | last_optimized_word | | | deleted… quite right. Intuitively, I would expect some changes in total_word_count, or optimize_(start|end)_time, and the like. However… to the default InnoDB settings for MySQL 5.6, and that was to change innodb_ft_min_token_size from the default of…

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

Comment: ORDER BY ... LIMIT Performance Optimization

September 1, 2006 By 100 Comments

…`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CNF ——- [mysqld] socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 256M…=6 net_buffer_length = 8K log-slow-queries=/var/lib/mysql/astdb01.as.osti.local-slow.log log-warnings=2 max…_connections=1000 max_heap_table_size=1073741824 local_infile=0 ft_min_word_len=3 tmpdir = /opt/ key_buffer_size=256M connect_timeout…

Filed Under: Insight for Developers Tagged With: ,

Comment: Database problems in MySQL/PHP Applications

November 6, 2006 By 13 Comments

… MySQL clients [client] #password = your_password port = 3306 socket = /tmp/mysql.sock #tmpdir =/mysql_tmp/ # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind… of CPU’s*2 for thread_concurrency thread_concurrency = 8 ft_min_word_len=3 #skip-grant-tables # Don’t listen on a…

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