Open tiger5226 opened 5 years ago
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html#optimizer-hints-execution-time
We can add optimizer hints to our exposed query API that prevents big queries from running on the instance.
We should also consider requiring LIMIT on all queries performed via the public API. Preferably we use a regex to require <query> LIMIT X( OFFSET Y)
LIMIT
<query> LIMIT X( OFFSET Y)
Big queries can cause a memory spike on the machine.
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html#optimizer-hints-execution-time
We can add optimizer hints to our exposed query API that prevents big queries from running on the instance.
We should also consider requiring
LIMITon all queries performed via the public API. Preferably we use a regex to require<query> LIMIT X( OFFSET Y)Big queries can cause a memory spike on the machine.