Update MySQL Packet Size and Case Settings for AIQ
Recommended guidance
Update MySQL packet size and case-sensitivity settings only when required by the AIQ version, database workload, or support guidance. These settings can affect imports, upgrades, reports, and cross-platform database behavior.
Before changing settings
- Back up the database and current MySQL configuration.
- Confirm the exact variable names, target values, and MySQL version.
- Coordinate downtime if a database restart is required.
- Document why the setting is being changed and who approved it.
Validation workflow
- Apply changes in the correct MySQL configuration file or managed service setting.
- Restart MySQL if required and confirm the active values.
- Run AIQ login, scenario, service, report, and upgrade-related smoke tests.
- Review logs for packet, table-name, permission, or migration errors.
Last updated: October 7, 2026