MySQL Optimization


  1. The system variable to maintain InnoDB log buffer size is _________________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The InnoDB storage engine has its own cache used for buffering the data and index values. It maintains a log buffer. The size for this is controlled by innodb_log_buffer_size.


  1. In MySQL, the default size of the key buffer in MB is _________________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The larger values allow MySQL to hold more index blocks in memory at once. This increases the chances of finding key values in memory without having to read a new block from disk.



  1. Which status indicator assesses how effective the table cache is?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    When the server accesses various tables, the table cache fills up. The server closes the tables that have not been used recently in order to make room for opening the new tables.


  1. Which system variable controls the size of the table cache?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    In MySQL, when the server opens table files it keeps them open to minimize the number of file-opening operations. It maintains information about open files in the table cache.



  1. Accessing data from which of these is faster?
    memory, disk











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    In MySQL, the administrators have more privileges since they have more control of the MySQL server or the machine on which it runs. Accessing data in memory is faster than from disk.