…to belong to mysql.com domain, while searching for “dev.mysql.com/download”" will only match dev.mysql.com domain and…be able to use index past link_date part, it is true so we had to use link_date in () and…text search applications. Group By was added to…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
…going to diverge into a discussion of how OLAP varies from OLTP, it suffices to…will examine each partition serially. In the end, this means that things get slower as the query has to…to add support for those queries though, and I’ll post a follow-up when I do. — Full Disclosure — This is a text…
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
…going to be free Russian Speaking event. This is the second Sphinx event in Russia and I really wish there would be and International Sphinx Conference somewhere in…Text Search coming up in MySQL 5.6 and Claimed to be faster than MyISAM’s I really would like to see some benchmarks comparing it to…
Post: Quickly preloading Innodb tables in the buffer pool
May 1, 2008 By 9 Comments
… be great if Innodb would implement command to preload table to Innodb buffer pool, which would simply go through .ibd file sequentially and inject pages in… preloading BLOB/TEXT columns you do not need to use first query I mentioned because scanning potentially externally stored blobs will also scan…
Post: Percona is hiring performance experts
February 13, 2009 By 2 Comments
…and we go to conferences and other events). But we don’t require most consultants to be ready to…to working in this fashion. That last paragraph sounds like standard text…
Post: Benchmarking Galera replication overhead
October 13, 2011 By 12 Comments
…to observe stability of results. As final result I take median (line that divides top 50% measurements and bottom 50%). In text…semisync MySQL replication And now go to results. 1. Compare baseline to the same node but … it will be interesting to see what overhead we can get in 3-nodes setup, and also…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…going to followup with results on Percona Server. So first recommendation you may hear in this case from the Oracle/MySQL engineers is to… will try to keep less dirty pages in buffer pool, and hopefully it will spend less time in “…better), the same way InnoDB will not be able to change a lot of data …
Post: Give me 8 hours, and I'll help you build a better application
August 29, 2009 By 4 Comments
…go wrong. Keep it simple and monitor things that matter to your business: does the website load in the expected time and contain the expected text…in the future, you are going to be very grateful that you have historical metrics to understand changes in…
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 16 Comments
…and uses lower value as a limit to for in memory temporary table after which it will be converted to MyISAM. To…going to be read only variable to tell you what maximum temporary table size is or is it going to…
Post: HighLoad 2007 Review
October 6, 2007 By 1 Comment
…be willing to share. I specially mention Yandex here as they had very well presented team on the conference and… recoded and them converted to the text and put together…to get to registration desk. A lot of people (including myself) also could not be found in the list and had to go to special desk to…
