Re: mysql showing too many processlist.

[Krishna N]

My problem is

" Every mysql connection that is opened in Linux ES 3.0 is creating a new mysqld process. This was not observed while using
the same application with same mysql version on RH 8.0 "


4 S root 29952 1 0 79 0 - 1080 wait Aug09 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe
4 S mysql 2563 29952 0 76 0 - 10822 select Aug09 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2564 2563 0 76 0 - 10822 - Aug09 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2565 2564 0 80 0 - 10822 rt_sig Aug09 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2566 2564 0 76 0 - 10822 rt_sig Aug09 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2567 2564 0 76 0 - 10822 rt_sig Aug09 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2568 2564 0 76 0 - 10822 rt_sig Aug09 ? 00:00:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2569 2564 0 76 0 - 10822 rt_sig Aug09 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2571 2564 0 76 0 - 10822 select Aug09 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2572 2564 0 76 0 - 10822 select Aug09 ? 00:00:10 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2573 2564 0 76 0 - 10822 rt_sig Aug09 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20603 2564 0 75 0 - 10822 335011 Aug10 ? 00:00:39 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20604 2564 0 75 0 - 10822 413460 Aug10 ? 00:00:39 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20605 2564 0 75 0 - 10822 413460 Aug10 ? 00:00:41 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20606 2564 0 75 0 - 10822 381998 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20607 2564 0 75 0 - 10822 413146 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20609 2564 0 75 0 - 10822 413146 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
sql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20610 2564 0 75 0 - 10822 413581 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20611 2564 0 75 0 - 10822 413631 Aug10 ? 00:00:41 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20612 2564 0 75 0 - 10822 413631 Aug10 ? 00:00:41 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20613 2564 0 75 0 - 10822 413631 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20614 2564 0 75 0 - 10822 415294 Aug10 ? 00:00:41 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20615 2564 0 75 0 - 10822 415294 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20616 2564 0 75 0 - 10822 413957 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20617 2564 0 75 0 - 10822 400663 Aug10 ? 00:00:41 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20618 2564 0 75 0 - 10822 400663 Aug10 ? 00:00:41 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20619 2564 0 75 0 - 10822 415032 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20620 2564 0 75 0 - 10822 415032 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20621 2564 0 75 0 - 10822 415032 Aug10 ? 00:00:41 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20622 2564 0 75 0 - 10822 415032 Aug10 ? 00:00:38 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20713 2564 0 75 0 - 10822 414080 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20716 2564 0 75 0 - 10822 396740 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20720 2564 0 76 0 - 10822 415272 Aug10 ? 00:00:38 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20722 2564 0 75 0 - 10822 414080 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/my
1 S mysql 20722 2564 0 75 0 - 10822 414080 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20723 2564 0 75 0 - 10822 414080 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20726 2564 0 75 0 - 10822 407999 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20727 2564 0 75 0 - 10822 361798 Aug10 ? 00:00:39 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20729 2564 0 75 0 - 10822 361798 Aug10 ? 00:00:39 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20731 2564 0 75 0 - 10822 409604 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20734 2564 0 75 0 - 10822 413715 Aug10 ? 00:00:39 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20736 2564 0 75 0 - 10822 400210 Aug10 ? 00:00:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20739 2564 0 75 0 - 10822 401786 Aug10 ? 00:00:41 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20766 2564 0 76 0 - 10822 354310 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20767 2564 0 76 0 - 10822 393279 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20768 2564 0 76 0 - 10822 414213 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20769 2564 0 76 0 - 10822 414804 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20770 2564 0 76 0 - 10822 382635 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20771 2564 0 76 0 - 10822 400209 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20772 2564 0 76 0 - 10822 412831 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20773 2564 0 76 0 - 10822 350571 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
sql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20771 2564 0 76 0 - 10822 400209 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20772 2564 0 76 0 - 10822 412831 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20773 2564 0 76 0 - 10822 350571 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20774 2564 0 76 0 - 10822 327506 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20775 2564 0 76 0 - 10822 412831 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20776 2564 0 76 0 - 10822 376450 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20777 2564 0 76 0 - 10822 341837 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20778 2564 0 76 0 - 10822 368090 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20779 2564 0 76 0 - 10822 415097 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20780 2564 0 76 0 - 10822 415097 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20781 2564 0 76 0 - 10822 413977 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20782 2564 0 76 0 - 10822 375160 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20783 2564 0 76 0 - 10822 333045 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20784 2564 0 76 0 - 10822 404578 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 20785 2564 0 76 0 - 10822 404578 Aug10 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 3881 2564 0 76 0 - 10822 - 11:47 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
0 S root 4582 4510 0 76 0 - 1046 pipe_w 12:29 pts/2 00:00:00 grep mysqld