Shulou(Shulou.com)05/31 Report--

This article mainly introduces the MySQL 5.5 NDB cluster how to view the log, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to know about it.

View logs in the management node

~ > 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

..

View logs on the data node

~ / 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 2464 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:

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:

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

View logs on the SQL node

~ / 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

Thank you for reading this article carefully. I hope the article "MySQL 5.5 NDB Cluster how to View logs" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and follow the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.