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?
您的一位同事正在尝试使用mysql命令行客户端对其应用程序会话进行更改。
同事向您发送以下命令的即时消息:
mysql> SET SESSION max_connections = 200;
为什么命令失败?
A. max_connections requires the GLOBAL scope.
max_connections需要GLOBAL范围
B. Its current user does not have the SUPER privilege.
它的当前用户没有SUPER特权。
C. max_connections is not a dynamic variable. You need to change the config file and restart the database.
max_connections不是动态变量。您需要更改配置文件并重新启动数据库
D. Users can control only the max_user_connections variable.
用户只能控制max_user_connections变量。
Answer: A
版权声明:本文为博主原创文章,未经博主允许不得转载。
MYSQL
- 上一篇:Mysql OCP 59题
- 下一篇:Mysql OCP 61题