…selectivity (over 50% matching rows) simple full table scan with limit actually would offer best …agree with you. Everything has its purpose – sphinx is designed exactly for usages where relevance…MySQL has no way to use multiple CPUs for such query. Even with MySQL Cluster sort would be done on MySQL…
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
… week average) real deadlocks with up to 120 load average, mysql master restart needed and apache servers as well. At first… all the parameters I could think of, and mysql processes showed in issue periods multiple copies of the same query, sometimes with… your opinion? What do you think of Sphinx to substitute the fulltext search on MyISAM table? Peter, I owe you a beer…
Comment: Full text search for all MySQL Storage Engines
February 12, 2010 By 37 Comments
… better to cron it and rebuild at interval. In fact, MySQL documentation indicates it is much faster to rebuild sometimes as… multiple FT indices is NOT to do so, and create a table or column that puts all the information together. Unfortunately, in MySQL… returned anyway. I have reasonable success with MySQL 5.1 and 100k+ product rows. Sphinx is better in some ways, but FT…
