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
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
, 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
[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
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
, 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
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
, 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
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
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
10 matches
Mail list logo