Database Pre-Installation Tasks for MySQL

Increase innodb_log_file_size in my.ini file - MySQL

NOTE:  If the size of your application is more than the variable size of server database, an error occurs. Ensure the variable max_allowed_packet_size is set to a higher value than the application size. To avoid this error, increase the global variable in the server database.

Modify the SQL Statement to Set global max_allowed_packet=10*1024*1024.
In this statement the server database size is configured to 10-Megabytes(MB).
For example, if your application size is 1024-kilobytes (1 MB) and you try to publish an application from Quantum Studio of 2048-Kilobytes(2 MB), an error occurs while publishing. Increase the size of server database to a value more than 2048-Kilobytes (2 MB) to publish the application.

For innodb_log_file_size, the value is set to 48M by default.

In the my.ini file, increase the innodb_log_file_size value such that it is greater than 10% of the max_allowed_packet value.