The myisamchk command-line program must not be run on a set of tables if...

The correct answer is B. The server might access the same table files. The myisamchk utility for MyISAM tables also performs table maintenance. However, it takes a different approach from MySQL Administrator and mysqlcheck. Rather than sending SQL statements to the server, myisamchk directly reads and modified the table files. For this reason…

MySQL Database Maintenance

Question

Options

AThe server is running.
BThe server might access the same table files.
CThe server might access any tables in the same database.

How the community answered

(37 responses)

A
11% (4)
B
73% (27)
C
16% (6)

Explanation

The myisamchk utility for MyISAM tables also performs table maintenance. However, it takes a different approach from MySQL Administrator and mysqlcheck. Rather than sending SQL statements to the server, myisamchk directly reads and modified the table files. For this reason, it's necessary when using myisamchk to ensure that the server does not access the tables at the same time.The myisamchk utility for MyISAM tables also performs table maintenance. However, it takes a different approach from MySQL Administrator and mysqlcheck. Rather than sending SQL statements to the server, myisamchk directly reads and modified the table files. For this reason, it's necessary when using myisamchk to ensure that the server does not access the tables at the same time.

Topics

#myisamchk#MyISAM maintenance#table file access#server concurrency

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice