Hello,
On Sep/25/2008, Ananda Kumar wrote:
> On the new machine its on a different partition than the database.
>
> Also did u try to analyze the table and run the query
I will do it (maybe on Saturday, as I guess that will take long time to
do it). But I think that I did last weekend when I mo
On the new machine its on a different partition than the database.
Also did u try to analyze the table and run the query
On 9/25/08, Carles Pina i Estany <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
>
> On Sep/25/2008, Ananda Kumar wrote:
> > is /tmpdir parameter on both machines using the default va
Hello,
On Sep/25/2008, Ananda Kumar wrote:
> does it have the same network speed as your old server.
yes, it has. But I'm running the query from localhost :-) (socket
connection). Even, the query only returns one number and I don't have
any federated tables, etc.
>
> On 9/25/08, Carles Pina i
Hello,
On Sep/25/2008, Ananda Kumar wrote:
> is /tmpdir parameter on both machines using the default value
Old machine: yes.
New machine: I have tried two places (different partitions, same FS
-ext3-, same hard disk). On the old machine it's in a different
partition of the same hard disk than t
is /tmpdir parameter on both machines using the default value
On 9/25/08, Carles Pina i Estany <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
>
> On Sep/25/2008, Ananda Kumar wrote:
> > does it have the same network speed as your old server.
>
> yes, it has. But I'm running the query from localhost :-) (
does it have the same network speed as your old server.
On 9/25/08, Carles Pina i Estany <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
>
> On Sep/24/2008, Phil wrote:
> > Just a wild guess but, did you perhaps change the filesystem to a
> > journalling filsystem when moving to the different server?
>
>
Hello,
On Sep/24/2008, Phil wrote:
> Just a wild guess but, did you perhaps change the filesystem to a
> journalling filsystem when moving to the different server?
mount reports the same (ext3)
> I once accidently moved my database from an ext2 to an ext3 partition and it
> took me a while to f
Just a wild guess but, did you perhaps change the filesystem to a
journalling filsystem when moving to the different server?
I once accidently moved my database from an ext2 to an ext3 partition and it
took me a while to figure out the degradation of queries..
Phil
On Wed, Sep 24, 2008 at 6:16 P