{"id":12720,"date":"2023-12-07T19:27:45","date_gmt":"2023-12-08T02:27:45","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=12720"},"modified":"2023-12-18T06:14:12","modified_gmt":"2023-12-18T13:14:12","slug":"mysqld","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-administration\/mysqld\/","title":{"rendered":"mysqld"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn about the mysqld which is known as the MySQL Server.<\/p>\n\n\n\n

Introduction to the mysqld<\/h2>\n\n\n\n

The mysqld<\/code> is a core component of a MySQL Database Server, which is often referred to as the MySQL Server.<\/p>\n\n\n\n

The mysqld<\/code> is a multithreaded program that performs a variety of critical tasks such as managing access to the MySQL data directory without spawning additional processes.<\/p>\n\n\n\n

When MySQL Server starts<\/a>, the mysqld<\/code> listens for network connections from client programs and manages database access on behalf of those clients.<\/p>\n\n\n\n

The mysqld<\/code> has many options that you can use at startup. To view a complete list of options, you can use the following command:<\/p>\n\n\n

mysqld --verbose --help<\/span><\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
This command shows a comprehensive list of available options that allow you to configure the MySQL server based on your specific requirements.<\/p>\n\n\n\n
System variables<\/h3>\n\n\n\n
The mysqld<\/code> relies on system variables to control its operations. You can set these variables during the server startup. You can also modify the values of many system variables at runtime.<\/p>\n\n\n\n
For example, the @@max_connections<\/code> controls the maximum number of concurrent connections. To show the @@max_connections<\/code> variable, you need to follow these steps:<\/p>\n\n\n\n
First, connect to the MySQL database server<\/a>:<\/p>\n\n\n
mysql -u root -p<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Then, show the value of the @@max_connections<\/code> variable:<\/p>\n\n\n
select<\/span> @@max_connections;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+-------------------+<\/span>\n| @@max_connections |\n+-------------------+<\/span>\n|               151 |\n+-------------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The output indicates that the MySQL server can handle up to 151 concurrent client connections. Note that your MySQL server may show a different number.<\/p>\n\n\n\n
Status variables<\/h3>\n\n\n\n
In addition to system variables, the mysqld<\/code> provides a set of status variables that offer insights into its ongoing operations. <\/p>\n\n\n\n
By checking and monitoring these variables, you can obtain valuable information about the runtime.<\/p>\n\n\n\n
For example, you can use the Uptime<\/code> status variable to show the number of seconds the server has been running:<\/p>\n\n\n
SHOW<\/span> GLOBAL<\/span> STATUS<\/span> LIKE<\/span> 'Uptime'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+---------------+-------+<\/span>\n| Variable_name | Value |\n+---------------+-------+<\/span>\n| Uptime        | 6965  |\n+---------------+-------+<\/span>\n1 row in set<\/span> (0.01<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • The mysqld<\/code> is known as the MySQL Server, which is responsible for many critical tasks of the MySQL Database Server.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful? <\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t