…MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL…MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
…Read on to see the list of sessions we’re presenting at the…MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL… MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx …
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… years in MySQL I have created more than hundred of such little projects suggested by MySQL customers and myself based on long MySQL usage for Web. Later I stopped adding these because I have not seen much traction for these tasks as well as of…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing and Sales departments and of course loyal community of millions of users… the whiteboard or to have mini training done about efficient MySQL usage, or simply when security is too tight or time is… we work on Sphinx Search as well as bunch of MySQL related scripts. As a summary we have 70+ hours of work per week…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… ask how many disks they have instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be… we can comfortably put in MySQL Instance without getting in too much trouble with backups etc – because Sphinx is doing all search… of the data is a good idea as Matt says – you do not want your runaway logs or extreme temporary space usage…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… time of the problematic pages: mysql> select count(*),avg(wtime),avg(utime/wtime) cpu_ratio, avg(mysql_time/wtime) mysql_ratio ,avg(sphinx_time/wtime) sphinx… usage as the main factor because sphinx and MySQL respond from cache. We however see for pages which have the problem it is Sphinx…
Page: Presentations
May 3, 2006 By
…. Sphinx search engine for RDBMS Egypt, December 2007 Presentation about Sphinx, the tasks it solves, internals and examples of usage …MySQL Settings which should be tuned for optimal MySQL performance giving some advice of selecting prover values for them. Download MySQL Performance CookBook MySQL…
Comment: Using Sphinx as MySQL data retrieval accelerator
November 7, 2006 By 25 Comments
…purpose – sphinx is designed exactly for usages where relevance is very important. No speaking about why Sphinx is faster (by the way if you would check the link I have provided in the top of… such query. Even with MySQL Cluster sort would be done on MySQL server – single node. And …
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… for index process. With Sphinx which talks directly to the MySQL database we can get some 10.000 of documents indexed per second… general we’ll be adding features to the Sphinx to accommodate special needs of some applications. As you can take a look… required to avoid massive data duplication for some usages. We also already make sure Sphinx can be used efficiently to perform queries…
Post: Percona's patches spread to a wider audience
October 13, 2008 By 7 Comments
… patches, etc) and storage engines (PBXT, Sphinx, etc) that aren’t in the main MySQL server. Arjen Lentz is really the brainchild… judgment about what’s the state of the art in the MySQL server for real-world usage, and we have no plans to change that. The OurDelta project is a great way to get pre-built versions of…
