The my.cnf (or my.ini on Windows) file is the primary configuration file used to customize MySQL’s behavior, performance, security, and logging settings. Understanding how to modify and optimize MySQL through this file is essential for database administrators and developers.
This quiz will test your knowledge on key my.cnf parameters, server performance tuning, security configurations, logging and debugging options, and applying changes to MySQL settings. By completing this quiz, you will gain deeper insights into how MySQL’s configuration can be adjusted to meet specific application needs.
1.
How can you check if a specific configuration setting is applied after modifying my.cnf?
2.
Which my.cnf parameter is used to define the default storage engine for tables?
3.
Which my.cnf parameter enables query caching in MySQL?
4.
Which parameter in my.cnf enables slow query logging?
5.
How do you check which configuration files MySQL reads at startup?
6.
What is the recommended setting for 'innodb_buffer_pool_size'?
7.
Which MySQL configuration setting controls the maximum number of concurrent client connections?
8.
Which section of the my.cnf file is used to configure MySQL server settings?
9.
What does the 'bind-address' parameter in my.cnf control?
10.
Where is the my.cnf file typically located on Linux?
11.
What is the equivalent of the my.cnf file on Windows?
12.
Which of the following parameters improves performance by caching client threads?
13.
What is the purpose of the my.cnf file in MySQL?
14.
Which command is used to restart MySQL after modifying the my.cnf file on Linux?
15.
What does 'secure-file-priv' do in my.cnf?
16.
Which of the following settings improves security by preventing remote MySQL access?
17.
What is the purpose of the 'log_error' parameter in my.cnf?
18.
Which parameter controls the size of the InnoDB redo log files?
19.
Which command is used to apply configuration changes after editing my.cnf on Windows?
