Re: the number of mysqld processes in pstree is not equal to mysqld status report
mysqld internally has more threads in additional to all the connections, for instance InnoDB has a number of background reader and writer threads.
So what you see is entirely normal. I'm going to set this to "not a bug".

Re: [Bug 619417] Re: the number of mysqld processes in pstree is not equal to mysqld status report
Thank you for your help.
I have installed MariaDB over existing MySQL server and the install process
is not as smooth as expected (i.e: the install script did not fully replace
all startup scripts, so there are two mysql master server startup, one is
from old script, one (mysql-safe) from the new script).
And the new server is not faster than the old one which is installed on a
VPS. When I try to narrow down the reasons, I have checked for the mysql
processes as I fear there are still something not correctly configured.

With your help, I will spend my time to explore other area for the faulty.
Thank you again,
Tu Pham Ngoc
--------------------------------
Skype: phamngoctuuk
YM/MSN: phamngoctuuk@hotmail.com
HP: +84 90 446 1132
--------------------------------
Anh Ngoc Co., Ltd.
56 Trung Hoa Street, Cau Giay District
Hanoi, Vietnam
www.anhngoc.vn

On Wed, Aug 18, 2010 at 7:46 AM, Arjen Lentz <arjen@openquery.com> wrote:

> mysqld internally has more threads in additional to all the connections,
> for instance InnoDB has a number of background reader and writer threads.
> So what you see is entirely normal. I'm going to set this to "not a bug".
>
> ** Changed in: maria
> Status: New => Invalid
>
> –
> the number of mysqld processes in pstree is not equal to mysqld status
> report
> https://bugs.launchpad.net/bugs/619417
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Maria: Invalid
>
> Bug description:
> Currently, from pstree command result:
>
> ├─mysqld_safe─┬─logger
> │ └─mysqld───77*[

]
>
> But from the status of mysql:
>
> MariaDB [(none)]> status
> --------------
> mysql Ver 14.16 Distrib 5.1.49-MariaDB, for debian-linux-gnu (x86_64)
> using readline 5.1
>
> Connection id: 662451
> Current database:
> Current user: root@localhost
> SSL: Not in use
> Current pager: stdout
> Using outfile: ''
> Using delimiter: ;
> Server: MariaDB
> Server version: 5.1.49-MariaDB-mariadb82-log (MariaDB -
> http://mariadb.com/)
> Protocol version: 10
> Connection: Localhost via UNIX socket
> Server characterset: latin1
> Db characterset: latin1
> Client characterset: latin1
> Conn. characterset: latin1
> UNIX socket: /var/run/mysqld/mysqld.sock
> Uptime: 5 days 23 min 34 sec
>
> Threads: 1 Questions: 10112301 Slow queries: 14117 Opens: 3992 Flush
> tables: 2 Open tables: 398 Queries per second avg: 23.331
>
>
> MariaDB [(none)]> SHOW STATUS LIKE 'threads%'
> -> ;
> ------------------------+
> | Variable_name | Value |
> ------------------------+
> | Threads_cached | 54 |
> | Threads_connected | 1 |
> | Threads_created | 55 |
> | Threads_running | 1 |
> ------------------------+
> 4 rows in set (0.00 sec)
>
> The total running threads are 55. Where is 22 threads (77-55) gone?
> Please help me solve the bugs
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/maria/+bug/619417/+subscribe
>

Launchpad bug id: 619417