… trust that your current API or config is optimal, test and make sure it fits your application. … for this app. What is very interesting is accessing 100% of the data in memcached gives very …of writes against the database increase this gap will increase. So let’s ditch the database! But wait! you …
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… vs Disk question. If you look at Disk Based databases all data accesses are treated as IOs – it can be “logical” if… to optimize these reads a bit – there is sequential read ahead and random read ahead which are designed to spot data access… drives are idle. The other seek time optimizations come from the striping – consider 100GB database which is stored on single disk. Assuming…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… database, I believe different applications work best on different database brands. Oracle’s main database … or “does not fit”. Depending on data access distribution gains will be different ranging … fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it …
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
… a performance optimization because: The contents of the result set are computed each time the view is accessed. If multiple statements access the… be transactionally consistent with one another, unless you stop all database write activity. Materialized views can be used to enhance performance…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… your business run? If you can’t get access to the time of day of every click on…there’s still another reason to use InnoDB/XtraDB tables… Optimize For I/O It is pretty much inevitable: if…Keep those big fat log files out of the database. The database is usually the most expensive and hardest-to…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… rows are the worst case for performance. Optimal mathematical performance requires operations on reduced sets…fully in parallel. Distributed set processing is database agnostic. Keep in mind, at each level…some minor abstraction modifications in the data access layer. Shard-Query can provide query …
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… so long recovery time is because their application was well optimized to accumulate updates in the cache and so having pretty… per second. Database Size This comes back to the data locality but with same data access distribution the larger database you’ll have the more scattered records will be in the end thus larger database tend…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…transaction effectively gets its own snapshot of the database. And write locks are not acquired when updating…. then have to be fixed. How to optimize the program without compromising data integrity is … returns quickly, but the first queries that access PBXT tables may hang waiting for recovery to…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… the changes that have happened in the database, instead of replaying binary logs directly. Selecting… will be more expensive. This is an optimization which is required to efficiently refresh MV…but still provides improved performance during refresh by accessing summarized data. I hope this helps you…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… check if your innodb_log_buffer_size is optimal – if you see more than 30% of log …allocated 16773888 Buffer pool size 262144 Free buffers 0 Database pages 258053 Modified db pages 37491 Pending reads … equal of course and accessing of 10 byte rows is much cheaper than accessing 10MB blog, but it …
