Bug #31849 prefomance and cpu usage
Submitted: 25 Oct 2007 13:29 Modified: 29 Oct 2007 14:22
Reporter: elena guerrini Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S5 (Performance)
Version:mysql-5.0.45b-i5os-power-64bit OS:Other (IBM/os400)
Assigned to: CPU Architecture:Any
Tags: performance cpu usage
Triage: Triaged: D3 (Medium) / R4 (High) / E4 (High)

[25 Oct 2007 13:29] elena guerrini
we installed mysql on a IBM/os400 V5R4 where we'd already installed php.
Testing our application we've realized that mysqld job cpu consumption is very high (about 50%) and its execution time is about 50% higher then on our linux box. Any suggestion or consideration? 
Thank you 

How to repeat:
test the same configuration.
[26 Oct 2007 6:57] Valeriy Kravchuk
Thank you for a problem report. Please, send the results of SHOW GLOBAL STATUS and SHOW VARIABLES from both Linux and i5OS. 

Are you sure you have same amounts of data and same workload on these boxes?
[26 Oct 2007 7:29] elena guerrini
Both the boxes are underloaded, mysql database  on os400 is a copy of the one on linux and input data is the same db2 table.
[26 Oct 2007 7:39] elena guerrini
os400 global status

Attachment: os400 global status.pdf (application/pdf, text), 21.76 KiB.

[26 Oct 2007 7:39] elena guerrini
linux global status

Attachment: linux global status.pdf (application/pdf, text), 25.53 KiB.

[26 Oct 2007 7:39] elena guerrini
os400 variables

Attachment: os400 variables.pdf (application/pdf, text), 24.40 KiB.

[26 Oct 2007 7:40] elena guerrini
linux variables

Attachment: linux variables.pdf (application/pdf, text), 26.26 KiB.

[27 Oct 2007 17:16] Kyle Joiner
could you please submit the results of WRKACTJOB and WRKDSKSTS before and during the peak of processor usage.
[29 Oct 2007 11:02] elena guerrini
the report requested

Attachment: AS400.txt (text/plain), 7.66 KiB.

[29 Oct 2007 15:46] Kyle Joiner
could you please supply the hardware layout of your I5,  number of processors and type, memory, any partitioning and type of DASD.  And also the equivalent information from your Linux server..