MySQL 5.5 NDB集群如何查阅日志
发布时间：2022-01-11 16:22:40 所属栏目：MySql教程 来源：互联网
导读：这篇文章主要介绍了MySQL 5.5 NDB集群如何查看日志，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。 /var/lib/mysql/mysql-cluster cat config.ini | more .. [NDB_MGMD] # MySQL Cluste
|
这篇文章主要介绍了MySQL 5.5 NDB集群如何查看日志，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。 /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 （编辑：好传媒网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
