MariaDB 10.2.6 Stable now available
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.6 Stable (GA). This is the first stable (GA) release in the MariaDB 10.2 series. See the What is MariaDB 10.2? page for more details on the new features in MariaDB 10.2.
Release Notes Changelog What is MariaDB 10.2?
MariaDB APT and YUM Repository Configuration Generator
MariaDB 10.0.31 and MariaDB Connector/ODBC 2.0.15 have also been released. See their release notes and changelogs for details.
Release Notes Changelog What is MariaDB 10.0?
MariaDB APT and YUM Repository Configuration Generator
Download MariaDB Connector/ODBC 2.0.15
Release Notes Changelog About MariaDB Connector/ODBC
Thanks, and enjoy MariaDB!
Looks like Version 10.2.6 is unstable, I am doing stress test via sysbench, the server crashes and restart again and again. And there is an Error: [ERROR] InnoDB: The age of the last checkpoint is 12, which exceeds the log group capacity 0.
The server is running 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 intended loop took 44513ms. The settings might not be optimal. (flushed=17527 and evicted=0, during the time.)
2017-05-24 18:47:50 140270970722048 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4154ms. The settings might not be optimal. (flushed=2049 and evicted=0, during the time.)
Great improvements, thanks
It seems like something changed or it is a bug with “ALTER TABLE IGNORE”
On my mariadb 10.1.23 i can do a
ALTER IGNORE TABLE mytable ADD UNIQUE (bean_id, field, history_date, value, deleted);
and it removes all my duplicate rows for this set.
On 10.2.6 i get a:
ERROR 1062 (23000): Duplicate entry ‘123456-price-2016-0’ for key ‘bean_id’
Version 10.2.6 is unstable.
I work through ODBC for remote access. The connection goes through, but requests to the database are not executed.
Log 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] Malformed packet (2027)
Server error:
InnoDB: File \\. \ C :: ‘DeviceIoControl (IOCTL_STORAGE_QUERY_PROPERTY)’ returned OS error 250.
When working on a local network, everything is fine.