InnoDB Buffer Pool InnoDB buffer pool is one of the most important options for improving InnoDB performance. InnoDB buffer pool is a space reserved in memory which is used to save data and indexes that are frequently accessed. When MySQL server receives a query, if the...
Database Backups can take several formats. Backup size, backup time, and restore time will vary for each of these formats. In this post, we will use a 13 GB database with a total of 66 million rows to compare and evaluate the backup and restore time...
The common scenario for using Amazon RDS is to be connected to application servers. An example for this is a solution introduced by Amazon:
Introducing Amazon RDS Amazon Relational Database service, or as it's known RDS, is a pre-packaged version of MySQL on Amazon services. Unlike it may seem, it's not just an EC2 instance with MySQL installed on it. The difference between RDS and EC2 with MySQL is that,...
Before Mysql 5.6 indexes had some limitations like the range comparisons, if the part of the index used in a range comparison the part of the index after the range scans cannot be used by where conditions so mysql retrieves all rows which met only...
