June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

… help resolve the obtuse errors that a database sometimes gives related to failures due to constraints. One of the things that… the table sizes and an easy way to use the search feature of your browser to zero in on a particular…

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

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

February 26, 2013 By 1 Comment

… was the only storage engine with support for full-text search (FTS). And I’ve encountered many customers for whom the… same (modulo any new features introduced with InnoDB full-text search), that’s largely where the similarities end. NOTE 1: I….ibd file just yet; I thought it might be somehow related to a custom stopwords table, but that doesn’t seem…

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

Post: EuroOSCON 2006 - High Performance FullText Search

September 22, 2006 By 4 Comments

… Europe thing. I gave a talk on High Performance FullText Search for Database Content which is now available for download from…’ve done so it will be helpful for full text search benchmarks with your own data. It was great to see… not know. This year were were quite a few talks related to Mobile market. It does not seems to have same…

Filed Under: Events and Announcements Tagged With: ,

Post: The case for getting rid of duplicate “sets”

May 17, 2011 By 2 Comments

… numbers (and their desired minimum cardinality) to a “search set” table: CREATE TABLE `search_set` ( `val` bigint(20) DEFAULT NULL, `cnt` bigint… join search_set using (val) where compressed.cnt >= search_set.cnt; mysql> select * from compressed join search_set using (val) where compressed.cnt >= search… this on our original relation before compression? This is a way to do it without using the “search set” trick above. Also…

Filed Under: MySQL

Post: Speaking on OSCON 2007

July 3, 2007 By 2 Comments

… and Performance related questions could be taken care of on it. We’re also organizing Open Source Full Text Search BOF to hear from people working developing or using Full Text Search and related solutions. One of the… a better understanding of what people need from Full Text Search applications and which kind of problems they have with existing…

Filed Under: Events and Announcements Tagged With:

Post: MySQL Consulting - Being on your own

February 20, 2007 By 7 Comments

… Related work – it is very hard to find people with good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching… work is designing implementing and performance optimization of full text search applications, especially after we brought Andrew Aksyonoff to the team… Open Source area we work on Sphinx Search as well as bunch of MySQL related scripts. As a summary we have 70…

Filed Under: Events and Announcements Tagged With:

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

… has 4091 buffer(s) 2208.17 hash searches/s, 175.05 non-hash searches/s This section shows insert buffer and adaptive… some pages to speed up row lookup replacing btree search with hash search. This section shows hash table size, number of used… of log/io operations allows to separate tablespace related IO from log related IO so you can see how much IO your…

Filed Under: Insight for DBAs Tagged With:

Comment: Full text search for all MySQL Storage Engines

June 28, 2006 By 37 Comments

… and then you have a lookup table which stores the relation between wordid and docid. The problem with this method compared… means that also the speed of the search is significally improved since having a search that contains 10 most common words means….66 seconds Sphinx: 16.31 seconds Vectorbased search: 0.06 seconds On xp3200+ windowsbox: Vectorbased search: 0.01 seconds I dont know…

Filed Under: Insight for DBAs Tagged With: ,

Page: Presentations

May 3, 2006 By

… various things in MySQL as well as solve other performance related problems. Download Innodb Performance Optimization MySQL Users Conference 2007, Santa… dump, when we compare it to other opensource full text search search engines such as lucene,sphinx,tbgsearch,sienna, mnogosearch and perform…

Filed Under:

Post: Sphinx Developer joins our team

January 8, 2007 By 7 Comments

… to announce Andrew Aksyonoff, developer of popular OpenSource full text search software Sphinx joins our team. Andrew will now have more…’ll be able to solve all kinds of problems related to full text search, tagging and general information retrieval. It does not… high quality or complex full text search applications – but If you’re looking at smaller search applications we can help you getting…

Filed Under: Events and Announcements Tagged With:
« Older Posts