mysql import stuck in "Repair with keycache" state

[Radityo Eko Prasojo]

I am stuck when trying to import the data files into mysql database. I checked the process list and found out that the import of "page_inlinks.txt" is stuck in the "Repair with keycache" state for 22 hours and counting.

mysql> show processlist;

+----+---------+-----------+---------+---------+-------+----------------------+------------------------------------------------------------------------------------------------------+

| Id | User    | Host      | db      | Command | Time  | State                | Info                                                                                                 |

+----+---------+-----------+---------+---------+-------+----------------------+------------------------------------------------------------------------------------------------------+

| 87 | unibase | localhost | unibase | Query   | 80583 | Repair with keycache | LOAD DATA  LOCAL INFILE '/data/unibase/test/source/output/page_inlinks.txt' INTO TABLE `page_inlinks |

| 90 | unibase | localhost | unibase | Query   |     0 | NULL                 | show processlist                                                                                     |

+----+---------+-----------+---------+---------+-------+----------------------+------------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

The size of the table also apparently does not change during this state (the page_inlinks stay 0).

I am no mysql expert so I don't know how or why that happens. Any hint or help to solve this would be much appreciated!

[Oliver Ferschke]

How much disk space does your mysql server have access to?

Repair with keycache usually only happens if the server doesn't have enough temporary disk space.

Here's a good explanation:

https://stackoverflow.com/questions/1067367/how-to-avoid-repair-with-keycache

--
You received this message because you are subscribed to the Google Groups "jwpl-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jwpl+uns...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Radityo Eko Prasojo]

Thanks for your reply! Now I understand the problem.

How much disk space does your mysql server have access to?

I do not know, I need to ask the admins.

Do you know how much temporary disk space do I need for this importing process? If I want to request an increase, I need to know an approximate number that would be necessary.

[Radityo Eko Prasojo]

I made it  work by migrating my mysql database into a bigger partition of the disk.

Thank you Oliver for the hint!