June 19, 2013

Post: What would make MySQL Multiple Queries Usable ?

September 5, 2007 By 1 Comment

… would make MySQL Multiple Queries API more usable ? Allow to run queries in parallel – The great benefit of knowning all queries at once is…. This could be very well optimized by performing search query only once while having multiple results aggregation routers building the stream from that…

Filed Under: Insight for Developers Tagged With:

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

February 26, 2013 By 1 Comment

… any new features introduced with InnoDB full-text search), that’s largely where the similarities end. NOTE …getting it configured. The second part will compare query results between MyISAM FTS and InnoDB FTS …FT indexes, it’s entirely possible to DROP multiple FT indexes with InnoDB in the same ALTER…

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

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

March 4, 2013 By 7 Comments

…=”alignright” width=”214″] InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a… the docs, if we run a boolean mode query where some of the search terms are prefixed with “+” and others have no… we change the above query to be “+james +peterson arizona” then we might expect to get back multiple matches containing the words…

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

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… solely on query response time for this test. You’re right that the specific results probably vary based on the search implementation, and that’s an important factor in choosing a solution. David S. asked: Q: If searching on multiple terms…, only the documents included in the Sphinx Search indexes will be returned by Sphinx Search queries. Mike W. also asked: Q: What about…

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: Using flow control functions for performance monitoring queries

May 24, 2008 By 12 Comments

…time as well as classifies requests to multiple classes. From the same query we can see portion of requests … +——-+——————-+——–+——–+——–+—————+ | 21954 | 0.36869757085721 | 0.4373 | 0.0545 | 0.0008 | search | | 25843 | 1.1290003426468 | 0.9114 | 0.4267 | 0.0081 …

Filed Under: Insight for DBAs Tagged With:

Post: What to do with MySQL Full Text Search while migrating to Innodb ?

September 10, 2009 By 12 Comments

… desire for better data consistency guaranty or being bitten repairing multiple GB MyISAM table few times, though Table Locks is probably… problem we often run into during migration is Full Text Search indexes which are not supported for Innodb tables. So what… or several of slaves and use it for full text search queries. This approach is helpful if migration has to be performed…

Filed Under: Insight for Developers Tagged With: ,

Post: FaceBook Search, Search for social networks

August 12, 2007 By 4 Comments

… of users with not trivial full text search needs. We’ve recently added support for multiple value attributes which can be used for storing tags or list of friends. We’re now adding support for search… sure Sphinx can be used efficiently to perform queries going beyond full text search. Such as finding the goods from the given…

Filed Under: Events and Announcements Tagged With: ,

Post: Innodb performance gotcha w Larger queries.

August 28, 2009 By 7 Comments

…application and I was replacing single value UPDATE with multiple value REPLACE (though I also saw the same … bug of 5.0. At row0sel.c:row_search_for_mysql() “PHASE 3:”, InnoDB judge whether the …_lock_type != LOCK_NONE && trx->mysql_query_str) { /* Scan the MySQL query string; check if SELECT is the …

Filed Under: Insight for Developers Tagged With:

Post: Introducing our Percona Live speakers

May 10, 2011 By 4 Comments

…’s capabilities. Many people think of Sphinx as a great search engine, but it’s much more powerful than just that…. That’s a nightmare of temp tables and filesorts and multiple queries and all sorts of things in MySQL — and that’s…

Filed Under: MySQL

Post: Goal driven performance optimization

December 22, 2008 By Leave a Comment

… Search taking longer time than other interactions for many applications, and also we speak about percentile response time rather than “all queries“. It is surely good all search queries complete in one seconds but it is too… the queries causing the problem you see the ones which cause the most impact and focus on optimizing them. There are multiple…

Filed Under: Insight for Developers Tagged With: ,
« Older Posts