How is a query executed in MySQL?

This post is for the testers who have some basic idea about MySQL database. I want to put up few things I came across when I dove deeper into MySQL. Here’s a brief overview of the order in which a query is executed inside a MySQL server. When you execute a SQL query, the order in which the SQL directives […]

MySQL Architecture and Layers

Many testers know how to write SQL queries and how to fetch data from the tables. But only a few understand the internal architecture and how MySQL interacts with storage engines. This blog discusses the MySQL architecture, different layers and journey of SQL statement in MySQL data. MySQL architecture is broken into three layers basically which can be defined by, […]