Hi,
Here, threads_connected is considerable and below the preset value.
The threads_connected and threads_running are the good indicators to see how
loaded the server is. In your case it is good numbers.
So use 'iostat'/relavant utility to monitor the DB activity.
Also threads_created is mor
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
