… 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server… cause read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and hence… indexes causes a write throughput increase of 2x to 3x. In this particular case, since I was mostly concerned with write performance, so I…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
March 7, 2012 By 21 Comments
…AWS MySQL RDS, InnoDB engine. Our requirement is to insert data in same table and read… composite (5 columns) primary key). Reading and Writing in same table. For 22,518,912 rows …in 8 chunks then it took 10min. Question : Can 14min time be reduce further? Is there anyway I can improve the performance…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… test as our concern is general IO performance in this case – it is not something MySQL related. I tested things on RHEL5, RAID10… decided to check how things improve in case writes come over and over again in the same place – my assumption in this case would be… system doing writes to experience the “performance shock” when LVM snapshot is created with greatly reduced capacity which when will improve as smaller…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… system. What I usually look for MySQL is performance in random reads and random writes. Sequential reads and writes are rarely the problem for OLTP… threads for writes did not improve performance as dramatically as for reads. This is because as we have BBU writes are just stored in controller…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…changes will most commonly offer only incremental performance improvements. key_buffer_size – Very important if …of OK for many workloads with medium write load and shorter transactions. If you …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… suggestions for what to monitor in MySQL. Those are only suggestions; any …in that list, there are several others that can be performed with existing plugins, so there was no need to write…improve them. If you are a customer and you need help configuring any of the plugins, we are happy to assist. In…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…been talking and writing a bit lately about the scaling problems I’m… performance, and occasionally have much worse, and — here’s the magic — the byte offset of the worst performer in … — and that’s where improvements to the MySQL source code are necessary. But in many cases something can be done…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…in MySQL 5.5 there is an option to have a single separate dedicated purge thread and in MySQL…improvement: once the purge threads fully catch up with the history list (e.g. at around 2800 seconds in…MySQL 5.6 versions will contain a fixed and much better performing…
Post: MySQL Limitations Part 3: Subqueries
October 25, 2010 By 20 Comments
…, which in some cases execute outside-in instead of inside-out as users expect. It’s easy to pick on subqueries in MySQL, so… poor subquery performance, or have had it in the past and have fixed it. And many MySQL users have learned to simply write JOINs instead, so it isn’t that much of a limitation. But it would be a big improvement if…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL…improvement when WB cache is used. With WT cache enabled, single thread performance improvement is marginal however WB cache brings single thread random write performance…
