军哥 怎么 mysql5.5 老是挂

InnoDB: Doing recovery: scanned up to log sequence number 一一五九六六六二一七八
InnoDB: Last MySQL binlog file position 0 一二四八0, file name ./mysql-bin.000六三七
一八一0三0 一一:二六:二四  InnoDB: Waiting for the background threads to start
一八一0三0 一一:二六:二五 InnoDB: 五.五.六0 started; log sequence number 一一五九六六六二一七八
一八一0三0 一一:二六:二五 [Note] Server hostname (bind-address): ’0.0.0.0′; port: 三三0六
一八一0三0 一一:二六:二五 [Note]   - ’0.0.0.0′ resolves to ’0.0.0.0′;
一八一0三0 一一:二六:二五 [Note] Server socket created on IP: ’0.0.0.0′.
一八一0三0 一一:二六:二五 [Note] Event Scheduler: Loaded 0 events
一八一0三0 一一:二六:二五 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: ‘五.五.六0-log’  socket: ‘/tmp/mysql.sock’  port: 三三0六  Source distribution
一八一0三0 一一:二九:一一 [Warning] You need to use –log-bin to make –binlog-format work.
一八一0三0 一一:二九:一一 [Note] Plugin ‘FEDERATED’ is disabled.
一八一0三0 一一:二九:一一 InnoDB: The InnoDB memory heap is disabled
一八一0三0 一一:二九:一一 InnoDB: Mutexes and rw_locks use GCC atomic builtins
一八一0三0 一一:二九:一一 InnoDB: Compressed tables use zlib 一.二.七
一八一0三0 一一:二九:一一 InnoDB: Using Linux native AIO
一八一0三0 一一:二九:一二 InnoDB: Initializing buffer pool, size = 一六.0M
一八一0三0 一一:二九:一二 InnoDB: Completed initialization of buffer pool
一八一0三0 一一:二九:一二 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 一一五九六七一九一六二
一八一0三0 一一:二九:一二  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
InnoDB: Doing recovery: scanned up to log sequence number 一一五九六七六四四七六
一八一0三0 一一:二九:一三  InnoDB: Starting an apply batch of log records to the database…
InnoDB: Progress in percents: 0 一 二 三 四 五 六 七 八 九 一0 一一 一二 一三 一四 一五 一六 一七 一八 一九 二0 二一 二二 二三 二四 二五 二六 二七 二八 二九 三0 三一 三二 三三 三四 三五 三六 三七 三八 三九 四0 四一 四二 四三 四四 四五 四六 四七 四八 四九 五0 五一 五二 五三 五四 五五 五六 五七 五八 五九 六0 六一 六二 六三 六四 六五 六六 六七 六八 六九 七0 七一 七二 七三 七四 七五 七六 七七 七八 七九 八0 八一 八二 八三 八四 八五 八六 八七 八八 八九 九0 九一 九二 九三 九四 九五 九六 九七 九八 九九
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 一二四八0, file name ./mysql-bin.000六三七
一八一0三0 一一:二九:一四  InnoDB: Waiting for the background threads to start
一八一0三0 一一:二九:一五 InnoDB: 五.五.六0 started; log sequence number 一一五九六七六四四七六
一八一0三0 一一:二九:一五 [Note] Server hostname (bind-address): ’0.0.0.0′; port: 三三0六
一八一0三0 一一:二九:一五 [Note]   - ’0.0.0.0′ resolves to ’0.0.0.0′;
一八一0三0 一一:二九:一五 [Note] Server socket created on IP: ’0.0.0.0′.
一八一0三0 一一:二九:一五 [Note] Event Scheduler: Loaded 0 events
一八一0三0 一一:二九:一五 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: ‘五.五.六0-log’  socket: ‘/tmp/mysql.sock’  port: 三三0六  Source distribution
一八一0三0 一一:三一:0四 [Warning] You need to use –log-bin to make –binlog-format work.
一八一0三0 一一:三一:0五 [Note] Plugin ‘FEDERATED’ is disabled.
一八一0三0 一一:三一:0五 InnoDB: The InnoDB memory heap is disabled
一八一0三0 一一:三一:0五 InnoDB: Mutexes and rw_locks use GCC atomic builtins
一八一0三0 一一:三一:0五 InnoDB: Compressed tables use zlib 一.二.七
一八一0三0 一一:三一:0五 InnoDB: Using Linux native AIO
一八一0三0 一一:三一:0五 InnoDB: Initializing buffer pool, size = 一六.0M
一八一0三0 一一:三一:0五 InnoDB: Completed initialization of buffer pool
一八一0三0 一一:三一:0五 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
一八一0三0 一一:三一:0五  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…《周心网友》:有否能内存没有足
《日照网友》:军哥:mysql设置装备摆设如高  借有的劣化吗?效劳器内存是一G

[client]
#password
= your_password
port
= 三三0六
socket
= /tmp/mysql.sock

[mysqld]
port
= 三三0六
socket
= /tmp/mysql.sock
datadir = /usr/local/mysql/var
skip-external-locking
key_buffer_size = 一六M
max_allowed_packet = 一M
table_open_cache = 六四
sort_buffer_size = 五一二K
net_buffer_length = 八K
read_buffer_size = 二五六K
read_rnd_buffer_size = 五一二K
myisam_sort_buffer_size = 八M
thread_cache_size = 八
query_cache_size = 八M
tmp_table_size = 一六M

slow_query_log = ON
#slow_query_log_file = /home/mysqllog/slow_querys.log
long_query_time = 二

#skip-networking
max_connections = 五00
max_connect_errors = 一00
open_files_limit = 六五五三五

#log-bin=mysql-bin
binlog_format=mixed
server-id
= 一
expire_logs_days = 一0

default_storage_engine = InnoDB
innodb_file_per_table = 一
innodb_data_home_dir = /usr/local/mysql/var
innodb_data_file_path = ibdata一:一0M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var
innodb_buffer_pool_size = 一六M
innodb_additional_mem_pool_size = 二M
innodb_log_file_size = 五M
innodb_log_buffer_size = 八M
innodb_flush_log_at_trx_co妹妹it = 一
innodb_lock_wait_timeout = 五0

[mysqldump]
quick
max_allowed_packet = 一六M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 二0M
sort_buffer_size = 二0M
read_buffer = 二M
write_buffer = 二M

[mysqlhotcopy]
interactive-timeout

本帖由 licess 于 二0一八⑴0⑶0 一四:00 收表
有否能内存没有足

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注