无法在Ubuntu 14.04上安装MySQL5.6

Question

我正在Ubuntu14.04上尝试从Mysql 5.5升级到Mysql 5.6

我试过：

• 直接用sudo apt-get安装mysql-server-5.6安装-没有成功
• 首先完全删除Mysql 5.5，按照下面的线程：Removing MySQL 5.5 Completely然后用sudo apt安装mysql-server-5.6 -没有成功
• 创建4g交换，如这里所解释的：https://askubuntu.com/questions/457923/why-did-installation-of-mysql-5-6-on-ubuntu-14-04-fail -没有成功

这些选择都行不通..。我得到的错误是：

2015-07-06 02:32:33 12412 [Note] Plugin 'FEDERATED' is disabled.
2015-07-06 02:32:33 12412 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-06 02:32:33 12412 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-06 02:32:33 12412 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-07-06 02:32:33 12412 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-07-06 02:32:33 12412 [Note] InnoDB: Using Linux native AIO
2015-07-06 02:32:33 12412 [Note] InnoDB: Not using CPU crc32 instructions
2015-07-06 02:32:33 12412 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-07-06 02:32:33 12412 [Note] InnoDB: Completed initialization of buffer pool
2015-07-06 02:32:33 12412 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-06 02:32:33 12412 [Note] InnoDB: 128 rollback segment(s) are active.
2015-07-06 02:32:33 12412 [Note] InnoDB: Waiting for purge to start
2015-07-06 02:32:33 12412 [Note] InnoDB: 5.6.19 started; log sequence number 1626183
2015-07-06 02:32:33 12412 [Note] Binlog end
2015-07-06 02:32:33 12412 [Note] InnoDB: FTS optimize thread exiting.
2015-07-06 02:32:33 12412 [Note] InnoDB: Starting shutdown...
2015-07-06 02:32:35 12412 [Note] InnoDB: Shutdown completed; log sequence number 1626193
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.6 (--configure):
 subprocess installed post-installation script returned error exit status 1
Setting up mysql-common-5.6 (5.6.19-0ubuntu0.14.04.1) ...

我不能设置它，我真的很沮丧

在数码海洋VPS上运行，请指点师父:(

Answer 1

似乎"innodb_buffer_pool_size“的可变大小在您的配置文件中设置得太低，所以根据您的服务器RAM增加它(您可以设置高达80%的内存)，然后尝试.

Answer 2

我以前遇到过这个问题，在我的情况下，这是因为我使用了迷航的vpc服务器。

1.remove all Local MySQL
$ sudo apt-get autoremove –purge mysql*
$ sudo rm -rf /var/lib/mysql/
$ sudo rm -rf /etc/mysql/

2.install mysql
$ sudo apt-get update
$ sudo apt-get build-dep mysql-server-5.6
$ sudo apt-get install mysql-server-5.6

如果您仍然有问题，请检查以下信息：

1. 增加EC2中的内存量
2. 为MySQL的max_connections变量设置一个较小的值