…on Amazon EC2, and I have some interesting results that I wanted to share. I used …query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL…using partitioning to reduce the size of the B+tree, having multiple buffer pool instances to reduce …
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…of specific MariaDB 5.3 and MySQL 5.6 optimizer improvements, and both of them look very good indeed. Peter will present the results…of nice features like less lock contention, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…take into account locality of access, as you could be reading the same page multiple times. Consider if… in numbers. Benchmark results For the purpose of this benchmark, I have used TPC-H Query #3 and ran…set to 6M, the query time for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… is similar to storing the results of a query in Memcache. When the cache… refresh algorithm computes changes in multiple transactions. After each transaction it…of the view, making it available for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… nature of algorithms involved, at least we can use same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query…the query result. Removing of stale queries in this case can be done through some sort of garbage collection. Support for Delayed Invalidation Many MySQL application…
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
… essentially the cause of the unpredictable performance of the MySQL query cache, since the rate of invalidation can not be controlled, and multiple cache entries may… makes most sense to your application. Don’t cache the results of every query, simply because it is easy to do so.
Post: What would make MySQL Multiple Queries Usable ?
September 5, 2007 By 1 Comment
… would make MySQL Multiple Queries API more usable ? Allow to run queries in parallel – The great benefit of knowning all queries at once is of course you… execution engine changes to optimize for set of queries and to execute query set generating all result set in question at the same time…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… which helps improve the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple cores. This is similar… containing the 11 queries. This same SQL script was used in the Shard-Query tests. For the baseline, the results and response times…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…. The databases do 99.9% of the work, due to the multiple levels of result set reduction. Finally, Shard-Query can automatically partition sets into… to distribute work over any type of compute resource which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
… ORDER BY NULL ) The other important optimization combines results from multiple queries together. This query is single threaded, and thus this serves no purpose… of parallelism that this data set can achieve with my method. Likely current network technologies can not support such a degree. mysql…
