358 Part III . Administration The -c switch (Apache web server for windows)

358 Part III . Administration The -c switch (which instructs the utility to check) is the default with myisamchk. The –extended-check, –fast, –check-only-changed, –force, and -medium- check options were discussed in the preceding section on mysqlcheck. The –informationswitch prints more information on the table(s) examined. Figure 13-30 shows an example of the myisamchkcommand run with the -i switch. Compare the results to Figure 13-29 to see the extra information printed. Figure 13-30: Using the -i or –information switch tells myisamchk to print more information about the table or tables that it examines. The -T or –read-only switch tells myisamchk not to update the Check_time table variable. (Information about tables can be obtained with the SHOW TABLE STATUS statement using the CLI.) Normally, when myisamchk operates on a table, it updates the Check_time variable. Examples of the -Tor –read-onlyswitch appear in Figures 13-31 through 13-33. Figure 13-31, the SHOW TABLE STATUS statement displays a table that hasn t been checked recently. Figure 13-32 shows a run of the myisamchkcommand with the -T switch. (Notice that the command operates the same as it would without the -T switch.) Figure 13-33 shows the SHOW TABLE STATUS command run again; notice that Check_time still hasn t changed.
We recommend high quality webhost to host and run your jsp application: christian web host services.

Leave a Reply