mysql端口被占用_MySQL重啟端口被占用處理

1,查看日志的ERROR

2018-05-23T01:26:59.230382Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.

2018-05-23T01:26:59.230409Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled

2018-05-23T01:26:59.230457Z 0 [Note] /usr/bin/mysqld (mysqld 5.7.18-log) starting as process 1274 ...

2018-05-23T01:26:59.232456Z 0 [Warning] Using pre 5.5 semantics to load error messages from /usr/share/.

2018-05-23T01:26:59.232467Z 0 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.

2018-05-23T01:26:59.338644Z 0 [Warning] InnoDB: Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html

2018-05-23T01:26:59.338778Z 0 [Note] InnoDB: PUNCH HOLE support not available

2018-05-23T01:26:59.338797Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-05-23T01:26:59.338811Z 0 [Note] InnoDB: Uses event mutexes

2018-05-23T01:26:59.338820Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier

2018-05-23T01:26:59.338841Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3

2018-05-23T01:26:59.338849Z 0 [Note] InnoDB: Using Linux native AIO

2018-05-23T01:26:59.343415Z 0 [Note] InnoDB: Number of pools: 1

2018-05-23T01:26:59.343606Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-05-23T01:26:59.351180Z 0 [Note] InnoDB: Initializing buffer pool, total size = 16G, instances = 8, chunk size = 128M

2018-05-23T01:27:01.144704Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-05-23T01:27:01.805956Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-05-23T01:27:01.869612Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2018-05-23T01:27:02.161447Z 0 [Note] InnoDB: The log sequence number 463085832558 in the system tablespace does not match the log sequence number 527415094655 in the ib_logfiles! --表示磁盤lsn和共享表空間中lsn不一致

2018-05-23T01:27:02.161487Z 0 [Note] InnoDB: Database was not shutdown normally! --顯示沒有正常關機

2018-05-23T01:27:02.161500Z 0 [Note] InnoDB: Starting crash recovery.

2018-05-23T01:27:03.342445Z 0 [Note] InnoDB: Last MySQL binlog file position 0 835316239, file name slave1-bin.000662

2018-05-23T01:27:14.727716Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2018-05-23T01:27:14.727757Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-05-23T01:27:14.735961Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-05-23T01:27:14.779905Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-05-23T01:27:14.781644Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-05-23T01:27:14.781675Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-05-23T01:27:14.783034Z 0 [Note] InnoDB: Waiting for purge to start

2018-05-23T01:27:14.833225Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13028ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)

2018-05-23T01:27:14.844368Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 527415094655

2018-05-23T01:27:14.844947Z 0 [Note] InnoDB: Loading buffer pool(s) from /r2/mysqldata/ib_buffer_pool

2018-05-23T01:27:14.845201Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180523 9:27:14 (/r2/mysqldata/ib_buffer_pool was empty)

2018-05-23T01:27:14.850829Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-05-23T01:27:31.198380Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2018-05-23T01:27:31.198414Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2018-05-23T01:27:31.198460Z 0 [Note] IPv6 is available.

2018-05-23T01:27:31.198473Z 0 [Note] - '::' resolves to '::';

2018-05-23T01:27:31.198521Z 0 [Note] Server socket created on IP: '::'.

2018-05-23T01:27:31.198551Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use

2018-05-23T01:27:31.198557Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? --顯示端口被占用

2018-05-23T01:27:31.198569Z 0 [ERROR] Aborting

2018-05-23T01:27:31.201402Z 0 [Note] Binlog end

2018-05-23T01:27:31.202398Z 0 [Note] Shutting down plugin 'ngram'

2018-05-23T01:27:31.202428Z 0 [Note] Shutting down plugin 'partition'

2018-05-23T01:27:31.202434Z 0 [Note] Shutting down plugin 'ARCHIVE'

2018-05-23T01:27:31.202439Z 0 [Note] Shutting down plugin 'BLACKHOLE'

2018-05-23T01:27:31.202447Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2018-05-23T01:27:31.202453Z 0 [Note] Shutting down plugin 'MyISAM'

2018-05-23T01:27:31.203867Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'

2018-05-23T01:27:31.203880Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2018-05-23T01:27:31.203885Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2018-05-23T01:27:31.203890Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2018-05-23T01:27:31.203895Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

2018-05-23T01:27:31.203899Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

2018-05-23T01:27:31.203904Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

2018-05-23T01:27:31.203909Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2018-05-23T01:27:31.203913Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2018-05-23T01:27:31.203923Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2018-05-23T01:27:31.203927Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2018-05-23T01:27:31.203932Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2018-05-23T01:27:31.203936Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2018-05-23T01:27:31.203940Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2018-05-23T01:27:31.203945Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2018-05-23T01:27:31.203950Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2018-05-23T01:27:31.203954Z 0 [Note] Shutting down plugin 'INNODB_METRICS'

2018-05-23T01:27:31.203959Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'

2018-05-23T01:27:31.203963Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2018-05-23T01:27:31.203968Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2018-05-23T01:27:31.203972Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2018-05-23T01:27:31.203984Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2018-05-23T01:27:31.203989Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2018-05-23T01:27:31.203993Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2018-05-23T01:27:31.203997Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'

2018-05-23T01:27:31.204002Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2018-05-23T01:27:31.204006Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2018-05-23T01:27:31.204010Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2018-05-23T01:27:31.204015Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2018-05-23T01:27:31.204019Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2018-05-23T01:27:31.204024Z 0 [Note] Shutting down plugin 'InnoDB'

2018-05-23T01:27:31.204097Z 0 [Note] InnoDB: FTS optimize thread exiting.

2018-05-23T01:27:31.204234Z 0 [Note] InnoDB: Starting shutdown...

2018-05-23T01:27:31.304450Z 0 [Note] InnoDB: Dumping buffer pool(s) to /r2/mysqldata/ib_buffer_pool

2018-05-23T01:27:31.305044Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180523 9:27:31

2018-05-23T01:27:33.817117Z 0 [Note] InnoDB: Shutdown completed; log sequence number 527415094683

2018-05-23T01:27:33.817469Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2018-05-23T01:27:33.817494Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2018-05-23T01:27:33.817618Z 0 [Note] Shutting down plugin 'MEMORY'

2018-05-23T01:27:33.817632Z 0 [Note] Shutting down plugin 'CSV'

2018-05-23T01:27:33.817642Z 0 [Note] Shutting down plugin 'sha256_password'

2018-05-23T01:27:33.817659Z 0 [Note] Shutting down plugin 'mysql_native_password'

2018-05-23T01:27:33.817898Z 0 [Note] Shutting down plugin 'binlog'

2018-05-23T01:27:33.819411Z 0 [Note] /usr/bin/mysqld: Shutdown complete

2,查看3306端口的進程情況

[root@slave1 mysqldata]# netstat -an |grep 3306

tcp 0 0 192.168.102.131:52090 192.168.102.130:3306 ESTABLISHED

tcp 0 0 192.168.102.131:54416 192.168.102.130:3306 ESTABLISHED

tcp 0 0 192.168.102.131:32214 192.168.102.137:3306 TIME_WAIT

tcp 0 0 192.168.102.131:60596 192.168.102.137:3306 TIME_WAIT

tcp 0 0 127.0.0.1:3306 127.0.0.1:3306 ESTABLISHED --ESTABLISHED的意思是建立連接。表示兩臺機器正在通信。

tcp 0 0 192.168.102.131:26186 192.168.102.130:3306 ESTABLISHED

tcp 0 0 192.168.102.131:54528 192.168.102.130:3306 ESTABLISHED

tcp 0 0 192.168.102.131:52587 192.168.102.130:3306 ESTABLISHED

unix 3 [ ] STREAM CONNECTED 23306

[root@slave1 mysqldata]# ps -ef |grep mysql

root 874 1 0 5月21 ? 00:00:00 /bin/sh -c /usr/local/percona/qan-agent/bin/percona-qan-agent >> /var/log/pmm-mysql-queries-0.log 2>&1

root 23208 1977 0 09:34 pts/1 00:00:00 grep --color=auto mysql

root 27712 1 0 5月21 ? 00:00:00 /bin/sh -c /usr/local/percona/pmm-client/mysqld_exporter -collect.auto_increment.columns=false -collect.binlog_size=true -collect.global_status=true -collect.global_variables=true -collect.info_schema.innodb_metrics=true -collect.info_schema.processlist=true -collect.info_schema.query_response_time=true -collect.info_schema.tables=false -collect.info_schema.tablestats=false -collect.info_schema.userstats=true -collect.perf_schema.eventswaits=true -collect.perf_schema.file_events=true -collect.perf_schema.indexiowaits=false -collect.perf_schema.tableiowaits=false -collect.perf_schema.tablelocks=false -collect.slave_status=true -web.listen-address=192.168.101.131:42002 -web.auth-file=/usr/local/percona/pmm-client/pmm.yml -web.ssl-cert-file=/usr/local/percona/pmm-client/server.crt -web.ssl-key-file=/usr/local/percona/pmm-client/server.key >> /var/log/pmm-mysql-metrics-42002.log2>&1

root 27714 27712 5 5月21 ? 02:45:30 /usr/local/percona/pmm-client/mysqld_exporter -collect.auto_increment.columns=false -collect.binlog_size=true -collect.global_status=true -collect.global_variables=true -collect.info_schema.innodb_metrics=true -collect.info_schema.processlist=true -collect.info_schema.query_response_time=true -collect.info_schema.tables=false -collect.info_schema.tablestats=false -collect.info_schema.userstats=true -collect.perf_schema.eventswaits=true -collect.perf_schema.file_events=true -collect.perf_schema.indexiowaits=false -collect.perf_schema.tableiowaits=false -collect.perf_schema.tablelocks=false -collect.slave_status=true -web.listen-address=192.168.101.131:42002 -web.auth-file=/usr/local/percona/pmm-client/pmm.yml -web.ssl-cert-file=/usr/local/percona/pmm-client/server.crt -web.ssl-key-file=/usr/local/percona/pmm-client/server.key

root 29857 1 0 5月22 ? 00:00:00 /bin/sh -c [ `ps -ef |grep orzdba_mysql|grep -v grep|wc -l` -eq 0 ] && source /etc/profile && /scripts/db/orzdba -i 10 -t -mysql -innodb_rows -L /r2/monitor/orzdba_mysql.log -logfile_by_day > /dev/null 2>&1 &

root 29928 29857 0 5月22 ? 00:00:00 /usr/bin/perl -w /scripts/db/orzdba -i 10 -t -mysql -innodb_rows -L /r2/monitor/orzdba_mysql.log -logfile_by_day

root 29937 29928 0 5月22 ? 00:00:00 mysql -s --skip-column-names -h127.0.0.1 -umonitor -px xxxxxxxxxxxxxxxxxx -P3306 -e show variables where Variable_name in ("sync_binlog","max_connections","max_user_connections","max_connect_errors","table_open_cache","table_definition_cache","thread_cache_size","binlog_format","open_files_limit","max_binlog_size","max_binlog_cache_size")

3,獲取進程的名稱

[root@slave1 mysqldata]# lsof -i:3306

COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME

tsg.exe 27014 root 10u IPv4 28164389 0t0 TCP( secondmaster:54416->master:mysql )(ESTABLISHED) --ESTABLISHED的意思是建立連接。表示兩臺機器mysql正在通信。

tsg.exe 27014 root 21u IPv4 28148523 0t0 TCP secondmaster:54528->master:mysql (ESTABLISHED)

mysql 29937 root 3u IPv4 14731893 0t0 TCP localhost:mysql->localhost:mysql (ESTABLISHED) --ESTABLISHED的意思是建立連接。表示本地mysql正在通信。要kill掉

iacs.exe 45909 root 10u IPv4 3015961 0t0 TCP secondmaster:26186->master:mysql (ESTABLISHED)

iacs.exe 45909 root 21u IPv4 2996694 0t0 TCP secondmaster:52090->master:mysql (ESTABLISHED)

iacs.exe 45909 root 65u IPv4 23893332 0t0 TCP secondmaster:52587->master:mysql (ESTABLISHED)

COMMAND：進程的名稱

PID：進程標識符

USER：進程所有者

FD：文件描述符，應用程序通過文件描述符識別該文件。如cwd、txt等

TYPE：文件類型，如DIR、REG等

DEVICE：指定磁盤的名稱

SIZE：文件的大小

NODE：索引節點(文件在磁盤上的標識)

NAME：打開文件的確切名稱

4,kill掉進程

[root@slave1 mysqldata]# ps -aux | grep 29937

root 29937 0.0 0.0 133488 1924 ? S 5月22 0:00 mysql -s --skip-column-names -h127.0.0.1 -umonitor -px xxxxxxxxxxxxxxxxxx -P3306 -e show variables where Variable_name in("sync_binlog","max_connections","max_user_connections","max_connect_errors","table_open_cache","table_definition_cache","thread_cache_size","binlog_format","open_files_limit","max_binlog_size","max_binlog_cache_size")

root 34694 0.0 0.0 112684 988 pts/1 S+ 09:35 0:00 grep --color=auto 29937

[root@slave1 mysqldata]# kill -9 29937

5,重啟MySQL,先關閉連接

[root@slave1 mysqldata]# vim /etc/my.cnf --更改日志時區

[root@slave1 mysqldata]# > error.log

[root@slave1 mysqldata]# systemctl stop mysql --先執行關閉，kill掉兩臺機器mysql連接( secondmaster:54416->master:mysql )

[root@slave1 mysqldata]# systemctl start mysql

[root@slave1 mysqldata]# tailf -500 error.log

2018-05-23T09:38:31.396150+08:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-05-23T09:38:31.396251+08:00 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.

2018-05-23T09:38:31.396284+08:00 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled

2018-05-23T09:38:31.396326+08:00 0 [Note] /usr/bin/mysqld (mysqld 5.7.18-log) starting as process 12884 ...

2018-05-23T09:38:31.397974+08:00 0 [Warning] Using pre 5.5 semantics to load error messages from /usr/share/.

2018-05-23T09:38:31.397983+08:00 0 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.

2018-05-23T09:38:31.439195+08:00 0 [Warning] InnoDB: Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html

2018-05-23T09:38:31.439324+08:00 0 [Note] InnoDB: PUNCH HOLE support not available

2018-05-23T09:38:31.439343+08:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-05-23T09:38:31.439352+08:00 0 [Note] InnoDB: Uses event mutexes

2018-05-23T09:38:31.439361+08:00 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier

2018-05-23T09:38:31.439370+08:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.3

2018-05-23T09:38:31.439379+08:00 0 [Note] InnoDB: Using Linux native AIO

2018-05-23T09:38:31.442855+08:00 0 [Note] InnoDB: Number of pools: 1

2018-05-23T09:38:31.443024+08:00 0 [Note] InnoDB: Using CPU crc32 instructions

2018-05-23T09:38:31.445355+08:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16G, instances = 8, chunk size = 128M

2018-05-23T09:38:32.980649+08:00 0 [Note] InnoDB: Completed initialization of buffer pool

2018-05-23T09:38:33.207935+08:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-05-23T09:38:33.241437+08:00 0 [Note] InnoDB: Highest supported file format is Barracuda.

2018-05-23T09:38:34.034327+08:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-05-23T09:38:34.034431+08:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-05-23T09:38:34.043708+08:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-05-23T09:38:34.044716+08:00 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-05-23T09:38:34.044745+08:00 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-05-23T09:38:34.045637+08:00 0 [Note] InnoDB: Waiting for purge to start

2018-05-23T09:38:34.095960+08:00 0 [Note] InnoDB: 5.7.18 started; log sequence number 527415094702

2018-05-23T09:38:34.096530+08:00 0 [Note] InnoDB: Loading buffer pool(s) from /r2/mysqldata/ib_buffer_pool

2018-05-23T09:38:34.097285+08:00 0 [Note] Plugin 'FEDERATED' is disabled.

2018-05-23T09:38:34.160270+08:00 0 [Note] InnoDB: Buffer pool(s) load completed at 180523 9:38:34

2018-05-23T09:38:34.171769+08:00 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2018-05-23T09:38:34.171815+08:00 0 [Note] Server hostname (bind-address): '*'; port: 3306

2018-05-23T09:38:34.171876+08:00 0 [Note] IPv6 is available.

2018-05-23T09:38:34.171900+08:00 0 [Note] - '::' resolves to '::';

2018-05-23T09:38:34.171963+08:00 0 [Note] Server socket created on IP: '::'.

2018-05-23T09:38:34.297995+08:00 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.

2018-05-23T09:38:34.298227+08:00 0 [Warning] 'user' entry 'operator@localhost' ignored in --skip-name-resolve mode.

2018-05-23T09:38:34.305132+08:00 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.

2018-05-23T09:38:34.312612+08:00 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.

2018-05-23T09:38:34.414747+08:00 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.

2018-05-23T09:38:34.497898+08:00 0 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=slave1-relay-bin' to avoid this problem.

2018-05-23T09:38:46.589637+08:00 1 [Warning] Slave SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0

2018-05-23T09:38:46.589652+08:00 2 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please considerusing the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.

2018-05-23T09:38:46.589735+08:00 1 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'slave1-bin.000461' at position 1035528252, relay log './slave1-relay-bin.000079' position: 1035528467

2018-05-23T09:38:46.591039+08:00 2 [Note] Slave I/O thread for channel '': connected to master 'repl@192.168.102.130:3306',replication started in log 'slave1-bin.000461' at position 1035528252

2018-05-23T09:38:46.717702+08:00 0 [Note] Event Scheduler: Loaded 0 events

2018-05-23T09:38:46.718462+08:00 0 [Note] /usr/bin/mysqld: ready for connections.

Version: '5.7.18-log' socket: '/r2/mysqldata/mysql.sock' port: 3306 MySQL Community Server (GPL)

2018-05-23T09:38:46.718484+08:00 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.

2018-05-23T09:38:46.718491+08:00 0 [Note] Beginning of list of non-natively partitioned tables

2018-05-23T09:38:58.533297+08:00 0 [Note] End of list of non-natively partitioned tables

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/news/273185.shtml
繁體地址，請注明出處：http://hk.pswp.cn/news/273185.shtml
英文地址，請注明出處：http://en.pswp.cn/news/273185.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

poj 3660 傳遞閉包 **

poj 3660 傳遞閉包 **

題意：題目給出了m對的相對關系，求有多少個排名是確定的。 鏈接：點我 如果這個點到其他點的關系是確定的，那么這個點就是確定的，注意如果這個點到不了其他點，但其他點能到這個點，那么這個點和其他…
閱讀更多...
C# 網絡編程之webBrowser獲取網頁url和下載網頁中圖片

C# 網絡編程之webBrowser獲取網頁url和下載網頁中圖片

該文章主要是通過C#網絡編程的webBrowser獲取網頁中的url并簡單的嘗試下載網頁中的圖片,主要是為以后網絡開發的基礎學習.其中主要的通過應用程序結合網頁知識、正則表達式實現瀏覽、獲取url、下載圖片三個功能.而且很清晰的解析了每一步都是以前一步為基礎實現的. 一.界面設計…
閱讀更多...
mysql員工腳本_mySQL常用腳本匯總

mysql員工腳本_mySQL常用腳本匯總

mysql的常用腳本有哪些呢？我們來做個總結建表語句sql語句最后指定主鍵DROP TABLE IF EXISTS user_info1;CREATE TABLE user_info1 (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主鍵,name varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 姓名,password varcha…
閱讀更多...
多線程 調用多線程的方法 Runtime與ProcessBuilder

多線程 調用多線程的方法 Runtime與ProcessBuilder

一般我們使用Java運行其他類中的方法的時候，無論是靜態調用還是動態調用，都是在當前的進程中執行的。也就是只有一個Java虛擬機實例在運行。有時候需要通過Java代碼啟動多個Java子進程，這樣做會消耗些資源，但是程序變得更穩定。因…
閱讀更多...
mysql可連接_mysql開啟遠程可連接

mysql可連接_mysql開啟遠程可連接

1.打開cmd窗口，進入MySql安裝的bin目錄2.執行命令登錄數據庫,之后會出現一行要你輸入密碼的mysql -u root -p3.執行以下命令分配新用戶：grant all privileges on *.* to ‘用戶名‘‘IP地址‘ identified by ‘密碼‘;4.執行完上述命令后用下面的命令刷新…
閱讀更多...
ubuntu14.04 python2.7 安裝配置OpenCV3.0

ubuntu14.04 python2.7 安裝配置OpenCV3.0

環境：ubuntu14.04 python2.7 內容：安裝并配置OpenCV3.0 今天按照OpenCV官網上的步驟裝了OpenCV但是，裝好之后python提示“No module named cv2” 首先，安裝OpenCV的步驟： OpenCV官網的安裝步驟：http://doc…
閱讀更多...
mysql導出如何不區分大小寫_mysql 不區分大小寫

mysql導出如何不區分大小寫_mysql 不區分大小寫

show variables like %case%-------------------------------| Variable_name | Value |-------------------------------| lower_case_file_system | OFF || lower_case_table_names | 1 | 表示已經是支持忽略大小寫了-------------------------------修改 /etc/mysql/…
閱讀更多...
[iOS] Win8下在Vmware11中安裝使用蘋果系統OS X 10.10

[iOS] Win8下在Vmware11中安裝使用蘋果系統OS X 10.10

近來因為人事變動，領導打算安排我做 iOS 的項目，所以需要花一些時間提前準備一下iOS相關的東西。因為自己手頭上并沒有 Mac（過年為了閑的時候能玩玩游戲買了聯想，唉），想想不能只靠每天在公司的時間練 demo …
閱讀更多...
html5的網絡書店圖書網站代碼_【技能提升】10個編寫HTML5的實用小技巧

html5的網絡書店圖書網站代碼_【技能提升】10個編寫HTML5的實用小技巧

1. 新的文檔類型(Doctype)html PUBLIC ”-//W3C//DTD XHTML 1.0 Transitional//EN”“http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>上面這個既麻煩又難記的XHTML文檔類型你還在使用嗎？如果還是這樣的話，現在該切換到新的HTML5文檔類型…
閱讀更多...
hdu2457 Trie圖+dp

hdu2457 Trie圖+dp

hdu2457 給定n個模式串， 和一個文本串 問如果修改最少的字符串使得文本串不包含模式串， 輸出最少的次數，如果不能修改成功，則輸出-1 dp[i][j] 表示長度為i的字符串， 到達狀態j（Trie圖中的結點）…
閱讀更多...
sql中if語句的用法_Python中的if條件語句

sql中if語句的用法_Python中的if條件語句

Python中的if語句在實際的編程中，經常需要檢查一系列條件，并據此決定采取什么措施。正常情況下，程序的執行是自上而下的進行，if語句則根據條件判斷，實現程序的執行順序改變。一、if-else語句1、語法：if 條件…
閱讀更多...
mysql 1449 ： The user specified as a definer ('root'@'%') does not exist 解決方法

mysql 1449 ： The user specified as a definer ('root'@'%') does not exist 解決方法

權限問題，授權 給 root 所有sql 權限 mysql> grant all privileges on *.* to root"%" identified by ".";Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)轉載于:https://www.cnbl…
閱讀更多...
mysql中non用什么_mysql Non-Transactional Database Only(只支持MyISAM)

mysql中non用什么_mysql Non-Transactional Database Only(只支持MyISAM)

后來在做WordPress，一開始還不知道原來WordPress用的是InnoDB數據引擎，于是在原來的數據庫里面就建了一個數據庫,一開始也沒發覺問題，安裝，導入sql，都沒問題，當時也沒多想。直到這幾天因為又要裝多一個Word…
閱讀更多...
openSUSE 11 上的配置可以Xmanager遠程桌面

openSUSE 11 上的配置可以Xmanager遠程桌面

openSUSE 11 上的配置(適用于默認圖形環境為KDE的Linux)： 1、配置KDM。 openSUSE 11的默認圖形環境為KDE，雖然可以同時安裝GDM和KDM，但默認只啟動了KDM。所以openSUSE 11只需配置KDM，如果你啟動了GDM來代替KDM，則配置可…
閱讀更多...
timed_waiting線程是否占用cpu_程序CPU占用率飆升，如何定位線程的堆棧信息？超詳細，值得收藏看不懂還有配套視頻 第319篇...

timed_waiting線程是否占用cpu_程序CPU占用率飆升，如何定位線程的堆棧信息？超詳細，值得收藏看不懂還有配套視頻 第319篇...

相關歷史文章(閱讀本文前，您可能需要先看下之前的系列?)國內最全的Spring Boot系列之三2020上半年發文匯總「值得收藏」GraphQL的探索之路 – SpringBoot集成GraphQL小栗子篇二 - 第315篇GraphQL的探索之路 – SpringBoot集成GraphQL之Query篇三 - 第316篇GraphQL的…
閱讀更多...
圖片的縮放（放大縮小）

圖片的縮放（放大縮小）

package com.school.util;import java.awt.Graphics; import java.awt.Image; import java.awt.image.BufferedImage; import java.io.File; import java.io.IOException;import javax.imageio.ImageIO; /*** * <b>類名稱&#xff1a;圖片處理工具類</b>ImageUtils…
閱讀更多...
sql多層嵌套別名無效_SQL之復雜查詢

sql多層嵌套別名無效_SQL之復雜查詢

前文學了匯總分析&#xff0c;學了常見的匯總函數&#xff0c;會分組并且掌握了對分組結果指定條件。今天開始學習SQL的視圖和子查詢&#xff0c;還有數據庫關聯與嵌套查詢內容的學習。一、視圖1.1視圖是有單固定存儲可反復讀取使用的子查詢&#xff0c;所以視圖適用于頻繁使用…
閱讀更多...
POJ 1195 Mobile phones【 二維樹狀數組 】

POJ 1195 Mobile phones【 二維樹狀數組 】

題意&#xff1a;基礎的二維數組&#xff0c;注意 0 lowbit(0)會陷入無限循環----- 之前做一道一維的一直tle,就是因為這個-------------------------- 1 #include<iostream> 2 #include<cstdio> 3 #include<cstring> 4 #include <cmath> 5 #includ…
閱讀更多...
mysql 交叉連接的用法_深入理解MySQL的外連接、內連接、交叉連接

mysql 交叉連接的用法_深入理解MySQL的外連接、內連接、交叉連接

1、內聯接(典型的聯接運算&#xff0c;使用像 或 <> 之類的比較運算符)。包括相等聯接和自然聯接。內聯接使用比較運算符根據每個表共有的列的值匹配兩個表中的行。例如&#xff0c;檢索 students和courses表中學生標識號相同的所有行。2、外聯接。外聯接可以是左向外聯…
閱讀更多...
基于Angularjs實現分頁

基于Angularjs實現分頁

前言 學習任何一門語言前肯定是有業務需求來驅動你去學習它&#xff0c;當然ng也不例外&#xff0c;在學習ng前我第一個想做的demo就是基于ng實現分頁&#xff0c;除去基本的計算思路外就是使用指令封裝成一個插件&#xff0c;在需要分頁的列表頁面內直接引用。 插件 在封裝分頁…
閱讀更多...
最新文章

Copyright @ 2022~2023