… to store an interim result set, and then use that to … variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know …optimizing a query automatically would be more costly than just running the query in a … uniformly over the range 1..MAX(id)? Yes, there’s a …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL…option was set in the [client] …
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query… 0.5129 ms max per/cmd 0.0802 ms range per/cmd Keep in mind that the entire data set fits into the… ms/op) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“SELECT * FROM…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL…option was set in the [client] …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… HDD MySQL configuration for purposes of comparison. Given the apparent differences in time-based flushing in vCache and FlashCache, both cache devices were set… max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…produce updates in-place (I…mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max…max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query…with good settings out-…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…queries_in_cacheblogpercona.commanual Qcache_total_blocksblogpercona.commanual Queriesblogpercona.commanual query_alloc_block_sizeblogpercona.commanual query_cache_limitblogpercona.commanual query_cache_min_res_unitblogpercona.commanual query…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_SETS_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX… tables in this system. innodb_stats_on_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb… in MySQL 5.5 and before it was “ON” by default with query cache size of 0 which makes it disabled. I wish query…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…Query will execute queries in parallel over all of these machines. With enough machines, massive parallelism is possible and very large data sets…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…right query in the right way. But vanilla MySQL …SET timestamp=1325146286; select count(*) from auto_inc; Note that logging all queries in this fashion as opposed to the general query…# Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= =======…
