You are installing MySQL Server 5.7 from a tarball package. You have already set up the correct PATH environment variable and configured your /etc/my.cnf file.
Which command will correctly prepare a data directory?
After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?
Why should you be selective when granting the PROCESS privilege to an account?
The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:
Which two options would help avoid the long wait in the future?