启动mysql发生innodb错误_MySQL启动时的InnoDB错误

启动MySQL时,我收到以下InnoDB错误 .

mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

[Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.

[Warning] 'record_buffer' is deprecated and will be removed in a future release. Please use 'read_buffer_size' instead.

[Note] Plugin 'FEDERATED' is disabled.

InnoDB: Initializing buffer pool, size = 8.0M

InnoDB: Completed initialization of buffer pool

log file ./ib_logfile0 is of different size 0 503316480 bytes

InnoDB: than specified in the .cnf file 0 5242880 bytes!

[ERROR] Plugin 'InnoDB' init function returned error.

[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

[Note] Event Scheduler: Loaded 0 events

[Note] /usr/sbin/mysqld: ready for connections.

Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 12485 MySQL Community Server (GPL)

[Note] /usr/sbin/mysqld: Normal shutdown

my.conf 的内容是:

[mysqld]

local-infile=0

port = 12485

#skip-innodb

#socket=/var/lib/mysql/mysql.sock

#innodb_log_file_size=503316480

#innodb_force_recovery=6

skip-locking

query_cache_limit=1M

query_cache_size=4M

query_cache_type=1

max_allowed_packet=800M

max_connections=2000

interactive_timeout=1000

wait_timeout=1000

connect_timeout=100

thread_cache_size=8

key_buffer=8M

join_buffer=1M

table_cache=100

record_buffer=1M

sort_buffer_size=2M

read_buffer_size=2M

max_connect_errors=200

thread_concurrency=1

myisam_sort_buffer_size=4M

server-id=1

[safe_mysqld]

err-log=/var/log/mysqld.log

open_files_limit=400

[mysqldump]

quick

[mysql]

#default-storage-engine=myisam

no-auto-rehash

#safe-updates

[isamchk]

key_buffer=4M

sort_buffer=4M

read_buffer=4M

write_buffer=4M

[myisamchk]

key_buffer=4M

sort_buffer=4M

read_buffer=4M

write_buffer=4M

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值