Magento 2 Migration Error – Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size

How to solve the following error,

main.WARNING: Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 556; Allocated memory size: 28022400 bytes; InnoDB buffer pool size: 134217728 bytes. [] []

Reindex issue, No such entity error.