…its inner workings well enough to answer questions about its internals from memory, such as “how does the insert buffer work?” or “how does MVCC work on…storage engines and appliances, etc. Technologies such as LVS, Nginx, Sphinx, and load balancers. Other operating systems such FreeBSD and …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… keeping in touch with what the lead consultant does. We want two sets of eyes on things…is where you need to really know how to write queries and how EXPLAIN works. At Percona, we have peer …may suggest caching, or tell the customer to evaluate Sphinx, or something like that.) In the common case, …
Post: MySQL Performance Blog now uses Sphinx for Site Search
February 15, 2008 By 52 Comments
… never liked how build in Wordpress search works. it shows full documents rather than snippets it does not search comments and it does not… new search functionality for our site which is based on Sphinx. We have developed it as WordPress plugin which will be… be relevance of freshness. You can also use query standard Sphinx query language to search phrases or Search MyISAM in post…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
…hard depending on how search is implemented is counting number of results matched. FaceBook does not give …search which does not seems to be where. I also was surprised advanced search only work for your …for some usages. We also already make sure Sphinx can be used efficiently to perform queries …
Page: Presentations
May 3, 2006 By
…company or group. Sphinx search engine for RDBMS Egypt, December 2007 Presentation about Sphinx, the tasks …, OR Performance optimization in numbers. Presentation shows how changing various MySQL Server OS and … projects MySQL Benchmark Group was working at the time. Does not have too much meat about …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… on couple few questions on how to tackle application performance. These … use of replication, caching, using memcached, sphinx, implementing proper web caching etc. … your application very modest 10% does not give you much benefit -… similar situations and know what works well which reduces trial and …
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…the same problem as everybody else who does MySQL Related work – it is very hard to find …problems because we have experience not only advising how to do the things but also implementing things…work on Sphinx Search as well as bunch of MySQL related scripts. As a summary we have 70+ hours of work…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…DRBD yes NDB Cluster yes 3. Does your application use MyISAM only … MyISAM. The HA solutions that work well with MyISAM are “MySQL replication”… by another search engine like Sphinx in order to remove the restriction…the solutions are approximately equal. 6. How qualified is your staff or support…
Post: Percona turns two today !
August 1, 2008 By 13 Comments
… start we’re making money as consulting company being for work it takes to deliver service rather than focusing on maximizing…), Sponsored some Sphinx development. We also published variety of patches for MySQL. Though our giving back to community does not stop there… having no office where people would work. The MySQL was a great school to show how this is possible. We’re staying…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…how much data we can comfortably put in MySQL Instance without getting in too much trouble with backups etc – because Sphinx… few rows to show search results which does not require too much IO capacity or … on the memory fit diagram – understanding your working set is paramount but taking number from …
