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:
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set =utf8
[mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0
[mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking bind-address = 127.0.0.1 key_buffer = 16M max_allowed_packet = 256K thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M log_error = /var/log/mysql/error.log expire_logs_days = 10 max_binlog_size = 100M
collation-server = utf8_unicode_ci init-connect ='SET NAMES utf8' character-set-server = utf8
[mysqldump] quick quote-names max_allowed_packet = 16M
[mysql] default-character-set = utf8
[isamchk] key_buffer = 16M
!includedir /etc/mysql/conf.d/
Any idea?
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:
- Installing tables.sql
- Executing a script to disable foreign key checks
- 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
xmldatadumps-l@lists.wikimedia.org