Comments on: Understanding MySQL Triggers: Exploring How Triggers Impact MySQL Memory Allocation https://www.percona.com/blog/how-triggers-may-significantly-affect-the-amount-of-memory-allocated-to-your-mysql-server/ Wed, 13 Sep 2023 12:05:29 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: kclee https://www.percona.com/blog/how-triggers-may-significantly-affect-the-amount-of-memory-allocated-to-your-mysql-server/#comment-10973721 Thu, 18 Aug 2022 03:14:16 +0000 https://www.percona.com/blog/?p=78927#comment-10973721 SP also increases “memory/sql/sp_head::main_mem_root”.

]]> By: Sveta Smirnova https://www.percona.com/blog/how-triggers-may-significantly-affect-the-amount-of-memory-allocated-to-your-mysql-server/#comment-10973427 Mon, 06 Dec 2021 12:21:02 +0000 https://www.percona.com/blog/?p=78927#comment-10973427 This is a linear list. Check High Level Architecture tab at https://dev.mysql.com/worklog/task/?id=9703 too

]]> By: Ross https://www.percona.com/blog/how-triggers-may-significantly-affect-the-amount-of-memory-allocated-to-your-mysql-server/#comment-10973425 Fri, 03 Dec 2021 13:11:31 +0000 https://www.percona.com/blog/?p=78927#comment-10973425 Deep! This is the kind of post that makes Percona stand alone in database support.

How do processes find the table descriptors in the table open cache? Is it hashed or otherwise indexed? Or is a simple linear list scan? (Yikes!)

Reason for asking: in cases with many many tables and very large table open caches doesn’t “marching the table open list“ add processing time as well as memory space?

]]> By: svetsmirnova https://www.percona.com/blog/how-triggers-may-significantly-affect-the-amount-of-memory-allocated-to-your-mysql-server/#comment-10973417 Fri, 26 Nov 2021 21:25:46 +0000 https://www.percona.com/blog/?p=78927#comment-10973417 You can call stored procedures from triggers. There is nothing wrong with it. But I doubt it will reduce size of the sp cache.

]]> By: fred blouin https://www.percona.com/blog/how-triggers-may-significantly-affect-the-amount-of-memory-allocated-to-your-mysql-server/#comment-10973415 Fri, 26 Nov 2021 14:22:57 +0000 https://www.percona.com/blog/?p=78927#comment-10973415 Is it a good practice to call stored procedures in triggers to reduce the size of it?

]]> By: Oli Sennhauser https://www.percona.com/blog/how-triggers-may-significantly-affect-the-amount-of-memory-allocated-to-your-mysql-server/#comment-10973400 Fri, 19 Nov 2021 09:03:12 +0000 https://www.percona.com/blog/?p=78927#comment-10973400 Thanks Sveta, some interesting answers to questions I did not find the time yet to investigate on…

]]>