Re: Status of revivesa

[Izumi Tsutsui <tsutsui%ceres.dti.ne.jp@localhost>]

I wrote:

> I'm also preparing mysqlbench with mysql5-server packages.

I'm not sure what parameter should be used to test pthread properly
but currently it doesn't fail:

---
UID  PID %CPU PPID    CPU LID NLWP PRI NI    VSZ   RSS WCHAN    STAT TTY        
TIME COMMAND
  0  636  0.0  535   1024   1    1  63  0    164     4 wait     IW   ttyp0   
0:00.02 /bin/sh /usr/pkg/bin/mysqld_safe --user
  0  941 29.1  636 149583  20   20  73  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583  19   20  62  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583  18   20  73  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583  17   20  62  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583  16   20  63  0  94028 14244 select   S    ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583  15   20  62  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583  14   20  62  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583  13   20  62  0  94028 14244 sawait   S    ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583  12   20  62  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583  11   20  73  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583  10   20  73  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583   9   20  73  0  94028 14244 biowait  D    ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583   8   20  63  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583   7   20  59  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583   6   20  73  0  94028 14244 sigwait  IW   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583   5   20  59  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583   4   20  73  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583   3   20  62  0  94028 14244 select   S    ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583   2   20  61  0  94028 14244 lwpcache SL   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
  0  941 29.1  636 149583   1   20  73  0  94028 14244 select   IW   ttyp0 
105:49.29 /usr/pkg/libexec/mysqld --basedir=/usr/
100 4260  0.1  538  65055  16   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055  15   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055  14   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055  13   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055  12   16  73  0  62960  3636 lwpcache SL   ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055  11   16  73  0  62960  3636 sawait   S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055  10   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055   9   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055   8   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055   7   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055   6   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055   5   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055   4   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055   3   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055   2   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
100 4260  0.1  538  65055   1   16  73  0  62960  3636 netio    S    ttyp0   
0:05.33 ./mysqlbench -U test -P test -c 14 -s 1
---
Izumi Tsutsui