| What has been done:
- Enabled DATABASE logging with
SET GLOBAL general_log = 'ON';
|
- Monitored the executed SQLs by tailing the generated log.
- Checked the number of queries executed with both the cache on and off
The number of executed queries on the DB has been reduced from some hundreds to less than 10 when the cache was on. |