MySQL 5.5 NDB集群查看日志

缺乏、安全感 2024-04-18 02:08 57阅读 0赞

#### 在管理节点查看日志 ####

~> ps -ef|grep mysql  
root      3934     1  0 May11 ?        00:08:45 /usr/sbin/ndb\_mgmd -f /var/lib/mysql/mysql-cluster/config.ini  
apache    4563 24164  0 Sep04 ?        00:00:00 /usr/var/ss7/mctel/bin/dmc\_mysqlmap -id 10 -t /tmp/dmc\_mysqlmap.log -c /usr/var/ss7/mctel/conf/dmc\_mysqlmap.conf -enc 1 -list BLACKBERRY TORCH 9800  
ss7       6107 31236  0 10:44 pts/0    00:00:00 grep --color mysql  
 ~> cd /var/lib/mysql/mysql-cluster/  
ss7@bep02.mtnng.com - Tue Sep 06 10:44:44  
/var/lib/mysql/mysql-cluster> ll  
total 5.5M  
\-rw-r--r-- 1 root root 4.9K May 15  2014 config.ini  
\-rw-r--r-- 1 root root 671K Sep  6 09:25 ndb\_1\_cluster.log  
\-rw-r--r-- 1 root root 977K Feb 10  2015 ndb\_1\_cluster.log.1  
\-rw-r--r-- 1 root root 977K Feb 13  2015 ndb\_1\_cluster.log.2  
\-rw-r--r-- 1 root root 977K Feb 24  2015 ndb\_1\_cluster.log.3  
\-rw-r--r-- 1 root root 977K Apr  6  2015 ndb\_1\_cluster.log.4  
\-rw-r--r-- 1 root root 977K Oct  4  2015 ndb\_1\_cluster.log.5  
\-rw-r--r-- 1 root root 5.3K Aug  8 06:22 ndb\_1\_out.log  
\-rw-r--r-- 1 root root    4 May 11 21:05 ndb\_1.pid  
ss7@bep02.mtnng.com - Tue Sep 06 10:44:46  
  
/var/lib/mysql/mysql-cluster> cat config.ini | more  
..  
 \[NDB\_MGMD\]  
\# MySQL Cluster Management node on 'vbep'  
NodeId=1  
Hostname=vbep-bepdb                     \# Alias for the internal eth/bond name server  
                                       \# Note: this alias must be defined in /etc/hosts  
DataDir=/var/lib/mysql/mysql-cluster   \# This is a NOT the default location  
                                       \# It has been customized for MCTEL!!  
\[NDBD\]  
\--More--  
\# NDB Storage node on 'db01-sync'  
NodeId=11  
\--More--  
HostName=db01-sync                  \# Alias for the SYNC eth/bond name server  
                                       \# Note: this alias must be defined in /etc/hosts  
DataDir=/var/lib/mysql/data            \# MCTEL check-point and REDO logs directory  
\[NDBD\]  
\# NDB Storage node on 'db02-sync'  
NodeId=12  
HostName=db02-sync                  \# Alias for the SYNC eth/bond name server  
                                       \# Note: this alias must be defined in /etc/hosts  
DataDir=/var/lib/mysql/data            \# MCTEL check-point and REDO logs directory  
..

#### 在数据节点查看日志 ####

~/mctel> ps -ef|grep ndb  
root      6735     1  0 May11 ?        00:00:00 /usr/sbin/ndbd --defaults-file=/etc/my.cnf  
root      6736  6735 51 May11 ?        60-18:02:44 /usr/sbin/ndbd --defaults-file=/etc/my.cnf  
ss7      28110 27214  0 10:59 pts/0    00:00:00 grep --color ndb  
 /var/lib/mysql/database> cd /var/lib/mysql/data  
ss7@db01.mtnng.com - Tue Sep 06 11:09:19  
  
/var/lib/mysql/data> ls -trl  
total 31M  
\-rw-r--r-- 1 root root  959K Jan  2  2014 ndb\_11\_trace.log.1  
\-rw-r--r-- 1 root root  933K May  6  2014 ndb\_11\_trace.log.2  
\-rw-r--r-- 1 root root  997K May 11  2014 ndb\_11\_trace.log.3  
\-rw-r--r-- 1 root root 1015K May 16  2014 ndb\_11\_trace.log.4  
\-rw-r--r-- 1 root root  940K May 16  2014 ndb\_11\_trace.log.5  
\-rw-r--r-- 1 root root  940K May 16  2014 ndb\_11\_trace.log.6  
\-rw-r--r-- 1 root root  940K May 16  2014 ndb\_11\_trace.log.7  
\-rw-r--r-- 1 root root  939K May 16  2014 ndb\_11\_trace.log.8  
\-rw-r--r-- 1 root root  940K May 16  2014 ndb\_11\_trace.log.9  
\-rw-r--r-- 1 root root  940K May 16  2014 ndb\_11\_trace.log.10  
\-rw-r--r-- 1 root root  940K May 16  2014 ndb\_11\_trace.log.11  
\-rw-r--r-- 1 root root  939K May 16  2014 ndb\_11\_trace.log.12  
\-rw-r--r-- 1 root root  940K May 16  2014 ndb\_11\_trace.log.13  
\-rw-r--r-- 1 root root  940K May 16  2014 ndb\_11\_trace.log.14  
\-rw-r--r-- 1 root root     5 May 16  2014 ndb\_11.pid-BAK  
drwxr-x--- 9 root root  4.0K Feb  9  2015 ndb\_11\_fs/  
\-rw-r--r-- 1 root root     2 Feb 24  2015 ndb\_11\_trace.log.next  
\-rw-r--r-- 1 root root  1.1M Feb 24  2015 ndb\_11\_trace.log.15  
\-rw-r--r-- 1 root root  7.4K Feb 24  2015 ndb\_11\_error.log  
\-rw-r--r-- 1 root root     5 May 19 12:05 ndb\_11.pid  
\-rw-r--r-- 1 root root   17M Sep  6 09:18 ndb\_11\_out.log  
ss7@db01.mtnng.com - Tue Sep 06 11:09:23  
  
/var/lib/mysql/data> cat ndb\_11.pid  
30946ss7@db01.mtnng.com - Tue Sep 06 11:09:37  
/var/lib/mysql/data> ps -ef|grep 30946  
ss7       6072  2663  0 11:09 pts/0    00:00:00 grep --color 30946  
root     30946     1  0 May19 ?        00:03:26 /usr/sbin/ndbd --defaults-file=/etc/my.cnf  
root     30947 30946 56 May19 ?        61-15:10:58 /usr/sbin/ndbd --defaults-file=/etc/my.cnf  
ss7@db01.mtnng.com - Tue Sep 06 11:09:46  
 /var/lib/mysql/data> tailf -20 ndb\_11\_out.log  
2016-09-06 08:05:33 \[ndbd\] INFO     -- timerHandlingLab now: 27683165959 sent: 27683165808 diff: 151  
2016-09-06 08:16:25 \[ndbd\] INFO     -- part: 0 : time to complete: 1  
2016-09-06 08:16:28 \[ndbd\] WARNING  -- Ndb kernel thread 0 is stuck in: Job Handling elapsed=100  
2016-09-06 08:16:28 \[ndbd\] WARNING  -- Time moved forward with 2538 ms  
2016-09-06 08:16:28 \[ndbd\] INFO     -- Watchdog: User time: 407716035  System time: 124144921  
2016-09-06 08:16:28 \[ndbd\] WARNING  -- timerHandlingLab now: 27683820592 sent: 27683818054 diff: 2538  
2016-09-06 08:16:28 \[ndbd\] INFO     -- Watchdog: User time: 407716045  System time: 124144922  
2016-09-06 08:16:28 \[ndbd\] WARNING  -- Watchdog: Warning overslept 2464 ms, expected 100 ms.  
2016-09-06 08:17:42 \[ndbd\] INFO     -- timerHandlingLab now: 27683895142 sent: 27683894986 diff: 156  
2016-09-06 08:29:52 \[ndbd\] INFO     -- timerHandlingLab now: 27684624899 sent: 27684624737 diff: 162  
2016-09-06 08:40:00 \[ndbd\] INFO     -- timerHandlingLab now: 27685233311 sent: 27685233138 diff: 173  
2016-09-06 08:46:05 \[ndbd\] INFO     -- timerHandlingLab now: 27685598094 sent: 27685597940 diff: 154  
Backup : Excessive Backup/LCP write rate in last monitoring period - recorded = 12920841 bytes/s, configured = 10485760 bytes/s  
Backup : Monitoring period : 1055 millis. Bytes written : 3407872.  Max allowed : 3145728  
Backup : Excessive Backup/LCP write rate in last monitoring period - recorded = 12970017 bytes/s, configured = 10485760 bytes/s  
Backup : Monitoring period : 1051 millis. Bytes written : 3407872.  Max allowed : 3145728  
2016-09-06 09:10:27 \[ndbd\] INFO     -- timerHandlingLab now: 27687059954 sent: 27687059803 diff: 151  
2016-09-06 09:18:34 \[ndbd\] INFO     -- timerHandlingLab now: 27687547122 sent: 27687546958 diff: 164  
Backup : Excessive Backup/LCP write rate in last monitoring period - recorded = 13157806 bytes/s, configured = 10485760 bytes/s  
Backup : Monitoring period : 1036 millis. Bytes written : 3407872.  Max allowed : 3145728

#### 在SQL节点查看日志 ####

~/mctel> ps -ef|grep mysql  
ss7       3786  2663  0 11:06 pts/0    00:00:00 grep --color mysql  
root     16451     1  0 Aug13 ?        00:00:00 /bin/sh /usr/bin/mysqld\_safe --defaults-file=/var/lib/mysql/main\_my.cnf  
mysql    16888 16451 81 Aug13 ?        19-05:35:07 /usr/sbin/mysqld --defaults-file=/var/lib/mysql/main\_my.cnf --basedir=/usr --datadir=/var/lib/mysql/database --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/database/db01.mtnng.com.err --open-files-limit=50000 --pid-file=/var/lib/mysql/database/db01.mtnng.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306  
ss7@db01.mtnng.com - Tue Sep 06 11:06:31

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2124627/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2124627/