Percona's MySQL & InnoDB performance and scalability blog
… capacity (for the 16-disk RAID10 or RAID0 for that matter). Let me put it another way. If your MySQL or Sphinx query takes… changes to the sphinx configuration. The Plan First of all, let me explain what we are trying to achieve here. Sphinx has the… a local machine for this index of ours – idx1. Here’s how we would change the configuration: source src1 { type = mysql sql_query…
…, RAID Configuration, File Systems to assist you with your choices next time you select platform for MySQL. Performance comparison of MySQL 5.0, MySQL 5… Billions of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This presentation will…
… exist for many commercial databases but until recently this type of software was not available for MySQL…. purpose of FlexCDC). Feed search engines like Sphinx or Solr only the rows that change….the local machine which is the usual configuration for Flexviews since it requires local access to…
…for MySQL Performance Optimization data as well as for general MySQL application design practices. Download MySQL…configuration, using DBT2 Benchmark as example. Focuses on Innodb but most things are relevant for any storage engine. Download Improving MySQL…
… shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for Audi A6 will… shortcut) in MySQL Full Text Search configuration – relaying on minimum keyword length while their application has use cases when search for short keywords…, which we’re often using with MySQL – Sphinx Search we still tend to use stop word list for performance reasons, but it is…
… I look for outliers and anomalies in every aspect of the server’s configuration and performance and contents. I’m looking for characteristics… on a 64-bit OS. Examining MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v… (we may suggest caching, or tell the customer to evaluate Sphinx, or something like that.) In the common case, though, a…
…configuration often causes serious challenge choosing proper index configuration…for complex searches which generate a lot of rows. Another interesting technique is to use sphinx…
… changes, use of replication, caching, using memcached, sphinx, implementing proper web caching etc. These …efficiently past certain hardware configuration – some of these issues may be MySQL related and others (… services around MySQL and LAMP and MySQL is one of them. Plus for large companies …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.