Web site developers - Analyze Table:This tool updates the data sta- tistics
Analyze Table:This tool updates the data sta- tistics used by the MySQL optimizer. Run thiswhen you ve made significant changes to thedata in your tables. Check Table:This tool checks the table forerrors. If you get an error message that youdon t understand, run Check Table to look forpossible problems. Repair Table:This tool repairs the table. Choose this tool if Check Table reports anyerrors. Optimize Table:This tool reclaims free spaceand rebuilds indexes to increase performance. Show Create:This tool displays the CreateTable and Create Index statements that cre- ated the table. Figure 43-8:The tools included with MySQLCC. After you select the tool that you want to run, apop-up window opens, displaying the tables inyour database (see Figure 43-9). 3.Choose the table you want the tool to act on andthen click the Action button (for the AnalyzeTable tool, it s labeled Analyze, for the CheckTable tool, it s labeled Check, and so on). Figure 43-9:Choose a table from the list. It s a good idea to analyze, check, and opti- mize your MySQL tables on a regular basis tokeep them in top form (database performancetends to degrade over time and the analyzeand optimize tools can give you a quick speedboost). If the Check Table tool reports anyerrors, use the Repair Table tool to correct theproblem. Putting the Server AdministrationcontrolstoworkFollow these steps to begin working with the ServerAdministration controls: 1.Follow the steps in the section, AccessingMySQL Control Center features, earlier in thistechnique, to find the Server Administrationcontrols. 2.Double-click the Server Administration entryon the tree control to open the AdministrationPanel. The panel has three tab controls. Table 43-1gives you a quick look at what each tab has tooffer.
Searching for affordable and proven webhost to host and run your servlet applications? Go to Linux Web Hosting services and you will find it.