What is the biggest factor to influence the MYSQL database?
CPU frequency? CPU number?
Memory?
The mainboard IO?
Disk read/write speed?

CodePudding user response:

Particular case is particular analysis

CodePudding user response:

Particular case is particular analysis, the key is to see people, cattle server again, I also can use a small piece of code to make it gets stuck, or go to a design, as well as the code quality,

CodePudding user response:

The specific circumstances, specific analysis

CodePudding user response:

refer to the original poster long foot big fairy response:

what is the biggest factor to influence the MYSQL database?
CPU frequency? CPU number?
Memory?
The mainboard IO?
Disk read/write speed?

In reality, has the greatest effect in the application code, for mysql, SQL and stored program (procedure, function, trigger, etc.) the performance of the second, is the original poster said these,

CodePudding user response:

I met a very strange phenomenon, the same code, the same hardware, but different versions of MYSQL, one is MYSQL5.7, another is MYSQL8, ran for a few hours, the former the latter run for half an hour, I don't know what reason be? Feel version has a very big impact on database performance,

CodePudding user response:

1, database for each version upgrade will do some improvement, upgrade the DB version, performance improvement is normal, the general recommended the newer version;
2, problems mainly IO hardware, database and surrounding IO to do a lot of ascension,
3, if the performance, the first screening index, is reasonable, SQL database design is reasonable, whether the database cache open,