How can I optimize a single server for real-time query? One of the ip tables is frequently written into php + mysql. how can I optimize a single server for real-time queries? One of the ip tables is frequently written.
Php + mysql
The company asked us to build a management system. the finance-related data should be real-time and only be provided to one server.
Reply to discussion (solution)
What data is mainly queried? what is ip write frequency used?
What data is mainly queried? what is ip write frequency used?
The ip address is written into the access IP address and the number of times and time. the amount payable is calculated by querying the data.
We recommend that you paste the table structure and expected results to make it easier to understand.
Add an index to the table
You don't have to talk about indexes. now we think of partitions.
"Ip table writing frequency"
Frequently written tables should reduce indexes,
This table should not need to be modified (delete/replace/update). you can use the archive engine
"Ip table writing frequency"
Frequently written tables should reduce indexes,
This table should not need to be modified (delete/replace/update). you can use the archive engine
Well, I need this voice. Thank you!