Mysql Database Engine Optimization

Mysql database engine optimization --------------- myisam ---------------- • Optimizing disk storage
• Tuning your tables for performance analyze table, optimize table, and repair table. • Using the MyISAM utilities myisam_ftdump analyzes the full-text index.
Performance Analysis of myisamchk tables.
Analysis of myisamlog Log changes ..
Myisampack compression table. Stored • Storing a table in index order • Compressing tables • Defragmenting tables • Monitoring the key cache • Preloading key caches • Using multiple key caches • Other parameters to consider Using innodb --------------- • Using SHOW ENGINE command • Using InnoDB monitors • Monitoring logfiles • Monitoring the buffer pool • Monitoring tablespaces • Using INFORMATION_SCHEMA table S www.2cto.com • Other parameters to consider: innodb_thread_concurrency adjust concurrent Thread 0 --> independent hard disk partition + number of cpu cores; innodb_fast_shutdown reduces shutdown time; batch default lock timeout; batch import data: AUTOCOMMIT; temporarily stop the foreign key and unique value restriction. Author: Orange