Ask the individual server to do real-time queries, how to optimize? One of the IP table writes is more frequent
Php+mysql
Company let us do a management system, about the financial, data to real-time, only to a server
Reply to discussion (solution)
The main query is what data ah, IP write frequently is used to do?
The main query is what data ah, IP write frequently is used to do?
The IP is written to the access IP and the number of times and time to calculate the amount of the payables by querying these data.
It is easier to read the table structure and expected results.
Index on table
The index does not have to say, now think of is the partition
"IP table writes more frequently"
Tables that are written frequently should have fewer indexes,
This table should not need to be modified (delete/replace/update), consider using the archive engine
"IP table writes more frequently"
Tables that are written frequently should have fewer indexes,
This table should not need to be modified (delete/replace/update), consider using the archive engine
That's a good one, I need that sound. Thanks, man.