List:General Discussion« Previous MessageNext Message »
From:Nihal Date:November 5 2003 9:14pm
Subject:INNODB flush holdup
View as plain text  
OK, I've got another quandary, thanks for the help on the last one, I'm
working on it.

| 15203 | root   | web:36810     | ez2000 | Query   | 137  | Sorting
result    | SELECT from table_a |
| 15235 | root   | web:36849     | ez2000 | Query   | 67   | Sorting
result    | SELECT from table_a |
| 15244 | root   | db:32779      | NULL   | Refresh | 42   | Flushing
tables   | NULL                |
| 15246 | root   | runque1:3220  | ez2000 | Query   | 40   | Waiting for
table | insert into table_a |
| 15247 | root   | runque1:3221  | ez2000 | Sleep   | 2    |
| NULL
|
| 15250 | root   | web:36863     | ez2000 | Query   | 34   | Waiting for
table | SELECT from table_a |
| 15251 | root   | web:36864     | ez2000 | Query   | 34   | Waiting for
table | select from table_b |

What would cause the flush tables to take so long?
Have I made my log files to large?
Does the flush lock all queries until complete?
And do any prior queries have to finish before it will start?

Sorry, I'm new to INNODB, thanks in advance for the help.





Thread
INNODB flush holdupNihal5 Nov
  • Re: INNODB flush holdupMatt W6 Nov
    • RE: INNODB flush holdupNihal6 Nov
      • Re: INNODB flush holdupJeremy Zawodny6 Nov
        • RE: INNODB flush holdupNihal6 Nov
        • Table CreationArnoldus Th.J. Koeleman6 Nov
          • Re: Table CreationChris Boget6 Nov
          • Re: Table CreationDan Nelson6 Nov
          • Simple question about updating a table fieldAdmin-Stress6 Nov
            • Re: Simple question about updating a table fieldgerald_clark6 Nov