I am seeing the worst performing query as administrator command: Prepare over the last 12 hours where we saw a huge CPU usage spike in MySQL today. All of the usages of this query took 10+ seconds to execute.
We are using Percona pt-query-digest analysis tool.
There are plenty of other normal queries and details as expected in positions 2+. We've also run this tool against our slow query log numerous times without seeing administrator command: Prepare
I have looked all over for examples of a similar result but have found none. What could be causing this?