We are using Percona 5.6 in our production environment. The database is more read intensive but no read replica’s has been setup yet but that is one of the thing in our TODO list.
Last week I was checking memory usage and I observed that MySQL was using more than 85% of memory but I did not seen any performance depletion due to high memory usage. Is it normal for MySQL to claim maximum Memory but not actually using those memory?
What is the best way to see how MySQL is allocating its memory? Please sherd some light to me.