2006 MySQL server has gone away Error while saving H5P content

Problem/Motivation

2006 MySQL server has gone away Error while saving H5P content. especially interactive videos.

Steps to reproduce

Using Drupal version 9.5.10
PHP 8.1.14
Mysql max_allowed_packet value 512MB

Add a Interactive Content – H5P type of field to Basic page content type
Select H5P Editor in the form display
Create content and get "Interactive Video" type
Add a video of any size.
Save the node
On view/edit of the node getting 2006 MySQL server has gone away Error

Proposed resolution

I have tried applying patches mentioned in this core issue https://www.drupal.org/project/drupal/issues/3327118 🐛 Chunk multiple cache sets into groups of 100 to avoid OOM/max_allowed_packet issues Fixed

Patch 1 - https://www.drupal.org/project/drupal/issues/3327118#comment-15035871 🐛 Chunk multiple cache sets into groups of 100 to avoid OOM/max_allowed_packet issues Fixed
Patch 2 - https://www.drupal.org/project/drupal/issues/3327118#comment-14827481 🐛 Chunk multiple cache sets into groups of 100 to avoid OOM/max_allowed_packet issues Fixed