mysqlbinlog - Why binlog stop when mysql start -


i use mysql 5.7.19 in docker

after mysql starting, show binlog events return below, binlog stop after previous_gtids:

enter image description here

and configuration file simple :

[mysqld] server-id=100 log-bin=mysq-bin binlog_do_db=test

withshow variables '%bin%', can see log_bin on

and log

2017-08-14t17:12:55.036324z 0 [warning] timestamp implicit default value deprecated. please use --explicit_defaults_for_timestamp server option (see documentation more details). 2017-08-14t17:12:55.036845z 0 [note] mysqld (mysqld 5.7.19-log) starting process 1 ... 2017-08-14t17:12:55.038682z 0 [note] innodb: punch hole support available 2017-08-14t17:12:55.038696z 0 [note] innodb: mutexes , rw_locks use gcc atomic builtins 2017-08-14t17:12:55.038698z 0 [note] innodb: uses event mutexes 2017-08-14t17:12:55.038699z 0 [note] innodb: gcc builtin __atomic_thread_fence() used memory barrier 2017-08-14t17:12:55.038700z 0 [note] innodb: compressed tables use zlib 1.2.3 2017-08-14t17:12:55.038704z 0 [note] innodb: using linux native aio 2017-08-14t17:12:55.038815z 0 [note] innodb: number of pools: 1 2017-08-14t17:12:55.038859z 0 [note] innodb: using cpu crc32 instructions 2017-08-14t17:12:55.039557z 0 [note] innodb: initializing buffer pool, total size = 128m, instances = 1, chunk size = 128m 2017-08-14t17:12:55.043151z 0 [note] innodb: completed initialization of buffer pool 2017-08-14t17:12:55.044137z 0 [note] innodb: if mysqld execution user authorized, page cleaner thread priority can changed. see man page of setpriority(). 2017-08-14t17:12:55.055186z 0 [note] innodb: highest supported file format barracuda. 2017-08-14t17:12:55.095292z 0 [note] innodb: creating shared tablespace temporary tables 2017-08-14t17:12:55.095415z 0 [note] innodb: setting file './ibtmp1' size 12 mb. physically writing file full; please wait ... 2017-08-14t17:12:55.318358z 0 [note] innodb: file './ibtmp1' size 12 mb. 2017-08-14t17:12:55.320087z 0 [note] innodb: 96 redo rollback segment(s) found. 96 redo rollback segment(s) active. 2017-08-14t17:12:55.320110z 0 [note] innodb: 32 non-redo rollback segment(s) active. 2017-08-14t17:12:55.321156z 0 [note] innodb: waiting purge start 2017-08-14t17:12:55.371381z 0 [note] innodb: 5.7.19 started; log sequence number 12144759 2017-08-14t17:12:55.372224z 0 [note] innodb: loading buffer pool(s) /var/lib/mysql/ib_buffer_pool 2017-08-14t17:12:55.372582z 0 [note] plugin 'federated' disabled. 2017-08-14t17:12:55.377608z 0 [note] innodb: buffer pool(s) load completed @ 170814 17:12:55 2017-08-14t17:12:55.510976z 0 [note] found ca.pem, server-cert.pem , server-key.pem in data directory. trying enable ssl support using them. 2017-08-14t17:12:55.511523z 0 [warning] ca certificate ca.pem self signed. 2017-08-14t17:12:55.516422z 0 [note] server hostname (bind-address): '*'; port: 3306 2017-08-14t17:12:55.516439z 0 [note] ipv6 available. 2017-08-14t17:12:55.516444z 0 [note]   - '::' resolves '::'; 2017-08-14t17:12:55.516453z 0 [note] server socket created on ip: '::'. 2017-08-14t17:12:55.567045z 0 [note] event scheduler: loaded 0 events 2017-08-14t17:12:55.567443z 0 [note] mysqld: ready connections. version: '5.7.19-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mysql community server (gpl) 2017-08-14t17:12:55.567474z 0 [note] executing 'select * information_schema.tables;' list of tables using deprecated partition engine. may use startup option '--disable-partition-engine-check' skip check.  2017-08-14t17:12:55.567480z 0 [note] beginning of list of non-natively partitioned tables 2017-08-14t17:12:55.588831z 0 [note] end of list of non-natively partitioned tables 2017-08-14t17:13:04.076825z 3 [warning] ip address '172.17.0.1' not resolved: name or service not known

anything thing wrong？


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more