Query hangs on one server, but not the other

I have the following query

Select distinct subscriberidx from
subscriber_emailcategories where emailcategory in (select
emailcategory from subscriber_emailcategories where
emailcategory in ('fh','si','wh','','',''))

Now on our one server, this query just hangs, on another
server, with an identical database schema, it returns
results instantly.

Any ideas what I can start looking for?
____________________________________________________________ __
http://www.webmail.co.za the South African FREE email service

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Query hangs on one server, but not the other

Hi Tim,

Sorry, but these two questions are not related.

This it not a network thing, it only started doing this on
our one server the other day...

On Thu, 17 Mar 2005 11:23:20 +0000
Tim.Lloyd@biomni.com wrote:
> If you haven't got a DNS server on your network, Mysql
> will hopping out
> onto the internet assigned DNS address - if the
> connection goes down it
> can't (attempt to) resolve client ip's to hostnames - try
> starting the
> mysql server with '--skip-name-resolve'.
>
>
>
> -----Original Message-----
> From: Greg Quinn [mailto:gregquinn@webmail.co.za]
> Sent: 17 March 2005 11:19
> To: win32@lists.mysql.com
> Subject: Query hangs on one server, but not the other
>
> I have the following query
>
> Select distinct subscriberidx from
> subscriber_emailcategories where emailcategory in (select
> emailcategory
> from subscriber_emailcategories where emailcategory in
> ('fh','si','wh','','',''))
>
> Now on our one server, this query just hangs, on another
> server, with an
> identical database schema, it returns results instantly.
>
> Any ideas what I can start looking for?
>
____________________________________________________________ __
> http://www.webmail.co.za the South African FREE email
> service
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=tim.lloyd@biomni.com
>

____________________________________________________________ __
http://www.webmail.co.za the South African FREE email service

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Query hangs on one server, but not the other

Why don't you write your query as

Select distinct subscriberidx from
subscriber_emailcategories where=20
emailcategory in ('fh','si','wh','')

As far as I can see this is equivalent to what you have written and is
much simpler.

John Bonnett

-----Original Message-----
From: Greg Quinn [mailto:gregquinn@webmail.co.za]=20
Sent: Thursday, 17 March 2005 9:49 PM
To: win32@lists.mysql.com
Subject: Query hangs on one server, but not the other

I have the following query

Select distinct subscriberidx from
subscriber_emailcategories where emailcategory in (select
emailcategory from subscriber_emailcategories where
emailcategory in ('fh','si','wh','','',''))=20

Now on our one server, this query just hangs, on another
server, with an identical database schema, it returns
results instantly.

Any ideas what I can start looking for?
____________________________________________________________ __
http://www.webmail.co.za the South African FREE email service

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org