Bug #111690 Expose number of table objects with triggers in table cache

Description:
This is a follow-up to my contribution for the bug #44625 "Triggers should not be loaded on SELECTs".

I would like to contribute another patch on top of one provided in #44625 which adds Open_tables_with_triggers status variable, which shows number of TABLE objects with fully loaded triggers in Table Cache. Having such variable in addition to Table_open_cache_triggers_hits and Table_open_cache_triggers_misses variables should allow user to better understand how well caching for TABLE objects with triggers work and if the limits on such objects needs to be adjusted.

How to repeat:
Apply contributed patch for bug#44625 "Triggers should not be loaded on SELECTs" to recent snapshot of 8.0 (e.g. 8.0.33), observe that there is no way to see current number of TABLE objects with fully loaded triggers in Table Cache (similar to Open_tables status variable for example).

Suggested fix:
Apply contributed patch adding Open_tables_with_triggers status variable.

Hello Dmitry,

Thank you for the feature request.

Sincerely,
Umesh

Patch adding Open_tables_with_triggers status variable.

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: ps-8624-bug111690-contrib.patch (text/x-patch), 29.04 KiB.

Thank you for the Contribution.

Sincerely,
Umesh

Hello Dmitry!

Thank you for this contribution!

Can you please create github issue (https://github.com/mysql/mysql-server/issues/new/choose) for this ?

Regards,
Praveen

Hello Dmitry!

Kindly ignore the link for creating issue.

Here is the correct link to create github issue https://github.com/mysql/mysql-community/issues/new/choose.

Regards,
Praveen

Hello Dmitry!

Here is the template for feature proposal https://github.com/mysql/mysql-community/blob/main/.github/ISSUE_TEMPLATE/feature_proposal.... FJYI.

Regards,
Praveen

Posted by developer:
 
Hi Dmitry,

We have merged your contribution as WL#17341, and it will be available in MySQL Server 27.1.0.

Thank you for the contribution!

Regards,
Tarang