Oracle MySQL 5 Database Administrator Certified Professional Set 5

The slow log records the timestamps of when the server is performing slowly and when it is low on resources. The slow log records the text of all queries that exceed the long_query_time variable. The slow log is enabled with the --log-slow-queries or --log-slow-queries=file_name option. The slow log is enabled with the --log-slow or --log-slow=file_name option.

Use the --log-queries-indexes option. ✘ Use the --log-slow-queries-indexes option. ✘ Use the --log-queries-not-using-indexes option. ✘ Use the --log-slow-queries-not-using-indexes option. ✔

The script is used to convert Unix-type timezone files into SQL statements that can be loaded. The script is used to insert timezone files into MySQL. shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql shell> /usr/share/zoneinfo mysql_tzinfo_to_sql | mysql -u root mysql

All initial accounts should have passwords set and unused accounts should be removed. The MySQL server should be set to run as it's own user, not as an administrative account. The data directory and it's contents should be strictly accessible only to the user MySQL runs as. The server should be started with the mysqld_secure script.

The server SQL mode determines how the server should behave when performing data validation checks
and interpreting different forms of syntax. ✘ The server SQL mode determines whether the server should be read-only or accept commands such asINSERT, UPDATE, etc. ✘ The default SQL mode can be set by adding a mode="" to the [mysqld] section of a server option file. ✘ The SQL mode can be changed at the session level with a SET SESSION sql_mode="" command. ✔

Read and understand the appropriate "Upgrading MySQL" section of the online manual. ✘ Read through the online change notes and understand the changes made between the versions. ✘ Prepare the datadir to be read in by a new version by running the mysqlupgrade --prepare command on it. ✘ Nothing; MySQL data files are binary compatible between all versions and the server will automaticallyperform any conversions needed. ✔

Check the MySQL Reference Manual upgrading section and read the parts that concern your upgrade ✘ Backup your databases ✘ Stop the MySQL server ✘ Install the new version of MySQL on top of the existing version ✔ Start the new server ✔

1 ✘

24 by 7 operations can be maintained but backups may not consist of a full snapshot ✘ 24 by 7 operations can be maintained but may be halted at backup time. ✘ 24 by 7 operations can be maintained without interruptions. ✘ 24 by 7 operations can be maintained with backups from a slave server. ✔ 24 by 7 operations can be maintained with a slave being the "hot spare". ✔

The master.info file Any relay logs The relay index The world db file The replication world file