[MDEV-20558] innodb processes appears in processlist, ver10.3.13 Created: 2019-09-11  Updated: 2019-09-11  Resolved: 2019-09-11

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3.13
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: steen bartholdy Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Red Hat Enterprise Linux Server release 7.7 (Maipo)


Issue Links:
Duplicate
is duplicated by MDEV-11703 InnoDB background threads show up in ... Stalled

 Description   

Hi
Installed 10.3.13 from redhat repository on 7.7.
Some innodb processes allways appears in processlist, is this "working as designed and with no issues" ?
Kind regards
Steen
List of processes :

---------------------------------------------------------------------------------------

| Id | User | Host | db | Command | Time | State | Info | Progress |

---------------------------------------------------------------------------------------

| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |

| 2 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |

| 1 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |

| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |

| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |

| 72 | root | localhost | NULL | Query | 0 | Init | show processlist | 0.000 |

---------------------------------------------------------------------------------------

I havent tested speed og any other consequences. I want to understand this change before going to production with setup.



 Comments   
Comment by Elena Stepanova [ 2019-09-11 ]

There has been a lot of discussion around it in MDEV-11703, which is still open.

Generated at Thu Feb 08 09:00:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.