Update MySQL Max Packet and Case Settings

Recommended

1. Open guidance

MySQLWorkbenchSelect 

Update MySQL packet sizeServer and case-sensitivityclick settingsStatus onlyand whenSystem requiredVariables
The byServer Variables window appears

Click the AIQSystem version,Variables 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.tabConfirmEnter 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 changesmax_allowed in the correctsearch MySQL configuration file or managed service setting.box
5. RestartUpdate MySQLthe ifmax_allowed_packet requiredvalue to 102400000 and confirmpress Enter
6. Enter lower in the activesearch values.box
7. RunUpdate AIQthe login,lower_case_table_names scenario,value service,to report,2 and upgrade-relatedpress smoke tests.
4. Review logs for packet, table-name, permission, or migration errors.Enter

You may now close MySQLWorkbench

 

Next step: Anti-Virus Settings

---

Last updated: OctoberJuly 7,31, 20262024

If you have any feedback on this topic, please contact us at documentation@appvance.ai