OPTIMIZING
Optimization is a complex task because ultimately it requires understang of the entire system to be optimized.
Although it may be possible to perform some local optimizations with little knowledge of your system or application,the more optimal you want your system to become, the more you must know about it.
Optimization is a complex task because ultimately it requires understang of the entire system to be optimized.
Although it may be possible to perform some local optimizations with little knowledge of your system or application,the more optimal you want your system to become, the more you must know about it.
REPAIRING
Repairing- If your checks reveals errors, or if you see cryptic error messages about table handlers or corrupt indexes,then you need to try repairing the table. Before repairing a corrupted table is to back it up.
Never try running a repair operation on a table without backing it up. If you fail.
Your data might be in worse shape than originally and may even become unsalvageable.
Repairing- If your checks reveals errors, or if you see cryptic error messages about table handlers or corrupt indexes,then you need to try repairing the table. Before repairing a corrupted table is to back it up.
Never try running a repair operation on a table without backing it up. If you fail.
Your data might be in worse shape than originally and may even become unsalvageable.
CHECKING
Checking- Thew mysql database is automatically checked weekly to verify the health of the database.
This check takes about an hour. If any errors are found, a report is sent to the administrator’s account.
The report name that runs the mysql checked is zmbintegrityreport, and the crontab is automatically configured to run this report once a week.
Checking- Thew mysql database is automatically checked weekly to verify the health of the database.
This check takes about an hour. If any errors are found, a report is sent to the administrator’s account.
The report name that runs the mysql checked is zmbintegrityreport, and the crontab is automatically configured to run this report once a week.
ANALYZING
Analyzing – examines the result from a query and returns an analysis of the results that suggest optimal data types for each column that may help reduce table sizes. To obtain this analysis, append procedure analyze to the end of a select stament.
Analyzing – examines the result from a query and returns an analysis of the results that suggest optimal data types for each column that may help reduce table sizes. To obtain this analysis, append procedure analyze to the end of a select stament.
No comments:
Post a Comment