-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1.20
-
Fix Version/s: 10.1.23
-
Component/s: Encryption, Storage Engine - InnoDB, Storage Engine - XtraDB
-
Labels:None
-
Environment:Linux 4.8.0-32-generic #34-Ubuntu SMP Tue Dec 13 14:30:43 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
Ubuntu 16.10
7.5 GB memory. Core™ i7-4770T CPU @ 2.50GHz × 8. 64 bit.
Intel® Haswell Desktop
-
Sprint:10.1.22
I use mariadb purely for a local sql database (via LibreOffice Base). There are no other users.
Periodically the mysql process (still called that) take 37% (sometimes more) of the total available cpu, even though I am not doing anything at all, and the local database is not being used. If I restart the service the usage drops to 0%. I have not found any specific trigger for this behaviour.
mysql.txt attached is the result of 'show engine innodb status;'
my.cnf is the configuration file. Note that I use encryption for some tables - the key is itself encrypted and held in a part of my user space which is itself encrypted (I had to allow the service to access this in the mysql.service file). I then only start the mariadb/mysql service when I decrypt that part of my user space, so that it can get the key it needs. All this works without trouble.
The conf.d file mariadb.cnf only contain character set info.
- causes
-
MDEV-12428 SIGSEGV in buf_page_decrypt_after_read() during DDL
-
- Closed
-
-
MDEV-12467 encryption.create_or_replace hangs during DROP TABLE
-
- Closed
-
-
MDEV-13639 Server crashes in prepare_inplace_alter_table_dict upon altering a table with discarded tablespace
-
- Closed
-
-
MDEV-19111 Unused field INFORMATION_SCHEMA.INNODB_TABLESPACES_SCRUBBING.ROTATING_OR_FLUSHING
-
- Closed
-
- relates to
-
MDEV-11581 Mariadb starts innodb encryption threads when key has not changed or data scrubbing turned off
-
- Closed
-
-
MDEV-12602 InnoDB: Failing assertion: space->n_pending_ops == 0
-
- Closed
-
-
MDEV-15016 multiple page cleaner threads use a lot of CPU on idle server
-
- Closed
-
-
MDEV-24426 fil_crypt_thread keep spinning even if innodb_encryption_rotate_key_age=0
-
- Closed
-
-
MDEV-11222 encryption.encrypt_and_grep failed in buildbot on P8
-
- Closed
-
-
MDEV-11420 encryption.innodb_encryption-page-compression failed in buildbot
-
- Closed
-
-
MDEV-11929 During delete: InnoDB: Assertion failure in thread 139757855127296 in file buf0buf.cc line 4803
-
- Closed
-
-
MDEV-12694 test failure: encryption.create_or_replace hangs during DROP for CREATE OR REPLACE TABLE
-
- Closed
-
-
MDEV-17757 MariaDB 10.1 encryption threads consume CPU 100%
-
- Open
-