… you’d like us to present at yours! We can also give internal presentations for your company or group. Sphinx search engine… Sphinx Full Text Search solution and comparing it to the alternatives. Slides by Andrew Aksenoff, Russian Language. Download MySQL Performance Optimization Russian Internet…
Post: Tools and Techniques for Index Design Webinar Questions Followup
October 4, 2012 By 5 Comments
… recording. I’d like to invite folks who are interested in tools for query optimization to attend the … relevant to current versions of MySQL. Q: How do the upcoming changes in MySQL 5.6 change the … scope of the search, the index search will be even more efficient than if you were searching for the …
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx …Search. [root@r27 sp]# mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL…rows in set (1 min 15.03 sec) Another optimization I wanted to check is the “early …
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 14 Comments
… I’m using some silly like query to illustrate some search is required, so count(*) can’t be optimized away for MyISAM Tables… | +——+—–+ 10 rows in set (21.12 sec) mysql> select count(*) cnt from dt where slack like “a%”; +———+ | cnt | +———+ | 2352996 | +———+ 1 row in…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… does MySQL Related work – it is very hard to find people with good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching… have them resolved. If you think you know MySQL well and would like to work in young and active company let us… implementing and performance optimization of full text search applications, especially after we brought Andrew Aksyonoff to the team. Projects Leaving MySQL we wanted…
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
…search URLS, such as “dev.mysql.com/download/mysql-5.1.html” would match “mysql.com”, “dev.mysql.com”, “dev.mysql.com/download/” and “dev.mysql… use link_date in () and link like “prefix%” which allows to use both…great as there is still room for optimization – Sphinx stores word positions in the …
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,…MySQL, you will need to aggregate your data. What you want to do is aggregate in ways that optimize…traditional DW methods, like star schemas. The problem is that MySQL doesn’t tend …
Page: Consulting for MySQL
July 31, 2006 By
…expertise in MySQL Server and performance optimization. Solutions and Competitive Benchmarks If you’re hardware or software vendor and would like to get…Text Search applications. Need help with implementing Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search …
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 8 Comments
… hired at MySQL. The assumptions about what are typical MySQL may have been true then in 2004, but they are likely not true… the so-called “greedy optimizer“, I did some experiments to determine what is a reasonable limit for the search depth (and the total number of tables) that can be optimized in reasonable time. I reached…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… same components. Tagging, friends, queues, click tracking, search, paginated displays — we’ve seen these and … there. So at this point, it looks like MySQL is probably a good place to look … big gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index …
