Introduction Locking mechanisms are critical to keep the database consistent (a fact that is not well understood by some developers). However, unnecessary locks can have a negative impact on system pe...
Introduction When we're facing a write-intensive workload where it's required to provide the best possible write throughput (writes per seconds), we need to think out-of-the-box and select a persisten...
Introduction Durability is the D in the ACID properties of transactions in the context of RDBMS. Durability is the guarantee that data has been physically recorded to permanent storage (such as a hard...
Introduction Sometimes it's necessary to execute queries involving our actual tables along with some temporary or derived data. One common type of temporary data that might be used in this sort of ca...
Introduction Slow queries can negatively impact database performance. If you don't analyze, optimize, and tune the slow queries as early as possible, the overall performance of your system will eventu...
Introduction Today it's very common to store a lot of data in our MySQL databases. Common examples are: storing tracking information about your website to do analytics later, logging facts about your ...
Introduction Transportable tablespace is a mechanism to copy and move large data very easily and efficiently between different MySQL instances. Transportable tablespace is faster than any other mechan...
Introduction MySQL 8.0 DMR is been released with a bunch of new, exciting features. Notable features are: Transactional data dictionary implemented as tables in InnoDB Roles as a named collection of...
Introduction A covering index is a special case of an index in InnoDB where all required fields for a query are included in the index; in other words, the index itself contains the required data to ex...
Introduction Data security is a very important concern in any enterprise solution supporting the Health Insurance Portability and Accountability Act (HIPAA), Sarbanes Oxley, PII (names, driver license...
Introduction Deploying MySQL on Amazon RDS has more benefits than traditional datacenter deployment; for example we don’t have to purchase and manage hardware for replacing failed disks or upgrading ...
