mysqldump
.
.dump
通过运行
mysql-uroot moodle<moodle.dump——冗长
它跑了几秒钟就卡住了。当我检查时
mysql_error.log
2018-06-27 11:14:36 5000 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2018-06-27 11:18:33 5124 [Warning] InnoDB: A long semaphore wait:
--Thread 5200 has waited at ibuf0ibuf.cc line 4403 for 241.00 seconds the semaphore:
Mutex at 00C3C3F0, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
2018-06-27 11:18:33 5124 [Warning] InnoDB: A long semaphore wait:
--Thread 4212 has waited at ibuf0ibuf.cc line 4403 for 241.00 seconds the semaphore:
Mutex at 00C3C3F0, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
2018-06-27 11:18:33 5124 [Warning] InnoDB: A long semaphore wait:
--Thread 3956 has waited at btr0pcur.cc line 444 for 241.00 seconds the semaphore:
X-lock on RW-latch at 04844024 created in file buf0buf.cc line 1478
a writer (thread id 4440) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file not yet reserved line 0
Last time write locked in file btr0cur.cc line 293
2018-06-27 11:18:33 5124 [Warning] InnoDB: A long semaphore wait:
--Thread 4440 has waited at buf0buf.cc line 4145 for 241.00 seconds the semaphore:
S-lock on RW-latch at 0483BA74 created in file buf0buf.cc line 1478
a writer (thread id 0) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file dict0stats.cc line 1556
Last time write locked in file buf0buf.cc line 5349
2018-06-27 11:18:33 5124 [Note] InnoDB: A semaphore wait:
--Thread 5200 has waited at ibuf0ibuf.cc line 4403 for 241.00 seconds the semaphore:
Mutex at 00C3C3F0, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
在生产数据库工作良好,会有什么问题?
我在用
10.2.8-MariaDB - mariadb.org binary distribution
windows server 2012中的xampp 3.2.2
