can u please do show full processlist when the update is happening, and
if its innodb
please do SHOW INNODB STATUS, which will give complete activity on innodb
engine, including lock information.
Please show use the output of these.
regards
anandkl
On 11/27/08, David Scott [EMAIL PROTECTED]
show full processlist
userX is the user the site is using to connect
databaseX is the database in question
1976156, 'userX', 'localhost', 'databaseX', 'Sleep', 13, '', ''
13508974, 'dave', 'IPX:29212', 'databaseX', 'Sleep', 0, '', ''
13759139, 'sen', '1 IPX:32775', '', 'Sleep', 160, '', ''
Hi David,
can you please let me know what is the select query and the update query
along with the explain plan of the same.
can you please let me know if you are using innodb storage engine?
Regards,
Chandru
www.mafiree.com
On Thu, Nov 27, 2008 at 4:45 PM, David Scott
[EMAIL
Hi list.We have 2 tables, both have a few inserts, many updates and the
occasional select.
When running a select joining the 2 tables (which can take upto 20 seconds
to complete, they are large tables) all updates are blocked and the
maxconnections is quickly reached.
We tried copying the data to
Thanks for the improved query.The indexing didn't help much and still the
main problem is it locking all updates to the tables while it executes...
even if I am executing it on a copy of the tables in a different database
--
Dave
2008/11/27 Chandru [EMAIL PROTECTED]
Hi David,
please create