om:* Rob Wultsch [mailto:wult...@gmail.com]
> *Sent:* 02 July 2010 10:46 AM
>
> *To:* Machiel Richards
> *Cc:* mysql@lists.mysql.com
> *Subject:* Re: Mysql connections not released
>
>
>
> A bad assumption I make these days is that everyone has skip resolve off.
> If th
RDC_Logo
From: Rob Wultsch [mailto:wult...@gmail.com]
Sent: 02 July 2010 10:46 AM
To: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Mysql connections not released
A bad assumption I make these days is that everyone has skip resolve off. If
that is the case DNS issues will not impac
hy and how to resolve this.
>
>
>
>
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>
> *From:* Rob Wultsch [mailto:wult...@gmail.com]
> *Sent:* 02 July 2010 9:42 AM
> *To:* Mac
o: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Mysql connections not released
On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards
wrote:
Good morning all
A few days ago i posted some questions relating to mysql
threads running out and not being able to restart th
On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards wrote:
> Good morning all
>
>
>
> A few days ago i posted some questions relating to mysql
> threads running out and not being able to restart the database.
>
>
>
> We had the same again this morning however this ti
My first guess would be that you have a MyISAM table that gets hit with a long running query which locks the table. When that
happens, all other queries start queueing up and connections will rise as new queries come in. Once the long running query finishes,
all the other queued queries run and f
Erich,
You need to create special "root" or "superuser" account so that you can connect
from your PC. This will allow you full access from DBtools. This is what I had
to do in order to make the connection. You'll need to log in as the 'root' or
'superuser' to execute your mysql client.
%>mysql g
