…_list scan we discussed in Friday’s post, there is another issue in InnoDB transaction processing that notably affects MySQL performance – for every transaction… approach is quite inefficient and in some cases can be the reason for notable MySQL performance drop. Now in Percona Server, for each connection…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… Toolkit Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database administration…-query-digest, to select the queries you should try to improve to get optimal response times pt-archiver, to efficiently purge… MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of tools that can help serious MySQL administrators perform…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…costs while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower resource usage. This release is the first GA (Generally Available) stable release in …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona XtraDB Cluster… of the network issues in Galera has been improved. Bug fixed #1153727 (Teemu Ollakka). Fixed the wrong path in the /etc/xinetd.d…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… upgrade, change in my.cnf or schema change can affect the overall performance of your MySQL database server. Percona Playback for MySQL can also… to connect to the MySQL database server. Bug fixed #1070824 (Vlad Lesin). Multi-line query parsing has been improved. Bug fixed #1080648…
Post: Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
March 21, 2013 By Leave a Comment
…, “MySQL 5.6 improvements from InnoDB internals prospective,” with Oracle’s Sunny Bains and his talk, MySQL 5.6: What’s New in InnoDB…, what the next bottleneck in MySQL will be, and how we, with Percona Server, are going to beat MySQL in performance. And you can actually go and ask Sunny anything about InnoDB internals: He is one of the few engineers in…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs… by avoiding the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL…and ineffectual. FlashCache does substantially better, coming in at an average of around 600 tps,…IO wait. FlashCache and vCache both show improvements, but it’s not until we get…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… changes done to the core of original implementation which appeared in MySQL 4.0 Query Cache was designed to work with single… with MySQL Query Cache so it once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query… applications in MySQL have very large number of queries doing updates through primary key and use primary key for selects. I believe in…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
… to “can anything be improved for less than it costs not to improve it? – if not, we’re done.” In databases, we care…, which has been available in MySQL for years. This is necessary for determining whether a group of queries completed in a cluster. One…-second performance stalls we are interested in. Without data, you can only guess; and guessing ain’t optimizing. We are considering improving mk…
