MySQL Forums :: InnoDB :: COMMIT function take too much time to respond
Re: COMMIT function take too much time to respond
Posted by: Rick James ()
Date: April 10, 2011 04:11PM
The UPDATE statement is chopped off, so it is hard to say what is going on.
Also, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
and surround them with [ code ] and [ / code ]
How much RAM do you have?
Also, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
and surround them with [ code ] and [ / code ]
How much RAM do you have?
| Subject | Views | Written By | Posted |
|---|---|---|---|
| COMMIT function take too much time to respond | 2043 | He Ha | 04/09/2011 02:35AM |
| Re: COMMIT function take too much time to respond | 662 | Rick James | 04/10/2011 04:11PM |
| Re: COMMIT function take too much time to respond | 622 | He Ha | 04/10/2011 08:09PM |
| Re: COMMIT function take too much time to respond | 606 | Rick James | 04/10/2011 10:15PM |
| Re: COMMIT function take too much time to respond | 938 | He Ha | 04/10/2011 10:23PM |
| Re: COMMIT function take too much time to respond | 744 | Rick James | 04/11/2011 09:41PM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.