0

I'm trying to upgrade from Mysql 5.5 to Mysql 5.6 on Ubuntu 14.04

I've tried:

None of these options worked.. the error I get is this:

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) ...

I can't set it up, getting really really frustrated

Running on Digital Ocean VPS, please enlighten me masters :(

Community
  • 1
  • 1
sigmaxf
  • 7,998
  • 15
  • 65
  • 125

2 Answers2

0

It seems "innodb_buffer_pool_size" variable size is set too low in your configuration file, so increase it as per your server RAM (you can set upto 80% of total RAM) and then try...

Zafar Malik
  • 6,734
  • 2
  • 19
  • 30
  • where should I set that? I didn't find it in the default my.cnf – sigmaxf Jul 06 '15 at 15:56
  • update innodb_buffer_pool_size = 5G (as per your RAM), in my.cnf under [mysqld] section – Zafar Malik Jul 06 '15 at 17:54
  • tried it, and it didn't work.. then I upgrade my server from 512 to 1gb ram, and it worked.. I wonder why it didn't work with 4gb swap memory though, any ideas? – sigmaxf Jul 06 '15 at 19:15
  • 1
    bcoz mysql 5.6 need more than 128MB (which is default ram set) for innodb_buffer_pool initialization, so you need at least 1 GB RAM to start mysql 5.6. Regarding swap it is not RAM it is part of ROM, but yes system will consider it as RAM in some manner as your RAM will be utilized completely... – Zafar Malik Jul 07 '15 at 04:05
0

I meet this problem before, in my situation, it happens because i use vagrant vpc server.

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

If you still have problem, check the following info:

  1. Increase the amount of memory in your EC2
  2. Set a smaller value for MySQL’s max_connections variable
Zhe Xiao
  • 454
  • 1
  • 3
  • 9