SQLStats is a MySQL 5.5 plugin that allows MySQL SQL Statement
monitoring in "real time", without any Proxies, source code
modifications, different connectors or anything. Read more on my blog here:
http://karlssonondatabases.blogspot.com/2010/11/monitoring-mysql-sql-statement-way-it.html
The p
On Tue, Nov 23, 2010 at 7:55 PM, Jerry Schwartz wrote:
> >IIRC, "localhost" is seen by the client as a magic word to mean "use the
> >UNIX socket, not 127.0.0.1".
> >
> [JS] IF it is enabled in my.cnf.
>
Hmm, didn't know that bit. What's the option called ?
--
Bier met grenadyn
Is als mosterd
>-Original Message-
>From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
>Meersman
>Sent: Tuesday, November 23, 2010 6:19 AM
>To: Brent Clark
>Cc: mysql mailing list
>Subject: Re: localhost vs domain for connection string
>
>IIRC, "localhost" is seen by the client as
Hi All
Maybe someone can help me with this one.
We have set the table_cache to 1024, however the open tables
value stays 64 of 64.
Everything I checked stated that the open tables is related to
the table_cache variable.
Can someone please assist on why the value i
> From: Brent Clark
>
> Is there a difference if someone had to make the connection string the a
> domain (hosts file entry makes the machine look at its ip) as opposed to just
> using localhost.
> If so would a performance hit be incurred?
Using 'localhost' will always be faster, although per
IIRC, "localhost" is seen by the client as a magic word to mean "use the
UNIX socket, not 127.0.0.1".
So, yes, that would make the connection not show up in netstat :-)
On Tue, Nov 23, 2010 at 11:11 AM, Brent Clark wrote:
> Hiya
>
> Is there a difference if someone had to make the connection str
Hiya
Is there a difference if someone had to make the connection string the a
domain (hosts file entry makes the machine look at its ip) as opposed to
just using localhost.
If so would a performance hit be incurred?
I have this client that has used the domain and in netstat im seeing
all th
