How to calculate MySQL Query Memory/CPU Cost

Question

Is there a way/tool/technique to calculate the processor and memory cost of a specific MySQL query?

You might want to mention whether you've already used explain or not, and if so, what you find lacking about it. It may not give what you want, but if you haven't tried it, it's usually the first thing to try. — Jerry Coffin
– Jerry Coffin, Commented Dec 13, 2009 at 23:06

pipelinecache · Accepted Answer · 2009-12-13 23:08:59Z

3

Check this sample:

answered Dec 13, 2009 at 23:08

pipelinecache

4,0341 gold badge19 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Same page states that > MEMORY is not currently implemented I need a way to profile memory cost as well as the cpu.

SHOW PROFILES is deprecated, you can get better data with modern versions of MySQL using performance schema dev.mysql.com/doc/refman/5.7/en/performance-schema.html