MySQL Bugs: #57590: Thread Priority in Mysqld Daemon on System i

Bug #57590	Thread Priority in Mysqld Daemon on System i
Submitted:	20 Oct 2010 6:20	Modified:	9 Feb 2011 14:50
Reporter:	Eduardo Pascual	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server: DB2SE for IBM i	Severity:	S2 (Serious)
Version:	5.1.51 GA	OS:	IBM i
Assigned to:		CPU Architecture:	Any

Description:
We have MySQL Running on System i with IBMDB2I Storage Engine. The MySQL daemon (mysqld) is running on separated subsystem with priority of 40. The QSQSRVR jobs for MySQL are running on the same subsystem with the same priority (40).
The MySQLd job have 10 threads. Each Thread have the priority of 80 (approximately twice the job priority). Is it possible to have the same priority in threads that the prority of the job?
For Example in the QZDASOINIT jobs the priority of the threads is the same as the priority of the work itself.

How to repeat:
It's set as indicated by the IBM RedBook.

This is a setting controlled by the System I job class which is not a bug or feature that MySQL can control.  Normally the priority must be controlled by creating a class(CRTCLS) and route(ADDRTGE) for the job.  

Does your job have these?  Could you please attach text file of a screen print of the class for the job.

Hi, 

I send you attached three files:
DSPSBSD
DSPCLS
CL Program with start job of MYSQL Daemon.

Best Regards Edu

Subsystem

Attachment: QPRTSBSD803836.txt (text/plain), 19.68 KiB.

Class

Attachment: QPDSPCLS803836.txt (text/plain), 1.92 KiB.

Start Program

Attachment: QPSUPRTF803836.txt (text/plain), 2.57 KiB.

According to http://dev.mysql.com/doc/refman/5.1/en/news-5-1-54.html we do not support IBMDB2I storage engine any more. Sorry.