MariaDB 10.2.6 稳定版现已发布
MariaDB 项目很高兴宣布 MariaDB 10.2.6 稳定版 (GA) 现已立即发布。这是 MariaDB 10.2 系列的第一个稳定版 (GA) 发布。有关 MariaDB 10.2 新功能的更多详细信息，请参阅什么是 MariaDB 10.2？页面。
MariaDB 10.0.31 和 MariaDB Connector/ODBC 2.0.15 也已发布。请参阅其发布说明和更新日志以了解详细信息。
下载 MariaDB Connector/ODBC 2.0.15
发布说明 更新日志 关于 MariaDB Connector/ODBC
谢谢，祝您愉快使用 MariaDB！
看起来 10.2.6 版本不稳定，我正在通过 sysbench 进行压力测试，服务器反复崩溃并重启。并且出现错误：[ERROR] InnoDB: The age of the last checkpoint is 12, which exceeds the log group capacity 0.
服务器运行在 centos 7 x86_64 系统上。
2017-05-24 13:25:37 140427917658240 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-24 13:25:37 140427917658240 [Note] InnoDB: Uses event mutexes
2017-05-24 13:25:37 140427917658240 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-24 13:25:37 140427917658240 [Note] InnoDB: Using Linux native AIO
2017-05-24 13:25:37 140427917658240 [Note] InnoDB: Number of pools: 1
2017-05-24 13:25:37 140427917658240 [Note] InnoDB: Using SSE2 crc32 instructions
2017-05-24 13:25:37 140427917658240 [Note] InnoDB: Initializing buffer pool, total size = 96G, instances = 64, chunk size = 128M
2017-05-24 13:25:41 140427917658240 [Note] InnoDB: Completed initialization of buffer pool
2017-05-24 13:25:41 140427138938624 [ERROR] InnoDB: The age of the last checkpoint is 12, which exceeds the log group capacity 0.
2017-05-24 13:25:41 140316587964160 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-05-24 13:25:41 140427917658240 [Note] InnoDB: Opened 8 undo tablespaces
2017-05-24 13:25:41 140427917658240 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: 128 out of 128 rollback segments in 8 undo tablespaces are active.
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Setting file ‘/data/mysql/data/ibtmp1’ size to 512 MB. Physically writing the file full; Please wait …
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Progress in MB
100 200 300 400 500
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: File ‘/data/mysql/data/ibtmp1’ size is now 512 MB.
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: 5.7.14 started; log sequence number 2621502988
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Creating 1 encryption thread id 140319039407872 total threads 8.
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Creating 2 encryption thread id 140318930368256 total threads 8.
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Creating 3 encryption thread id 140319031015168 total threads 8.
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Creating 4 encryption thread id 140319022622464 total threads 8.
2017-05-24 13:25:43 140319047800576 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Creating 5 encryption thread id 140319014229760 total threads 8.
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Creating 6 encryption thread id 140318921975552 total threads 8.
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Creating 7 encryption thread id 140318913582848 total threads 8.
2017-05-24 13:25:43 140427917658240 [Note] InnoDB: Creating 8 encryption thread id 140318905190144 total threads 8.
2017-05-24 13:25:43 140427917658240 [Note] Plugin ‘FEEDBACK’ is disabled.
2017-05-24 13:25:43 140427917658240 [Note] Server socket created on IP: ‘0.0.0.0’.
2017-05-24 13:25:43 140427917658240 [Note] Server socket created on IP: ‘0.0.0.0’.
2017-05-24 13:25:43 140427111372544 [Note] Event Scheduler: scheduler thread started with id 11
2017-05-24 13:25:43 140427917658240 [Note] Reading of all Master_info entries succeded
2017-05-24 13:25:43 140427917658240 [Note] Added new Master_info ” to hash table
2017-05-24 13:25:43 140427917658240 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.2.6-MariaDB-log’ socket: ‘/data/mysql/vars/mysql.sock’ port: 3306 MariaDB Server
2017-05-24 13:26:37 140319047800576 [Note] InnoDB: Buffer pool(s) load completed at 170524 13:26:37
2017-05-24 16:11:24 140315776251648 [Warning] InnoDB: Compression failed for space: 17 name: sbtest/sbtest1 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 16:15:41 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6317ms. The settings might not be optimal. (flushed=9152 and evicted=0, during the time.)
2017-05-24 16:33:14 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21170ms. The settings might not be optimal. (flushed=7588 and evicted=0, during the time.)
2017-05-24 16:34:50 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14413ms. The settings might not be optimal. (flushed=6952 and evicted=0, during the time.)
2017-05-24 16:35:52 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9563ms. The settings might not be optimal. (flushed=4990 and evicted=0, during the time.)
2017-05-24 16:36:30 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12184ms. The settings might not be optimal. (flushed=4391 and evicted=0, during the time.)
2017-05-24 16:38:14 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 41610ms. The settings might not be optimal. (flushed=19582 and evicted=0, during the time.)
2017-05-24 16:39:47 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 31052ms. The settings might not be optimal. (flushed=18860 and evicted=0, during the time.)
2017-05-24 16:40:40 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4893ms. The settings might not be optimal. (flushed=2585 and evicted=0, during the time.)
2017-05-24 16:40:54 140319670028032 [Warning] Aborted connection 415 to db: ‘sbtest’ user: ‘sb’ host: ‘172.30.17.209’ (Got an error reading communication packets)
2017-05-24 16:40:58 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10955ms. The settings might not be optimal. (flushed=5304 and evicted=0, during the time.)
2017-05-24 16:41:03 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4350ms. The settings might not be optimal. (flushed=2048 and evicted=0, during the time.)
2017-05-24 16:41:50 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4946ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2017-05-24 16:43:42 140313058326272 [Warning] InnoDB: Compression failed for space: 18 name: sbtest/sbtest1 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 16:44:29 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 25849ms. The settings might not be optimal. (flushed=18117 and evicted=0, during the time.)
2017-05-24 16:48:04 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23649ms. The settings might not be optimal. (flushed=10583 and evicted=0, during the time.)
2017-05-24 16:49:06 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15105ms. The settings might not be optimal. (flushed=6863 and evicted=0, during the time.)
2017-05-24 16:49:54 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6086ms. The settings might not be optimal. (flushed=2800 and evicted=0, during the time.)
2017-05-24 16:50:18 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4653ms. The settings might not be optimal. (flushed=2100 and evicted=0, during the time.)
2017-05-24 16:50:51 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10741ms. The settings might not be optimal. (flushed=4206 and evicted=0, during the time.)
2017-05-24 16:51:48 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12918ms. The settings might not be optimal. (flushed=5193 and evicted=0, during the time.)
2017-05-24 16:53:23 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 44141ms. The settings might not be optimal. (flushed=18791 and evicted=0, during the time.)
2017-05-24 16:54:34 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13506ms. The settings might not be optimal. (flushed=3998 and evicted=0, during the time.)
2017-05-24 16:55:38 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15464ms. The settings might not be optimal. (flushed=6342 and evicted=0, during the time.)
2017-05-24 16:56:37 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 25715ms. The settings might not be optimal. (flushed=9707 and evicted=0, during the time.)
2017-05-24 16:57:54 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8024ms. The settings might not be optimal. (flushed=4960 and evicted=0, during the time.)
2017-05-24 16:59:18 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 35985ms. The settings might not be optimal. (flushed=18124 and evicted=0, during the time.)
2017-05-24 17:01:02 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14486ms. The settings might not be optimal. (flushed=6164 and evicted=0, during the time.)
2017-05-24 17:02:12 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18906ms. The settings might not be optimal. (flushed=9155 and evicted=0, during the time.)
2017-05-24 17:03:48 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5083ms. The settings might not be optimal. (flushed=2978 and evicted=0, during the time.)
2017-05-24 17:05:01 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19082ms. The settings might not be optimal. (flushed=9507 and evicted=0, during the time.)
2017-05-24 17:07:21 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12852ms. The settings might not be optimal. (flushed=6520 and evicted=0, during the time.)
2017-05-24 17:09:07 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 41119ms. The settings might not be optimal. (flushed=18190 and evicted=0, during the time.)
2017-05-24 17:10:39 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14286ms. The settings might not be optimal. (flushed=6153 and evicted=0, during the time.)
2017-05-24 17:11:31 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4938ms. The settings might not be optimal. (flushed=2304 and evicted=0, during the time.)
2017-05-24 17:12:38 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 37948ms. The settings might not be optimal. (flushed=15921 and evicted=0, during the time.)
2017-05-24 17:14:17 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 24682ms. The settings might not be optimal. (flushed=17188 and evicted=0, during the time.)
2017-05-24 17:15:38 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8294ms. The settings might not be optimal. (flushed=3245 and evicted=0, during the time.)
2017-05-24 17:16:21 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5166ms. The settings might not be optimal. (flushed=1993 and evicted=0, during the time.)
2017-05-24 17:17:20 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 32805ms. The settings might not be optimal. (flushed=16564 and evicted=0, during the time.)
2017-05-24 17:19:05 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9093ms. The settings might not be optimal. (flushed=9297 and evicted=0, during the time.)
2017-05-24 17:21:18 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19363ms. The settings might not be optimal. (flushed=9480 and evicted=0, during the time.)
2017-05-24 17:22:26 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11385ms. The settings might not be optimal. (flushed=5032 and evicted=0, during the time.)
2017-05-24 17:23:55 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 40682ms. The settings might not be optimal. (flushed=18152 and evicted=0, during the time.)
2017-05-24 17:25:15 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8358ms. The settings might not be optimal. (flushed=4759 and evicted=0, during the time.)
2017-05-24 17:26:04 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13770ms. The settings might not be optimal. (flushed=6526 and evicted=0, during the time.)
2017-05-24 17:27:45 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10457ms. The settings might not be optimal. (flushed=4958 and evicted=0, during the time.)
2017-05-24 17:29:47 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 40274ms. The settings might not be optimal. (flushed=18185 and evicted=0, during the time.)
2017-05-24 17:31:47 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 37748ms. The settings might not be optimal. (flushed=17347 and evicted=0, during the time.)
2017-05-24 17:33:09 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6309ms. The settings might not be optimal. (flushed=2513 and evicted=0, during the time.)
2017-05-24 17:33:55 140316587964160 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6687ms. The settings might not be optimal. (flushed=4751 and evicted=0, during the time.)
2017-05-24 17:35:19 140176681117824 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-24 17:35:19 140176681117824 [Note] InnoDB: Uses event mutexes
2017-05-24 17:35:19 140176681117824 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-24 17:35:19 140176681117824 [Note] InnoDB: Using Linux native AIO
2017-05-24 17:35:19 140176681117824 [Note] InnoDB: Number of pools: 1
2017-05-24 17:35:19 140176681117824 [Note] InnoDB: Using SSE2 crc32 instructions
2017-05-24 17:35:19 140176681117824 [Note] InnoDB: Initializing buffer pool, total size = 96G, instances = 64, chunk size = 128M
2017-05-24 17:35:22 140176681117824 [Note] InnoDB: Completed initialization of buffer pool
2017-05-24 17:35:22 140175867275008 [ERROR] InnoDB: The age of the last checkpoint is 12, which exceeds the log group capacity 0.
2017-05-24 17:35:23 140065349162752 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-05-24 17:35:23 140176681117824 [Note] InnoDB: Opened 8 undo tablespaces
2017-05-24 17:35:23 140176681117824 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-24 17:35:23 140176681117824 [Note] InnoDB: Starting crash recovery from checkpoint LSN=37587051124
2017-05-24 17:35:28 140176681117824 [Note] InnoDB: Starting final batch to recover 20635 pages from redo log.
InnoDB: Last MySQL binlog file position 0 527496260, file name /data/mysql/tran/mysql-bin.000027
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: 128 out of 128 rollback segments in 8 undo tablespaces are active.
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1″
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Setting file ‘/data/mysql/data/ibtmp1’ size to 512 MB. Physically writing the file full; Please wait …
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Progress in MB
100 200 300 400 500
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: File ‘/data/mysql/data/ibtmp1’ size is now 512 MB.
2017-05-24 17:35:30 140065349162752 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7285ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: 5.7.14 started; log sequence number 37608145048
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Creating 1 encryption thread id 140067892860672 total threads 8.
2017-05-24 17:35:30 140067901253376 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Creating 2 encryption thread id 140067808999168 total threads 8.
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Creating 3 encryption thread id 140067800606464 total threads 8.
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Creating 4 encryption thread id 140067792213760 total threads 8.
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Creating 5 encryption thread id 140067783821056 total threads 8.
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Creating 6 encryption thread id 140067775428352 total threads 8.
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Creating 7 encryption thread id 140067767035648 total threads 8.
2017-05-24 17:35:30 140176681117824 [Note] InnoDB: Creating 8 encryption thread id 140067758642944 total threads 8.
2017-05-24 17:35:32 140065349162752 [Warning] InnoDB: Compression failed for space: 18 name: sbtest/sbtest1 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:35:42 140176681117824 [Note] Plugin ‘FEEDBACK’ is disabled.
2017-05-24 17:35:42 140176681117824 [Note] Recovering after a crash using /data/mysql/tran/mysql-bin
2017-05-24 17:35:42 140067901253376 [Note] InnoDB: Buffer pool(s) load completed at 170524 17:35:42
2017-05-24 17:35:48 140176681117824 [Note] Starting crash recovery…
2017-05-24 17:35:48 140176681117824 [Note] Crash recovery finished.
2017-05-24 17:35:48 140176681117824 [Note] Server socket created on IP: ‘0.0.0.0’.
2017-05-24 17:35:48 140176681117824 [Note] Server socket created on IP: ‘0.0.0.0’.
2017-05-24 17:35:48 140175989122816 [Note] Event Scheduler: scheduler thread started with id 11
2017-05-24 17:35:48 140176681117824 [Note] Reading of all Master_info entries succeded
2017-05-24 17:35:48 140176681117824 [Note] Added new Master_info ” to hash table
2017-05-24 17:35:48 140176681117824 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.2.6-MariaDB-log’ socket: ‘/data/mysql/vars/mysql.sock’ port: 3306 MariaDB Server
2017-05-24 17:38:04 140175988852480 [Note] /usr/sbin/mysqld (unknown): Normal shutdown
2017-05-24 17:38:04 140175988852480 [Note] Event Scheduler: Killing the scheduler thread, thread id 11
2017-05-24 17:38:04 140175988852480 [Note] Event Scheduler: Waiting for the scheduler thread to reply
2017-05-24 17:38:04 140175988852480 [Note] Event Scheduler: Stopped
2017-05-24 17:38:04 140175988852480 [Note] Event Scheduler: Purging the queue. 0 events
2017-05-24 17:38:04 140067263735552 [Note] InnoDB: FTS optimize thread exiting.
2017-05-24 17:38:04 140175988852480 [Note] InnoDB: Starting shutdown…
2017-05-24 17:38:04 140067901253376 [Note] InnoDB: Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool
2017-05-24 17:38:05 140067901253376 [Note] InnoDB: Buffer pool(s) dump completed at 170524 17:38:05
2017-05-24 17:38:20 140175988852480 [Note] InnoDB: Shutdown completed; log sequence number 37608220684
2017-05-24 17:38:20 140175988852480 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1″
2017-05-24 17:38:20 140175988852480 [Note] /usr/sbin/mysqld: Shutdown complete
2017-05-24 17:38:22 140382311307392 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-24 17:38:22 140382311307392 [Note] InnoDB: Uses event mutexes
2017-05-24 17:38:22 140382311307392 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-24 17:38:22 140382311307392 [Note] InnoDB: Using Linux native AIO
2017-05-24 17:38:22 140382311307392 [Note] InnoDB: Number of pools: 1
2017-05-24 17:38:22 140382311307392 [Note] InnoDB: Using SSE2 crc32 instructions
2017-05-24 17:38:22 140382311307392 [Note] InnoDB: Initializing buffer pool, total size = 96G, instances = 64, chunk size = 128M
2017-05-24 17:38:25 140382311307392 [Note] InnoDB: Completed initialization of buffer pool
2017-05-24 17:38:25 140381491934976 [ERROR] InnoDB: The age of the last checkpoint is 12, which exceeds the log group capacity 0.
2017-05-24 17:38:25 140270970722048 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-05-24 17:38:25 140382311307392 [Note] InnoDB: Opened 8 undo tablespaces
2017-05-24 17:38:25 140382311307392 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: 128 out of 128 rollback segments in 8 undo tablespaces are active.
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Setting file ‘/data/mysql/data/ibtmp1’ size to 512 MB. Physically writing the file full; Please wait …
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Progress in MB
100 200 300 400 500
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: File ‘/data/mysql/data/ibtmp1’ size is now 512 MB.
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: 5.7.14 started; log sequence number 37608220684
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Creating 1 encryption thread id 140273766102784 total threads 8.
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Creating 2 encryption thread id 140273757710080 total threads 8.
2017-05-24 17:38:27 140273849964288 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Creating 3 encryption thread id 140273749317376 total threads 8.
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Creating 4 encryption thread id 140273740924672 total threads 8.
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Creating 5 encryption thread id 140273732531968 total threads 8.
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Creating 6 encryption thread id 140273724139264 total threads 8.
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Creating 7 encryption thread id 140273715746560 total threads 8.
2017-05-24 17:38:27 140382311307392 [Note] InnoDB: Creating 8 encryption thread id 140273229231872 total threads 8.
2017-05-24 17:38:27 140382311307392 [Note] Plugin ‘FEEDBACK’ is disabled.
2017-05-24 17:38:27 140382311307392 [Note] Server socket created on IP: ‘0.0.0.0’.
2017-05-24 17:38:27 140382311307392 [Note] Server socket created on IP: ‘0.0.0.0’.
2017-05-24 17:38:27 140381614094080 [Note] Event Scheduler: scheduler thread started with id 11
2017-05-24 17:38:27 140382311307392 [Note] Reading of all Master_info entries succeded
2017-05-24 17:38:27 140382311307392 [Note] Added new Master_info ” to hash table
2017-05-24 17:38:27 140382311307392 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.2.6-MariaDB-log’ socket: ‘/data/mysql/vars/mysql.sock’ port: 3306 MariaDB Server
2017-05-24 17:38:51 140273849964288 [Note] InnoDB: Buffer pool(s) load completed at 170524 17:38:51
2017-05-24 17:40:15 140273900320512 [Warning] InnoDB: Compression failed for space: 19 name: sbtest/sbtest1 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:40:17 140273883535104 [Warning] InnoDB: Compression failed for space: 20 name: sbtest/sbtest2 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:40:18 140273858356992 [Warning] InnoDB: Compression failed for space: 24 name: sbtest/sbtest6 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:40:18 140273875142400 [Warning] InnoDB: Compression failed for space: 28 name: sbtest/sbtest10 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:40:18 140273992574720 [Warning] InnoDB: Compression failed for space: 23 name: sbtest/sbtest5 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:40:18 140273900320512 [Warning] InnoDB: Compression failed for space: 21 name: sbtest/sbtest3 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:40:18 140273883535104 [Warning] InnoDB: Compression failed for space: 25 name: sbtest/sbtest7 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:40:18 140273891927808 [Warning] InnoDB: Compression failed for space: 27 name: sbtest/sbtest9 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:40:18 140273866749696 [Warning] InnoDB: Compression failed for space: 22 name: sbtest/sbtest4 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:40:18 140273984182016 [Warning] InnoDB: Compression failed for space: 26 name: sbtest/sbtest8 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:41:58 140266610599680 [Warning] InnoDB: Compression failed for space: 29 name: sbtest/sbtest1 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-05-24 17:44:41 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17622ms. The settings might not be optimal. (flushed=26468 and evicted=0, during the time.)
2017-05-24 17:48:04 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4216ms. The settings might not be optimal. (flushed=4869 and evicted=0, during the time.)
2017-05-24 17:48:27 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4211ms. The settings might not be optimal. (flushed=4935 and evicted=0, during the time.)
2017-05-24 17:52:00 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15480ms. The settings might not be optimal. (flushed=23611 and evicted=0, during the time.)
2017-05-24 17:59:10 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7720ms. The settings might not be optimal. (flushed=6632 and evicted=0, during the time.)
2017-05-24 17:59:44 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4432ms. The settings might not be optimal. (flushed=3564 and evicted=0, during the time.)
2017-05-24 18:04:14 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9062ms. The settings might not be optimal. (flushed=2620 and evicted=0, during the time.)
2017-05-24 18:12:07 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 34339ms. The settings might not be optimal. (flushed=11068 and evicted=0, during the time.)
2017-05-24 18:14:19 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 52621ms. The settings might not be optimal. (flushed=15953 and evicted=0, during the time.)
2017-05-24 18:16:34 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 52672ms. The settings might not be optimal. (flushed=15151 and evicted=0, during the time.)
2017-05-24 18:24:19 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15492ms. The settings might not be optimal. (flushed=4826 and evicted=0, during the time.)
2017-05-24 18:24:57 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4804ms. The settings might not be optimal. (flushed=1380 and evicted=0, during the time.)
2017-05-24 18:25:12 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5985ms. The settings might not be optimal. (flushed=1739 and evicted=0, during the time.)
2017-05-24 18:25:34 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10810ms. The settings might not be optimal. (flushed=4895 and evicted=0, during the time.)
2017-05-24 18:26:34 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 28125ms. The settings might not be optimal. (flushed=12155 and evicted=0, during the time.)
2017-05-24 18:27:55 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8599ms. The settings might not be optimal. (flushed=3221 and evicted=0, during the time.)
2017-05-24 18:28:32 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16075ms. The settings might not be optimal. (flushed=6338 and evicted=0, during the time.)
2017-05-24 18:29:49 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7109ms. The settings might not be optimal. (flushed=2213 and evicted=0, during the time.)
2017-05-24 18:31:13 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 58241ms. The settings might not be optimal. (flushed=18987 and evicted=0, during the time.)
2017-05-24 18:33:05 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 31668ms. The settings might not be optimal. (flushed=8984 and evicted=0, during the time.)
2017-05-24 18:34:10 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11041ms. The settings might not be optimal. (flushed=6137 and evicted=0, during the time.)
2017-05-24 18:35:42 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 43212ms. The settings might not be optimal. (flushed=17986 and evicted=0, during the time.)
2017-05-24 18:37:28 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 32099ms. The settings might not be optimal. (flushed=16217 and evicted=0, during the time.)
2017-05-24 18:39:04 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11785ms. The settings might not be optimal. (flushed=4759 and evicted=0, during the time.)
2017-05-24 18:40:10 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8700ms. The settings might not be optimal. (flushed=3380 and evicted=0, during the time.)
2017-05-24 18:40:52 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4962ms. The settings might not be optimal. (flushed=2062 and evicted=0, during the time.)
2017-05-24 18:42:00 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 42945ms. The settings might not be optimal. (flushed=18473 and evicted=0, during the time.)
2017-05-24 18:43:48 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19657ms. The settings might not be optimal. (flushed=9112 and evicted=0, during the time.)
2017-05-24 18:45:14 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4979ms. The settings might not be optimal. (flushed=2327 and evicted=0, during the time.)
2017-05-24 18:46:39 140270970722048 [Note] InnoDB: page_cleaner: 预定的 1000ms 循环耗时 44513ms。设置可能不是最优的。(在此期间：flushed=17527, evicted=0)
2017-05-24 18:47:50 140270970722048 [Note] InnoDB: page_cleaner: 预定的 1000ms 循环耗时 4154ms。设置可能不是最优的。(在此期间：flushed=2049, evicted=0)
很大的改进，谢谢
看起来好像有些东西改变了，或者这与“ALTER TABLE IGNORE”有关，是个 bug。
在我的 mariadb 10.1.23 上，我可以执行
ALTER IGNORE TABLE mytable ADD UNIQUE (bean_id, field, history_date, value, deleted);
然后它会删除这组数据中的所有重复行。
在 10.2.6 上我遇到了一个
ERROR 1062 (23000): 重复条目 ‘123456-price-2016-0’ 对于键 ‘bean_id’
版本 10.2.6 不稳定。
我使用 ODBC 进行远程访问。连接可以建立，但对数据库的请求没有被执行。
ODBC 日志
Forceds 1e38-1f08 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 0x00349480
UCHAR * 0x01E907C8 [-3] “SELECT ……… SDWORD -3
DIAG [S1000] [MySQL] [ODBC 5.3 (a) Driver] [mysqld-5.5.5-10.2.6-MariaDB] 格式错误的报文 (2027)
服务器错误
InnoDB: 文件 \\. \ C :: ‘DeviceIoControl (IOCTL_STORAGE_QUERY_PROPERTY)’ 返回了 OS 错误 250。
在本地网络中工作时，一切正常。