Page MenuHomePhabricator

Reinstate innodb_large_prefix on ToolsDB (clouddb1001)
Closed, ResolvedPublic


After a reboot of clouddb1001 earlier this week, the value for innodb_large_prefix changed to "false", and innodb_file_format changed to "Antelope", because those variables (introduced in [1]) were removed recently from the file in [2] and [3], as they are set by default in MariaDB >=10.2.2, but we are still running 10.1.39 on clouddb1001.

I re-instated the values innodb_file_format=Barracuda and innodb_large_prefix=1 by manually running SET GLOBAL on clouddb1001:

SET GLOBAL innodb_large_prefix=1;
SET GLOBAL innodb_file_format = 'Barracuda';

I think it's worth re-adding those to, with a comment specifying that those variables will no longer be needed after we upgrade ToolsDB to MariaDB 10.4 in T301949.


Event Timeline

Change 866598 had a related patch set uploaded (by FNegri; author: FNegri):

[operations/puppet@production] Reinstate innodb_large_prefix on ToolsDB

fnegri changed the task status from Open to In Progress.Dec 9 2022, 2:30 PM
fnegri triaged this task as Medium priority.
fnegri moved this task from Inbox to Doing on the cloud-services-team (Kanban) board.

Change 866598 merged by FNegri:

[operations/puppet@production] Reinstate innodb_large_prefix on ToolsDB