linux中mysql日志位置_Liunx MySQL日志位置以及查看
操作系统:CentOS,数据库:MySQL5.6日志位置: /var/log/mysqld.log启动日志:2017-09-1001:40:2318731[Warning]Youneedtouse--log-bintomake--binlog-formatwork.2017-09-1001:40:2318731[Note]Plugin'FEDERATED'is...
操作系统:CentOS,数据库:MySQL5.6
日志位置: /var/log/mysqld.log
启动日志:2017-09-10 01:40:23 18731 [Warning] You need to use --log-bin to make --binlog-format work.
2017-09-10 01:40:23 18731 [Note] Plugin 'FEDERATED' is disabled.
2017-09-10 01:40:23 7f283f68f720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2017-09-10 01:40:23 18731 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-09-10 01:40:23 18731 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-10 01:40:23 18731 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-10 01:40:23 18731 [Note] InnoDB: Memory barrier is not used
2017-09-10 01:40:23 18731 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-09-10 01:40:23 18731 [Note] InnoDB: Using Linux native AIO
2017-09-10 01:40:23 18731 [Note] InnoDB: Using CPU crc32 instructions
2017-09-10 01:40:23 18731 [Note] InnoDB: Initializing buffer pool, size = 24.0G
2017-09-10 01:40:24 18731 [Note] InnoDB: Completed initialization of buffer pool
2017-09-10 01:40:30 18731 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-10 01:40:34 18731 [Note] InnoDB: 128 rollback segment(s) are active.
2017-09-10 01:40:39 18731 [Note] InnoDB: Waiting for purge to start
2017-09-10 01:40:39 18731 [Note] InnoDB: 5.6.37 started; log sequence number 85748758
2017-09-10 01:40:39 18731 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2017-09-10 01:40:39 18731 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2017-09-10 01:40:39 18731 [Note] Server socket created on IP: '0.0.0.0'.
2017-09-10 01:40:39 18731 [Note] Event Scheduler: Loaded 0 events
2017-09-10 01:40:39 18731 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.37' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
更多推荐
所有评论(0)