… glance, this might not look too bad. MySQL is using three different indexes to search approximately 8100 out of 4.5M rows… the context of index merge, it means that MySQL is really looking at a search space closer to 8.5M rows, not… you might not see right away. Disabling this setting might speed up this query (it did), but it might also negatively…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… offload MySQL. When it comes to large scale data processing other techniques are used. Google uses some bigtable based technologies for search… build in parallel processing. When you need high data processing speed you simply can’t do it on single CPU especially… data and kill them. Now think what happens if you Search Google or engage in any other processing intensive activity. If…
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
… it possible to connect to Sphinx as if it were MySQL Server with more advanced connectors which issue such commands when… in 2012. Another thought – with Innodb Full Text Search coming up in MySQL 5.6 and Claimed to be faster than MyISAM… not because it is faster – speed might not be the main thing on smaller collections but its various full text search features.
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
…from the MySQL Slow Query Log. The name comes from the instrument in a weather station that measures wind speed. SQL … * filtering reports by different query conditions; * graphing reports; * explaining queries; * searching and displaying samples; * displaying table status and CREATE statements; * …
Comment: Why MySQL could be slow with large tables ?
February 2, 2008 By 141 Comments
… your searches. MySQL will not combine indexes, only choose the best one it sees fit. There for if you do a search on 2 columns a lot then I would have a separate index to speed up that query…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Percona Server wins 'Top Innovator in SQL Technologies' award!
January 18, 2013 By Leave a Comment
… our press release: According to a 451 Research report titled, “MySQL vs. NoSQL and NewSQL: 2011-2015,” Percona Server is one of the most deployed alternatives to MySQL. Percona Server offers hosting providers advanced features that speed up searches, increase security, and provide administrators…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…log_081221 where page_type=’search‘ and wtime>1; +———-+—————–+——————+——————+——————+——————+ | count(*) | avg(wtime) | cpu_ratio | mysql_ratio | sphinx_ratio … part yet but if we’d speed up Sphinx and MySQL dramatically we would have to …
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… (to make it easier to count I leave out the mysql codes needed to store these bytes). If you have an… want OR search just do resultvector = vector1 | vector2, and so on. So this means that also the speed of the search is significally improved since having a search that contains 10 most common words…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… information is stored, and a search almost as efficient as a binary search can be performed. But InnoDB’… so that we can see the full write speed of the disk for throughput. INNODB uses fuzzy …? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_…
