Den 23-08-2013 00:54, A B skrev:
I'm trying to install enwiki-20130503-page.sql
into an empty database and the process is too slow (it takes days), so I think it
isn't normal. What I do is:
1. Installing tables.sql
2. Executing a script to disable foreign key checks
3. Installing enwiki-20130503-page.sq (mysql -u <usr> -p<pwd> enwiki <
enwiki-20130503-page.sql &).
I don't know if the problem can be my MySQL configuration:
Any idea?
I don't know about the configuration, but I would first read all rows
into a table without any keys at all, and then create the keys I need
afterwards. It is much faster to do the necessary sorting once instead
of updating the keys for each inserted row. It is not enough to an
"alter table page disable keys" because unique keys will still be
updated and checked for uniqueness at each inserted row.
Regards,
- Byrial