Details electric business platform in the like order table, table, increases as the amount of data continuously infinite, database performance also gradually slowed down, how should I deal with these data, ask the great spirit show!!!!!

CodePudding user response:

Code:
1, the real-time performance is not high consider joining the cache

Database:
1, first add index, to check the database table index usage, the commonly used data can give priority to add index see execution speed
2, if after add the index or slow, can consider to master-slave replication, reading and writing separation,
2, the above is still outweighs depots table

CodePudding user response:

With what database, specific bottleneck on what action, if have index, how to use the index, the write operation is frequent, whether the large time span data are often high real-time statistics?

CodePudding user response:

CodePudding user response:

May encounter the same question mark

CodePudding user response:

Points history library and the library

Such as jd, query the order column only 3 months, this in the current library, library history in history, the query frequency much lower

CodePudding user response:

reference 1st floor a52233014 response:

code:
1, the real-time performance is not high consider joining the cache

Database:
1, first add index, to check the database table index usage, the commonly used data can give priority to add index see execution speed
2, if after add the index or slow, can consider to master-slave replication, reading and writing separation,
2, the above is still outweighs depots table it

is very comprehensive