habibzain Just husband, father and enthusiastic men about System Administration. Love to write short article about it. Perhaps can help and be useful for others.

Process PS FAXU when snapshot percona Xtra Cluster

1 min read

Process-PS-FAXU-when-snapshot
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
See also  Mysql Backup and Restore from CLI
habibzain Just husband, father and enthusiastic men about System Administration. Love to write short article about it. Perhaps can help and be useful for others.

Ansible Ubuntu 20.04

Introduction Ansible is an open-source automation tool that simplifies configuration management, application deployment, and task automation. It is designed to be simple, lightweight, and...
habibzain
1 min read

Leave a Reply

Your email address will not be published. Required fields are marked *

Never miss good article from us, get weekly updates in your inbox