Why MySQL (paid supported version from Oracle) causes hyper threading?
Issue
Oracle MySQL causes hyper threading by using only 1 CPU, which is handling all transactions.
# cat interrupts
CPU0 CPU1 CPU2 CPU3 CPU4 CPU5 CPU6 CPU7
0: 2167854801 0 0 0 0 0 0 0 IO-APIC-edge timer
1: 3 0 0 0 0 0 0 0 IO-APIC-edge i8042
5: 0 0 0 0 0 0 0 0 IO-APIC-level ehci_hcd:usb1, ohci_hcd:usb2, ohci_hcd:usb
8: 1 0 0 0 0 0 0 0 IO-APIC-edge rtc
9: 0 0 0 0 0 0 0 0 IO-APIC-level acpi
12: 5 0 0 0 0 0 0 0 IO-APIC-edge i8042
66: 36 0 0 0 0 0 0 0 IO-APIC-level uhci_hcd:usb4
74: 135198629 0 0 0 0 0 0 0 PCI-MSI cciss0
98: 4262186501 0 0 0 0 0 0 0 PCI-MSI eth0
106: 24247371 0 0 0 0 0 0 0 PCI-MSI eth1
114: 718162701 0 0 0 0 0 0 0 PCI-MSI eth2
122: 25096631 0 0 0 0 0 0 0 PCI-MSI eth3
169: 130604790 0 0 0 0 0 0 0 IO-APIC-level qla2xxx
177: 130697839 0 0 0 0 0 0 0 IO-APIC-level qla2xxx
NMI: 253074 28726 38044 31343 26489 16586 46228 49604
LOC: 2167646381 2167646387 2167646311 2167646230 2167646161 2167646086 2167646011 2167645936
ERR: 0
MIS: 0
Environment
- Red Hat Enterprise Linux 5.7
- MySQL 5.5.17
- HP ProLiant BL465c G5 (2x2 dual core processors)
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.