This error is very commonly appear when we are working with huge MySQL Database with inno DB storage engine.
To resolve this error we needs to update following variable in my.ini file.
(my.ini file is available in mysql folder)
After update above variable restart Mysql server your issue has been resolved. To get more detail also refer following link
InnoDB Startup Options and System Variables
This technique will work for all version of MySQL
To resolve this error we needs to update following variable in my.ini file.
(my.ini file is available in mysql folder)
| Variable | Default | Required |
| innodb_buffer_pool_size | 15M | 500M |
After update above variable restart Mysql server your issue has been resolved. To get more detail also refer following link
InnoDB Startup Options and System Variables
This technique will work for all version of MySQL
Thanks a lot. It solved my problem.
ReplyDelete