Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 3

It shows a summary of the slow log contents. It dumps the contents of the slow log into a readable format. Shell> mysqldumpslow log_name Shell> mysqldumpslow < log_name

The average amount of space used will be less. Generally, there will be less disk I/O during processing. VARCHAR columns provide better transaction support. The optimizer always performs better with VARCHAR columns over CHAR columns.

Table opening time. Size limits of files. Time to recover from a crash. The number of users MySQL can handle. The type of storage engines that can be used.

The record buffer is set per connection. The record buffer is used for operations such as ORDER BY or GROUP BY. The record buffer is global and is only set by restarting the server. The record buffer is used to perform sequential table scans, reducing the number of readsfrom disk