MySQL Forums
Forum List  »  Quality Assurance

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Win 10 Task Manager shows 2 instances of mysqld process
4047
Judy Whiteside
July 18, 2020 12:20PM
Re: Win 10 Task Manager shows 2 instances of mysqld process
996
Peter Brawley
July 18, 2020 01:19PM
Re: Win 10 Task Manager shows 2 instances of mysqld process
1150
Daniel Blanchard
July 20, 2020 08:10AM
Re: Win 10 Task Manager shows 2 instances of mysqld process
688
Judy Whiteside
July 21, 2020 10:00AM


Sorry, you can't reply to this topic. It has been closed.

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.