Monday, 7 January 2019

Import Mysql script

Problem:

When importing a Sql script into Mysql DB and the process hangs

Solutions:

1. Due to memory issue. In this case memory need to be increased, which can be achieved by the below script

SET GLOBAL max_allowed_packet=1073741824;

No comments:

Post a Comment

The total number of locks exceeds the lock table size

 SHOW VARIABLES LIKE 'innodb_buffer_pool_size'; SET GLOBAL innodb_buffer_pool_size = 2147483648;  -- 2GB Note: The value is in byte...