Installed in the Windows server 2012 R2 MySQL8.0.15 community edition, is a 64 - bit; MySQL Server memory is 64 g, the CPU is very good, but the front desk system using very card, and check the MySQL Server, MySQL used RAM only about 3 g, MySQL with CPU is only about 3%, what reason is this excuse me? Thank you very much!

CodePudding user response:

Under Windows Suggestions in essentially, the default installation performance is far above the mysql

Must use the mysql, check the configuration, especially the buffer pool

Windows + mysql this combination with few, tuning must be done by a person himself tried

CodePudding user response:

Affect the performance of mysql key points in IO, i.e., disk, to use SSD, mysql data is stored on disk, disk, memory and CPU again good is useless, you can check the disk,

CodePudding user response:

Thank you, know that MySQL is mainly used to Linux, below is currently installed in the Windows, so don't know what is the reason when the CPU and RAM are couldn't get on even if there is a large number of users access,

Another disk is no problem, is the SSD

CodePudding user response:

Db RAM is mainly buffer allocation, this part is to start to take up,
High CPU part, the CPU is not necessarily the performance is good, appear slow SQL, can easily play the full CPU, QPS, TPS such indicators more objective point,

CodePudding user response:

reference 4 floor luijianfie response:

db RAM is mainly buffer allocation, this part is to start the footprint, the
High CPU part, the CPU is not necessarily the performance is good, appear slow SQL, can easily play the full CPU, QPS, TPS such indicators more objective point,

Has set up some common parameters, such as innodb_buffer_pool_size;


The question now is whether the RAM and CPU usage are only 10%, but the system is very busy

CodePudding user response:

To determine whether the performance bottleneck problem in the database, if the application server, staring at the database does not put a little use,

CodePudding user response:

refer to 6th floor lhdz_bj response:

first to determine whether the performance bottleneck problem in the database, if the application server, staring at the database does not put a little use,

Is how to locate problems in the application server or database server? Thank you very much!

CodePudding user response:

Basically see the innodb_buffer_pool_size
Then look at the
Innodb_flush_log_at_trx_commit
sync_binlog