Installing Percona MySQL - Track SQL CPU, SQL queries, table access volumes, by user
[ SCROLL TO POST #4 TO SEE WHAT USEFUL STUFF YOU CAN DO ]
[ Question below answered, instruction in Post #3 ]
Hey!
I want to install the Percona MySQL server so I can track user stats. This version has been built with the Google userstatsv2.patch so you can do things like look at queries per table to see what users are doing per table.
I've used it before but had it overwritten when 5.0.67 update came out.
Would I be correct that all I need to do to prevent cPanel from updates is going to server config -> updates and set MySQL update to Never?
Word of warning for those who get the idea to try this. You will need to be sure you preserve dbs, make sure all old MySQL packages are removed, be sure you install devel libraries, and also will need to recompile (Easy Apache) apache/php/etc to be sure they are compiled with the correct libraries.
W
[ SCROLL TO POST #4 TO SEE WHAT USEFUL STUFF YOU CAN DO ]
[ Question below answered, instruction in Post #3 ]
Hey!
I want to install the Percona MySQL server so I can track user stats. This version has been built with the Google userstatsv2.patch so you can do things like look at queries per table to see what users are doing per table.
I've used it before but had it overwritten when 5.0.67 update came out.
Would I be correct that all I need to do to prevent cPanel from updates is going to server config -> updates and set MySQL update to Never?
Word of warning for those who get the idea to try this. You will need to be sure you preserve dbs, make sure all old MySQL packages are removed, be sure you install devel libraries, and also will need to recompile (Easy Apache) apache/php/etc to be sure they are compiled with the correct libraries.
W
Last edited: