… we’re doing kind of “boolean full text search“. Plus we can make index built sorted by timestamp which would allow to… for SQL databases rather than full text search applications. Group By was added to Sphinx so we could search number of matches per day, or number of matches per language. For…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…no indexes there defined – Sphinx does not support explicit indexes and it is clear when you can use index for…of extensions to the SQL which are helpful for search use cases – WITHIN GROUP ORDER BY allows to…be able to talk to MySQL these days. Now on performance – for given class of queries Sphinx …
Comment: Full text search for all MySQL Storage Engines
February 28, 2007 By 37 Comments
… index for two forums. Size is 2 Million records and 100,000 records. Average new rows per day 400. Average page hits per day 250,000 I’m very unhappy about using MyISAM for obvious table locking reasons and issues. The combination of complicated (long) search… that don’t use FT search could run without slowdown from the normal table … A FT search for Inno would propably the easiest…
Page: Consulting for MySQL
July 31, 2006 By
… for. Remote DBA Services for MySQL We act as your remote MySQL DBA – manage users, make sure server runs well on day to day basis, install security updates, perform schema maintainance setup backup procedures, pro actively monitor server to avoid downtime. Customized Training for… Text Search applications. Need help with implementing Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search indexing…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… indexes for MyISAM tables. Good for …For example Innodb tables do not support them. So in practice it is MyISAM related. expire_logs_days…search related variables. As FullText currently works with MyISAM tables these are MyISAM related. join_buffer_size Buffer used for joins without indexes…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… OpenSource projects such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel….have) as well as Full Text Search parses but there is very long…go in stable release just the day before it is released. With …it stays where for very long time. For example Query Cache support for Prepared …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… and others, it’s easy and familiar for me to use the example of search engine marketing. I’ll do that throughout… null, …. primary key(day, ad, is_blue) ); What can we improve here? Especially assuming that there are indexes other than the primary key, we can shrink the primary key’s width: create table ads_by_day_by_blueness ( day…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… days) Here are some more details. oprofile: 867964 15.1181 mysqld btr_cur_search_to_nth_level 792651 13.8063 mysqld btr_search…_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::index_read,handler::read_ra nge_first,handler…_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::index_read,handler::read_ra nge_first,handler…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… It may be as simple as adding few indexes and tuning MySQL Server settings. It is …good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching for them, Yahoo is also on …very chaotic – we may have work piling or days becoming idle pretty quickly. With customers it …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… they become so large it would take days to do operations on them. Idea for Heikki – it should be possible to implement… of table online. Q38: Seems that adaptive hash indexes are not used for primary key lookups or not showed up in â….00 hash searches/s, 15979.01 non-hash searches/s HT: Strange, primary key equality searches should work through the adaptive hash index! What…
