Hello everyone,,
Just getting started with MySQL and Percona (5.6.25) - I have a fairly heavy workload (scripts to load a Moodle instance) that takes about 3 hours to run and I'm trying to figure out how to profile or somehow determine whether the system can be tuned and where my bottlenecks are. I've already gone through the slow query log and I have the sys (performance) schema installed and I've looked at the views but was wondering if anyone had any pointers or could give me an idea of how you would go about profiling/tuning/etc.
