1. Home
  2. Development
  3. mysql 8 service stop automatically during migration from 6.2 to DXP 7.2

mysql 8 service stop automatically during migration from 6.2 to DXP 7.2

Pankaj Kumar, modified 5 Years ago.
mysql 8 service stop automatically during migration from 6.2 to DXP 7.2
Regular Member Posts: 101 Join Date: 7/27/14 Recent Posts
Hi All,
We are  migrating  DB from Liferay 6.2 to Liferay dxp 7.2.For DB we are using Mysql 8.While doing migration in case of  ResourcePermisson table which have large  amount of data  around 3GB.Mysql 8 service stop automatically  and due this the migration failing.To again start migration we need to manually start the mysql 8  service.WE are using DXP 7.2 DB upgrade tool for migration.Can any body tell us how we should proceed now.
Thanks,Pankaj Semwal
thumbnail
Aditya Bhardwaj, modified 5 Years ago.
RE: mysql 8 service stop automatically during migration from 6.2 to DXP 7
Junior Member Posts: 78 Join Date: 1/8/15 Recent Posts
Hi pankaj,I also face same kind of issue . When i reach at ResourcePermission table it will take around 20 minutes and after that MySQL 8 Service stops and as a result migration also stops.I am using MySQL 8 with Liferay DXP 7.2 on window machine and database size is around 40 GB.For database upgrade i am using dbmigration tool.Please helpThanks,Aditya
thumbnail
Aditya Bhardwaj, modified 5 Years ago.
RE: mysql 8 service stop automatically during migration from 6.2 to DXP 7
Junior Member Posts: 78 Join Date: 1/8/15 Recent Posts
Now it resolved.
  • Stop the mysql services.
  • Inside  my.ini file of Mysql change the value of property  innodb_buffer_pool_size to 2G:-
                        innodb_buffer_pool_size=2G

  • Restart the Mysql Services.
thumbnail
Alberto Chaparro, modified 5 Years ago.
RE: mysql 8 service stop automatically during migration from 6.2 to DXP 7
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Hi Adita,
Thanks for sharing how you solved it.

Regarding that, it's really important to look for unused objects before the upgrade to remove them and improve the performance of the upgrade and future installation. Removing entities properly (using the API) you also removing resourcePermission objects, with that purpose check this article and try to remove useless data before the upgrade:https://portal.liferay.dev/docs/7-2/deploy/-/knowledge_base/d/pruning-the-database
Thanks.