Comments on: Who is hogging my MySQL connections? https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections Blog by Shlomi Noach Tue, 26 Jun 2012 04:53:05 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections/comment-page-1#comment-103111 Tue, 26 Jun 2012 04:53:05 +0000 https://shlomi-noach.github.io/blog/?p=4977#comment-103111 @Rick,
As do I; but the aforementioned connections were not idle. Due to some bug they continuously pinged the server.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections/comment-page-1#comment-103110 Tue, 26 Jun 2012 04:52:03 +0000 https://shlomi-noach.github.io/blog/?p=4977#comment-103110 @Ike,
Cool. Yes, I completely forgot about it!

]]> By: Rick James https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections/comment-page-1#comment-103079 Tue, 26 Jun 2012 00:28:26 +0000 https://shlomi-noach.github.io/blog/?p=4977#comment-103079 I like to keep @@global.wait_timeout low enough so that those connections that fail to disconnected get booted.

Also, if Apache is involved, I like to keep MaxClients at a reasonable level. Note: You need to have ((#apaches) * MaxClients) < ((#slaves) * max_connections)

]]> By: Ike Walker https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections/comment-page-1#comment-103021 Mon, 25 Jun 2012 19:21:32 +0000 https://shlomi-noach.github.io/blog/?p=4977#comment-103021 @shlomi, regarding your desire for “killing of processes using user name / host name / combination / regex”, you can probably do that with pt-kill using the –match-user and –match-host options.

]]> By: Log Buffer #275, A Carnival of the Vanities for DBAs | The Pythian Blog https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections/comment-page-1#comment-102202 Fri, 22 Jun 2012 08:01:55 +0000 https://shlomi-noach.github.io/blog/?p=4977#comment-102202 […] Shlomi Noach is blogging about a real world experience about MySQL connections. […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections/comment-page-1#comment-102002 Thu, 21 Jun 2012 16:06:31 +0000 https://shlomi-noach.github.io/blog/?p=4977#comment-102002 @Sinisa,
You’re absolutely right about this. With InnoDB Plugin + I_S plugins enables this is solvable. May integrate this onto common_schema.

@Justin,
Very cool. pt-mysql-summary is a very useful tool.

]]> By: Justin Swanhart https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections/comment-page-1#comment-102000 Thu, 21 Jun 2012 16:00:51 +0000 https://shlomi-noach.github.io/blog/?p=4977#comment-102000 pt-mysql-summary can also display this information.

]]> By: Sinisa Milivojevic https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections/comment-page-1#comment-101990 Thu, 21 Jun 2012 15:33:17 +0000 https://shlomi-noach.github.io/blog/?p=4977#comment-101990 @schlomi

I personally have a small problem with sleeping connections.

A connection can be sleeping while still running a non-committed transaction. Yet another column can be invented, like “Total of active transactions”, but I do not think it would help much.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections/comment-page-1#comment-101900 Thu, 21 Jun 2012 08:32:52 +0000 https://shlomi-noach.github.io/blog/?p=4977#comment-101900 @Marc,

Taking this chance to throw in a suggestion: add a “active_connections” columns to indicate the numebr of connections not sleeping, for the “accounts”, “hosts”, “users” tables.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/who-is-hogging-my-mysql-connections/comment-page-1#comment-101899 Thu, 21 Jun 2012 08:29:08 +0000 https://shlomi-noach.github.io/blog/?p=4977#comment-101899 Marc, cool! Wasn’t aware of this table in 5.6

Of course, a few years will pass before everyone is updated with a MySQL 5.6 server.

Keep up the good work

]]>