If the timeout should be how to solve?
A software users probably at around 12 million, for example, a table backup for 5 years or so the user operation record,
At ordinary times to check within 1 month (export) to repeat (distinct) user records in about 3 million or so would take 4 to 5 minutes,
Now you need to check (export) 1, 2 years of record, will timeout, if have any overtime should be how to solve?
Use database tools are aqua date studio, if you can set the timeout? How to set up?
CodePudding user response:
This kind of situation will not appear the lock timeout, because the app is being read data, that is to say the app without waiting for the lock, but if other apps are waiting for the query of lock, if exceed the configured timeout or there will be a lock timeout, but this is other app, rather than the query of the app itself,