root@db2:/var/lib/mysql# ps faxu | grep sql
root 1573 0.0 0.0 12892 1972 pts/1 S+ 10:25 0:00 | \_ /bin/bash /etc/init.d/mysql start
root 1616 0.0 0.0 4452 780 pts/1 S+ 10:25 0:00 | \_ /bin/sh /usr/bin/mysqld_safe
mysql 2724 0.1 1.1 1441084 627584 pts/1 Sl+ 10:27 0:00 | | \a_ /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --wsrep-provider=/usr/lib/libgalera_smm.so --log-error=/var/log/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_start_position=b175620a-7bec-11e7-ae2a-9f97552b922a:10860996
mysql 2734 0.0 0.0 4452 652 pts/1 S 10:27 0:00 | | \_ sh -c wsrep_sst_xtrabackup-v2 --role 'joiner' --address '10.66.7.3' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --defaults-group-suffix '' --parent '2724' ''
mysql 2735 0.0 0.0 13004 2200 pts/1 S 10:27 0:00 | | \_ /bin/bash -ue /usr/bin/wsrep_sst_xtrabackup-v2 --role joiner --address 10.66.7.3 --datadir /var/lib/mysql/ --defaults-file /etc/mysql/my.cnf --defaults-group-suffix --parent 2724
mysql 3096 0.0 0.0 13004 1440 pts/1 S 10:27 0:00 | | \_ /bin/bash -ue /usr/bin/wsrep_sst_xtrabackup-v2 --role joiner --address 10.66.7.3 --datadir /var/lib/mysql/ --defaults-file /etc/mysql/my.cnf --defaults-group-suffix --parent 2724
mysql 3103 22.8 0.0 19620 1524 pts/1 S 10:27 0:45 | | \_ socat -u TCP-LISTEN:4444,reuseaddr stdio
mysql 3104 28.1 0.0 106420 11680 pts/1 Sl 10:27 0:56 | | \_ xbstream -x
root 3156 0.0 0.0 11752 904 pts/2 S+ 10:31 0:00 | \_ grep --color=auto sql
root 2690 0.0 0.0 7244 616 pts/3 S+ 10:27 0:00 \_ tail -f /var/log/mysql/mysql-error.log
root@db2:/var/lib/mysql# ps faxu | grep sql
root 3280 0.0 0.0 11752 904 pts/2 S+ 10:33 0:00 | \_ grep --color=auto sql
root 2690 0.0 0.0 7244 616 pts/3 S+ 10:27 0:00 \_ tail -f /var/log/mysql/mysql-error.log
root 1616 0.0 0.0 4452 780 pts/1 S 10:25 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 2724 0.5 5.1 38184736 2935680 pts/1 Sl 10:27 0:01 \_ /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --wsrep-provider=/usr/lib/libgalera_smm.so --log-error=/var/log/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_start_position=b175620a-7bec-11e7-ae2a-9f97552b922a:10860996
Process PS FAXU when snapshot percona Xtra Cluster
1 min read