Taras Onishchuk, Author at Percona Database Performance Blog Fri, 19 Apr 2024 13:46:56 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png Taras Onishchuk, Author at Percona Database Performance Blog 32 32 76301791 Did MyDumper LIKE Triggers? https://www.percona.com/blog/did-mydumper-like-triggers/ https://www.percona.com/blog/did-mydumper-like-triggers/#respond Fri, 19 Apr 2024 13:46:56 +0000 https://www.percona.com/blog/?p=95924 Yes, but now it likes them more, and here is why.IntroUsing the LIKE clause to filter triggers or views from a specific table is common. However, it can play a trick on you, especially if you don’t get to see the output (i.e., in a non-interactive session). Let’s take a look at a simple example […]]]> https://www.percona.com/blog/did-mydumper-like-triggers/feed/ 0 95924 Update Percona Monitoring and Management Agent Settings for Already-Added Instances https://www.percona.com/blog/update-percona-monitoring-and-management-agent-settings-for-already-added-instances/ https://www.percona.com/blog/update-percona-monitoring-and-management-agent-settings-for-already-added-instances/#respond Wed, 19 Jul 2023 13:02:03 +0000 https://www.percona.com/blog/?p=89373 When adding a remote MySQL instance to Percona Monitoring and Management (PMM), there are a few options you can specify during the setup, but they are not editable once added. For example, a table statistics limit is introduced to avoid querying information_schema.tables that may impact DB performance, especially with a high number of DBs / […]]]> https://www.percona.com/blog/update-percona-monitoring-and-management-agent-settings-for-already-added-instances/feed/ 0 89373 Diagnosing and Fixing “MySQL Server Has Gone Away” Messages https://www.percona.com/blog/diagnosing-and-fixing-mysql-server-has-gone-away-messages/ https://www.percona.com/blog/diagnosing-and-fixing-mysql-server-has-gone-away-messages/#comments Fri, 25 Sep 2020 18:13:51 +0000 https://www.percona.com/blog/?p=71106 We all like when error messages are descriptive and give a clear idea about what is happening; however, there are some cases when a few possible reasons lay behind one error message. “MySQL server has gone away” is one of them. Most of the cases when the error occurs are described in MySQL documentation, but […]]]> https://www.percona.com/blog/diagnosing-and-fixing-mysql-server-has-gone-away-messages/feed/ 3 71106