…work on crawler in this project only on database Backend and full text search engine implementation. …first you can use it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in …tables as we want to count uniques, but it should be fixed once we rewrite it using sphinx. …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…MySQL replication” and “Master-Master with MMM manager” Don’t use any special MyISAM feature All Can change MyISAM Full text to Sphinx…database server. In term of write capacity here are you choices. Write capacity MySQL…replication” can be as simple as CHANGE MASTER TO, and can take as little as a …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… swap, but basically none is used. This isn’t all that relevant, as you’ll see later, but …’s up with the database. The first step is to find out what MySQL instances are on the machine…may suggest caching, or tell the customer to evaluate Sphinx, or something like that.) In the common case, though…
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…as Matt says – you do not want your runaway logs or extreme temporary space usage to stop the database…on the same partition as well because this makes it very easy to use LVM for backups …
Post: Should MySQL Extend GROUP BY Syntax ?
August 17, 2007 By 11 Comments
… is not offset by any MySQL specific extensions,yet As you can see if… sorted some way you have to use ugly hacks. This is because SQL…In fact we had similar problem in Sphinx when we were working on BoardReader project… enough in MySQL they would have rewrite a lot going to other database anyway while…
Post: Large result sets vs. compression protocol
December 20, 2007 By 6 Comments
mysql_connect() function in PHP’s MySQL interface (which for reference maps to mysql_real_connect() function in MySQL… using it if your Web application is on the same host as the database. When the database…fast enough. Oleksandr Typlynski, one of the Sphinx users, has conducted a benchmark, indexing …
Post: Percona Live gets bigger: two more speaker tracks!
May 3, 2011 By 1 Comment
… database in the cloud. This isn’t an extraordinary database, all things considered — as they told me, “it’s not a science fiction use… it all possible: Clustrix, Vork, Continuent, Webyog, EffectiveMySQL, Facebook, OmniTI, Sphinx, Tokutek, Zmanda, DaniWeb, and PalominoDB.
Page: Presentations
May 3, 2006 By
…using ICC complier (Outdated) Download Scaling and Performance Issues in MySQL MiracleAS Database Forum 2003, Denmark Presentation speaks about benchmarking issues and MySQL…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… position * chunkid). Reversed index is often described as using unsigned int where each unique word …database, linux 2.6 and mysql 4.1.18 was used in all cases – SQL_NO_CACHE was used…sphinx stores data internally but hopefully something of what I have said above might be valuable/used to make sphinx…
Post: Getting around optimizer limitations with an IN() list
January 9, 2010 By 9 Comments
…” radius? Anyone out there created a zipcode database and created a “search within x numer … that we estimate just as many rows on the first EXPLAIN as the second one? That… missing feature of the MySQL optimizer – and it has to do with using x BETWEEN 30 …these types of queries, you should give Sphinx…
