… NOT NULL, k INTEGER UNSIGNED DEFAULT ’0′ NOT NULL, c CHAR(120) DEFAULT ” NOT NULL, pad CHAR(60) DEFAULT ” NOT NULL, PRIMARY KEY… DEFAULT ’0′, `mid` int(10) unsigned NOT NULL DEFAULT ’0′, `id` bigint(20) unsigned NOT NULL, `k` int(10) unsigned NOT NULL DEFAULT… = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… HDD storage configuration? After creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL… that the best vCache performance results were obtained with the default vCache configuration, I think vCache can be declared the clear…_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…ft_boolean_syntaxblogpercona.commanual ft_max_word_lenblogpercona.commanual ft_min_word_lenblogpercona.commanual ft_query_expansion_limitblogpercona.commanual ft…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
… their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for Audi A6 will give you a lot… the same time we can find V40 which means ft_min_word_len was adjusted from default value of 4 which probably had even worse… “stop words” rarely cause problems with sphinx because it uses word position based ranking not just frequency based ranking by default which means…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…) default NULL, `DESCRIPTION` varchar(1024) default NULL, `OTHER_INFO` varchar(1024) default NULL, `CATEGORY` varchar(3072) default NULL, `REMARKS` varchar(1024) default NULL, `…=1000 max_heap_table_size=1073741824 local_infile=0 ft_min_word_len=3 tmpdir = /opt/ key_buffer_size=256M connect_timeout=…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… of CPU’s*2 for thread_concurrency thread_concurrency = 8 ft_min_word_len=3 #skip-grant-tables # Don’t listen on a TCP…” option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication log-bin=db1-bin… #master-password = # # The port the master is listening on. # optional – defaults to 3306 #master-port = # # binary logging – not required for slaves…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer…
Comment: FreeBSD tests
August 4, 2006 By 15 Comments
…_concurrency=16 \ –thread_stack=196K \ –query_cache_size=0 \ –ft_min_word_len=4 \ –default_table_type=MYISAM \ –transaction_isolation=REPEATABLE-READ \ –tmp_table_size…
