Bug #92683 | Mysql server 8.0.12 windows service install or mysqld issue | ||
---|---|---|---|
Submitted: | 5 Oct 2018 10:11 | Modified: | 12 Oct 2018 13:08 |
Reporter: | lionel mazeyrat | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Installing | Severity: | S1 (Critical) |
Version: | 8.0.12 | OS: | Windows (Server 2016) |
Assigned to: | CPU Architecture: | Any |
[5 Oct 2018 10:11]
lionel mazeyrat
[5 Oct 2018 10:16]
lionel mazeyrat
-
[5 Oct 2018 11:07]
MySQL Verification Team
Thank you for the bug report. I am a little confused here, on my computer the Windows MySQL installer placed the my.ini file in below path: C:\>"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --install MySQL80 --defaults-file="C:\Program Files\MySQL\MySQL Server 8.0\my.ini" Service successfully installed. instead of: "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --install MySQL80 --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" C:\Program Files <> C:\ProgramData Please check. Thanks.
[5 Oct 2018 12:15]
lionel mazeyrat
mysql service
Attachment: mysql.png (image/png, text), 298.48 KiB.
[5 Oct 2018 12:17]
lionel mazeyrat
I've removed the service and reinstalled it if with : C:\>"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --install MySQL80 --defaults-file="C:\Program Files\MySQL\MySQL Server 8.0\my.ini" I still have 2 mysqld lainched each time I start the service. See File attached
[5 Oct 2018 12:52]
MySQL Verification Team
Thank you for the feedback.
[9 Oct 2018 7:48]
Thayumanavar Sachithanantham
In 8.0 the one instance of the mysqld is the monitor process which monitors the mysqld that serves the requests. This is the default behaviour. This is required RESTART sql implemented. If this is not required, the server can be started with the option --no-monitor.
[9 Oct 2018 18:53]
lionel mazeyrat
thanks for the reply
[12 Oct 2018 13:08]
Paul DuBois
Posted by developer: Addition to https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html under "Additional Installation Information": To accommodate the RESTART statement, the MySQL server forks when run as a service or standalone, to enable a monitor process to supervise the server process. In this case, you will observe two mysqld processes. If RESTART capability is not required, the server can be started with the --no-monitor option. See Section 13.7.7.8, “RESTART Syntax”.