qq_35280588
qq_35280588
采纳率88.9%
2018-01-17 08:46

mysql5.7启动报错,配置文件修改后又恢复为最初的配置,启动报错,

5
已采纳

这是error_log中的错误信息,希望各位大神帮忙看一下

2018-01-17T16:31:15.955382+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-01-17T16:31:15.956199+08:00 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-log) starting as process 8086 ...
2018-01-17T16:31:15.959194+08:00 0 [Warning] InnoDB: Using innodb_file_format 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-01-17T16:31:15.959221+08:00 0 [Warning] InnoDB: Using innodb_file_format_max 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-01-17T16:31:15.959236+08:00 0 [Warning] InnoDB: innodb-page-size has been changed from the default value 16384 to 8192.
2018-01-17T16:31:15.959284+08:00 0 [Note] InnoDB: PUNCH HOLE support available
2018-01-17T16:31:15.959292+08:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-17T16:31:15.959297+08:00 0 [Note] InnoDB: Uses event mutexes
2018-01-17T16:31:15.959301+08:00 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-01-17T16:31:15.959306+08:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-01-17T16:31:15.959310+08:00 0 [Note] InnoDB: Using Linux native AIO
2018-01-17T16:31:15.959589+08:00 0 [Note] InnoDB: Number of pools: 1
2018-01-17T16:31:15.959656+08:00 0 [Note] InnoDB: Using CPU crc32 instructions
2018-01-17T16:31:15.960602+08:00 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-01-17T16:31:16.109011+08:00 0 [Note] InnoDB: Completed initialization of buffer pool
2018-01-17T16:31:16.119766+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-01-17T16:31:16.129910+08:00 0 [ERROR] InnoDB: Data file './ibdata1' uses page size 16384, but the innodb_page_size start-up parameter is 8192
2018-01-17T16:31:16.129942+08:00 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2018-01-17T16:31:16.129954+08:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-01-17T16:31:16.730466+08:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-01-17T16:31:16.730503+08:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-01-17T16:31:16.730518+08:00 0 [ERROR] Failed to initialize plugins.
2018-01-17T16:31:16.730525+08:00 0 [ERROR] Aborting

2018-01-17T16:31:16.730559+08:00 0 [Note] Binlog end
2018-01-17T16:31:16.730649+08:00 0 [Note] Shutting down plugin 'CSV'
2018-01-17T16:31:16.731019+08:00 0 [Note] /usr/sbin/mysqld: Shutdown complete

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

5条回答

  • lizhongyu 仲宇 3年前

    配置是在my.cnf中配置。
    这个错误,需要在数据库目录下删除ib_logfile0、ib_logfile1、ib_logfile2和ibdata1文件,然后再重启试试。

    点赞 1 评论 复制链接分享
  • qq_35280588 qq_35280588 3年前

    这是我的配置文件,默认的

    For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html [mysqld] # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M character_set_server=utf8 init_connect='SET NAMES utf8' lower_case_table_names=1 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 user = mysql log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

    点赞 评论 复制链接分享
  • qq_30478931 qq_30478931 3年前

    是不是配置文件,缓存,都检查一下

    点赞 评论 复制链接分享
  • ncp278635832 ncp278635832 3年前

    这个问题
    [ERROR] InnoDB: Data file './ibdata1' uses page size 16384, but the innodb_page_size start-up parameter is 8192

    点赞 评论 复制链接分享
  • weixin_39239385 weixin_39239385 3年前

    是不是没有配置环境变量

    点赞 评论 复制链接分享