Thanks Gavin. Rewriting the query to not use the subselect solved the problem!
On Tue, Dec 7, 2010 at 11:33 AM, Gavin Towey wrote:
> Mysql often handles subqueries poorly. It's best to rewrite that as a JOIN
> instead:
>
> http://dev.mysql.com/doc/refman/5.1/en/rewriting-subqueries.html
>
> If
" intermittent connection problems (error 2013)"
Look at SHOW PROCESSLIST; when you're having a connection problem. If you see
lots of "unathenticated user" in the list, then it means you're having DNS
problems.
Typically the best way to handle this is to set skip-name-resolve, and using ip
Mysql often handles subqueries poorly. It's best to rewrite that as a JOIN
instead:
http://dev.mysql.com/doc/refman/5.1/en/rewriting-subqueries.html
If you have further questions after doing that, show the table structures, the
query, and the explain output.
-Original Message-
From: A
Basically, I'm doing a:
select FROM Database1.table1 WHERE indexed_field IN (Select
field from Database2.table2, );
It's taking about 40sec to execute where table1 (InnoDB) only has
about 33k records and my subselect is returning about 600 records.
Explain shows that it's doing a type=ALL a
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
if you dont specify it it will listen to all interfaces,
and it is the standard option.
you dont break anything.
Claudio
2010/12/7 Machiel Richards
> what will the effect be if we disable this option in the config file by
> means of hashing out the option?
>
> will it break the database or
what will the effect be if we disable this option in the config file by
means of hashing out the option?
will it break the database or just listen on any device?
-Original Message-
From: Claudio Nanni
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Bind-address use?
Date: Tue,
Hi,
You may have multiple interfaces and each multiple ips (private or public).
With bind-address you force mysql to listen to a specific ip address instead
of any. In case you have both public and private ips, binding to the
private, for example, prevents from connections from the internet.
Just k
Hi All
I am unable to find an answer on what the bind-address in
mysql-5.1 actually does.
From the config file it says that it provides the same function
as the previous skip-networking function.
However, let's say I configure the bind-adress value to the IP
of the machin
