Brief architectural overview of several RDBMS - MySQL

Details

Published on Saturday, 04 January 2014 17:53

MySQL

   A MySQL server process (mysqld) can create a number of threads:

• A global thread (per server process) is responsible for creating and managing each user connection thread;

• A thread is created to handle each new user connection;

• Each connection thread also performs authentication and query execution;

• On Windows, there is a named pipe handler thread that does the same work as the connection thread for named pipe connection requests;

• A signal thread handles alarms and forces timeouts on connections that have been idle too long;

• A thread is allocated to handle shutdown events;

• There are threads for handling synchronization of master and slave servers for replication;

• Threads are used for table flushing, maintenance tasks, and so on.

References

1) Oracle Process Architecture
http://docs.oracle.com/cd/B28359_01/server.111/b28318/process.htm#CNCPT008

2) Architecture of Oracle Database Management System
http://k.web.umkc.edu/kumarv/cs471/oracle-arch.htm

3) Microsoft SQL Server architecture
http://msdn.microsoft.com/en-us/library/aa933154(v=sql.80).aspx

4) SQL Server Database Architecture
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/63485c89-40e1-4347-9cd8-a6547e81aba8/database-architecture?forum=sqlgetstarted

5) SQL tutorial: SQLOS
http://1hw.in/sql-tutorial-sqlos/

6) SQL Server 2011 architecture
http://4sqldba.blogspot.com/2011/01/sql-server-2008-architecture.html

7) DB2 Architecture and process overview
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.admin.doc%2Fdoc%2Fc0005418.htm

8) Migrate from MySQL or PostgreSQL to DB2
http://www.ibm.com/developerworks/data/library/techarticle/dm-0606khatri/

9) MySQL 5.1 Reference Manual
http://www.cs.duke.edu/csl/docs/mysql-refman/storage-engines.html

• Next >