login as: root root@192.168.56.228's password: ┌──────────────────────────────────────────────────────────────────────┐ │ ? MobaXterm Personal Edition v24.0 ? │ │ (SSH client, X server and network tools) │ │ │ │ ? SSH session to root@192.168.56.228 │ │ ? Direct SSH : ? │ │ ? SSH compression : ? │ │ ? SSH-browser : ? │ │ ? X11-forwarding : ? (disabled or not supported by server) │ │ │ │ ? For more info, ctrl+click on help or visit our website. │ └──────────────────────────────────────────────────────────────────────┘ Activate the web console with: systemctl enable --now cockpit.socket Last login: Tue May 27 00:05:37 2025 from 192.168.56.100 [root@DB4 ~]# cd /MARIA_LOG/binary/ [root@DB4 binary]# ll 합계 20056 -rw-rw----. 1 maria maria 1545428 5월 25 22:17 mysql-bin.000005 -rw-rw----. 1 maria maria 496 5월 25 23:08 mysql-bin.000006 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000007 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000008 -rw-rw----. 1 maria maria 496 5월 25 23:10 mysql-bin.000009 -rw-rw----. 1 maria maria 1597609 5월 25 23:28 mysql-bin.000010 -rw-rw----. 1 maria maria 496 5월 25 23:28 mysql-bin.000011 -rw-rw----. 1 maria maria 496 5월 26 00:00 mysql-bin.000012 -rw-rw----. 1 maria maria 2596295 5월 26 00:28 mysql-bin.000013 -rw-rw----. 1 maria maria 7203223 5월 27 02:57 mysql-bin.000014 -rw-rw----. 1 maria maria 1773789 5월 27 03:06 mysql-bin.000015 -rw-rw----. 1 maria maria 385 5월 27 02:57 mysql-bin.index -rw-r--r--. 1 root root 5776884 5월 27 03:45 mysql.test [root@DB4 binary]# cat mysql.test |grep -i gtid |more #250527 2:57:09 server id 4 end_log_pos 363 CRC32 0xcf6bd758 Gtid list [5-5-964, #250527 3:02:20 server id 5 end_log_pos 491 CRC32 0xc78f3592 GTID 5-5-1439 trans /*!100001 SET @@session.gtid_domain_id=5*//*!*/; /*!100001 SET @@session.gtid_seq_no=1439*//*!*/; #250527 3:02:20 server id 5 end_log_pos 2612 CRC32 0xf0500521 GTID 5-5-1440 trans waited /*!100001 SET @@session.gtid_seq_no=1440*//*!*/; #250527 3:02:20 server id 5 end_log_pos 4735 CRC32 0x5a639c26 GTID 5-5-1441 cid=92031 trans /*!100001 SET @@session.gtid_seq_no=1441*//*!*/; #250527 3:02:20 server id 5 end_log_pos 6858 CRC32 0x0732eee9 GTID 5-5-1442 cid=92031 trans /*!100001 SET @@session.gtid_seq_no=1442*//*!*/; #250527 3:02:20 server id 5 end_log_pos 8979 CRC32 0xe7580ad1 GTID 5-5-1443 trans /*!100001 SET @@session.gtid_seq_no=1443*//*!*/; #250527 3:02:20 server id 5 end_log_pos 11100 CRC32 0x41c3d50c GTID 5-5-1444 trans waited /*!100001 SET @@session.gtid_seq_no=1444*//*!*/; #250527 3:02:20 server id 5 end_log_pos 13221 CRC32 0x4cf9d696 GTID 5-5-1445 trans waited /*!100001 SET @@session.gtid_seq_no=1445*//*!*/; #250527 3:02:20 server id 5 end_log_pos 15342 CRC32 0xf8b74e52 GTID 5-5-1446 trans /*!100001 SET @@session.gtid_seq_no=1446*//*!*/; #250527 3:02:20 server id 5 end_log_pos 17463 CRC32 0xacb130ac GTID 5-5-1447 trans /*!100001 SET @@session.gtid_seq_no=1447*//*!*/; #250527 3:02:20 server id 5 end_log_pos 19584 CRC32 0xd1bea2bb GTID 5-5-1448 trans waited /*!100001 SET @@session.gtid_seq_no=1448*//*!*/; #250527 3:02:20 server id 5 end_log_pos 21705 CRC32 0x9997f920 GTID 5-5-1449 trans waited /*!100001 SET @@session.gtid_seq_no=1449*//*!*/; #250527 3:02:20 server id 5 end_log_pos 23826 CRC32 0x3e1f8ed0 GTID 5-5-1450 trans waited /*!100001 SET @@session.gtid_seq_no=1450*//*!*/; #250527 3:02:20 server id 5 end_log_pos 25947 CRC32 0x88e02b31 GTID 5-5-1451 trans waited /*!100001 SET @@session.gtid_seq_no=1451*//*!*/; #250527 3:02:20 server id 5 end_log_pos 28068 CRC32 0x6b68aced GTID 5-5-1452 trans /*!100001 SET @@session.gtid_seq_no=1452*//*!*/; #250527 3:02:20 server id 5 end_log_pos 30189 CRC32 0x449f6bb8 GTID 5-5-1453 trans waited /*!100001 SET @@session.gtid_seq_no=1453*//*!*/; #250527 3:02:20 server id 5 end_log_pos 32310 CRC32 0x3a2cd047 GTID 5-5-1454 trans waited /*!100001 SET @@session.gtid_seq_no=1454*//*!*/; #250527 3:02:20 server id 5 end_log_pos 34433 CRC32 0xbc4ad294 GTID 5-5-1455 cid=92101 trans /*!100001 SET @@session.gtid_seq_no=1455*//*!*/; #250527 3:02:20 server id 5 end_log_pos 36556 CRC32 0x817e6f71 GTID 5-5-1456 cid=92101 trans /*!100001 SET @@session.gtid_seq_no=1456*//*!*/; #250527 3:02:20 server id 5 end_log_pos 38677 CRC32 0x29a92d30 GTID 5-5-1457 trans waited /*!100001 SET @@session.gtid_seq_no=1457*//*!*/; #250527 3:02:20 server id 5 end_log_pos 40798 CRC32 0xfa39293a GTID 5-5-1458 trans waited /*!100001 SET @@session.gtid_seq_no=1458*//*!*/; #250527 3:02:20 server id 5 end_log_pos 42921 CRC32 0xfd127fd7 GTID 5-5-1459 cid=92121 trans /*!100001 SET @@session.gtid_seq_no=1459*//*!*/; #250527 3:02:20 server id 5 end_log_pos 45044 CRC32 0xf04472fd GTID 5-5-1460 cid=92121 trans /*!100001 SET @@session.gtid_seq_no=1460*//*!*/; #250527 3:02:20 server id 5 end_log_pos 47165 CRC32 0x4127080a GTID 5-5-1461 trans waited /*!100001 SET @@session.gtid_seq_no=1461*//*!*/; #250527 3:02:20 server id 5 end_log_pos 49286 CRC32 0xac3628c4 GTID 5-5-1462 trans /*!100001 SET @@session.gtid_seq_no=1462*//*!*/; #250527 3:02:20 server id 5 end_log_pos 51407 CRC32 0xfcaa90ac GTID 5-5-1463 trans waited /*!100001 SET @@session.gtid_seq_no=1463*//*!*/; #250527 3:02:20 server id 5 end_log_pos 53528 CRC32 0x74e8cd84 GTID 5-5-1464 trans /*!100001 SET @@session.gtid_seq_no=1464*//*!*/; #250527 3:02:21 server id 5 end_log_pos 55649 CRC32 0x41c5e1bc GTID 5-5-1465 trans waited /*!100001 SET @@session.gtid_seq_no=1465*//*!*/; #250527 3:02:21 server id 5 end_log_pos 57770 CRC32 0xbec25542 GTID 5-5-1466 trans waited /*!100001 SET @@session.gtid_seq_no=1466*//*!*/; #250527 3:02:21 server id 5 end_log_pos 59891 CRC32 0xd197568a GTID 5-5-1467 trans waited /*!100001 SET @@session.gtid_seq_no=1467*//*!*/; #250527 3:02:21 server id 5 end_log_pos 62012 CRC32 0x9a8df23f GTID 5-5-1468 trans waited /*!100001 SET @@session.gtid_seq_no=1468*//*!*/; #250527 3:02:21 server id 5 end_log_pos 64133 CRC32 0x342f89af GTID 5-5-1469 trans /*!100001 SET @@session.gtid_seq_no=1469*//*!*/; #250527 3:02:21 server id 5 end_log_pos 66254 CRC32 0xf1ca7527 GTID 5-5-1470 trans waited /*!100001 SET @@session.gtid_seq_no=1470*//*!*/; #250527 3:02:21 server id 5 end_log_pos 68375 CRC32 0xb290227b GTID 5-5-1471 trans waited /*!100001 SET @@session.gtid_seq_no=1471*//*!*/; #250527 3:02:21 server id 5 end_log_pos 70498 CRC32 0xb63a00a2 GTID 5-5-1472 cid=92186 trans [root@DB4 binary]# [root@DB4 binary]# [root@DB4 binary]# ll 합계 22096 -rw-rw----. 1 maria maria 1545428 5월 25 22:17 mysql-bin.000005 -rw-rw----. 1 maria maria 496 5월 25 23:08 mysql-bin.000006 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000007 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000008 -rw-rw----. 1 maria maria 496 5월 25 23:10 mysql-bin.000009 -rw-rw----. 1 maria maria 1597609 5월 25 23:28 mysql-bin.000010 -rw-rw----. 1 maria maria 496 5월 25 23:28 mysql-bin.000011 -rw-rw----. 1 maria maria 496 5월 26 00:00 mysql-bin.000012 -rw-rw----. 1 maria maria 2596295 5월 26 00:28 mysql-bin.000013 -rw-rw----. 1 maria maria 7203223 5월 27 02:57 mysql-bin.000014 -rw-rw----. 1 maria maria 2554321 5월 27 03:48 mysql-bin.000015 -rw-rw----. 1 maria maria 385 5월 27 02:57 mysql-bin.index -rw-r--r--. 1 root root 5776884 5월 27 03:45 mysql.test [root@DB4 binary]# ll 합계 22096 -rw-rw----. 1 maria maria 1545428 5월 25 22:17 mysql-bin.000005 -rw-rw----. 1 maria maria 496 5월 25 23:08 mysql-bin.000006 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000007 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000008 -rw-rw----. 1 maria maria 496 5월 25 23:10 mysql-bin.000009 -rw-rw----. 1 maria maria 1597609 5월 25 23:28 mysql-bin.000010 -rw-rw----. 1 maria maria 496 5월 25 23:28 mysql-bin.000011 -rw-rw----. 1 maria maria 496 5월 26 00:00 mysql-bin.000012 -rw-rw----. 1 maria maria 2596295 5월 26 00:28 mysql-bin.000013 -rw-rw----. 1 maria maria 7203223 5월 27 02:57 mysql-bin.000014 -rw-rw----. 1 maria maria 2649766 5월 27 03:48 mysql-bin.000015 -rw-rw----. 1 maria maria 385 5월 27 02:57 mysql-bin.index -rw-r--r--. 1 root root 5776884 5월 27 03:45 mysql.test [root@DB4 binary]# ll 합계 22096 -rw-rw----. 1 maria maria 1545428 5월 25 22:17 mysql-bin.000005 -rw-rw----. 1 maria maria 496 5월 25 23:08 mysql-bin.000006 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000007 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000008 -rw-rw----. 1 maria maria 496 5월 25 23:10 mysql-bin.000009 -rw-rw----. 1 maria maria 1597609 5월 25 23:28 mysql-bin.000010 -rw-rw----. 1 maria maria 496 5월 25 23:28 mysql-bin.000011 -rw-rw----. 1 maria maria 496 5월 26 00:00 mysql-bin.000012 -rw-rw----. 1 maria maria 2596295 5월 26 00:28 mysql-bin.000013 -rw-rw----. 1 maria maria 7203223 5월 27 02:57 mysql-bin.000014 -rw-rw----. 1 maria maria 2666734 5월 27 03:48 mysql-bin.000015 -rw-rw----. 1 maria maria 385 5월 27 02:57 mysql-bin.index -rw-r--r--. 1 root root 5776884 5월 27 03:45 mysql.test [root@DB4 binary]# ll 합계 20928 -rw-rw----. 1 maria maria 1545428 5월 25 22:17 mysql-bin.000005 -rw-rw----. 1 maria maria 496 5월 25 23:08 mysql-bin.000006 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000007 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000008 -rw-rw----. 1 maria maria 496 5월 25 23:10 mysql-bin.000009 -rw-rw----. 1 maria maria 1597609 5월 25 23:28 mysql-bin.000010 -rw-rw----. 1 maria maria 496 5월 25 23:28 mysql-bin.000011 -rw-rw----. 1 maria maria 496 5월 26 00:00 mysql-bin.000012 -rw-rw----. 1 maria maria 2596295 5월 26 00:28 mysql-bin.000013 -rw-rw----. 1 maria maria 7203223 5월 27 02:57 mysql-bin.000014 -rw-rw----. 1 maria maria 2666734 5월 27 03:48 mysql-bin.000015 -rw-rw----. 1 maria maria 385 5월 27 02:57 mysql-bin.index -rw-r--r--. 1 root root 5776884 5월 27 03:45 mysql.test [root@DB4 binary]# mysqlbinlog -vv mysql-bin.000015 > mysql.test [root@DB4 binary]# ll 합계 23776 -rw-rw----. 1 maria maria 1545428 5월 25 22:17 mysql-bin.000005 -rw-rw----. 1 maria maria 496 5월 25 23:08 mysql-bin.000006 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000007 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000008 -rw-rw----. 1 maria maria 496 5월 25 23:10 mysql-bin.000009 -rw-rw----. 1 maria maria 1597609 5월 25 23:28 mysql-bin.000010 -rw-rw----. 1 maria maria 496 5월 25 23:28 mysql-bin.000011 -rw-rw----. 1 maria maria 496 5월 26 00:00 mysql-bin.000012 -rw-rw----. 1 maria maria 2596295 5월 26 00:28 mysql-bin.000013 -rw-rw----. 1 maria maria 7203223 5월 27 02:57 mysql-bin.000014 -rw-rw----. 1 maria maria 2666734 5월 27 03:48 mysql-bin.000015 -rw-rw----. 1 maria maria 385 5월 27 02:57 mysql-bin.index -rw-r--r--. 1 root root 8694577 5월 27 03:53 mysql.test [root@DB4 binary]# tail -1000 mysql.test |grep -i gtid|more #250527 3:48:38 server id 2 end_log_pos 2649808 CRC32 0x4047a9fa GTID 2-2-381607 trans /*!100001 SET @@session.gtid_seq_no=381607*//*!*/; #250527 3:48:38 server id 2 end_log_pos 2651929 CRC32 0xd7c22cad GTID 2-2-381608 trans waited /*!100001 SET @@session.gtid_seq_no=381608*//*!*/; #250527 3:48:38 server id 2 end_log_pos 2654050 CRC32 0xff01db2a GTID 2-2-381609 trans /*!100001 SET @@session.gtid_seq_no=381609*//*!*/; #250527 3:48:38 server id 2 end_log_pos 2656171 CRC32 0x9cdbda98 GTID 2-2-381610 trans waited /*!100001 SET @@session.gtid_seq_no=381610*//*!*/; #250527 3:48:38 server id 2 end_log_pos 2658292 CRC32 0xff8b2938 GTID 2-2-381611 trans /*!100001 SET @@session.gtid_seq_no=381611*//*!*/; #250527 3:48:38 server id 2 end_log_pos 2660413 CRC32 0x644143ca GTID 2-2-381612 trans /*!100001 SET @@session.gtid_seq_no=381612*//*!*/; #250527 3:48:38 server id 2 end_log_pos 2662534 CRC32 0xdb389f40 GTID 2-2-381613 trans waited /*!100001 SET @@session.gtid_seq_no=381613*//*!*/; #250527 3:48:38 server id 2 end_log_pos 2664655 CRC32 0xff1021d9 GTID 2-2-381614 trans /*!100001 SET @@session.gtid_seq_no=381614*//*!*/; [root@DB4 binary]# tail -100000 mysql.test |grep -i gtid|more #250527 3:02:28 server id 5 end_log_pos 806623 CRC32 0xa40b8155 GTID 5-5-1819 trans waited /*!100001 SET @@session.gtid_seq_no=1819*//*!*/; #250527 3:02:28 server id 5 end_log_pos 808744 CRC32 0xf21813ea GTID 5-5-1820 trans waited /*!100001 SET @@session.gtid_seq_no=1820*//*!*/; #250527 3:02:28 server id 5 end_log_pos 810865 CRC32 0x9d4d1022 GTID 5-5-1821 trans waited /*!100001 SET @@session.gtid_seq_no=1821*//*!*/; hGM1aBMFAAAAOAAAAGtiDAAAACQAAAAAAAEAA2VuZwAHc2J0ZXN0NAAEAwP+/gTu4P7wAAgrsy8= #250527 3:02:28 server id 5 end_log_pos 812986 CRC32 0x05943812 GTID 5-5-1822 trans /*!100001 SET @@session.gtid_seq_no=1822*//*!*/; #250527 3:02:28 server id 5 end_log_pos 815107 CRC32 0x37483776 GTID 5-5-1823 trans waited /*!100001 SET @@session.gtid_seq_no=1823*//*!*/; #250527 3:02:28 server id 5 end_log_pos 817228 CRC32 0xca6a24fe GTID 5-5-1824 trans waited /*!100001 SET @@session.gtid_seq_no=1824*//*!*/; #250527 3:02:28 server id 5 end_log_pos 819349 CRC32 0xe2cd981d GTID 5-5-1825 trans waited /*!100001 SET @@session.gtid_seq_no=1825*//*!*/; #250527 3:02:28 server id 5 end_log_pos 821470 CRC32 0x315d9c17 GTID 5-5-1826 trans waited /*!100001 SET @@session.gtid_seq_no=1826*//*!*/; #250527 3:02:28 server id 5 end_log_pos 823591 CRC32 0xbd42faaa GTID 5-5-1827 trans waited /*!100001 SET @@session.gtid_seq_no=1827*//*!*/; #250527 3:02:28 server id 5 end_log_pos 825712 CRC32 0x081b0d60 GTID 5-5-1828 trans waited /*!100001 SET @@session.gtid_seq_no=1828*//*!*/; #250527 3:02:28 server id 5 end_log_pos 827835 CRC32 0x9cd887a8 GTID 5-5-1829 cid=93975 trans /*!100001 SET @@session.gtid_seq_no=1829*//*!*/; #250527 3:02:28 server id 5 end_log_pos 829958 CRC32 0xf15cce15 GTID 5-5-1830 cid=93975 trans /*!100001 SET @@session.gtid_seq_no=1830*//*!*/; #250527 3:02:28 server id 5 end_log_pos 832079 CRC32 0xb2347a46 GTID 5-5-1831 trans /*!100001 SET @@session.gtid_seq_no=1831*//*!*/; #250527 3:02:28 server id 5 end_log_pos 834202 CRC32 0xa2278ccf GTID 5-5-1832 cid=93990 trans /*!100001 SET @@session.gtid_seq_no=1832*//*!*/; #250527 3:02:28 server id 5 end_log_pos 836325 CRC32 0xd9e068e1 GTID 5-5-1833 cid=93990 trans /*!100001 SET @@session.gtid_seq_no=1833*//*!*/; #250527 3:02:28 server id 5 end_log_pos 838446 CRC32 0xdfde8d39 GTID 5-5-1834 trans /*!100001 SET @@session.gtid_seq_no=1834*//*!*/; #250527 3:02:28 server id 5 end_log_pos 840567 CRC32 0xa83e6d02 GTID 5-5-1835 trans waited /*!100001 SET @@session.gtid_seq_no=1835*//*!*/; #250527 3:02:28 server id 5 end_log_pos 842688 CRC32 0xdc90e290 GTID 5-5-1836 trans /*!100001 SET @@session.gtid_seq_no=1836*//*!*/; #250527 3:02:28 server id 5 end_log_pos 844809 CRC32 0xf65d41b5 GTID 5-5-1837 trans /*!100001 SET @@session.gtid_seq_no=1837*//*!*/; #250527 3:02:28 server id 5 end_log_pos 846930 CRC32 0x1a04fe1f GTID 5-5-1838 trans waited /*!100001 SET @@session.gtid_seq_no=1838*//*!*/; #250527 3:02:28 server id 5 end_log_pos 849051 CRC32 0xff079437 GTID 5-5-1839 trans waited /*!100001 SET @@session.gtid_seq_no=1839*//*!*/; #250527 3:02:28 server id 5 end_log_pos 851172 CRC32 0xab4604d7 GTID 5-5-1840 trans /*!100001 SET @@session.gtid_seq_no=1840*//*!*/; #250527 3:02:28 server id 5 end_log_pos 853293 CRC32 0xa67e8c67 GTID 5-5-1841 trans waited /*!100001 SET @@session.gtid_seq_no=1841*//*!*/; #250527 3:02:28 server id 5 end_log_pos 855414 CRC32 0x2df9af03 GTID 5-5-1842 trans waited /*!100001 SET @@session.gtid_seq_no=1842*//*!*/; #250527 3:02:28 server id 5 end_log_pos 857535 CRC32 0xaf2459e5 GTID 5-5-1843 trans /*!100001 SET @@session.gtid_seq_no=1843*//*!*/; #250527 3:02:28 server id 5 end_log_pos 859656 CRC32 0x83947f5f GTID 5-5-1844 trans waited /*!100001 SET @@session.gtid_seq_no=1844*//*!*/; #250527 3:02:28 server id 5 end_log_pos 861777 CRC32 0x0aa2611e GTID 5-5-1845 trans /*!100001 SET @@session.gtid_seq_no=1845*//*!*/; #250527 3:02:28 server id 5 end_log_pos 863898 CRC32 0x13c6c869 GTID 5-5-1846 trans waited /*!100001 SET @@session.gtid_seq_no=1846*//*!*/; #250527 3:02:28 server id 5 end_log_pos 866021 CRC32 0x22afce5f GTID 5-5-1847 cid=94065 trans /*!100001 SET @@session.gtid_seq_no=1847*//*!*/; #250527 3:02:28 server id 5 end_log_pos 868144 CRC32 0xb1a2ea75 GTID 5-5-1848 cid=94065 trans /*!100001 SET @@session.gtid_seq_no=1848*//*!*/; #250527 3:02:28 server id 5 end_log_pos 870265 CRC32 0x48bf5134 GTID 5-5-1849 trans waited /*!100001 SET @@session.gtid_seq_no=1849*//*!*/; #250527 3:02:28 server id 5 end_log_pos 872386 CRC32 0x02cf0a08 GTID 5-5-1850 trans /*!100001 SET @@session.gtid_seq_no=1850*//*!*/; [root@DB4 binary]# tail -100000 mysql.test |more hGM1aBcFAAAA3wAAAJZODAAAACMAAAAAAAEABA/wMgAAADMAAAB3ADY0ODY0Njk5MDQ0LTgxMjkx Mzg0NDAwLTYzNDIyMzU4MTE5LTQ2NjEyNDA4NTM3LTEyMDU2OTQwODA5LTc3MDYyMzY0ODMxLTY4 NTE1ODM4MjQ5LTkzMDcwMTI1MjAyLTM0NTgzMTE2Mzk5LTA1MDgwNDQ2NTM1Ozc0NzYxMjgzOTk0 LTU4OTQwNzE3OTU3LTQ5ODM1OTA3ODQzLTU2MTI0MTI0MDg1LTY5NzcwNzIyNzYyD7FeAA== '/*!*/; ### INSERT INTO `eng`.`sbtest3` ### SET ### @1=50 /* INT meta=0 nullable=0 is_null=0 */ ### @2=51 /* INT meta=0 nullable=0 is_null=0 */ ### @3='64864699044-81291384400-63422358119-46612408537-12056940809-77062364831-68515838249-93070125202-34583116399-05080446535' /* STRING(480) meta=61152 nullable=0 is_null=0 */ ### @4='74761283994-58940717957-49835907843-56124124085-69770722762' /* STRING(240) meta=65264 nullable=0 is_null=0 */ # Number of rows: 1 # at 806550 #250527 3:02:28 server id 5 end_log_pos 806581 CRC32 0x11d0c34c Xid = 93917 COMMIT/*!*/; # at 806581 #250527 3:02:28 server id 5 end_log_pos 806623 CRC32 0xa40b8155 GTID 5-5-1819 trans waited /*!100001 SET @@session.gtid_seq_no=1819*//*!*/; START TRANSACTION /*!*/; # at 806623 # at 806682 #250527 3:02:28 server id 5 end_log_pos 806682 CRC32 0x9333c20f Annotate_rows: #Q> UPDATE sbtest4 SET k=k+1 WHERE id=51 #250527 3:02:28 server id 5 end_log_pos 806738 CRC32 0xfd779cb4 Table_map: `eng`.`sbtest4` mapped to number 36 # at 806738 #250527 3:02:28 server id 5 end_log_pos 807152 CRC32 0x1286649b Update_rows: table id 36 flags: STMT_END_F BINLOG ' hGM1aBMFAAAAOAAAAFJPDAAAACQAAAAAAAEAA2VuZwAHc2J0ZXN0NAAEAwP+/gTu4P7wALScd/0= hGM1aBgFAAAAngEAAPBQDAAAACQAAAAAAAEABP//8DMAAAA4AAAAdwAwMjIxOTA4NDY0Mi03MzQy ODk0MTY1Mi02NDM0NDYyMTQ1OS0zNDUzMDMzNTYxOS05NTc0Mjc3MDYzMS0wODQ1MDk3ODAxMC0x MTEwOTk1OTQyNC0zMzAzMTEyMjIzNi0zMjgyNTI4MjE3Ny0yNTY5ODc3MTg4MDs2Njk0NzY0MjY2 MC05NDU4OTkzNDI5OS0wOTUzNjE3NjQxNi0zMDU3NDQ2NTcyMy01OTc0OTU3OTc1NvAzAAAAOQAA AHcAMDIyMTkwODQ2NDItNzM0Mjg5NDE2NTItNjQzNDQ2MjE0NTktMzQ1MzAzMzU2MTktOTU3NDI3 NzA2MzEtMDg0NTA5NzgwMTAtMTExMDk5NTk0MjQtMzMwMzExMjIyMzYtMzI4MjUyODIxNzctMjU2 OTg3NzE4ODA7NjY5NDc2NDI2NjAtOTQ1ODk5MzQyOTktMDk1MzYxNzY0MTYtMzA1NzQ0NjU3MjMt NTk3NDk1Nzk3NTabZIYS '/*!*/; ### UPDATE `eng`.`sbtest4` ### WHERE ### @1=51 /* INT meta=0 nullable=0 is_null=0 */ ### @2=56 /* INT meta=0 nullable=0 is_null=0 */ ### @3='02219084642-73428941652-64344621459-34530335619-95742770631-08450978010-11109959424-33031122236-32825282177-25698771880' /* STRING(480) meta=61152 nullable=0 is_null=0 */ ### @4='66947642660-94589934299-09536176416-30574465723-59749579756' /* STRING(240) meta=65264 nullable=0 is_null=0 */ ### SET ### @1=51 /* INT meta=0 nullable=0 is_null=0 */ ### @2=57 /* INT meta=0 nullable=0 is_null=0 */ ### @3='02219084642-73428941652-64344621459-34530335619-95742770631-08450978010-11109959424-33031122236-32825282177-25698771880' /* STRING(480) meta=61152 nullable=0 is_null=0 */ ### @4='66947642660-94589934299-09536176416-30574465723-59749579756' /* STRING(240) meta=65264 nullable=0 is_null=0 */ # Number of rows: 1 # at 807152 # at 807329 #250527 3:02:28 server id 5 end_log_pos 807329 CRC32 0xccddee4f Annotate_rows: #Q> UPDATE sbtest2 SET c='80097661003-37168622159-32110986633-80399832239-66905903739-44843242757-75705213623-47657958836-50074471816-08399338164' WHERE id=51 #250527 3:02:28 server id 5 end_log_pos 807385 CRC32 0xfe3a1df7 Table_map: `eng`.`sbtest2` mapped to number 34 # at 807385 #250527 3:02:28 server id 5 end_log_pos 807799 CRC32 0xc0bff501 Update_rows: table id 34 flags: STMT_END_F BINLOG ' hGM1aBMFAAAAOAAAANlRDAAAACIAAAAAAAEAA2VuZwAHc2J0ZXN0MgAEAwP+/gTu4P7wAPcdOv4= hGM1aBgFAAAAngEAAHdTDAAAACIAAAAAAAEABP//8DMAAAAsAAAAdwAwMDU4OTIwOTY3MC02MTI4 MzQxOTI3NS05MTg2MjAxMDUzOS01Nzk3MTgwMjAzNS01MTIxMTg0NzIwNS0xOTc2MDEwNzEzNC05 NTU0MDQ5NDEyOS0yODYzODcxMDIxOS0wNTcxNDczNzY4My05NDAwNzg4MTg1OTs5Njk3NDU0ODgy NC01NDQ4NzgyMDg1NS0wMjIxMTI4NTI3Mi05NjEyNTY4ODA4NS0yNDUwMTM1MDE3OfAzAAAALAAA AHcAODAwOTc2NjEwMDMtMzcxNjg2MjIxNTktMzIxMTA5ODY2MzMtODAzOTk4MzIyMzktNjY5MDU5 MDM3MzktNDQ4NDMyNDI3NTctNzU3MDUyMTM2MjMtNDc2NTc5NTg4MzYtNTAwNzQ0NzE4MTYtMDgz OTkzMzgxNjQ7OTY5NzQ1NDg4MjQtNTQ0ODc4MjA4NTUtMDIyMTEyODUyNzItOTYxMjU2ODgwODUt MjQ1MDEzNTAxNzkB9b/A '/*!*/; ### UPDATE `eng`.`sbtest2` ### WHERE ### @1=51 /* INT meta=0 nullable=0 is_null=0 */ ### @2=44 /* INT meta=0 nullable=0 is_null=0 */ ### @3='00589209670-61283419275-91862010539-57971802035-51211847205-19760107134-95540494129-28638710219-05714737683-94007881859' /* STRING(480) meta=61152 nullable=0 is_null=0 */ ### @4='96974548824-54487820855-02211285272-96125688085-24501350179' /* STRING(240) meta=65264 nullable=0 is_null=0 */ ### SET ### @1=51 /* INT meta=0 nullable=0 is_null=0 */ ### @2=44 /* INT meta=0 nullable=0 is_null=0 */ ### @3='80097661003-37168622159-32110986633-80399832239-66905903739-44843242757-75705213623-47657958836-50074471816-08399338164' /* STRING(480) meta=61152 nullable=0 is_null=0 */ ### @4='96974548824-54487820855-02211285272-96125688085-24501350179' /* STRING(240) meta=65264 nullable=0 is_null=0 */ # Number of rows: 1 # at 807799 # at 807853 #250527 3:02:28 server id 5 end_log_pos 807853 CRC32 0xab98d434 Annotate_rows: #Q> DELETE FROM sbtest5 WHERE id=51 #250527 3:02:28 server id 5 end_log_pos 807909 CRC32 0x6fa19aa7 Table_map: `eng`.`sbtest5` mapped to number 37 # at 807909 #250527 3:02:28 server id 5 end_log_pos 808132 CRC32 0xb33468ad Delete_rows: table id 37 flags: STMT_END_F BINLOG ' hGM1aBMFAAAAOAAAAOVTDAAAACUAAAAAAAEAA2VuZwAHc2J0ZXN0NQAEAwP+/gTu4P7wAKeaoW8= hGM1aBkFAAAA3wAAAMRUDAAAACUAAAAAAAEABP/wMwAAADMAAAB3ADY1NzE3MjczODk5LTc4MDk5 NDc5NTIzLTU3MjU2MTc5MjM4LTI3NTU5NzcyOTAxLTI1MzE3NDAxNzkzLTM0NDk0NjcyMzc0LTUy MTIyNjgxNTMyLTAwNDM0MDA0Mzg4LTQ3NzU0NTIwMDYyLTA5OTE4NDU4NTcyOzAxMjQ5NDM5NDAy LTQ2ODQ0NTY4MjU3LTgxMTc2MjY3OTczLTI3MjkwMjUwMTQ1LTM4NzA0MjQ4ODMxrWg0sw== '/*!*/; ### DELETE FROM `eng`.`sbtest5` ### WHERE ### @1=51 /* INT meta=0 nullable=0 is_null=0 */ ### @2=51 /* INT meta=0 nullable=0 is_null=0 */ ### @3='65717273899-78099479523-57256179238-27559772901-25317401793-34494672374-52122681532-00434004388-47754520062-09918458572' /* STRING(480) meta=61152 nullable=0 is_null=0 */ ### @4='01249439402-46844568257-81176267973-27290250145-38704248831' /* STRING(240) meta=65264 nullable=0 is_null=0 */ # Number of rows: 1 # at 808132 # at 808392 #250527 3:02:28 server id 5 end_log_pos 808392 CRC32 0x1d2391c1 Annotate_rows: #Q> INSERT INTO sbtest5 (id, k, c, pad) VALUES (51, 50, '20858984150-55980176824-42698474628-08001584909-13136869736-66798912402-57023853182-82322946246-51651516982-42768247990', '53612193315-74406930890-98654693884-09005079298-472567 28398') #250527 3:02:28 server id 5 end_log_pos 808448 CRC32 0xf93625c7 Table_map: `eng`.`sbtest5` mapped to number 37 # at 808448 #250527 3:02:28 server id 5 end_log_pos 808671 CRC32 0xeffa96bb Write_rows: table id 37 flags: STMT_END_F BINLOG ' hGM1aBMFAAAAOAAAAABWDAAAACUAAAAAAAEAA2VuZwAHc2J0ZXN0NQAEAwP+/gTu4P7wAMclNvk= hGM1aBcFAAAA3wAAAN9WDAAAACUAAAAAAAEABA/wMwAAADIAAAB3ADIwODU4OTg0MTUwLTU1OTgw MTc2ODI0LTQyNjk4NDc0NjI4LTA4MDAxNTg0OTA5LTEzMTM2ODY5NzM2LTY2Nzk4OTEyNDAyLTU3 MDIzODUzMTgyLTgyMzIyOTQ2MjQ2LTUxNjUxNTE2OTgyLTQyNzY4MjQ3OTkwOzUzNjEyMTkzMzE1 LTc0NDA2OTMwODkwLTk4NjU0NjkzODg0LTA5MDA1MDc5Mjk4LTQ3MjU2NzI4Mzk4u5b67w== '/*!*/; ### INSERT INTO `eng`.`sbtest5` ### SET ### @1=51 /* INT meta=0 nullable=0 is_null=0 */ ### @2=50 /* INT meta=0 nullable=0 is_null=0 */ ### @3='20858984150-55980176824-42698474628-08001584909-13136869736-66798912402-57023853182-82322946246-51651516982-42768247990' /* STRING(480) meta=61152 nullable=0 is_null=0 */ ### @4='53612193315-74406930890-98654693884-09005079298-47256728398' /* STRING(240) meta=65264 nullable=0 is_null=0 */ # Number of rows: 1 # at 808671 #250527 3:02:28 server id 5 end_log_pos 808702 CRC32 0xadb83b36 Xid = 93922 COMMIT/*!*/; # at 808702 #250527 3:02:28 server id 5 end_log_pos 808744 CRC32 0xf21813ea GTID 5-5-1820 trans waited /*!100001 SET @@session.gtid_seq_no=1820*//*!*/; START TRANSACTION /*!*/; # at 808744 # at 808803 #250527 3:02:28 server id 5 end_log_pos 808803 CRC32 0xaee8229c Annotate_rows: #Q> UPDATE sbtest5 SET k=k+1 WHERE id=51 #250527 3:02:28 server id 5 end_log_pos 808859 CRC32 0xcb8c42b2 Table_map: `eng`.`sbtest5` mapped to number 37 # at 808859 #250527 3:02:28 server id 5 end_log_pos 809273 CRC32 0x3cf52f9b Update_rows: table id 37 flags: STMT_END_F BINLOG ' hGM1aBMFAAAAOAAAAJtXDAAAACUAAAAAAAEAA2VuZwAHc2J0ZXN0NQAEAwP+/gTu4P7wALJCjMs= hGM1aBgFAAAAngEAADlZDAAAACUAAAAAAAEABP//8DMAAAAyAAAAdwAyMDg1ODk4NDE1MC01NTk4 MDE3NjgyNC00MjY5ODQ3NDYyOC0wODAwMTU4NDkwOS0xMzEzNjg2OTczNi02Njc5ODkxMjQwMi01 NzAyMzg1MzE4Mi04MjMyMjk0NjI0Ni01MTY1MTUxNjk4Mi00Mjc2ODI0Nzk5MDs1MzYxMjE5MzMx NS03NDQwNjkzMDg5MC05ODY1NDY5Mzg4NC0wOTAwNTA3OTI5OC00NzI1NjcyODM5OPAzAAAAMwAA AHcAMjA4NTg5ODQxNTAtNTU5ODAxNzY4MjQtNDI2OTg0NzQ2MjgtMDgwMDE1ODQ5MDktMTMxMzY4 Njk3MzYtNjY3OTg5MTI0MDItNTcwMjM4NTMxODItODIzMjI5NDYyNDYtNTE2NTE1MTY5ODItNDI3 NjgyNDc5OTA7NTM2MTIxOTMzMTUtNzQ0MDY5MzA4OTAtOTg2NTQ2OTM4ODQtMDkwMDUwNzkyOTgt NDcyNTY3MjgzOTibL/U8 '/*!*/; ### UPDATE `eng`.`sbtest5` ### WHERE ### @1=51 /* INT meta=0 nullable=0 is_null=0 */ ### @2=50 /* INT meta=0 nullable=0 is_null=0 */ ### @3='20858984150-55980176824-42698474628-08001584909-13136869736-66798912402-57023853182-82322946246-51651516982-42768247990' /* STRING(480) meta=61152 nullable=0 is_null=0 */ ### @4='53612193315-74406930890-98654693884-09005079298-47256728398' /* STRING(240) meta=65264 nullable=0 is_null=0 */ ### SET ### @1=51 /* INT meta=0 nullable=0 is_null=0 */ ### @2=51 /* INT meta=0 nullable=0 is_null=0 */ ### @3='20858984150-55980176824-42698474628-08001584909-13136869736-66798912402-57023853182-82322946246-51651516982-42768247990' /* STRING(480) meta=61152 nullable=0 is_null=0 */ ### @4='53612193315-74406930890-98654693884-09005079298-47256728398' /* STRING(240) meta=65264 nullable=0 is_null=0 */ # Number of rows: 1 # at 809273 # at 809450 #250527 3:02:28 server id 5 end_log_pos 809450 CRC32 0x1f6049a3 Annotate_rows: #Q> UPDATE sbtest3 SET c='59825327532-15792074477-85592010667-53502699815-66854480244-09024497273-45912299008-62998248174-69802931955-66215861728' WHERE id=43 #250527 3:02:28 server id 5 end_log_pos 809506 CRC32 0xf952d693 Table_map: `eng`.`sbtest3` mapped to number 35 # at 809506 #250527 3:02:28 server id 5 end_log_pos 809920 CRC32 0x334387bd Update_rows: table id 35 flags: STMT_END_F BINLOG ' hGM1aBMFAAAAOAAAACJaDAAAACMAAAAAAAEAA2VuZwAHc2J0ZXN0MwAEAwP+/gTu4P7wAJPWUvk= hGM1aBgFAAAAngEAAMBbDAAAACMAAAAAAAEABP//8CsAAAAyAAAAdwAxNzA0NzM4OTE3Ni0wMDEw NzU0NzExOS0xMzEyMzE0MzgxNi0wMjM3ODk5NzY1NC0yNTA4NjczMzUxMC0xOTI4MzcwMDU5MS05 MjUxNzM1MTk1OS0zMTY5MTE0MzE2Mi03MTYzNTk3NTAzMC0zODc5ODc2OTQzNTsxNDA5MTEyMjky Ny0zMTU2NzkwNjIyNS02NTk0ODEyNjIwNy00NDgzODc0MzYzMi0wNjYyMzA5OTA3OfArAAAAMgAA [root@DB4 binary]# [root@DB4 binary]# cd [root@DB4 ~]# ll 합계 1091456 -rw-------. 1 root root 1169 3월 20 20:25 anaconda-ks.cfg -rw-r--r--. 1 root root 128843903 5월 25 23:29 dumpfile.sql drwxr-xr-x. 2 root root 4096 5월 22 2024 lsb_core -rw-r--r--. 1 root root 27811840 3월 20 20:45 lsb_core.tar -rw-r--r--. 1 root root 6974 4월 22 21:05 maria_10.6.21_my.cnf.20250422.txt -rw-r--r--. 1 root root 960968127 3월 20 20:29 mariadb-10.3.27-linux-systemd-x86_64.tar.gz -rw-r--r--. 1 root root 2352 3월 20 20:34 my.cnf [root@DB4 ~]# ll 합계 1091456 -rw-------. 1 root root 1169 3월 20 20:25 anaconda-ks.cfg -rw-r--r--. 1 root root 128843903 5월 25 23:29 dumpfile.sql drwxr-xr-x. 2 root root 4096 5월 22 2024 lsb_core -rw-r--r--. 1 root root 27811840 3월 20 20:45 lsb_core.tar -rw-r--r--. 1 root root 6974 4월 22 21:05 maria_10.6.21_my.cnf.20250422.txt -rw-r--r--. 1 root root 960968127 3월 20 20:29 mariadb-10.3.27-linux-systemd-x86_64.tar.gz -rw-r--r--. 1 root root 2352 3월 20 20:34 my.cnf [root@DB4 ~]# ll 합계 1091460 -rw-r--r--. 1 root root 2413 5월 27 04:06 DB_INSERT_QUERY_test.sh.txt -rw-------. 1 root root 1169 3월 20 20:25 anaconda-ks.cfg -rw-r--r--. 1 root root 128843903 5월 25 23:29 dumpfile.sql drwxr-xr-x. 2 root root 4096 5월 22 2024 lsb_core -rw-r--r--. 1 root root 27811840 3월 20 20:45 lsb_core.tar -rw-r--r--. 1 root root 6974 4월 22 21:05 maria_10.6.21_my.cnf.20250422.txt -rw-r--r--. 1 root root 960968127 3월 20 20:29 mariadb-10.3.27-linux-systemd-x86_64.tar.gz -rw-r--r--. 1 root root 2352 3월 20 20:34 my.cnf [root@DB4 ~]# vi DB_INSERT_QUERY_test.sh.txt [root@DB4 ~]# [root@DB4 ~]# [root@DB4 ~]# mv DB_INSERT_QUERY_test.sh.txt DB_INSERT_QUERY_test.sh [root@DB4 ~]# [root@DB4 ~]# sh DB_INSERT_QUERY_test.sh PING 192.168.56.228 (192.168.56.228) 56(84) bytes of data. 64 bytes from 192.168.56.228: icmp_seq=1 ttl=64 time=0.037 ms --- 192.168.56.228 ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 0.037/0.037/0.037/0.000 ms Host 192.168.56.228 ping check successful. DB already exists. Skipping DB create phase. Table does not exist. Creating the table. Table created: test_db Test rows input starting ... ^C [root@DB4 ~]# vi /etc/my.cnf [root@DB4 ~]# sh DB_INSERT_QUERY_test.sh PING 192.168.56.228 (192.168.56.228) 56(84) bytes of data. 64 bytes from 192.168.56.228: icmp_seq=1 ttl=64 time=0.033 ms --- 192.168.56.228 ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 0.033/0.033/0.033/0.000 ms Host 192.168.56.228 ping check successful. DB already exists. Skipping DB create phase. Table exists. Retrieving the value of 'id' from the last row. Extracted INDEX_VALUE: Column value is empty. Test rows input starting ... ^C [root@DB4 ~]# sh DB_INSERT_QUERY_test.sh PING 192.168.56.228 (192.168.56.228) 56(84) bytes of data. 64 bytes from 192.168.56.228: icmp_seq=1 ttl=64 time=0.031 ms --- 192.168.56.228 ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 0.031/0.031/0.031/0.000 ms Host 192.168.56.228 ping check successful. DB already exists. Skipping DB create phase. Table exists. Retrieving the value of 'id' from the last row. Extracted INDEX_VALUE: Column value is empty. Test rows input starting ... ^C [root@DB4 ~]# mysql -uroot -pgrowin Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 999 Server version: 10.3.27-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> exit Bye [root@DB4 ~]# sh DB_INSERT_QUERY_test.sh PING 192.168.56.228 (192.168.56.228) 56(84) bytes of data. 64 bytes from 192.168.56.228: icmp_seq=1 ttl=64 time=0.032 ms --- 192.168.56.228 ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 0.032/0.032/0.032/0.000 ms Host 192.168.56.228 ping check successful. DB already exists. Skipping DB create phase. Table exists. Retrieving the value of 'id' from the last row. Extracted INDEX_VALUE: Column value is empty. Test rows input starting ... ^C [root@DB4 ~]# vi /etc/my.cnf q 2 files to edit [root@DB4 ~]# vi /etc/my.cnf [root@DB4 ~]# vi /etc/my.cnf [root@DB4 ~]# service maria stop Shutting down MariaDB.. [ OK ] [root@DB4 ~]# vi /etc/my.cnf [root@DB4 ~]# [root@DB4 ~]# vi /etc/my.cnf [root@DB4 ~]# mysql -uroot -pgrowin ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/MARIA_DATA/mysql.sock' (2) [root@DB4 ~]# ps -ef |grep mysql root 16884 9807 0 05:31 pts/1 00:00:00 grep --color=auto mysql [root@DB4 ~]# service maria start Starting MariaDB.250527 05:31:16 mysqld_safe Logging to '/MARIA_LOG/error/mysql.err'. 250527 05:31:16 mysqld_safe Starting mysqld daemon with databases from /MARIA_DATA/DATA . [ OK ] [root@DB4 ~]# cd /MARIA_LOG/binary/ [root@DB4 binary]# ll 합계 24848 -rw-rw----. 1 maria maria 1545428 5월 25 22:17 mysql-bin.000005 -rw-rw----. 1 maria maria 496 5월 25 23:08 mysql-bin.000006 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000007 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000008 -rw-rw----. 1 maria maria 496 5월 25 23:10 mysql-bin.000009 -rw-rw----. 1 maria maria 1597609 5월 25 23:28 mysql-bin.000010 -rw-rw----. 1 maria maria 496 5월 25 23:28 mysql-bin.000011 -rw-rw----. 1 maria maria 496 5월 26 00:00 mysql-bin.000012 -rw-rw----. 1 maria maria 2596295 5월 26 00:28 mysql-bin.000013 -rw-rw----. 1 maria maria 7203223 5월 27 02:57 mysql-bin.000014 -rw-rw----. 1 maria maria 3760799 5월 27 05:26 mysql-bin.000015 -rw-rw----. 1 maria maria 406 5월 27 05:31 mysql-bin.000016 -rw-rw----. 1 maria maria 420 5월 27 05:31 mysql-bin.index -rw-r--r--. 1 root root 8694577 5월 27 03:53 mysql.test [root@DB4 binary]# mysql -uroot -pgrowin Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 20 Server version: 10.3.27-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use eng; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [eng]> show tables; +---------------+ | Tables_in_eng | +---------------+ | sbtest1 | | sbtest2 | | sbtest3 | | sbtest4 | | sbtest5 | | test_db | +---------------+ 6 rows in set (0.001 sec) MariaDB [eng]> drop table test_db; Query OK, 0 rows affected (0.061 sec) MariaDB [eng]> MariaDB [eng]> MariaDB [eng]> show global variables like 'log_slave%'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | log_slave_updates | OFF | +-------------------+-------+ 1 row in set (0.001 sec) MariaDB [eng]> exit Bye [root@DB4 binary]# [root@DB4 binary]# cd [root@DB4 ~]# ll 합계 1091460 -rw-r--r--. 1 root root 2413 5월 27 04:06 DB_INSERT_QUERY_test.sh -rw-------. 1 root root 1169 3월 20 20:25 anaconda-ks.cfg -rw-r--r--. 1 root root 128843903 5월 25 23:29 dumpfile.sql drwxr-xr-x. 2 root root 4096 5월 22 2024 lsb_core -rw-r--r--. 1 root root 27811840 3월 20 20:45 lsb_core.tar -rw-r--r--. 1 root root 6974 4월 22 21:05 maria_10.6.21_my.cnf.20250422.txt -rw-r--r--. 1 root root 960968127 3월 20 20:29 mariadb-10.3.27-linux-systemd-x86_64.tar.gz -rw-r--r--. 1 root root 2352 3월 20 20:34 my.cnf [root@DB4 ~]# sh DB_INSERT_QUERY_test.sh PING 192.168.56.228 (192.168.56.228) 56(84) bytes of data. 64 bytes from 192.168.56.228: icmp_seq=1 ttl=64 time=0.036 ms --- 192.168.56.228 ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 0.036/0.036/0.036/0.000 ms Host 192.168.56.228 ping check successful. DB already exists. Skipping DB create phase. Table does not exist. Creating the table. Table created: test_db Test rows input starting ... ^C [root@DB4 ~]# cd /MARIA_LOG/binary/ [root@DB4 binary]# ll 합계 24852 -rw-rw----. 1 maria maria 1545428 5월 25 22:17 mysql-bin.000005 -rw-rw----. 1 maria maria 496 5월 25 23:08 mysql-bin.000006 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000007 -rw-rw----. 1 maria maria 496 5월 25 23:09 mysql-bin.000008 -rw-rw----. 1 maria maria 496 5월 25 23:10 mysql-bin.000009 -rw-rw----. 1 maria maria 1597609 5월 25 23:28 mysql-bin.000010 -rw-rw----. 1 maria maria 496 5월 25 23:28 mysql-bin.000011 -rw-rw----. 1 maria maria 496 5월 26 00:00 mysql-bin.000012 -rw-rw----. 1 maria maria 2596295 5월 26 00:28 mysql-bin.000013 -rw-rw----. 1 maria maria 7203223 5월 27 02:57 mysql-bin.000014 -rw-rw----. 1 maria maria 3760799 5월 27 05:26 mysql-bin.000015 -rw-rw----. 1 maria maria 7339 5월 27 05:43 mysql-bin.000016 -rw-rw----. 1 maria maria 420 5월 27 05:31 mysql-bin.index -rw-r--r--. 1 root root 8694577 5월 27 03:53 mysql.test [root@DB4 binary]# mysql -uroot -pgrowin Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 51 Server version: 10.3.27-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | cmn | | drd | | eng | | information_schema | | mysql | | performance_schema | | sso | +--------------------+ 7 rows in set (0.001 sec) MariaDB [(none)]> use drd Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [drd]> show tables; +---------------+ | Tables_in_drd | +---------------+ | sbtest1 | | sbtest2 | | sbtest3 | | sbtest4 | | sbtest5 | | test_db | +---------------+ 6 rows in set (0.001 sec) MariaDB [drd]> select * from test_db; +----+---------------------+----------+ | id | created_at | hostname | +----+---------------------+----------+ | 0 | 2025-05-27 05:41:39 | DB2 | | 1 | 2025-05-27 05:41:42 | DB2 | | 2 | 2025-05-27 05:41:45 | DB2 | | 3 | 2025-05-27 05:41:48 | DB2 | | 4 | 2025-05-27 05:41:51 | DB2 | | 5 | 2025-05-27 05:41:54 | DB2 | | 6 | 2025-05-27 05:41:57 | DB2 | | 7 | 2025-05-27 05:42:00 | DB2 | | 8 | 2025-05-27 05:42:03 | DB2 | | 9 | 2025-05-27 05:42:06 | DB2 | | 10 | 2025-05-27 05:42:09 | DB2 | | 11 | 2025-05-27 05:42:12 | DB2 | | 12 | 2025-05-27 05:42:15 | DB2 | | 13 | 2025-05-27 05:42:18 | DB2 | | 14 | 2025-05-27 05:42:21 | DB2 | | 15 | 2025-05-27 05:42:24 | DB2 | | 16 | 2025-05-27 05:42:27 | DB2 | | 17 | 2025-05-27 05:42:30 | DB2 | | 18 | 2025-05-27 05:42:33 | DB2 | | 19 | 2025-05-27 05:42:36 | DB2 | | 20 | 2025-05-27 05:42:39 | DB2 | | 21 | 2025-05-27 05:42:42 | DB2 | | 22 | 2025-05-27 05:42:45 | DB2 | | 23 | 2025-05-27 05:42:48 | DB2 | | 24 | 2025-05-27 05:42:51 | DB2 | | 25 | 2025-05-27 05:42:54 | DB2 | | 26 | 2025-05-27 05:42:57 | DB2 | | 27 | 2025-05-27 05:43:00 | DB2 | | 28 | 2025-05-27 05:43:03 | DB2 | | 29 | 2025-05-27 05:43:06 | DB2 | | 30 | 2025-05-27 05:43:09 | DB2 | +----+---------------------+----------+ 31 rows in set (0.001 sec) MariaDB [drd]> exit Bye [root@DB4 binary]# mysql -uroot -pgrowin Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 53 Server version: 10.3.27-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> exit Bye [root@DB4 binary]# cd [root@DB4 ~]# sh DB_INSERT_QUERY_test.sh PING 192.168.56.228 (192.168.56.228) 56(84) bytes of data. 64 bytes from 192.168.56.228: icmp_seq=1 ttl=64 time=0.038 ms --- 192.168.56.228 ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 0.038/0.038/0.038/0.000 ms Host 192.168.56.228 ping check successful. DB already exists. Skipping DB create phase. Table exists. Retrieving the value of 'id' from the last row. Extracted INDEX_VALUE: Column value is empty. Test rows input starting ... ^C [root@DB4 ~]# mysql -uroot -pgrowin Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 134 Server version: 10.3.27-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select * from eng.test_db; +----+---------------------+----------+ | id | created_at | hostname | +----+---------------------+----------+ | 0 | 2025-05-27 05:41:53 | DB4 | | 1 | 2025-05-27 05:41:56 | DB4 | | 2 | 2025-05-27 05:41:59 | DB4 | | 3 | 2025-05-27 05:42:02 | DB4 | | 4 | 2025-05-27 05:42:05 | DB4 | | 5 | 2025-05-27 05:42:08 | DB4 | | 6 | 2025-05-27 05:42:11 | DB4 | | 7 | 2025-05-27 05:42:14 | DB4 | | 8 | 2025-05-27 05:42:17 | DB4 | | 9 | 2025-05-27 05:42:20 | DB4 | | 10 | 2025-05-27 05:42:23 | DB4 | | 11 | 2025-05-27 05:42:26 | DB4 | | 12 | 2025-05-27 05:42:29 | DB4 | | 13 | 2025-05-27 05:42:32 | DB4 | | 14 | 2025-05-27 05:42:35 | DB4 | | 15 | 2025-05-27 05:42:38 | DB4 | | 16 | 2025-05-27 05:42:41 | DB4 | | 17 | 2025-05-27 05:42:44 | DB4 | | 18 | 2025-05-27 05:42:47 | DB4 | | 19 | 2025-05-27 05:42:50 | DB4 | | 20 | 2025-05-27 05:42:53 | DB4 | | 21 | 2025-05-27 05:42:56 | DB4 | | 22 | 2025-05-27 05:42:59 | DB4 | | 23 | 2025-05-27 05:43:02 | DB4 | | 24 | 2025-05-27 05:43:05 | DB4 | | 25 | 2025-05-27 05:43:08 | DB4 | | 26 | 2025-05-27 05:51:46 | DB4 | | 27 | 2025-05-27 05:51:49 | DB4 | | 28 | 2025-05-27 05:51:52 | DB4 | | 29 | 2025-05-27 05:51:55 | DB4 | | 30 | 2025-05-27 05:51:58 | DB4 | | 31 | 2025-05-27 05:52:01 | DB4 | | 32 | 2025-05-27 05:52:04 | DB4 | | 33 | 2025-05-27 05:52:07 | DB4 | | 34 | 2025-05-27 05:52:10 | DB4 | | 35 | 2025-05-27 05:52:13 | DB4 | | 36 | 2025-05-27 05:52:16 | DB4 | | 37 | 2025-05-27 05:52:19 | DB4 | | 38 | 2025-05-27 05:52:22 | DB4 | | 39 | 2025-05-27 05:52:25 | DB4 | | 40 | 2025-05-27 05:52:28 | DB4 | | 41 | 2025-05-27 05:52:31 | DB4 | | 42 | 2025-05-27 05:52:34 | DB4 | | 43 | 2025-05-27 05:52:38 | DB4 | | 44 | 2025-05-27 05:52:41 | DB4 | | 45 | 2025-05-27 05:52:44 | DB4 | | 46 | 2025-05-27 05:52:47 | DB4 | | 47 | 2025-05-27 05:52:50 | DB4 | | 48 | 2025-05-27 05:52:53 | DB4 | | 49 | 2025-05-27 05:52:56 | DB4 | | 50 | 2025-05-27 05:52:59 | DB4 | | 51 | 2025-05-27 05:53:02 | DB4 | | 52 | 2025-05-27 05:53:05 | DB4 | | 53 | 2025-05-27 05:53:08 | DB4 | | 54 | 2025-05-27 05:53:11 | DB4 | | 55 | 2025-05-27 05:53:14 | DB4 | | 56 | 2025-05-27 05:53:17 | DB4 | | 57 | 2025-05-27 05:53:20 | DB4 | | 58 | 2025-05-27 05:53:23 | DB4 | | 59 | 2025-05-27 05:53:26 | DB4 | | 60 | 2025-05-27 05:53:29 | DB4 | | 61 | 2025-05-27 05:53:32 | DB4 | | 62 | 2025-05-27 05:53:35 | DB4 | | 63 | 2025-05-27 05:53:38 | DB4 | | 64 | 2025-05-27 05:53:41 | DB4 | | 65 | 2025-05-27 05:53:44 | DB4 | | 66 | 2025-05-27 05:53:47 | DB4 | | 67 | 2025-05-27 05:53:50 | DB4 | | 68 | 2025-05-27 05:53:53 | DB4 | | 69 | 2025-05-27 05:53:56 | DB4 | | 70 | 2025-05-27 05:53:59 | DB4 | | 71 | 2025-05-27 05:54:02 | DB4 | | 72 | 2025-05-27 05:54:05 | DB4 | | 73 | 2025-05-27 05:54:08 | DB4 | | 74 | 2025-05-27 05:54:11 | DB4 | | 75 | 2025-05-27 05:54:14 | DB4 | | 76 | 2025-05-27 05:54:17 | DB4 | | 77 | 2025-05-27 05:54:20 | DB4 | | 78 | 2025-05-27 05:54:23 | DB4 | | 79 | 2025-05-27 05:54:26 | DB4 | | 80 | 2025-05-27 05:54:29 | DB4 | | 81 | 2025-05-27 05:54:32 | DB4 | | 82 | 2025-05-27 05:54:35 | DB4 | | 83 | 2025-05-27 05:54:39 | DB4 | | 84 | 2025-05-27 05:54:42 | DB4 | | 85 | 2025-05-27 05:54:45 | DB4 | | 86 | 2025-05-27 05:54:48 | DB4 | | 87 | 2025-05-27 05:54:51 | DB4 | | 88 | 2025-05-27 05:54:54 | DB4 | | 89 | 2025-05-27 05:54:57 | DB4 | | 90 | 2025-05-27 05:55:00 | DB4 | | 91 | 2025-05-27 05:55:03 | DB4 | | 92 | 2025-05-27 05:55:06 | DB4 | | 93 | 2025-05-27 05:55:09 | DB4 | | 94 | 2025-05-27 05:55:12 | DB4 | | 95 | 2025-05-27 05:55:15 | DB4 | | 96 | 2025-05-27 05:55:18 | DB4 | | 97 | 2025-05-27 05:55:21 | DB4 | | 98 | 2025-05-27 05:55:24 | DB4 | | 99 | 2025-05-27 05:55:27 | DB4 | +----+---------------------+----------+ 100 rows in set (0.001 sec) MariaDB [(none)]> exit Bye [root@DB4 ~]# sh DB_INSERT_QUERY_test.sh PING 192.168.56.228 (192.168.56.228) 56(84) bytes of data. 64 bytes from 192.168.56.228: icmp_seq=1 ttl=64 time=0.032 ms --- 192.168.56.228 ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 0.032/0.032/0.032/0.000 ms Host 192.168.56.228 ping check successful. DB already exists. Skipping DB create phase. Table exists. Retrieving the value of 'id' from the last row. Extracted INDEX_VALUE: Column value is empty. Test rows input starting ... ^C [root@DB4 ~]# sh DB_INSERT_QUERY_test.sh PING 192.168.56.228 (192.168.56.228) 56(84) bytes of data. 64 bytes from 192.168.56.228: icmp_seq=1 ttl=64 time=0.042 ms --- 192.168.56.228 ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 0.042/0.042/0.042/0.000 ms Host 192.168.56.228 ping check successful. DB already exists. Skipping DB create phase. Table exists. Retrieving the value of 'id' from the last row. Extracted INDEX_VALUE: Column value is empty. Test rows input starting ... ^C [root@DB4 ~]# mysql -uroot -pgrowin Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 191 Server version: 10.3.27-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select * from eng.test_db; +-----+---------------------+----------+ | id | created_at | hostname | +-----+---------------------+----------+ | 0 | 2025-05-27 05:41:53 | DB4 | | 1 | 2025-05-27 05:41:56 | DB4 | | 2 | 2025-05-27 05:41:59 | DB4 | | 3 | 2025-05-27 05:42:02 | DB4 | | 4 | 2025-05-27 05:42:05 | DB4 | | 5 | 2025-05-27 05:42:08 | DB4 | | 6 | 2025-05-27 05:42:11 | DB4 | | 7 | 2025-05-27 05:42:14 | DB4 | | 8 | 2025-05-27 05:42:17 | DB4 | | 9 | 2025-05-27 05:42:20 | DB4 | | 10 | 2025-05-27 05:42:23 | DB4 | | 11 | 2025-05-27 05:42:26 | DB4 | | 12 | 2025-05-27 05:42:29 | DB4 | | 13 | 2025-05-27 05:42:32 | DB4 | | 14 | 2025-05-27 05:42:35 | DB4 | | 15 | 2025-05-27 05:42:38 | DB4 | | 16 | 2025-05-27 05:42:41 | DB4 | | 17 | 2025-05-27 05:42:44 | DB4 | | 18 | 2025-05-27 05:42:47 | DB4 | | 19 | 2025-05-27 05:42:50 | DB4 | | 20 | 2025-05-27 05:42:53 | DB4 | | 21 | 2025-05-27 05:42:56 | DB4 | | 22 | 2025-05-27 05:42:59 | DB4 | | 23 | 2025-05-27 05:43:02 | DB4 | | 24 | 2025-05-27 05:43:05 | DB4 | | 25 | 2025-05-27 05:43:08 | DB4 | | 26 | 2025-05-27 05:51:46 | DB4 | | 27 | 2025-05-27 05:51:49 | DB4 | | 28 | 2025-05-27 05:51:52 | DB4 | | 29 | 2025-05-27 05:51:55 | DB4 | | 30 | 2025-05-27 05:51:58 | DB4 | | 31 | 2025-05-27 05:52:01 | DB4 | | 32 | 2025-05-27 05:52:04 | DB4 | | 33 | 2025-05-27 05:52:07 | DB4 | | 34 | 2025-05-27 05:52:10 | DB4 | | 35 | 2025-05-27 05:52:13 | DB4 | | 36 | 2025-05-27 05:52:16 | DB4 | | 37 | 2025-05-27 05:52:19 | DB4 | | 38 | 2025-05-27 05:52:22 | DB4 | | 39 | 2025-05-27 05:52:25 | DB4 | | 40 | 2025-05-27 05:52:28 | DB4 | | 41 | 2025-05-27 05:52:31 | DB4 | | 42 | 2025-05-27 05:52:34 | DB4 | | 43 | 2025-05-27 05:52:38 | DB4 | | 44 | 2025-05-27 05:52:41 | DB4 | | 45 | 2025-05-27 05:52:44 | DB4 | | 46 | 2025-05-27 05:52:47 | DB4 | | 47 | 2025-05-27 05:52:50 | DB4 | | 48 | 2025-05-27 05:52:53 | DB4 | | 49 | 2025-05-27 05:52:56 | DB4 | | 50 | 2025-05-27 05:52:59 | DB4 | | 51 | 2025-05-27 05:53:02 | DB4 | | 52 | 2025-05-27 05:53:05 | DB4 | | 53 | 2025-05-27 05:53:08 | DB4 | | 54 | 2025-05-27 05:53:11 | DB4 | | 55 | 2025-05-27 05:53:14 | DB4 | | 56 | 2025-05-27 05:53:17 | DB4 | | 57 | 2025-05-27 05:53:20 | DB4 | | 58 | 2025-05-27 05:53:23 | DB4 | | 59 | 2025-05-27 05:53:26 | DB4 | | 60 | 2025-05-27 05:53:29 | DB4 | | 61 | 2025-05-27 05:53:32 | DB4 | | 62 | 2025-05-27 05:53:35 | DB4 | | 63 | 2025-05-27 05:53:38 | DB4 | | 64 | 2025-05-27 05:53:41 | DB4 | | 65 | 2025-05-27 05:53:44 | DB4 | | 66 | 2025-05-27 05:53:47 | DB4 | | 67 | 2025-05-27 05:53:50 | DB4 | | 68 | 2025-05-27 05:53:53 | DB4 | | 69 | 2025-05-27 05:53:56 | DB4 | | 70 | 2025-05-27 05:53:59 | DB4 | | 71 | 2025-05-27 05:54:02 | DB4 | | 72 | 2025-05-27 05:54:05 | DB4 | | 73 | 2025-05-27 05:54:08 | DB4 | | 74 | 2025-05-27 05:54:11 | DB4 | | 75 | 2025-05-27 05:54:14 | DB4 | | 76 | 2025-05-27 05:54:17 | DB4 | | 77 | 2025-05-27 05:54:20 | DB4 | | 78 | 2025-05-27 05:54:23 | DB4 | | 79 | 2025-05-27 05:54:26 | DB4 | | 80 | 2025-05-27 05:54:29 | DB4 | | 81 | 2025-05-27 05:54:32 | DB4 | | 82 | 2025-05-27 05:54:35 | DB4 | | 83 | 2025-05-27 05:54:39 | DB4 | | 84 | 2025-05-27 05:54:42 | DB4 | | 85 | 2025-05-27 05:54:45 | DB4 | | 86 | 2025-05-27 05:54:48 | DB4 | | 87 | 2025-05-27 05:54:51 | DB4 | | 88 | 2025-05-27 05:54:54 | DB4 | | 89 | 2025-05-27 05:54:57 | DB4 | | 90 | 2025-05-27 05:55:00 | DB4 | | 91 | 2025-05-27 05:55:03 | DB4 | | 92 | 2025-05-27 05:55:06 | DB4 | | 93 | 2025-05-27 05:55:09 | DB4 | | 94 | 2025-05-27 05:55:12 | DB4 | | 95 | 2025-05-27 05:55:15 | DB4 | | 96 | 2025-05-27 05:55:18 | DB4 | | 97 | 2025-05-27 05:55:21 | DB4 | | 98 | 2025-05-27 05:55:24 | DB4 | | 99 | 2025-05-27 05:55:27 | DB4 | | 100 | 2025-05-27 06:11:02 | DB4 | | 101 | 2025-05-27 06:11:05 | DB4 | | 102 | 2025-05-27 06:11:08 | DB4 | | 103 | 2025-05-27 06:11:11 | DB4 | | 104 | 2025-05-27 06:11:14 | DB4 | | 105 | 2025-05-27 06:11:17 | DB4 | | 106 | 2025-05-27 06:11:20 | DB4 | | 107 | 2025-05-27 06:12:41 | DB4 | | 108 | 2025-05-27 06:12:44 | DB4 | | 109 | 2025-05-27 06:12:47 | DB4 | | 110 | 2025-05-27 06:12:50 | DB4 | | 111 | 2025-05-27 06:12:53 | DB4 | | 112 | 2025-05-27 06:12:56 | DB4 | | 113 | 2025-05-27 06:12:59 | DB4 | | 114 | 2025-05-27 06:13:02 | DB4 | | 115 | 2025-05-27 06:13:05 | DB4 | | 116 | 2025-05-27 06:13:08 | DB4 | | 117 | 2025-05-27 06:13:11 | DB4 | | 118 | 2025-05-27 06:13:14 | DB4 | | 119 | 2025-05-27 06:13:17 | DB4 | | 120 | 2025-05-27 06:13:20 | DB4 | | 121 | 2025-05-27 06:13:23 | DB4 | | 122 | 2025-05-27 06:13:26 | DB4 | | 123 | 2025-05-27 06:13:29 | DB4 | | 124 | 2025-05-27 06:13:32 | DB4 | | 125 | 2025-05-27 06:13:35 | DB4 | | 126 | 2025-05-27 06:13:38 | DB4 | | 127 | 2025-05-27 06:13:41 | DB4 | | 128 | 2025-05-27 06:13:44 | DB4 | | 129 | 2025-05-27 06:13:47 | DB4 | | 130 | 2025-05-27 06:13:50 | DB4 | | 131 | 2025-05-27 06:13:53 | DB4 | | 132 | 2025-05-27 06:13:56 | DB4 | | 133 | 2025-05-27 06:13:59 | DB4 | | 134 | 2025-05-27 06:14:02 | DB4 | | 135 | 2025-05-27 06:14:05 | DB4 | | 136 | 2025-05-27 06:14:08 | DB4 | | 137 | 2025-05-27 06:14:11 | DB4 | | 138 | 2025-05-27 06:14:14 | DB4 | | 139 | 2025-05-27 06:14:17 | DB4 | | 140 | 2025-05-27 06:14:20 | DB4 | | 141 | 2025-05-27 06:14:23 | DB4 | | 142 | 2025-05-27 06:14:26 | DB4 | | 143 | 2025-05-27 06:14:30 | DB4 | | 144 | 2025-05-27 06:14:33 | DB4 | | 145 | 2025-05-27 06:14:36 | DB4 | | 146 | 2025-05-27 06:14:39 | DB4 | | 147 | 2025-05-27 06:14:42 | DB4 | +-----+---------------------+----------+ 148 rows in set (0.001 sec) MariaDB [(none)]> select * from sso.test_db; +-----+---------------------+----------+ | id | created_at | hostname | +-----+---------------------+----------+ | 0 | 2025-05-27 05:41:34 | DB1 | | 1 | 2025-05-27 05:41:37 | DB1 | | 2 | 2025-05-27 05:41:40 | DB1 | | 3 | 2025-05-27 05:41:43 | DB1 | | 4 | 2025-05-27 05:41:46 | DB1 | | 5 | 2025-05-27 05:41:49 | DB1 | | 6 | 2025-05-27 05:41:52 | DB1 | | 7 | 2025-05-27 05:41:55 | DB1 | | 8 | 2025-05-27 05:41:58 | DB1 | | 9 | 2025-05-27 05:42:01 | DB1 | | 10 | 2025-05-27 05:42:04 | DB1 | | 11 | 2025-05-27 05:42:07 | DB1 | | 12 | 2025-05-27 05:42:10 | DB1 | | 13 | 2025-05-27 05:42:13 | DB1 | | 14 | 2025-05-27 05:42:16 | DB1 | | 15 | 2025-05-27 05:42:19 | DB1 | | 16 | 2025-05-27 05:42:22 | DB1 | | 17 | 2025-05-27 05:42:25 | DB1 | | 18 | 2025-05-27 05:42:28 | DB1 | | 19 | 2025-05-27 05:42:31 | DB1 | | 20 | 2025-05-27 05:42:34 | DB1 | | 21 | 2025-05-27 05:42:37 | DB1 | | 22 | 2025-05-27 05:42:40 | DB1 | | 23 | 2025-05-27 05:42:43 | DB1 | | 24 | 2025-05-27 05:42:46 | DB1 | | 25 | 2025-05-27 05:42:49 | DB1 | | 26 | 2025-05-27 05:42:52 | DB1 | | 27 | 2025-05-27 05:42:55 | DB1 | | 28 | 2025-05-27 05:42:58 | DB1 | | 29 | 2025-05-27 05:43:01 | DB1 | | 30 | 2025-05-27 05:43:04 | DB1 | | 31 | 2025-05-27 05:43:07 | DB1 | | 32 | 2025-05-27 05:43:10 | DB1 | | 33 | 2025-05-27 05:51:00 | DB1 | | 34 | 2025-05-27 05:51:03 | DB1 | | 35 | 2025-05-27 05:51:06 | DB1 | | 36 | 2025-05-27 05:51:09 | DB1 | | 37 | 2025-05-27 05:51:12 | DB1 | | 38 | 2025-05-27 05:51:15 | DB1 | | 39 | 2025-05-27 05:51:18 | DB1 | | 40 | 2025-05-27 05:51:21 | DB1 | | 41 | 2025-05-27 05:51:24 | DB1 | | 42 | 2025-05-27 05:51:27 | DB1 | | 43 | 2025-05-27 05:51:31 | DB1 | | 44 | 2025-05-27 05:51:34 | DB1 | | 45 | 2025-05-27 05:51:37 | DB1 | | 46 | 2025-05-27 05:51:40 | DB1 | | 47 | 2025-05-27 05:51:43 | DB1 | | 48 | 2025-05-27 05:51:46 | DB1 | | 49 | 2025-05-27 05:51:49 | DB1 | | 50 | 2025-05-27 05:51:52 | DB1 | | 51 | 2025-05-27 05:51:55 | DB1 | | 52 | 2025-05-27 05:51:58 | DB1 | | 53 | 2025-05-27 05:52:01 | DB1 | | 54 | 2025-05-27 05:52:04 | DB1 | | 55 | 2025-05-27 05:52:07 | DB1 | | 56 | 2025-05-27 05:52:10 | DB1 | | 57 | 2025-05-27 05:52:13 | DB1 | | 58 | 2025-05-27 05:52:16 | DB1 | | 59 | 2025-05-27 05:52:19 | DB1 | | 60 | 2025-05-27 05:52:22 | DB1 | | 61 | 2025-05-27 05:52:25 | DB1 | | 62 | 2025-05-27 05:52:28 | DB1 | | 63 | 2025-05-27 05:52:31 | DB1 | | 64 | 2025-05-27 05:52:34 | DB1 | | 65 | 2025-05-27 05:52:37 | DB1 | | 66 | 2025-05-27 05:52:40 | DB1 | | 67 | 2025-05-27 05:52:43 | DB1 | | 68 | 2025-05-27 05:52:46 | DB1 | | 69 | 2025-05-27 05:52:49 | DB1 | | 70 | 2025-05-27 05:52:52 | DB1 | | 71 | 2025-05-27 05:52:55 | DB1 | | 72 | 2025-05-27 05:52:58 | DB1 | | 73 | 2025-05-27 05:53:01 | DB1 | | 74 | 2025-05-27 05:53:04 | DB1 | | 75 | 2025-05-27 05:53:07 | DB1 | | 76 | 2025-05-27 05:53:10 | DB1 | | 77 | 2025-05-27 05:53:13 | DB1 | | 78 | 2025-05-27 05:53:16 | DB1 | | 79 | 2025-05-27 05:53:20 | DB1 | | 80 | 2025-05-27 05:53:23 | DB1 | | 81 | 2025-05-27 05:53:26 | DB1 | | 82 | 2025-05-27 05:53:29 | DB1 | | 83 | 2025-05-27 05:53:32 | DB1 | | 84 | 2025-05-27 05:53:35 | DB1 | | 85 | 2025-05-27 05:53:38 | DB1 | | 86 | 2025-05-27 05:53:41 | DB1 | | 87 | 2025-05-27 05:53:44 | DB1 | | 88 | 2025-05-27 05:53:47 | DB1 | | 89 | 2025-05-27 05:53:50 | DB1 | | 90 | 2025-05-27 05:53:53 | DB1 | | 91 | 2025-05-27 05:53:56 | DB1 | | 92 | 2025-05-27 05:53:59 | DB1 | | 93 | 2025-05-27 05:54:02 | DB1 | | 94 | 2025-05-27 05:54:05 | DB1 | | 95 | 2025-05-27 05:54:08 | DB1 | | 96 | 2025-05-27 05:54:11 | DB1 | | 97 | 2025-05-27 05:54:14 | DB1 | | 98 | 2025-05-27 05:54:17 | DB1 | | 99 | 2025-05-27 05:54:20 | DB1 | | 100 | 2025-05-27 05:54:23 | DB1 | | 101 | 2025-05-27 05:54:26 | DB1 | | 102 | 2025-05-27 05:54:29 | DB1 | | 103 | 2025-05-27 05:54:32 | DB1 | | 104 | 2025-05-27 05:54:35 | DB1 | | 105 | 2025-05-27 05:54:38 | DB1 | | 106 | 2025-05-27 05:54:41 | DB1 | | 107 | 2025-05-27 05:54:44 | DB1 | | 108 | 2025-05-27 05:54:47 | DB1 | | 109 | 2025-05-27 05:54:50 | DB1 | | 110 | 2025-05-27 05:54:53 | DB1 | | 111 | 2025-05-27 05:54:56 | DB1 | | 112 | 2025-05-27 05:54:59 | DB1 | | 113 | 2025-05-27 05:55:02 | DB1 | | 114 | 2025-05-27 05:55:05 | DB1 | | 115 | 2025-05-27 05:55:08 | DB1 | | 116 | 2025-05-27 05:55:11 | DB1 | | 117 | 2025-05-27 05:55:14 | DB1 | | 118 | 2025-05-27 05:55:17 | DB1 | | 119 | 2025-05-27 05:55:20 | DB1 | | 120 | 2025-05-27 05:55:23 | DB1 | | 121 | 2025-05-27 05:55:26 | DB1 | | 122 | 2025-05-27 05:55:29 | DB1 | | 123 | 2025-05-27 06:12:45 | DB1 | | 124 | 2025-05-27 06:12:48 | DB1 | | 125 | 2025-05-27 06:12:51 | DB1 | | 126 | 2025-05-27 06:12:54 | DB1 | | 127 | 2025-05-27 06:12:57 | DB1 | | 128 | 2025-05-27 06:13:00 | DB1 | | 129 | 2025-05-27 06:13:03 | DB1 | | 130 | 2025-05-27 06:13:06 | DB1 | | 131 | 2025-05-27 06:13:09 | DB1 | | 132 | 2025-05-27 06:13:12 | DB1 | | 133 | 2025-05-27 06:13:15 | DB1 | | 134 | 2025-05-27 06:13:18 | DB1 | | 135 | 2025-05-27 06:13:21 | DB1 | | 136 | 2025-05-27 06:13:24 | DB1 | | 137 | 2025-05-27 06:13:27 | DB1 | | 138 | 2025-05-27 06:13:30 | DB1 | | 139 | 2025-05-27 06:13:33 | DB1 | | 140 | 2025-05-27 06:13:36 | DB1 | | 141 | 2025-05-27 06:13:39 | DB1 | | 142 | 2025-05-27 06:13:42 | DB1 | | 143 | 2025-05-27 06:13:45 | DB1 | | 144 | 2025-05-27 06:13:48 | DB1 | | 145 | 2025-05-27 06:13:51 | DB1 | | 146 | 2025-05-27 06:13:54 | DB1 | | 147 | 2025-05-27 06:13:57 | DB1 | | 148 | 2025-05-27 06:14:00 | DB1 | | 149 | 2025-05-27 06:14:03 | DB1 | | 150 | 2025-05-27 06:14:06 | DB1 | | 151 | 2025-05-27 06:14:09 | DB1 | | 152 | 2025-05-27 06:14:12 | DB1 | | 153 | 2025-05-27 06:14:15 | DB1 | | 154 | 2025-05-27 06:14:18 | DB1 | | 155 | 2025-05-27 06:14:22 | DB1 | | 156 | 2025-05-27 06:14:25 | DB1 | | 157 | 2025-05-27 06:14:28 | DB1 | | 158 | 2025-05-27 06:14:31 | DB1 | | 159 | 2025-05-27 06:14:34 | DB1 | | 160 | 2025-05-27 06:14:37 | DB1 | +-----+---------------------+----------+ 161 rows in set (0.001 sec) MariaDB [(none)]>