 Lingue Disponibili: |
| Inglese >> |
| Italiano >> |
| Risorse Disponibili: |
| Download >> | Acquista >> | HoneySoftware EULA >> |
| Supporto Tecnico >> |
| Ulteriori Risorse:: |
| Richiesta CD >> |
HoneyMonitor |
 |
41.10 Table's Maintenance
HoneyMonitor gives you the necessary tools to do the maintenance of your tables. For partitioned tables, these tools are replaced by the partition's maintenance tools (sec. 41.9.4) and cannot be used for that tables.
41.10.1 Analyze Tables Wizard
The Analyze Tables Wizard allows you to analyze and store the key distribution for MyISAM and InnoDB tables. It implements the SQL syntax ANALYZE TABLE.
During the analysis, the tables are locked with a read lock for MyISAM. For InnoDB the table are locked with a write lock. For MyISAM tables, this statement is equivalent to using myisamchk -a.
MySQLTM uses the stored key distribution to decide the order in which tables should be joined when you perform a join on something other than a constant.
To open the Wizard click on the ''Database Objects / Tables / Table's Maintenance / General'' menu.
See Also:
- 41.10.2: Check Tables Wizard
- 41.10.3: Checksum Tables Wizard
- 41.10.4: Repair Tables Wizard
- 41.10.5: Optimize Tables Wizard
Please, select a connection, a database and the tables to be analyzed then click on the ''Execute'' button (Fig. 41.82).
When done an information message about the operation will be showed.
Options Description:
All tables
Select all the tables of the selected database.
41.10.2 Check Tables Wizard
The Check Tables Wizard allows you to check tables for errors. It implements the SQL syntax CHECK TABLE.
To open the Wizard click on the ''Database Objects / Tables / Table's Maintenance / General'' menu.
See Also:
- 41.10.1: Analyze Tables Wizard
- 41.10.3: Checksum Tables Wizard
- 41.10.4: Repair Tables Wizard
- 41.10.5: Optimize Tables Wizard
41.10.2.1 Choosing database and tables
Please, select a connection, a database and the tables to be checked then click on the ''Next'' button (Fig. 41.83).
Options Description:
All tables
Select all the tables of the selected database.
41.10.2.2 Setting Options
Select the check options then click on the ''Execute'' button (Fig. 41.84).
When done an information message about the operation will be showed. If too many tables have been selected to show the outline info, you may click on the ''Copy Info'' button to copy that information to the WindowsTM Clipboard.
Options Description (these options apply only to checking MyISAM tables and are ignored for InnoDB tables and views):
Quick
Do not scan the rows to check for incorrect links.
Fast
Check only tables that have not been closed properly.
Medium
Scan rows to verify that deleted links are valid. This also calculates a key checksum for the rows and verifies this with a calculated checksum for the keys.
Extended
Do a full key lookup for all keys for each row. This ensures that the table is 100% consistent, but takes a long time.
Changed
Check only tables that have been changed since the last check or that have not been closed properly.
41.10.3 Checksum Tables Wizard
The Checksum Tables Wizard allows you to calculate and view table checksums. It implements the SQL syntax CHECKSUM TABLE.
To open the Wizard click on the ''Database Objects / Tables / Table's Maintenance / General'' menu.
See Also:
- 41.10.1: Analyze Tables Wizard
- 41.10.2: Check Tables Wizard
- 41.10.4: Repair Tables Wizard
- 41.10.5: Optimize Tables Wizard
41.10.3.1 Choosing database and tables
Please, select a connection, a database and the tables for calculate the checksum then click on the ''Next'' button (Fig. 41.85).
Options Description:
All tables
Select all the tables of the selected database.
41.10.3.2 Setting Options
Select the checksum options then click on the ''Execute'' button (Fig. 41.86).
When done the checksum values are reported. If too many tables have been selected to show the outline info, you may click on the ''Copy Info'' button to copy that information to the WindowsTM Clipboard.
Options Description:
Quick
If Quick is selected, the checksum isn't calculated but the live table checksum is reported if it is available, or NULL otherwise. This is very fast. A live checksum is enabled by specifying the CHECKSUM=1 table option when you create the table; currently, this is supported only for MyISAM tables.
Extended
The entire table is read row by row and the checksum is calculated. This can be very slow for large tables.
41.10.4 Repair Tables Wizard
The Repair Tables Wizard allows you to repair a possibly corrupted MyISAM, ARCHIVE or (starting from MySQLTM v.5.1.9) CSV table. It implements the SQL syntax REPAIR TABLE. This statement is equivalent to using myisamchk -recover.
To open the Wizard click on the ''Database Objects / Tables / Table's Maintenance / General'' menu.
See Also:
- 41.10.1: Analyze Tables Wizard
- 41.10.2: Check Tables Wizard
- 41.10.3: Checksum Tables Wizard
- 41.10.5: Optimize Tables Wizard
41.10.4.1 Choosing database and tables
Please, select a connection, a database and the tables to be repaired then click on the ''Next'' button (Fig. 41.87).
Options Description:
All tables
Select all the tables of the selected database.
41.10.4.2 Setting Options
Select the repair options then click on the ''Execute'' button (Fig. 41.88).
When done an information message about the operation will be showed. If too many tables have been selected to show the outline info, you may click on the ''Copy Info'' button to copy that information to the WindowsTM Clipboard.
Options Description:
Quick
If Quick is selected only the index tree is repaired.
Extended
If this option is selected, MySQLTM creates the index row by row instead of creating one index at a time with sorting.
Use_frm
Use this option if the .MYI index file is missing or if its header is corrupted. In this mode, MySQLTM re-creates the .MYI file using information from the .frm file. Use this mode only if you cannot use regular REPAIR modes. The .MYI header contains important table metadata (in particular, current AUTO_INCREMENT value and Delete link) that are lost using this option. Don't use USE_FRM if the table is compressed.
41.10.5 Optimize Tables Wizard
The Optimize Tables Wizard allows you to reclaim any unused space and to defragment the table data file (only for MyISAM, InnoDB, and ARCHIVE tables; but this work on other storage engines by starting mysqld with the -skip-new or -safe-mode option). This can be useful if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns). It implements the SQL syntax OPTIME TABLE.
To open the Wizard click on the ''Database Objects / Tables / Table's Maintenance / General'' menu.
See Also:
- 41.10.1: Analyze Tables Wizard
- 41.10.2: Check Tables Wizard
- 41.10.3: Checksum Tables Wizard
- 41.10.4: Repair Tables Wizard
Select a connection, a database and the tables to be optimized then click on the ''Execute'' button (Fig. 41.89).
All tables
Select all the tables of the selected database.
Copyright © 2007 - 2009 HoneySoftware - All Rights Reserved
Submit feedback on this topic.
