fsck can prompt mysql to create tmp_disk_tables via file_to_queue

GoogleCodeExporter commented 8 years ago

Repro steps :
-------------

1. set max_heap_table_size and tmp_table_size relatively small
2. Start a mogile FSCK
3. notice that mogilefs sometimes creates tmp_disk_tables while selecting 
against file_to_queue. also notice that your database master performance has 
just dropped off a cliff as it appears to then do a full table scan of this 
temp disk table.

Expected/Actual behavior?
-------------------------
expected :

Awesomely indexed queries which magically never result in a tmp_disk_table on a 
typical database.

actual :

queries which result in tmp_disk_tables.

What version of the product are you using? On what operating system?
--------------------------------------------------------------------
2.44 on debian Lenny.

Original issue reported on code.google.com by robert.d...@gmail.com on 15 Dec 2010 at 12:55

GoogleCodeExporter commented 8 years ago

Just adding a note that I ran a 100m+ file fsck and wasn't able to reproduce 
this so far. More work is necessary.

Original comment by dorma...@rydia.net on 24 Dec 2010 at 12:48

GoogleCodeExporter commented 8 years ago

well... we've never been able to reproduce this. If anyone ever can, we'll look 
at it again. Sorry, robert! Thanks for the report. We were hammering on the 
fsck code quite a lot during the 2.61 series and it never came up.

Original comment by dorma...@rydia.net on 20 Jun 2012 at 12:52

Changed state: Invalid

GoogleCodeExporter commented 8 years ago

More than good enough for me. Hope commenting on here does not re-open this 
ticket. :)

Original comment by rc...@palominodb.com on 22 Jun 2012 at 8:14

glyustb / mogilefs

fsck can prompt mysql to create tmp_disk_tables via file_to_queue #29