charset Charset and Collation in MySql A character set is a set of symbols and encodings. And a collation is a set of rules for comparing and sorting characters in a character set. A charset must
replication Part-II: How Replication Works In MySql In the first part of this blog-post series, we looked at the theoretical side of how replication works, in this blog post, we will set up replication and see all
replication Part I: How Replication Works In MySql In this article, we will understand what replication is, the traditional and the new way of replication, the different components involved in replication, and other important aspects of replication. MySQL
Index Part II: How Indexes Work In Mysql In the first part of the article series, we understood what indexes are and how indexes work internally. In this part, we will look into multi-columnar indexes, ordering in indexes,
Database How Do Indexes Work In Mysql? In this article series, we will dig deep into what indexes are, how it works, what are the advantages and disadvantages of using an index, multi-column indexes, and what are
Database Transaction Isolation Levels In MySql (InnoDB) First, let's break the heading, a Transaction is a sequential group of statements, queries, or operations that performs as a single work unit that can be committed or rolled back.