… benchmark consists of four sets of queries. Each set is known as a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY… does not maintain checksum consistency during regular operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
Here at the MySQL Performance Blog, we’ve been discussing the several new features that … Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to… performance, and should be avoided. By the way, a good practice to avoid this is always naming your keys with a consistent…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…plugin authors say, aren’t exposed by a consistent API. If you also need to do this… plugin is its flexibility, and not its performance, which seems to be on par with …”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… terms of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view…!) angle. It requires neither read-only server nor rewriting application queries. Furthermore, it can be combined with the read-only optimization… alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… line – SSD config) which shows the most consistent performance. The others all have assorted performance drops scattered throughout the graph. We see the… with time-based flushing enabled actually produces better and more consistent performance than vCache without time-based flushing, but even at its… join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the right) configuration. No surprises here, the general pattern is consistent with what we saw previously. Note that the single-node… = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and indices to the buffer pool we use following queries: select…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… dimensional schema Test environment For this benchmark, a test environment consisting of a single commodity database server with 6 cores (+6ht…-Query performance continues to improve when grouping and filtering is used. Again, notice Q9. It doesn’t use any features which Shard-Query…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
… workload. The following tests assume a workload consisting of a small number of concurrent queries (or only one) to demonstrate how much….737620115286.07981824874886.0321369171143 The reason that Shard-Query performs better is that it turns the OLAP query into something more like OLTP. Instead…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… refreshable one, then you can keep the complete views transactionally consistent with each other, as long as you refresh all of….03 sec) Notice the difference in response time. Refresh method performance comparison For demonstration purposes, I did the following: Created one… Deleted 100 order lines. Refreshed both views. Compared the refresh performance and query results. The view type does not usually* affect the…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
… tool must generate to answer those queries. Performance challenges with larger databases, and some ways to help performance using aggregation. Using materialized views… a data warehouse. A particular combination of ETL jobs which consist of one or more data transformations is usually called a…
