MySQL Community

MySQL

Juan Carlos Olamendy
Follow /11 Jan 2018 at 5:13pm / MySQL

Explaining InnoDB Explicit Locking Mechanisms

By: Juan Carlos Olamendy Turruellas 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 performance...
99 0 /
Juan Carlos Olamendy
Follow /15 Nov 2017 at 5:40pm / MySQL

An LSM-tree engine for MySQL

By: Juan Carlos Olamendy Turruellas 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 persistent...
300 0 /
Juan Carlos Olamendy
Follow /19 Oct 2017 at 11:41pm / MySQL

Data Flushing Mechanisms in InnoDB

By: Juan Carlos Olamendy Turruellas Introduction Durability is the D in the ACI D 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 disk)...
245 0 /
Juan Carlos Olamendy
Follow /27 Sep 2017 at 3:36pm / MySQL

Temporary Tables in MySQL

By: Juan Carlos Olamendy Turruellas 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 case...
699 1 /
Juan Carlos Olamendy
Follow /9 Aug 2017 at 6:55pm / MySQL

Logging and analyzing slow queries in MySQL

By: Juan Carlos Olamendy Turruellas 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 eventually...
1325 0 /