innodb的问题，mysql启动不了

ashuma

我用的是阿里云基础版，512M的内存，自己配置的lmap环境，因为程序需要用到innodb的引擎，所以需要安装。
现在mysql启动不了，查看了日志，是这样的提示：

140613 02:26:58 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140613 02:29:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-06-13 02:29:00 29995 [Note] Plugin 'FEDERATED' is disabled.
2014-06-13 02:29:00 29995 [Note] InnoDB: Started in read only mode
2014-06-13 02:29:00 29995 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-06-13 02:29:00 29995 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-13 02:29:00 29995 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-06-13 02:29:00 29995 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-13 02:29:00 29995 [Note] InnoDB: Using Linux native AIO
2014-06-13 02:29:00 29995 [Note] InnoDB: Using CPU crc32 instructions
2014-06-13 02:29:00 29995 [Note] InnoDB: Disabling background IO write threads.
2014-06-13 02:29:00 29995 [Note] InnoDB: Initializing buffer pool, size = 32.0M
2014-06-13 02:29:00 29995 [Note] InnoDB: Completed initialization of buffer pool
2014-06-13 02:29:00 29995 [Note] InnoDB: Highest supported file format is Barracuda.
2014-06-13 02:29:00 29995 [Note] InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on, skipping log redo
2014-06-13 02:29:01 29995 [Note] InnoDB: 5.6.19 started; log sequence number 0
2014-06-13 02:29:01 29995 [Note] InnoDB: !!! innodb_force_recovery is set to 6 !!!
2014-06-13 02:29:01 29995 [Note] Server hostname (bind-address): '*'; port: 3306
2014-06-13 02:29:01 29995 [Note] IPv6 is available.
2014-06-13 02:29:01 29995 [Note]   - '::' resolves to '::';
2014-06-13 02:29:01 29995 [Note] Server socket created on IP: '::'.
2014-06-13 02:29:01 29995 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2014-06-13 02:29:01 29995 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2014-06-13 02:29:01 29995 [Note] Event Scheduler: Loaded 0 events
2014-06-13 02:29:01 29995 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.19'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2014-06-13 02:29:50 29995 [Note] /usr/sbin/mysqld: Normal shutdown

2014-06-13 02:29:50 29995 [Note] Giving 0 client threads a chance to die gracefully
2014-06-13 02:29:50 29995 [Note] Event Scheduler: Purging the queue. 0 events
2014-06-13 02:29:50 29995 [Note] Shutting down slave threads
2014-06-13 02:29:50 29995 [Note] Forcefully disconnecting 0 remaining clients
2014-06-13 02:29:50 29995 [Note] Binlog end
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'partition'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'BLACKHOLE'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'ARCHIVE'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_METRICS'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_CMP'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'INNODB_TRX'
2014-06-13 02:29:50 29995 [Note] Shutting down plugin 'InnoDB'
2014-06-13 02:29:50 29995 [Note] InnoDB: Starting shutdown...
140613 02:30:51 mysqld_safe A mysqld process already exists
140613 02:31:03 mysqld_safe A mysqld process already exists
140613 02:31:16 mysqld_safe A mysqld process already exists
140613 02:35:00 mysqld_safe A mysqld process already exists

不知道这个问题怎么处理呢？谢谢。

bikong0411

please run mysql_upgrade

ashuma

回复 2# bikong0411


    这个命令不能执行。。

错误提示:

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed