Author - Muhammad Irfan

MySQL 5.6 Transportable Tablespaces best practices

In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for partial backups which means you can now take individual database or table backups and your destination server can be a vanilla MySQL server. Moreover, since Percona Server 5.6, innodb_import_table_from_xtrabackup is obsolete as Percona Server […]

Read more

MySQL Replication: ‘Got fatal error 1236’ causes and cures

https://www.percona.com/blog/wp-content/uploads/2014/10/MySQL-Replication-Got-fatal-error-1236-causes-and-cures.jpg

MySQL replication is a core process for maintaining multiple copies of data – and replication is a very important aspect in database administration. In order to synchronize data between master and slaves you need to make sure that data transfers smoothly, and to do so you need to act promptly regarding replication errors to […]

Read more

MySQL Upgrade Best Practices

MySQL upgrade best practices

MySQL upgrades are necessary tasks and we field a variety of questions here at Percona Support regarding MySQL upgrade best practices. This post highlights the recommended ways to upgrade MySQL in different scenarios.
Why are MySQL upgrades needed? The reasons are many and include Access to new features, performance benefits, bug fixes… However, MySQL upgrades […]

Read more

MySQL 101: Monitor Disk I/O with pt-diskstats

Here on the iostat is one of the popular tools and pt-diskstats tool for this purpose. The pt-diskstats tool is similar to iostat but it’s more interactive and contains extended information. pt-diskstats reports current disk activity and shows the statistics for the last second (which by default is 1 second) and will continue until […]

Read more