MySQL Forums :: Performance :: Hanging on copying to tmp table
Re: Hanging on copying to tmp table
Posted by: Brian Dalby ()
Date: April 26, 2012 12:35AM
It is not stalling for a few seconds, it will stall for minutes, usually I find out quite fast, but I have seen queries hanging for more than 15 minutes.
Other databases on the same server would work fine, but that specific table would hang in every request when it happens.
As I understand Percona XtraDB would be a complete replacement for MySQL ?
Other databases on the same server would work fine, but that specific table would hang in every request when it happens.
As I understand Percona XtraDB would be a complete replacement for MySQL ?
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Hanging on copying to tmp table | 1972 | Brian Dalby | 04/23/2012 06:55AM |
| Re: Hanging on copying to tmp table | 1264 | Rick James | 04/24/2012 10:16AM |
| Re: Hanging on copying to tmp table | 937 | Brian Dalby | 04/24/2012 02:44PM |
| Re: Hanging on copying to tmp table | 947 | Brian Dalby | 04/25/2012 01:08PM |
| Re: Hanging on copying to tmp table | 865 | Rick James | 04/25/2012 08:43PM |
| Re: Hanging on copying to tmp table | 945 | Brian Dalby | 04/26/2012 12:35AM |
| Re: Hanging on copying to tmp table | 1097 | Brian Dalby | 04/26/2012 02:17AM |
| Re: Hanging on copying to tmp table | 915 | Seweryn Ożóg | 04/26/2012 03:28PM |
| Re: Hanging on copying to tmp table | 721 | Brian Dalby | 04/27/2012 07:02AM |
| Re: Hanging on copying to tmp table | 836 | Rick James | 04/28/2012 01:37PM |
| Re: Hanging on copying to tmp table | 882 | Brian Dalby | 04/28/2012 02:00PM |
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.
© 2013, Oracle Corporation and/or its affiliates