… Innovation I think happens with custom storage engines which are not designed to be run as core storage engines and are not match of functions… memcache or external search engine . As MySQL 5.1 and plugable storage engine interface matures I hope we’ll see more storage engines which are great…
Page: Presentations
May 3, 2006 By
… presentation about designing distributed LAMP…search functionality using real medium size text collection – Wikipedia Articles dump, when we compare it to other opensource full text search search engines…Storage Engine. Especially if you’re migrating data from other databases or other Storage Engines…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…insert (while Selects are running) for MyISAM storage engine. Other Storage engine ether always have it (ie Innodb) …which affects all tables but it was designed for MyISAM tables. It makes little …_query_expansion_limit, ft_stopword_file FullText search related variables. As FullText currently works …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and… per day becomes a fixed overhead of storage size. So, you actually have … with 10-15x fewer servers. Clever application design, and a holistic approach, are absolutely necessary…
Post: ClickAider - Track Adsense Clicks and much more
July 9, 2007 By 17 Comments
…know much more. We wanted to know which search engine keyword bring traffic which clicks, which countries … is also quite helpful. When I was designing another Web Statistics System – SpyLOG back in … and mostly Innodb storage engines. Initially we tried to use PBXT for log storage but it had …
Page: Consulting for MySQL
July 31, 2006 By
…, Caching etc. MySQL High Availability design and implementation Design of High Availability architecture… old ones. Storage engine development assistance If you’re developing MySQL Storage Engine, Appliance… Full Text Search applications. Need help with implementing Full Text Search solution ? We…
Post: Report from OSCON 2008
July 27, 2008 By 7 Comments
… build in full text search look too good to be true. I’ve clarified this comes from the design consideration which was built well exactly for the task while full text search in database systems if…. Monty’s Maria storage engine was only one which had dedicated session on OSCON (I did session which covered various storage engines) which was…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…reason is normally table design and understanding inner works of MySQL. If you design your data …for MySQL and other way around. Even storage engines have very important differences which can affect …is less of the problem. Data retrieval, search, DSS, business intelligence applications which need …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… most of those demand using some other storage engine like Archive… > 3. Using multiple databases Honestly … background. > Things are different with MySQL. Good design will help dictate how many tables are… the table) are potentially very valuable if searches are done against that information. On the …
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… fall into this trap, but if you search Google for Key_read_requests, you will … (anti-tuning anti-utilities?) for Oracle, specifically designed to mock and frustrate those who would …dedicated to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM, which is more …
