… happened in the database, instead of replaying …, making it available for querying: mysql> call flexviews.enable(… more quickly. If this had to actually access …optimization which is required to efficiently refresh MV which use those aggregate functions. Now I delete some line items from orders: mysql…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…worst case for performance. Optimal mathematical performance requires…more chunks. Each Shard-Query instance is a essentially a proxy for the distributed set based SQL operations executed on the nodes under the proxy. The databases…right now only MySQL storage nodes … the data access layer. Shard-…
Post: System size and Performance Optimization
February 27, 2007 By 2 Comments
…more and more time consuming and expensive and gains smaller. This observation does not only apply to MySQL but to systems running other databases…for example if your search is taking 10 seconds for…optimal as possible. If you’re using 50 5000$ database…to access if minor face lifting such as MySQL …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…optimizing DDL directly, expand_fast_index_creation may also optimize index access for…mysql> SET expand_fast_index_creation=OFF; Query OK, 0 rows affected (0.00 sec) mysql> OPTIMIZE…for a regular dump with a dump created with –innodb-optimize-keys (the test database…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…more rich than the simple sysbench table. The Star Schema Benchmark (SSB) seems ideal for…access…mysql> select * from information_schema.innodb_buffer_pool_stats\G *************************** 1. row *************************** POOL_ID: 0 POOL_SIZE: 8191 FREE_BUFFERS: 1024 DATABASE… | | 8 | optimizing …
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…MySQL has to do a lot of copying and conversions while accessing… handle all different cases in Optimizer – such as in memory nature… tuning becomes more complicated. Now what is interesting for probably 95…and hoping nobody is touching “mysql” database any more. Single Storage Engine server …
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
…for transactions there is obvious fix to use two phase commit for transactions spawning multiple databases…is expected to be accessed a lot on each …for data storage, which tend to lead to “holes” it should have rather compact foot print in optimal…for MySQL. We surely should get back soon and run more…
Comment: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…buffer pool faster and also give RAID more room to optimize requests so writes would impact reads. …for access to cached data, which makes it quite tricky to handle IO failure operations. But what is even more DataBases…good way to go is not supported by MySQL/Innodb right now and neither can be …
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
…for database…access…for sysbench oltp (with full report available later) below, and the results for tpcc-mysql in a followup post. For…optimized for Flash cards, with variations for…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… compression potentially compresses the database more than just prefix …access one of the pages being fetched does it has to wait for…of buffer pool would need more optimizations to work – Innodb…MySQL‘s binlog and InnoDB’s log must have the transactions in the same order, for a recovery based on MySQL…
