Re: improve performance of this sql

2008-06-26 Thread Ananda Kumar
on db , but when any insert or LOAD DATA Index creation happens it takes close to 80 sec. Any ways to improve the performance of this sql

Re: improve performance of this sql

2008-06-23 Thread Ananda Kumar
activity on db , but when any insert or LOAD DATA Index creation happens it takes close to 80 sec. Any ways to improve the performance of this sql. innodb_buffer=11GB , key_buffer=3 GB, we have totally 16GB EXPLAIN select * from (select A.LEAF_CATEG_ID, A.CLUSTER_ID, A.SIGNATURE

Re: improve performance of this sql

2008-06-23 Thread Jocelyn Fournier
, 2008 at 1:57 PM, Ananda Kumar [EMAIL PROTECTED] wrote: The below query performance in 10 sec when there are no other activity on db , but when any insert or LOAD DATA Index creation happens it takes close to 80 sec. Any ways to improve the performance of this sql. innodb_buffer=11GB , key_buffer=3

Re: improve performance of this sql

2008-06-23 Thread Ananda Kumar
[EMAIL PROTECTED] wrote: The below query performance in 10 sec when there are no other activity on db , but when any insert or LOAD DATA Index creation happens it takes close to 80 sec. Any ways to improve the performance of this sql. innodb_buffer=11GB , key_buffer=3 GB, we have totally 16GB

Re: improve performance of this sql

2008-06-23 Thread Jocelyn Fournier
in 10 sec when there are no other activity on db , but when any insert or LOAD DATA Index creation happens it takes close to 80 sec. Any ways to improve the performance of this sql

Re: improve performance of this sql

2008-06-23 Thread Ananda Kumar
, but when any insert or LOAD DATA Index creation happens it takes close to 80 sec. Any ways to improve the performance of this sql. innodb_buffer=11GB , key_buffer=3 GB, we have totally 16GB EXPLAIN select * from

Re: improve performance of this sql

2008-06-23 Thread Jocelyn Fournier
to 80 sec. Any ways to improve the performance of this sql. innodb_buffer=11GB , key_buffer=3 GB, we have totally 16GB EXPLAIN select * from (select A.LEAF_CATEG_ID

Re: improve performance of this sql

2008-06-23 Thread Ananda Kumar
, but when any insert or LOAD DATA Index creation happens it takes close to 80 sec. Any ways to improve the performance of this sql. innodb_buffer=11GB , key_buffer=3 GB, we have

Re: improve performance of this sql

2008-06-21 Thread Moon's Father
to 80 sec. Any ways to improve the performance of this sql. innodb_buffer=11GB , key_buffer=3 GB, we have totally 16GB EXPLAIN select * from (select A.LEAF_CATEG_ID, A.CLUSTER_ID, A.SIGNATURE, A.IS_NULL, A.HEIGHT, A.NO_LISTINGS, A.NO_SUCC_LISTINGS, A.TOTAL_QTY,A.SOLD_QTY, A.ASP, A.NO_BIDS

improve performance of this sql

2008-06-20 Thread Ananda Kumar
The below query performance in 10 sec when there are no other activity on db , but when any insert or LOAD DATA Index creation happens it takes close to 80 sec. Any ways to improve the performance of this sql. innodb_buffer=11GB , key_buffer=3 GB, we have totally 16GB EXPLAIN select * from