Chapter 6 Review Questions

Let us see how much you have learned in this chapter by going over these review questions.

  1. Which statement is false about server log maintenance?
    1. Force MySQL to start using new log files by issuing a FLUSH LOGS statement.
    2. Force MySQL to start using new log files by running mysqladmin flush-logs.
    3. Force MySQL to start using new log files by running mysqladmin refresh.
    4. Force MySQL to start using new log files by running mysqladmin rotate-logs.
    5. Use the mysql-log-rotate script for rotating logs and log clean up.

  2. With what option should mysqld be started to enable binary logging?
    1. --bin
    2. --binary
    3. --enable-bin
    4. --enable-binary
    5. --log-bin

  3. By default, in which directory are all MySQL server log files are created in?
    1. /bin
    2. /etc
    3. /mysql/log
    4. The mysqld data directory.
    5. /var/log

  4. Which statement is false about slow query log?
    1. Log order is always the same as execution order.
    2. The default value of long_query_time is 10 seconds.
    3. The minimum value of long_query_time is 1 second.
    4. To enable the slow query log, start mysqld with the --log-slow-queries option.
    5. Use the mysqldumpslow command to summarize the queries in the slow query log.
[OUTLINE] [PREVIOUS] [NEXT PAGE] [CHAPTER 6]

© 2007 John Michael Pierobon

Notes