A. The --open-files-limit option can be used to increase it. B. It limits the amount of operations MySQL can perform at one time. C. It limits the maximum size of the table cache that holds file descriptors. D. The operating system may be able to be reconfigured to increase this limit. Answer: D QUESTION: 130 Which of the following best describes what may limit the number of simultaneous connections to the server? What are possible ways to increase it? A. It is limited by the maximum size of the table cache. B. The --key_cache option may be used to increase the limit. C. The maximum number of threads per-process of the operating system. D. The operating system may be able to be reconfigured to increase this limit. Answer: A QUESTION: 131 Which of the following best describes what the connection backlog is and why it may need to be increased? A. It may need to be increased on a server with a high rate of transactions. B. The backlog is the queue of processes waiting to be processed on a server. C. The backlog is the queue of network connections of clients waiting to connect. D. It may need to be increased on a server with a high rate of client connections. 45
Answer: C QUESTION: 132 Which of the following are requirements for running more than one MySQL server on the same machine? A. On Windows each server that runs as a service must have a different service name. B. Each server must have its own log files. C. Each server must share the same error log. D. Each server must run on a different disk. E. Each server must have its own network interfaces. F. There must be more than one processor on the machine.
You've reached the end of your free preview.
Want to read all 7 pages?
- Fall '20
- MYSQL , InnoDB