Shulou(Shulou.com)05/31 Report--

This article focuses on "tuning methods of mysql database engine". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the tuning method of mysql database engine.

Optimizing disk storage

Tuning your tables for performance

ANALYZE TABLE, OPTIMIZE TABLE,REPAIR TABLE .

Using the MyISAM utilities

Myisam_ftdump analyzes the full-text index.

Performance analysis of myisamchk table.

Myisamlog log change analysis. .

Myisampack compression table.

Www.2cto.com

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

-innodb-

Using the SHOW ENGINE command

Using InnoDB monitors

Monitoring logfiles

Monitoring the buffer pool

Monitoring tablespaces

Using INFORMATION_SCHEMA tables

Www.2cto.com

Other parameters to consider:

Innodb_thread_concurrency adjusts the number of cores of concurrent threads 0-> independent hard disk partition + cpu kernel

Innodb_fast_shutdown reduces shutdown time

Innodb_lock_wait_timeout default lock timeout

When importing data in bulk: AUTOCOMMIT; temporarily stops foreign keys and unique value restrictions.

At this point, I believe that you have a deeper understanding of the tuning method of the mysql database engine. You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.