maria-developers team mailing list archive

Thread
Date

Re: New message from Yoshinori Matsunobu

To: maria-developers@xxxxxxxxxxxxxxxxxxx
From: Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx>
Date: Tue, 21 Jan 2014 08:54:21 +0100
In-reply-to: <e35021148b8e229a40729be93108678e@www.facebook.com> (Facebook's message of "Mon, 20 Jan 2014 23:25:14 -0800")
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux)

"Facebook" <notification+xxx@xxxxxxxxxxxxxxxx> writes:

> I read your latest blog post about profile-guided optisation, which is really interesting.
>
> I have one question.. What perf options/arguments did you use to get INST_RETIRED.ANY and ICACHE.MISSES ? perf stat -e cache-misses? I'm not sure what options give these numbers..

    perf record -e r03c -e r1c2 -e rc0 -e r280 -c 250000 sql/mysqld  ...

INST_RETIRED.ANY is -e rc0. ICACHE.MISSES is r280.

Note that except for a few, the performance counters are processer specific.
The full list of available counters is found in "Intel® 64 and IA-32
Architectures Software Developer’s Manual Volume 3B: System Programming Guide,
Part 2". Eg. the ones for Sandy Bridge are found in section 19.4:

    http://www.intel.com/content/www/us/en/processors/architectures-software-developer-manuals.html

(For example, ICACHE.MISSES is umask=0x02 and eventnum=0x80, hence r280.)

 - Kristian.