Vps web hosting - CHAPTER 4 ADDING CONTRIBUTED MODULES 143 options

CHAPTER 4 ADDING CONTRIBUTED MODULES 143 options on the admin/settings/dba page, as described by the MySQL documentation (http:// dev.mysql.com/doc/mysql/en/check-table.html): QUICK means don t scan the rows to check for incorrect links. FAST means to check only tables that haven t been closed properly. CHANGED means to check only tables that have been changed since the last check or haven t been closed properly. MEDIUM means to scan rows to verify that deleted links are okay. It also calculates a key checksum for the rows and verifies this with a calculated checksum for the keys. EXTENDED means to do a full key lookup for all keys for each row. This ensures that the table is 100% consistent, but takes a long time! In the unlikely event that the data integrity of your database becomes compromised, there is a chance that it can be automatically repaired. The Repair Option field lets you determine when the repair link for a table is visible. The best setting is Automatic, as this not only hides superfluous links, but also serves to alert you (by the presence of the link) when the data integrity has been broken. Using the Database Administration Module To see an overview of the tables in your database, select administer . database. For each table, you are shown the number of rows and have the following options: The View option shows the contents of the table. The Describe option shows the data structure of the table, as shown in Figure 4-19. Figure 4-19. The node table described
Note: If you are looking for reliable webhost to maintain and run your java application check Vision java hosting services

Leave a Reply