Skip to main content

Update MySQL Packet Size and Case Settings for AIQ

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

  1. Apply changes in the correct MySQL configuration file or managed service setting.
  2. Restart MySQL if required and confirm the active values.
  3. Run AIQ login, scenario, service, report, and upgrade-related smoke tests.
  4. Review logs for packet, table-name, permission, or migration errors.

Last updated: October 7, 2026