Arjen Lentz added a comment - 2010-08-18 00:46 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".

abcslayer added a comment - 2010-08-19 16:01 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*[ {mysqld} ] > > 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 >

Rasmus Johansson added a comment - 2010-08-19 16:03 Launchpad bug id: 619417