D]>
To:
Sent: Tuesday, January 23, 2007 11:59 AM
Subject: Urgent - MySQL 5 - mysqld using a lot of memory consistently
Hello all,
Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are
taking a lot of time to execute in the newer version. The queries which were
executing within 1
ype: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: tallydb.TFMM.FLD_ASSIGNED_TO
rows: 1
Extra: NULL
*** row 3 ***
table: TFMOT
type: ref
possible_keys: FLD_MSG_
: FLD_MSG_ID
key_len: 4
ref: tallydb.TFMM.FLD_MSG_ID
rows: 1
Extra: Using where
- Original Message -
*From:* Alex Arul <[EMAIL PROTECTED]>
*To:* Ratheesh K J <[EMAIL PROTECTED]>
*Sent:* Tuesday, January 23, 2007 11:57 AM
*Subject:*
age -
From: Alex Arul
To: Ratheesh K J
Sent: Tuesday, January 23, 2007 11:57 AM
Subject: Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently
you threads connected is 38 but your thread cache has only 8. So please do
bump it up. Also generate explain plan on both versio
Hello all,
Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are taking
a lot of time to execute in the newer version. The queries which were executing
within 10 secs are now taking more than 100 secs.
Running an expalin on the queries showed that an index_merge optimization i