Required MySQL Database Settings
Code Insight requires the MySQL database configuration described in this table to ensure best performance.
| Property | System Variable | Recommended Value |
|---|---|---|
| Storage Engine | default-storage-engine | innodb |
| Character Set | character-set-server | utf8mb4 (required value for all supported MySQL versions) |
| Collation | collation-server | utf8mb4_unicode_ci (required value for MySQL 5.7) utf8mb4_0900_ai_ci (required value for MySQL 8.0) |
| InnoDB Buffer Pool Size | innodb_buffer_pool_size | 12G (12 GB) |
| InnoDB Log File Size | innodb_log_file_size | 8G (8 GB) |
| Maximum Allowed Packets | max_allowed_packet | 100M (100 MB) |
If you need to verify the current settings in your MySQL installation, click the appropriate Property link in the table for a description of the verification command. If you need to change settings in your installation, use the next procedure.