pt-summary Reports Unstable CPU Speeds

Reported by Jervin R on 2012-04-04
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
Undecided
Unassigned

Bug Description

# Processor ##################################################
  Processors | physical = 1, cores = 4, virtual = 8, hyperthreading = yes
      Speeds | 7x1600.000, 1x2200.000
      Models | 8xIntel(R) Xeon(R) CPU E31230 @ 3.20GHz
      Caches | 8x8192 KB

# Processor ##################################################
  Processors | physical = 1, cores = 4, virtual = 8, hyperthreading = yes
      Speeds | 6x1600.000, 2x3201.000
      Models | 8xIntel(R) Xeon(R) CPU E31230 @ 3.20GHz
      Caches | 8x8192 KB

# Processor ##################################################
  Processors | physical = 1, cores = 4, virtual = 8, hyperthreading = yes
      Speeds | 8x1600.000
      Models | 8xIntel(R) Xeon(R) CPU E31230 @ 3.20GHz
      Caches | 8x8192 KB

[root@forge bin]# cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      8 1600.000
[root@forge bin]# cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      8 1600.000
[root@forge bin]# cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      8 1600.000
[root@forge bin]# cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      8 1600.000
[root@forge bin]# cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      8 1600.000
[root@forge bin]# cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      8 1600.000

[root@forge bin]# tail pt-summary
this program; if not, write to the Free Software Foundation, Inc., 59 Temple
Place, Suite 330, Boston, MA 02111-1307 USA.

=head1 VERSION

pt-summary 2.0.4

=cut

DOCUMENTATION

Jervin R (revin) wrote :
Download full text (7.8 KiB)

[root@forge bin]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 42
model name : Intel(R) Xeon(R) CPU E31230 @ 3.20GHz
stepping : 7
cpu MHz : 1600.000
cache size : 8192 KB
physical id : 0
siblings : 8
core id : 0
cpu cores : 4
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 x2apic popcnt xsave avx lahf_lm ida arat epb xsaveopt pln pts dts tpr_shadow vnmi flexpriority ept vpid
bogomips : 6385.73
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 42
model name : Intel(R) Xeon(R) CPU E31230 @ 3.20GHz
stepping : 7
cpu MHz : 1600.000
cache size : 8192 KB
physical id : 0
siblings : 8
core id : 1
cpu cores : 4
apicid : 2
initial apicid : 2
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 x2apic popcnt xsave avx lahf_lm ida arat epb xsaveopt pln pts dts tpr_shadow vnmi flexpriority ept vpid
bogomips : 6384.67
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 42
model name : Intel(R) Xeon(R) CPU E31230 @ 3.20GHz
stepping : 7
cpu MHz : 1600.000
cache size : 8192 KB
physical id : 0
siblings : 8
core id : 2
cpu cores : 4
apicid : 4
initial apicid : 4
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 x2apic popcnt xsave avx lahf_lm ida arat epb xsaveopt pln pts dts tpr_shadow vnmi flexpriority ept vpid
bogomips : 6384.67
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 42
model name : Intel(R) Xeon(R) CPU E31230 @ 3.20GHz
stepping : 7
cpu MHz : 1600.00...

Read more...

tags: added: pt-summary wrong-output
Changed in percona-toolkit:
status: New → Triaged
Brian Fraser (fraserbn) on 2012-08-27
Changed in percona-toolkit:
assignee: nobody → Brian Fraser (fraserbn)
Brian Fraser (fraserbn) wrote :

This seems to be a /proc/cpuinfo issue, or at least a problem with our assumptions:

hugmeir@naw:~/percona-toolkit$ cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      8 1400.000
hugmeir@naw:~/percona-toolkit$ cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      8 1400.000
hugmeir@naw:~/percona-toolkit$ cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      7 1400.000
      1 3100.000
hugmeir@naw:~/percona-toolkit$ cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      7 1400.000
      1 3100.000
hugmeir@naw:~/percona-toolkit$ cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      8 1400.000
hugmeir@naw:~/percona-toolkit$ cat /proc/cpuinfo |awk -F: '/cpu MHz/{print $2}'|sort | uniq -c
      8 1400.000

Which makes me think that it's reporting the scaling frequency, rathr than the min or max frequency.
Maybe the tool should be reporting the last two, taken from /sys/devices/system/cpu/cpuN/cpufreq/cpuinfo_{min,max}_freq for every core.
I'll go ahead and implement that in the next few days unless there's any objections.

Brian Fraser (fraserbn) on 2012-10-31
Changed in percona-toolkit:
status: Triaged → In Progress
Brian Fraser (fraserbn) on 2012-11-09
Changed in percona-toolkit:
milestone: none → 2.1.7
Changed in percona-toolkit:
milestone: 2.1.7 → 2.1.8
Changed in percona-toolkit:
milestone: 2.1.8 → none
Brian Fraser (fraserbn) on 2013-05-03
Changed in percona-toolkit:
milestone: none → 2.2.3
Changed in percona-toolkit:
assignee: Brian Fraser (fraserbn) → nobody
Changed in percona-toolkit:
status: In Progress → Triaged
Changed in percona-toolkit:
importance: Undecided → Low
Daniel Nichter (daniel-nichter) wrote :

Jervin, do you have a system on which we can reproduce this? Before we apply a fix at random, I'd like at least a manual test case.

Changed in percona-toolkit:
status: Triaged → In Progress
assignee: nobody → Daniel Nichter (daniel-nichter)
Jervin R (revin) wrote :

Daniel,

I could not reproduce this on the same box I tested this with - though it might be hyperthreading as it was enabled before.

[revin@forge pt]$ /wok/bin/pt/204/bin/pt-summary|grep -E "Processors|Speeds|Models"
  Processors | physical = 1, cores = 4, virtual = 4, hyperthreading = no
      Speeds | 4x3192.870
      Models | 4xIntel(R) Xeon(R) CPU E31230 @ 3.20GHz
[revin@forge pt]$ /wok/bin/pt/204/bin/pt-summary|grep -E "Processors|Speeds|Models"
  Processors | physical = 1, cores = 4, virtual = 4, hyperthreading = no
      Speeds | 4x3192.870
      Models | 4xIntel(R) Xeon(R) CPU E31230 @ 3.20GHz
[revin@forge pt]$ /wok/bin/pt/204/bin/pt-summary|grep -E "Processors|Speeds|Models"
  Processors | physical = 1, cores = 4, virtual = 4, hyperthreading = no
      Speeds | 4x3192.870
      Models | 4xIntel(R) Xeon(R) CPU E31230 @ 3.20GHz
[revin@forge pt]$ /wok/bin/pt/204/bin/pt-summary|grep -E "Processors|Speeds|Models"
  Processors | physical = 1, cores = 4, virtual = 4, hyperthreading = no
      Speeds | 4x3192.870
      Models | 4xIntel(R) Xeon(R) CPU E31230 @ 3.20GHz

Same with latest 2.2.3

[revin@forge pt]$ /wok/bin/pt/223/bin/pt-summary --version
pt-summary 2.2.3
[revin@forge pt]$ /wok/bin/pt/223/bin/pt-summary|grep -E "Processors|Speeds|Models"
  Processors | physical = 1, cores = 4, virtual = 4, hyperthreading = no
      Speeds | 4x3192.870
      Models | 4xIntel(R) Xeon(R) CPU E31230 @ 3.20GHz
[revin@forge pt]$ /wok/bin/pt/223/bin/pt-summary|grep -E "Processors|Speeds|Models"
  Processors | physical = 1, cores = 4, virtual = 4, hyperthreading = no
      Speeds | 4x3192.870
      Models | 4xIntel(R) Xeon(R) CPU E31230 @ 3.20GHz
[revin@forge pt]$ /wok/bin/pt/223/bin/pt-summary|grep -E "Processors|Speeds|Models"
  Processors | physical = 1, cores = 4, virtual = 4, hyperthreading = no
      Speeds | 4x3192.870
      Models | 4xIntel(R) Xeon(R) CPU E31230 @ 3.20GHz

I'll see if I can enable HT - might take a while though as KVM is slooow :)

Daniel Nichter (daniel-nichter) wrote :

Thanks Jervin. Let me know if HT changes it. If not, we'll close this bug and see if it comes up later.

Daniel Nichter (daniel-nichter) wrote :

Jervin, were you able to try with HT enabled?

Changed in percona-toolkit:
milestone: 2.2.4 → none
assignee: Daniel Nichter (daniel-nichter) → nobody
importance: Low → Undecided
status: In Progress → Incomplete
Jervin R (revin) wrote :

Daniel,

Now I am able to repeat this with HT

[root@forge ~]# pt-summary --version
pt-summary 2.2.4

[root@forge ~]# pt-summary
# Percona Toolkit System Summary Report ######################
        Date | 2013-08-06 14:20:09 UTC (local TZ: EDT -0400)
    Hostname | forge.dotmanila.com
      Uptime | 2 days, 9:14, 6 users, load average: 0.00, 0.00, 0.00
      System | Supermicro; X10SLH-F/X10SLM+-F; v0123456789 (Main Server Chassis)
 Service Tag | 0123456789
    Platform | Linux
     Release | CentOS release 6.4 (Final)
      Kernel | 2.6.32-358.14.1.el6.x86_64
Architecture | CPU = 64-bit, OS = 64-bit
   Threading | NPTL 2.12
     SELinux | Permissive
 Virtualized | No virtualization detected
# Processor ##################################################
  Processors | physical = 1, cores = 4, virtual = 8, hyperthreading = yes
      Speeds | 1x1000.000, 1x3501.000, 6x800.000
      Models | 8xIntel(R) Xeon(R) CPU E3-1270 v3 @ 3.50GHz
      Caches | 8x8192 KB
# Memory #####################################################
...

Launchpad Janitor (janitor) wrote :

[Expired for Percona Toolkit because there has been no activity for 60 days.]

Changed in percona-toolkit:
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers