MySQL Partition pruning Explained

Partitioning is a process in which a single larger table is split into several smaller tables (physically) and still considered as a single table.It is generally a good idea for the tables whose size is in a few 100 GB's. While performing select,update,delete operations in a partitioned tables, we can notice a better performance in … Continue reading MySQL Partition pruning Explained

Advertisements

GH-OST for MySQL Schema Change.

Schema change is one of the crucial tasks in MySQL with huge tables. Schema change can cause locks. What is gh-ost?                          gh-ost is a triggerless online schema change for MySQL by Github Engineering .It produces light workload on the master during the schema changes . We need online schema change to alter a table … Continue reading GH-OST for MySQL Schema Change.