Добрый день.
Переношу данные
from: Percona-Server-server-55-5.5.45-rel37.4.el5
to: MariaDB-server-10.3.10-1.el7.centos.x86_64
Выгружаю через mysqldump -B $db --add-locks
загружаю через mysql < $db.sql
Во время загрузки MariaDB перезапускается, на одной и той же таблице, причём в этой таблице оказывается всё время разное количество записей.
В логе MariaDB никаких наводок.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
2019-01-17 14:35:49 0 [Note] InnoDB: Using Linux native AIO
2019-01-17 14:35:49 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-17 14:35:49 0 [Note] InnoDB: Uses event mutexes
2019-01-17 14:35:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2019-01-17 14:35:49 0 [Note] InnoDB: Number of pools: 1
2019-01-17 14:35:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-01-17 14:35:49 0 [Note] InnoDB: Initializing buffer pool, total size = 24G, instances = 24, chunk size = 128M
2019-01-17 14:35:49 0 [Note] InnoDB: Completed initialization of buffer pool
2019-01-17 14:35:49 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-01-17 14:35:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=15775185544
2019-01-17 14:36:04 0 [Note] InnoDB: To recover: 27323 pages from log
2019-01-17 14:36:04 0 [Note] InnoDB: Transaction 12751 was in the XA prepared state.
2019-01-17 14:36:04 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
2019-01-17 14:36:04 0 [Note] InnoDB: Trx id counter is 12756
2019-01-17 14:36:04 0 [Note] InnoDB: Starting final batch to recover 27289 pages from redo log.
2019-01-17 14:36:18 0 [Note] InnoDB: Last binlog file '/srv/mysql/mysql-bin.000007', position 404442530
2019-01-17 14:36:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-01-17 14:36:21 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
2019-01-17 14:36:21 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2019-01-17 14:36:21 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-01-17 14:36:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-01-17 14:36:21 0 [Note] InnoDB: Setting file '/srv/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-01-17 14:36:21 0 [Note] InnoDB: File '/srv/mysql/ibtmp1' size is now 12 MB.
2019-01-17 14:36:21 0 [Note] InnoDB: Waiting for purge to start
Last message repeated 2 time(s)
2019-01-17 14:36:21 0 [Note] InnoDB: 10.3.10 started; log sequence number 15788221641; transaction id 12758
2019-01-17 14:36:21 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mysql/ib_buffer_pool
2019-01-17 14:36:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-01-17 14:36:21 0 [Note] InnoDB: Buffer pool(s) load completed at 190117 14:36:21
2019-01-17 14:36:21 0 [Note] Recovering after a crash using /srv/mysql/mysql-bin
2019-01-17 14:36:25 0 [Note] Starting crash recovery...
2019-01-17 14:36:25 0 [Note] InnoDB: Starting recovery for XA transactions...
2019-01-17 14:36:25 0 [Note] InnoDB: Transaction 12751 in prepared state after recovery
2019-01-17 14:36:25 0 [Note] InnoDB: Transaction contains changes to 18834 rows
2019-01-17 14:36:25 0 [Note] InnoDB: 1 transactions in prepared state after recovery
2019-01-17 14:36:25 0 [Note] Found 1 prepared transaction(s) in InnoDB
2019-01-17 14:36:25 0 [Note] Crash recovery finished.
2019-01-17 14:36:25 0 [Note] Server socket created on IP: '::'.
2019-01-17 14:36:26 0 [Note] Reading of all Master_info entries succeded
2019-01-17 14:36:26 0 [Note] Added new Master_info '' to hash table
2019-01-17 14:36:26 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.10-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
Конфиг MariaDB (в основном скопирован с сервера-источника):
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
[mysqld]
datadir = /srv/mysql
log-error = sed-db01.err
skip-name-resolve
back_log = 75
max_connections = 80
max_user_connections = 75
table_open_cache = 1800
thread_cache_size = 100
tmp_table_size = 33554432
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 1000
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072
long_query_time = 0
collation_server = koi8r_general_ci
character_set_server = koi8r
performance_schema = ON
innodb_data_home_dir = /srv/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_file_per_table
innodb_log_group_home_dir = /srv/mysql/
innodb_buffer_pool_size = 24G
innodb_log_file_size = 3G
innodb_buffer_pool_instances = 24
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_flush_method = O_DIRECT
innodb_stats_on_metadata = 0
server-id = 111
binlog-format = MIXED
log-bin = /srv/mysql/mysql-bin
log-bin-index = /srv/mysql/mysql-bin.index
expire_logs_days = 10
sync_binlog = 1
binlog_cache_size = 1M
[mariadb]
aria-pagecache-buffer-size = 100M
aria-encrypt-tables
encrypt-binlog
encrypt-tmp-disk-tables
encrypt-tmp-files
loose-innodb-encrypt-log
loose-innodb-encrypt-tables
[mariadb-10.3]
sql-mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
