Tag Archives: 5.1

MySQL can’t start after updating from 5.1 to 5.5

After updating a MySQL server from 5.1.73 to 5.5.4 it won’t start. To see what was going on I checked the logs:

# tail /var/log/mysql.log
141221 13:23:41  InnoDB: Waiting for the background threads to start
141221 13:23:42 InnoDB: 5.5.41 started; log sequence number 1589339
141221 13:23:42 [ERROR] /usr/libexec/mysqld: unknown variable 'record_buffer=1M'
141221 13:23:42 [ERROR] Aborting

It was obvious that many things had changed form 5.1 to 5.5 and in this case the reason to the problem was that record_buffer has been deprecated and now it’s called read_buffer_size. Changing the name of it in /etc/my.cnf fixed the problem.