… it unusable to check the optimizer performance. Solution for this problem was to use set optimizer_search_depth=0, rarely used option… in MySQL mailing list archives I have some recollection that there were few main reasons for the decision to keep exhaustive search… would be more important than backward compatibility. In MySQL 5.6 things are likely to get even better handling joins of many…
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: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… world values distribution. The query looks something like this: SELECT * FROM table WHERE deleted = 0 … gain system shows from performance at 1 thread to the peak performance we see the number …search_to_nth_level,btr_p cur_open_with_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…performance_log_081221 where page_type=’search‘ and wtime>1; +———-+—————–+——————+——————+——————+——————+ | count(*) | avg(wtime) | cpu_ratio | mysql… using mutliple components (like sphinx and MySQL) or multiple MySQL Servers because in …
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
….9.9-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes. This support… MySQL – it is implementation of the wire protocol from scratch. For this test I was not interesting in the full text search performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance of…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
… I would like to highlight – first you can use it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in… any other domain to search forums from that domain. For example you can use this link to search our MySQL Performance Forums Second – note the graph which shows how many results were found matching this terms right from search results…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… same components. Tagging, friends, queues, click tracking, search, paginated displays — we’ve seen these and…s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the …this point, it looks like MySQL is probably a good place to look for performance problems. Everything I…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… even PostgreSQL does not have) as well as Full Text Search parses but there is very long way to go before… engine for MySQL but this role does not suite it well as well for our performance optimization works – we would like to get much more stats from MySQL and it would be great…
Post: Meet MySQL Performance Blog guys on MySQL Users Conference
April 14, 2008 By Leave a Comment
… of sessions we have: Sphinx: High Performance Full Text Search for MySQL (Andrew) EXPLAIN Demystified (Baron) The MySQL Query Cache (Baron) Investigating Innodb Scalability… for these published online after the conference if you would like to take a look but can’t attend conference or…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can…them if you have underloaded master. For example search queries or reporting queries are very good candidates… which is both good from performance standpoint as he is likely to touch the same data …
