…aggregate and summarize data. Using the aggregated data …Sphinx or Solr only the rows that change. Feed third party replication systems. Provide data to “external triggers…triggers must be changed. The work in the trigger is immediate and affects every transaction. Finally, MySQL has limited trigger…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… “shadow” MyISAM table which is used for full text search. In certain cases you can just use MySQL triggers to maintain such table, in… can work pretty well. Use Sphinx or other external full text search engine This is what we use a lot especially if performance…. This eliminates the need to have MyISAM table anywhere. We use Sphinx in a lot of cases as it is very easy…
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
… however comes back in multiple pieces and if you’re using mysql_use_result you can do any work between fetches, which potentially… typical cause of aborted connections while using Sphinx with large data sets and large buffers. While indexing Sphinx performs sorts and flushes buffers to the disk every so often which can take long enough to trigger default net…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… for example. (The INFORMATION_SCHEMA query will surely trigger errors about this.) There are a bunch … If it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or … suggest caching, or tell the customer to evaluate Sphinx, or something like that.) In the common case,…
Comment: Full text search for all MySQL Storage Engines
February 12, 2010 By 37 Comments
… be too hard to use a MyISAM table just for search, and keep the information via rules (functions, triggers, whatever). In a… or column that puts all the information together. Unfortunately, in MySQL, there are no expression-based indexes, but I’m not… returned anyway. I have reasonable success with MySQL 5.1 and 100k+ product rows. Sphinx is better in some ways, but FT…
