Closed Bug 1422427 Opened 7 years ago Closed 6 years ago

Change the mysql variables innodb_file_format and innodb_large_prefix

Categories

(bugzilla.mozilla.org :: Infrastructure, enhancement)

Product:
bugzilla.mozilla.org
Component:
Infrastructure
Version:
Production
Type:
enhancement
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED FIXED

People

(Reporter: dylan, Assigned: bobm)

References

Details

In preparation of changing the row format to DYNAMIC, the following
innodb settings must set:

>    innodb_file_format = Barracuda
>    innodb_large_prefix = 1

This should not have any impact on the operation of the system
right now, although it might if we added any tables.
(and I'm sorry I didn't think to split this out as a task earlier, it seems obvious a year later. :-)
I'd like to do the row conversion on at least bugzilla-dev.
I think these settings should be safe to change everywhere, but at least for the dbs of staging/dev that would be good.
Flags: needinfo?(cvalaas)
Changed on bugzilla[12].stage.db.scl3
Flags: needinfo?(cvalaas)
so far it's taken 15 minutes to get to bugs_fulltext (on bugzilla-dev)
So far one hour to convert bugs_fulltext.
This happened a while ago: DBD::mysql::db do failed: Lost connection to MySQL server during query [for Statement "ALTER TABLE bugs_fulltext ROW_FORMAT=DYNAMIC"] at scripts/prepare-db-for-emoji.pl line 54.

I restarted the script, and it continued at the 'cc' table. It is now doing longdescs (comments) and I suspect this will take another few hours.
This is the first part of the conversion
Assignee: nobody → bobm
Status: NEW → RESOLVED
Closed: 6 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.