You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:
What would you run to fix the issue?
One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.
The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200;
Why does the command fail?
A MySQL database uses all InnoDB tables and is configured as follows;
You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?
You attempt to connect to a MySQL Server by using the mysqlclient program. However, you receive this notice:
What would you run to fix the issue?
