… of sessions we have: Sphinx: High Performance Full Text Search for MySQL (Andrew) EXPLAIN Demystified (Baron) The MySQL Query Cache (Baron) Investigating Innodb Scalability…. Andrew and Aurimas will be on on .org Both for Sphinx project showing some cool demos – we’re bringing few servers…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
…operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables and materialized views using Flexviews Scaling Applications with Caching, …Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text …
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
…operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables and materialized views using Flexviews Scaling Applications with Caching, …Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text …
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
…’ve already wrote a few times about various projects using Sphinx with MySQL for scalable Full Text Search applications. For example on… of problematic search urls does not allow to use pre-caching not to mention general load on server such batch processing… parallel processing using sphinx pretty good solution for many data crunching needs especially when lack of parallel abilities in MySQL makes its…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max…, or even eliminated entirely (we may suggest caching, or tell the customer to evaluate Sphinx, or something like that.) In the common…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… can be the problem, not to mention Key Cache which often becomes serious contention issue. The problem … search. In certain cases you can just use MySQL triggers to maintain such table, in other cases … search results it can work pretty well. Use Sphinx or other external full text search engine This …
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… retrieval. Even in this case however the cache (ie memcache) is often implemented to offload MySQL. When it comes to large scale… Hadoop or Sphinx used to crunch data in parallel or it even could be special wrapper on top of MySQL do do… need, even on the roadmap. Indeed MySQL has MySQL Cluster but it is quite different. MySQL Cluster at this point is a cluster…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL but this role does not suite…. I’m saying about Prepared Statements in MySQL 4.1 which came without query cache support but even worse not all of… very long time. For example Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and Most of other…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…: mysql> select count(*),avg(wtime),avg(utime/wtime) cpu_ratio, avg(mysql_time/wtime) mysql_ratio ,avg(sphinx_time/wtime) sphinx_ratio, avg((wtime-mysql_time-sphinx… main factor because sphinx and MySQL respond from cache. We however see for pages which have the problem it is Sphinx which accounts for…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… and mysql 4.1.18 was used in all cases – SQL_NO_CACHE was used in order to avoid hitting the query cache… (limit each word internally to 2000 hits): 1.66 seconds Sphinx: 16.31 seconds Vectorbased search: 0.06 seconds On xp3200+ windowsbox: Vectorbased search: 0.01 seconds I dont know how sphinx stores data internally but hopefully something of what I have…
