…MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full Text Search…
Page: Consulting for MySQL
July 31, 2006 By
…needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL …help. Full Text Search applications. Need help with implementing Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 13 Comments
…for Sphinx – Full Text Search Engine which we love to use where large scale search is needed. At… this problem we also store inbound links clustered by second level domain which allows to…Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other domain to search…
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
…full text search matching, but it is still extremely fast doing data crunching. I just tested right now performing search …one of our clients which uses cluster of 3 nodes to handle search. In this case no …with other databases which may be slower than MySQL. MySQL Make it so one would not need …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… engines (something even PostgreSQL does not have) as well as Full Text Search parses but there is very long way to go before… use them same as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but it does not… not think MySQL Cluster would ever be that thing as it provides too strong guarantees. It is same as with MySQL Replication – the…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…results and full-text search. Understand when to leverage MySQL features such as stored procedures, triggers and events. Operating and Troubleshooting for MySQL on …space work. See how key features of InnoDB work, including clustered indexes, insert buffer, adaptive hash and double write buffer. …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…/DRBD yes NDB Cluster yes 3. Does your application use MyISAM only features? There are some features like Full text indexes and GIS… “MySQL replication” and “Master-Master with MMM manager”. Depending on the application, the MyISAM Full text indexes might be replaced by another search engine…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
…. It integrates with MySQL and scripting languages very well, it is simple, it performs well and it is easily clustered, allowing you… ranking (similar to what MySQL build in full text search uses) you can get performance another 20-100% better though search result quality will be…
Comment: Using Sphinx as MySQL data retrieval accelerator
November 7, 2006 By 25 Comments
… each. MySQL has no way to use multiple CPUs for such query. Even with MySQL Cluster sort would be done on MySQL server – single… do not want full text search on the contrary they are asking about query to return all result set from full text search keyword matching standpoint…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…. On the benefits side we usually see clustering by primary key, caching data, higher concurrency,… moving to Innodb are typically Full Text Search and RTREE indexes/GIS with Full Text being much more common. … exercises not so common paths in the MySQL server – in particular Optimizer may have harder…
