…’s take a look at the graphs have a better view of the whole picture. Note, in the above graph, we… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and… write performance is using partitioning to reduce the size of the B+tree, having multiple buffer pool instances to reduce contention problems…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… closing MySQL source code.) Personally I don’t see the problem distros have with the MySQL model. Contrary to common belief… like server crash, wrong result or just performance regressions. From my point of view the distros insisting on sticking to the original…
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
… view which uses the MERGE algorithm can merge filter conditions into the view query itself. This has significant performance advantages over TEMPTABLE views. A view… make a trade off between increased query complexity for improved view performance.
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… would be the problem. However it is not always the case. There are whole classes of systems where Disk performance is not… fit. For large number of applications optimizing IO performance will be number one problem do not get me wrong, I just it… swap performance. I also fully support Matt in his views of black boxes. If you want to be able to resolve your performance problems…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… output of iostat.) I would characterize this as very good performance. Sub-millisecond latencies to disk, pretty much consistently, for reads… all aggregated together in each line. I can switch the view of the same data to look at it disk-by… a quarter of a second sometimes. This is causing acute performance problems for the database, manifested as epic stalls and server lockups…
Comment: MySQL VIEW as performance troublemaker
August 18, 2009 By 53 Comments
[...] complicated queries, and I’m running into a few obnoxious limitations, mostly involving known view performance problems. I’ve decided to start testing the waters in PostgreSQL, so I tried importing my data into PG [...]
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 53 Comments
… how would we solve the same problem having things more modular and using MySQL VIEWs ? mysql> create view user_counts as select user… implementing MySQL VIEWs in your application, especially ones which require temporary table execution method. VIEWs can be used with very small performance overhead…
Post: Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
… (or set of tables per user) which starts to cause problems if it is used on massive scale (blog hosting, forum… triggers on views, specially INSTEAD OF triggers so you could write triggers to perform insert inserts to base tables instead of views. BEFORE… places when insert happens so it should not be big problem. Technically if you can’t make inserts to the base…
Comment: Spreading .ibd files across multiple disks; the optimization that isn't
December 26, 2010 By 22 Comments
… to an entire database directory. This can be combined with views to move physical access to other devices while logically allowing…_db.log VIEW as a table with respect to SQL. The MERGE view algorithm will ensure that this doesn’t create performance problems. MySQL will simply access the base table (`fast_ssd`.log) instead of the view since there is no aggregation in the view…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
… READ-COMMITTED transaction mode it is actually fine from performance point of view as Innodb does not have to preserve row versions… a better metric, which in most cases will indicate the problem waiting to happen, this is when you have long enough… this case we see transactions are holding some locks and perform some update/deletes as there are undo log entries. This…
