[MDEV-11738] Mariadb uses 100% of several of my 8 cpus doing nothing - Jira

Details

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

Description

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.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

my.cnf
5 kB
2017-01-07 15:36
mysql.txt
6 kB
2017-01-07 15:34

Issue Links

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%

Closed

(8 relates to)

Activity

Ascending order - Click to sort in descending order

Tim Passingham created issue - 2017-01-07 15:47

Elena Stepanova made changes - 2017-01-07 16:14

Field	Original Value	New Value
Assignee		Jan Lindström [ jplindst ]

Rasmus Johansson (Inactive) made changes - 2017-01-11 08:02

Fix Version/s

10.1 [ 16100 ]

Jan Lindström (Inactive) made changes - 2017-01-11 10:16

Status

Open [ 1 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2017-01-11 10:17

Link

This issue relates to ~~MDEV-11581~~ [ ~~MDEV-11581~~ ]

Marko Mäkelä made changes - 2017-01-30 14:49

Link

This issue relates to ~~MDEV-11939~~ [ ~~MDEV-11939~~ ]

Jan Lindström (Inactive) made changes - 2017-02-02 05:45

Link

This issue relates to ~~MDEV-11939~~ [ ~~MDEV-11939~~ ]

Jan Lindström (Inactive) made changes - 2017-02-02 14:09

Assignee	Jan Lindström [ jplindst ]	Marko Mäkelä [ marko ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Marko Mäkelä made changes - 2017-02-03 14:21

Assignee	Marko Mäkelä [ marko ]	Jan Lindström [ jplindst ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Jan Lindström (Inactive) made changes - 2017-02-07 09:58

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2017-02-14 12:55

Assignee	Jan Lindström [ jplindst ]	Marko Mäkelä [ marko ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Marko Mäkelä made changes - 2017-02-16 09:28

Assignee	Marko Mäkelä [ marko ]	Jan Lindström [ jplindst ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Marko Mäkelä made changes - 2017-02-16 10:08

Link

This issue relates to ~~MDEV-11420~~ [ ~~MDEV-11420~~ ]

Marko Mäkelä made changes - 2017-02-16 13:02

Link

This issue relates to ~~MDEV-11222~~ [ ~~MDEV-11222~~ ]

Jan Lindström (Inactive) made changes - 2017-02-17 07:38

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2017-02-21 07:12

Assignee	Jan Lindström [ jplindst ]	Marko Mäkelä [ marko ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Marko Mäkelä made changes - 2017-02-27 15:10

Assignee	Marko Mäkelä [ marko ]	Jan Lindström [ jplindst ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Jan Lindström (Inactive) made changes - 2017-02-28 14:01

Assignee	Jan Lindström [ jplindst ]	Marko Mäkelä [ marko ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Rasmus Johansson (Inactive) made changes - 2017-03-02 11:33

Sprint

10.1.22 [ 143 ]

Rasmus Johansson (Inactive) made changes - 2017-03-02 11:33

Rank

Ranked lower

Marko Mäkelä made changes - 2017-03-02 13:55

Assignee	Marko Mäkelä [ marko ]	Jan Lindström [ jplindst ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Jan Lindström (Inactive) made changes - 2017-03-14 14:24

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2017-03-14 14:25

issue.field.resolutiondate

2017-03-14 14:25:07.0

2017-03-14 14:25:07.172

Jan Lindström (Inactive) made changes - 2017-03-14 14:25

Component/s		Encryption [ 11200 ]
Component/s		Storage Engine - InnoDB [ 10129 ]
Component/s		Storage Engine - XtraDB [ 10135 ]
Component/s	OTHER [ 10125 ]
Fix Version/s		10.1.23 [ 22503 ]
Fix Version/s	10.1 [ 16100 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Marko Mäkelä made changes - 2017-04-03 16:05

Link

This issue causes ~~MDEV-12428~~ [ ~~MDEV-12428~~ ]

Marko Mäkelä made changes - 2017-04-21 08:57

Link

This issue causes ~~MDEV-12467~~ [ ~~MDEV-12467~~ ]

Marko Mäkelä made changes - 2017-04-27 11:26

Link

This issue relates to ~~MDEV-12602~~ [ ~~MDEV-12602~~ ]

Marko Mäkelä made changes - 2017-06-05 07:01

Link

This issue relates to ~~MDEV-11929~~ [ ~~MDEV-11929~~ ]

Marko Mäkelä made changes - 2017-08-24 13:41

Link

This issue causes ~~MDEV-13639~~ [ ~~MDEV-13639~~ ]

Vladislav Vaintroub made changes - 2018-01-21 00:01

Link

This issue relates to ~~MDEV-15016~~ [ ~~MDEV-15016~~ ]

Marko Mäkelä made changes - 2018-11-20 14:10

Link

This issue relates to ~~MDEV-17757~~ [ ~~MDEV-17757~~ ]

Marko Mäkelä made changes - 2019-04-01 07:25

Link

This issue causes ~~MDEV-19111~~ [ ~~MDEV-19111~~ ]

Marko Mäkelä made changes - 2020-01-24 08:19

Link

This issue relates to ~~MDEV-12694~~ [ ~~MDEV-12694~~ ]

Marko Mäkelä made changes - 2020-12-17 11:52

Link

This issue relates to ~~MDEV-24426~~ [ ~~MDEV-24426~~ ]

Sergei Golubchik made changes - 2021-12-06 21:44

Workflow

MariaDB v3 [ 79120 ]

MariaDB v4 [ 151499 ]

Jira Automation (IT) made changes - 2024-07-04 08:35

Zendesk Related Tickets

175209

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Tim Passingham

Votes:: 0 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2017-01-07 15:47

Updated:: 2024-07-08 00:59

Resolved:: 2017-03-14 14:25

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration