MySQL

Beginners Guide to MySQL Performance Tuning

The performance of MySQL is affected by the performance characteristics of the host. Various factors can affect the …

MySQL Replication Replication in MySQL copies changes from one server―the master―to one or more slaves. The master …

If you are into systems, you would’ve heard about backups. I think in all fields backup is one thing which is of …

Triggers are named database objects that activate when you modify table data. They can: Examine data before it is …

MySQL Events are tasks that run according to a schedule. They can be referred to as “scheduled events.” When you create …

Exporting and Importing Data The two most common ways to accomplish export and import operations are: Using SELECT …

Stored Routines A stored routine is a named set of SQL statements that are stored on the server. Clients do not need to …

MySQL enables encryption on a per-connection basis. Depending on the requirements of individual applications, you can …

Partitioning A partition is the division of a database, or its constituting elements, into distinct independent parts. …

Locking InnoDB locking does not need to set locks to achieve consistent reads. It uses row-level locking for DML …

What is a MySQL Transaction A transaction is a way for you to execute one or more SQL statements as a single unit of …