The most important and distinctive feature of MySQL is his storage engine architecture, which is designed to separate query processing (precessing) and its system tasks (Server Task) from the storage/extraction of data.1.1 MySQL Logic
Logical architectureMySQL's logical architecture is divided into 3 layers,
Connection thread processing.
The core functionality of the server, query parsing, parsing, optimization, caching, and all of the inside to functions.
1. mysql System architectureThe system structure that displays MySQL content, the entire system is divided three times:1) network connection and thread processing layer, this layer handles client connection request, authentication and threading,
Transactions: A set of atomic SQL queries. If the database can successfully apply all the statements of the group query to the database, then the reorganization query is executed, otherwise none of the statements will be executed.ACID: atomicity
MySQL Logical architecture diagram:First-tier clientSecond tier (service layer): the parts that can be publicly extracted for all types of storage engines. This is where the rest of the storage engine is pumped away. Such as: query parsing, analysis
I. Defining databases and instancesDatabase:A collection of physical operating system files or other forms of file types. The database file can be a file ending with frm, MYD, IBD.Conceptually, a database is a collection of files that are organized
Do DBA more than three years, contacted many mainstream database products, but only had no chance to touch MySQL, today began to decide to self-study MySQL, to their own Chong Chong, first from the MySQL architecture began to learn.
The MySQL
MySQL logical architecture
connection Management and security:
1, MySQL will assign a thread to each client connection, and this connection query will only be executed on this separate thread. The
About MySQL ArchitectureThe MySQL server is comprised of the SQL layer and the storage engine layer. SQL layer functions include permission judgment, SQL parsing and query cache processing, and the storage engine layer is the completion of the
Take a picture:The plug-in storage engine architecture separates query processing from the storage extraction of other system tasks already dataFirst layer: Connection layer:The top level is a number of client and connection services, including
Objective:
This chapter outlines the MySQL server architecture, the main differences between various storage engines, and the importance of the differences
Review MySQL's historical background, Benchmark, and discuss the principles of MySQL by
First, the logical structureMySQL also uses a layered architecture. The plug-in storage engine architecture separates query processing from other system tasks and data access, so that the appropriate storage engine can be selected based on business
First, lamp architecture introduction1? is a shorthand, it contains four things:Linux operating system;Apache (httpd) is a Web services software;MySQL data storage software;PHP scripting language, similar to shell, more complex than the shell,
Preface:Always want to know how a SQL statement is executed, the order in which it executes, and then review the summary of the information, there is the following blog post. This article explores the knowledge from the MySQL overall architecture--->
Http://www.bitscn.com/pdb/mysql/201405/227583.htmlhttp://blog.csdn.net/wyzxg/article/details/7268122http://blog.csdn.net/wyzxg/article/details/7268175
From the way memory is used, the memory usage of MySQL database is divided into the following
1,mysql ArchitectureConsists of a database and a database instance, which is a single entry multithreaded architecture.Database: A collection of physical operating system files or other files, in MySQL, the database file can be frm, myd, Myi, IBD
MySQL ArchitectureConnection pooling Management tool SQL Interface Analyzer optimizer cache storage engine file systemWhat is a storage engineprocessors with different types of tables, different storage engines have different functions and storage
MySQL consists of a data file and a database instance, which is a single-process multithreaded architecture.Database files: A collection of physical operating system files or other files, in MySQL, the database file can be frm, myd, Myi, IBD and
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.