June 19, 2013

Post: Sphinx at MySQL Meetup at San Francisco

… upcoming MySQL Meetup at San Francisco this Thursday, August 13. I will talk about Sphinx covering the new cool features this search engine has as well as showing the demo on how simple it is to use Sphinx to implement high performance full text search for your MySQL driven application. We also will have…

Post: MySQL Consulting - Being on your own

… 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… optimization of full text search applications, especially after we brought Andrew Aksyonoff to the team. Projects Leaving MySQL we wanted not only…. In the Open Source area we work on Sphinx Search as well as bunch of MySQL related scripts. As a summary we have…

Post: Percona Live is on Wednesday - thank you to all our sponsors

… speakers include presenters from Rightscale, Clustrix, RethinkDB, Zmanda, Percona, Continuent, Sphinx Search, Fusion-io, Schooner, Scalr, CouchOne and FathomDB.  (I say… the best ignite talk. We would also like to thank Sphinx Search, Ivinco, Circonus, MariaDB, ScaleDB, Scalr, Surge, WebYog, Zmanda, Schooner, RethinkDB…

Post: Webinar for Full Text Search Throwdown

… text indexing for MySQL applications, including: LIKE predicates and regular expressions MyISAM FULLTEXT indexes InnoDB FULLTEXT indexes Apache Solr Sphinx Search Trigraphs I’ll compare the performance for building indexes and querying indexes. If you’re developing an application with text search

Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo

… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa… (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building on Strengths…

Post: Friends of Percona Get 20% Off at the MySQL Conference!

… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa… (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building on Strengths…

Post: Talking MySQL to Sphinx

… in the full text search performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather interested… approximate – this is geared towards full text search applications when exact number is not important. Sphinx mysql> select max(forum_id) as m… will likely stabilize soon. Sphinx also offers number of extensions to the SQL which are helpful for search use cases – WITHIN GROUP…

Post: Goal driven performance optimization

…) mysql_ratio ,avg(sphinx_time/wtime) sphinx_ratio, avg((wtime-mysql_time-sphinx_time-utime)/wtime) lost_ratio from performance_log_081221 where page_type=’search…: mysql> select date_format(logged,’%H’) h,count(*),avg(wtime),avg(sphinx_time/wtime) sphinx_ratio from performance_log_081221 where page_type=’search

Post: Sphinx 0.9.8 is released just in time for OSCON 2008

… we actively support Sphinx as in our opinion it is great complement to MySQL when it comes to full text search tasks and other real time information processing applications. It integrates with MySQL and… (similar to what MySQL build in full text search uses) you can get performance another 20-100% better though search result quality will…

Post: MySQL Performance Blog now uses Sphinx for Site Search

… find something on MySQL Performance Blog. Today we have published new search functionality for our site which is based on Sphinx. We have… Sphinx query language to search phrases or Search MyISAM in post title. Besides basic search functionality we’ve implemented list of last searches and Top searches