MySQL Forums
Forum List  »  Quality Assurance

Re: Win 10 Task Manager shows 2 instances of mysqld process
Posted by: Daniel Blanchard
Date: July 20, 2020 08:10AM

Since MySQL 8.0.12, the mysqld process launches a second copy of itself. The parent process monitors the child for restart requests (to support the SQL RESTART statement). The child process does all the work of running a MySQL server - you can see that the child process has a much larger memory footprint, typically associated with the innodb buffer pool.

It is possible to prevent this "two instances" behaviour and only run a single instance of mysqld by using the --no-monitor command line option, but then the SQL RESTART statement only shuts down the mysqld process without starting a new one.

See https://dev.mysql.com/doc/refman/8.0/en/server-options.html#option_mysqld_no-monitor

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Win 10 Task Manager shows 2 instances of mysqld process
171
July 20, 2020 08:10AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.