MySQL Bugs: #98958: Creating triggers causes mysql.ibd file to grow

Bug #98958	Creating triggers causes mysql.ibd file to grow
Submitted:	16 Mar 2020 10:13	Modified:	26 Mar 2020 14:04
Reporter:	Thomas Kosel	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S3 (Non-critical)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	trigger

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

Testscript, in case the bug does not get visible after first run, rerun the loop.

Attachment: test_mysql.sh (application/x-shellscript, text), 508 bytes.

Initial queries for the test script

Attachment: init_tables.sql (application/sql, text), 338 bytes.

creation of triggers to be executed in a loop

Attachment: create_triggers.sql (application/sql, text), 247.88 KiB.

fixed error for second trigger

Attachment: create_triggers.sql (application/sql, text), 247.92 KiB.