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 |
[25 Oct 2007 13:29]
elena guerrini
[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..