June 19, 2013

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

May 1, 2013 By 10 Comments

Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … stay with MyISAM nowadays i.e. if you have FULLTEXT you simply cannot replace in short term. Control Your Auto-Incrementing Columns…

Filed Under: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster Tagged With: , , , ,

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

February 26, 2013 By 1 Comment

… table for the SEO dataset looks identical, except that we replace “full_name” with a VARCHAR(255) “title” and “details” with…: mysql> alter table dir_test_innodb ADD FULLTEXT KEY (full_name, details), ADD FULLTEXT KEY (details); ERROR 1795 (HY000): InnoDB presently supports one FULLTEXT… what happens: mysql> set global innodb_ft_aux_table=’test/dir_test_innodb’; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from…

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

Comment: EuroOSCON 2006 - High Performance FullText Search

September 23, 2006 By 4 Comments

… to find a replacement of mysql fulltext for the forum at http://www.tbg.nu In my case the problem with mysql fulltext were that… irrelevant in this case :-) All the three reasons above made mysql fulltext to virtually puke when a client performed a search which… word. I assume the reason for that is that the mysql fulltext internally will first find all hits for each word (since…

Filed Under: Events and Announcements Tagged With: ,

Comment: Full text search for all MySQL Storage Engines

June 27, 2006 By 37 Comments

… have been for the past months experimenting with various fulltext engines since the mysql fulltext has it limitations specially when used in boolean…, does the implementation of sphinx as plugin for mysql 5.1 mean that mysqls own fulltext engine will/might be replaced shortly by sphinx ?

Filed Under: Insight for DBAs Tagged With: ,

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

March 4, 2013 By 7 Comments

… address, and the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration …escape hatch from this rabbit hole. When defining a FULLTEXT KEY, you can use the “WITH PARSER” modifier to…to use InnoDB FTS as a simple drop-in replacement for your current MyISAM FTS, the results may surprise…

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

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

June 8, 2006 By 14 Comments

… for in memory tables. So first MySQL versions did not bother naming variables …_expansion_limit, ft_stopword_file FullText search related variables. As FullText currently works with MyISAM …_cache_division_limit Key Cache/Key Buffer replacement algorithm configuration variables. Obviously only apply …

Filed Under: Insight for DBAs Tagged With: ,

Comment: Full text search for all MySQL Storage Engines

July 3, 2006 By 37 Comments

…the possibility of having mysql use sphinx as its native fulltext engine ? First, I think there’s some work do in … replacement to MySQL‘s own FT. Second, even when that’s done, including Sphinx into MySQL would depend on its owners – that it, MySQL…

Filed Under: Insight for DBAs Tagged With: ,