Creation of a temporary copy of the table Doing the modification on the temporary copy Dropping the original table Renaming the copy to the original The whole time the above happens, the table is ...

Changing storage engine; rebuild table; change file_per_table, ALTER COLUMN OF TABLE, Change auto-increment value, Renaming a MySQL table, ALTER table add INDEX, Changing the type of a primary key ...

Sometimes wee need to add a comment to a column for understanding purpose means to easily identify what is the use of that particular column. We can add comment to a column by two ways- at the time of ...

This article was contributed by Edwin Sanchez who is a brand ambassador of Devart, software developer and project manager. There is this one problem that’s killing your MySQL database performance.