… easy to “break” MySQL making it to do group by with on disk temporary table which will make Sphinx much faster and few others. The true gain from Sphinx however comes from its ability to scale almost linearly using multiple CPU cores and multiple nodes in the system…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… all requests to MySQL table for larger ones you can log only small portion of them. I usually keep one table per day…: 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… especially helpful for complex applications using mutliple components (like sphinx and MySQL) or multiple MySQL Servers because in these cases you often can’t…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
… out to multiple cores and multiple nodes, with close to linear scalability. Because of this we included Sphinx chapter in High Performance MySQL book… temporary table or sorting is needed for group by). Note that with Sphinx you can easily run the process on multiple cores/multiple nodes…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
…consistency guaranty or being bitten repairing multiple GB MyISAM table few times, though Table Locks is probably the … for Innodb tables. So what can you do ? Leave Tables as MyISAM The beauty of MySQL storage … eliminates the need to have MyISAM table anywhere. We use Sphinx in a lot of cases as …
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
… the things you don’t know about Sphinx’s capabilities. Many people think of Sphinx as a great search engine, but it…’s a nightmare of temp tables and filesorts and multiple queries and all sorts of things in MySQL — and that’s just for performing this task on a single server, not to mention a cluster of servers. Well, Sphinx…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… by another search engine like Sphinx in order to remove the restriction… sharding (splitting the database over multiple servers), then you might need …table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM manager Good, average MySQL…
Comment: Quick comparison of MyISAM, Infobright, and MonetDB
September 30, 2009 By 30 Comments
… storing the data in mysql but then loading it into Sphinx and querying that? I once used Sphinx for full table scans and it was much faster than doing it in myisam tables (mostly because multiple joins were involved…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… interested about it is Sphinx which is currently implemented as storage engine for MySQL but this role does …set to deal with multiple nodes nicely even if you do not have much support from MySQL to do so… summary tables and other tricks we use when such need arises but we still can’t deny – MySQL …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…comfortably put in MySQL Instance without getting in too much trouble with backups etc – because Sphinx is doing…issues along you need enough concurrency to utilize multiple hard drives and with 50 drives you would…3 hours reporting query or 5 hours ALTER TABLE command. Let me also comment on the …
Comment: Using Sphinx as MySQL data retrieval accelerator
November 7, 2006 By 25 Comments
…selectivity (over 50% matching rows) simple full table scan with limit actually would offer best …agree with you. Everything has its purpose – sphinx is designed exactly for usages where relevance…MySQL has no way to use multiple CPUs for such query. Even with MySQL Cluster sort would be done on MySQL…
