… on this socket and process the audit records as you wish. Performance-wise, I did basic tests on the VM I was… advantage of the plugin is its flexibility, and not its performance, which seems to be on par with having the general… what can be achieved with it. It is a very good one for me, since I think proper audit trail support…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…fixed, and you still have MyISAM tables you wish to keep running under PXC, wsrep_replicate_…for certification. Having said that, it would be good if your async master can use ROW based… PK imposes an additional overhead, and because cluster performance is somewhat dependent on the slowest node – this…
Post: Top 5 MySQL wishes - what is next ?
July 4, 2007 By 1 Comment
… some wishes to ease development process, MySQL DBAs would like stuff related to operations like Hot Backup. People actively working with Performance problems like Kevin,Jeremy or me have bunch of performance and scaling related wishes. There is also a good overlap among people wishes…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…. Well this may be too much of the wish but at least it should happen for most… extent because it is asynchronous. To offer great performance on distributed systems, especially if they are connected … federation support. 4. Be Solid MySQL has very good stability track record, with exception of MySQL 5…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…phase which is not counted as “inside innodb”. I wish there would be some stats for number of … so was basically disabled. Note getting BBU is often good idea anyway so you can use this together with…MySQL 4.0. MySQL 5.0 can offer substantial performance improvements in variety of cases as well as has…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… for many PHP applications abstraction layer is > not the main performance problem, also benefit from persistent > connections can be much more… well as much more queries per page which will make > performance improvement much smaller. Notable exception being > AJAX applications which may… not always bring good performance. Joins are expensive and > you can often do much better with denormalized data. You may wish > to use…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…we can use them for MySQL Performance tuning ? Not surpising associative array cache performs the best, almost 4 times …network by using memcached is very good way to go. File Cache is good for long term storage If … layering may make sense. For example you might wish to use APC Cache as L1 cache and …
Post: System size and Performance Optimization
February 27, 2007 By 2 Comments
… by expert you often can get significant performance increase in the matter of hours further performance improvements become more and more time… simple architectures can be good enough, but it should be right simple architectures. In some cases you might wish to implement simple… settings tuning, changing indexes and queries is enough to deliver performance required in cost efficient way, or if we should do…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… 5.5 and instead of expected performance improvement you see your performance being worse. What should you do ? …spot what exactly is causing the problem it is good to use pt-query-digest to compare workloads … be up for deep investigation. You may also wish to create a repeatable test case which does…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… for many PHP applications abstraction layer is not the main performance problem, also benefit from persistent connections can be much more… well as much more queries per page which will make performance improvement much smaller. Notable exception being AJAX applications which may… not always bring good performance. Joins are expensive and you can often do much better with denormalized data. You may wish to use…
