EmergencyEMERGENCY? Get 24/7 Help Now!

Open Source Databases on Big Machines: Disk Speed and innodb_io_capacity

 | March 1, 2017 |  Posted In: MySQL, open source databases, OpenSource Databases on big machines

In this blog post, I’ll look for the bottleneck that prevented the performance in my previous post from achieving better results. The powerful machine I used in the tests in my previous post has a comparatively slow disk, and therefore I expected my tests would hit a point when I couldn’t increase performance further due to the disk speed. […]

Read More

Jeremy Cole on MySQL Replication

 | May 27, 2006 |  Posted In: Insight for DBAs

Jeremy Cole recently posted very nice post about MySQL Replication Performance. There are however few points I should comment on. Jeremy Speaks about MyISAM and Innodb in the same terms, in fact they are quite different for Replication. As you probably know MyISAM uses buffered IO so if master crashes you’re out of sync anyway […]

Read More