advagg 5.0: Data transition from mysql5.7 to mysql8 fails with timeout

Problem/Motivation

I encountered an issue when transitioning data from Drupal 9.3:php7.2:mysql5.7 to Drupal 9.5.10:php8.1.23:mysql8

I wonder how to work around it.

I get the following errors

(function(){var settingsElement=document.querySelector('head > script[type="application/json"][data-drupal-selector="drupal-settings-json"], body > script[type="application/json"][data-drupal-selector="drupal-settings-json"]');window.drupalSettings={};if(settingsElement!==null){window.drupalSettings=JSON.parse(settingsElement.textContent);}})()
Fatal error: Maximum execution time of 30 seconds exceeded in /opt/drupal/site/web/modules/contrib/advagg/advagg_js_minify/jshrink.inc on line 274

I tried making the max_execution_time 900 in php.ini and adding more memory (512), but it didn't work. I also restarted my apache server (now reset to default settings)

I'm pretty sure this is not a Aggregator-PHP/MYSQL issue because I had the site run just fine with a new database. It's only when I add my data to it that it behaves like this.

Steps to reproduce

Create data and views with an earlier Drupal version using php7.2 and mysql5.7 then dump the data, import in new instance using php8.1 and mysql8. Go to home page or /update.php

Proposed resolution

Remaining tasks

1) Find source of issue
2) Apply patch or remove entries from DB

User interface changes

API changes

Data model changes