# Checking permissions issue in mysql processlist **URL:** \ **Category:** Percona Server for MySQL 5.7\ **Tags:** mysql\ **Created:** [December 4, 2020, 10:21am UTC](https://forums.percona.com/t/checking-permissions-issue-in-mysql-processlist/8346 "2020-12-04T10:21:36Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Gajendra](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gajendra/32/44_2.png) [@Gajendra](https://forums.percona.com/u/Gajendra)\ **Post date:** [December 4, 2020, 10:21am UTC](https://forums.percona.com/t/checking-permissions-issue-in-mysql-processlist/8346/1 "2020-12-04T10:21:36Z")
Hi Expert, I checked in process list there are so many connection which stuck in checking permissions state mysql\>show processlist; | 12211246 | myuser1 | _._._._:14919 | itbc | Query | 7861 | **checking permissions** | CREATE TABLE IF NOT EXISTS zones ( name varchar(255) not null primary key, status varchar mysql\> select count(_) from mysql.user;_ _±---------+_ _| count(_) | ±---------+ | 41 | ±---------+ 1 row in set (0.00 sec) mysql\> select count(_) from mysql.db;_ _±---------+_ _| count(_) | ±---------+ | 55 | ±---------+ please help me on this. ---
**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\ **Post date:** [December 4, 2020, 10:37am UTC](https://forums.percona.com/t/checking-permissions-issue-in-mysql-processlist/8346/2 "2020-12-04T10:37:41Z")
Hi, these could mean a lot of different things unfortunately. Mostly related to contention issues. Check show engine innodb status to see if anything stands out. Also I suggest installing PMM if you get a chance, having metrics will help you find out where is the problem more effectively. ---
**Author:** ![Gajendra](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gajendra/32/44_2.png) [@Gajendra](https://forums.percona.com/u/Gajendra)\ **Post date:** [December 4, 2020, 12:04pm UTC](https://forums.percona.com/t/checking-permissions-issue-in-mysql-processlist/8346/3 "2020-12-04T12:04:51Z")
@@igroene I found in show engine innodb status output and there are 100 connection state showing **wsrep: initiating replication for write set (-1)** —TRANSACTION 8236194995, ACTIVE 37273 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 12201711, OS thread handle 140594681710336, query id 3876413072 hostname myuser1 **wsrep: initiating replication for write set (-1)** UPDATE zxc SET toAt = ‘2020-12-04 08:04:31.814’, fromAt = null, class = null, goodTypeId = 1, badTypeId = NULL, samId = NULL WHERE id = 4738276 LIMIT 1 —TRANSACTION 8236194994, ACTIVE 37273 sec ---
**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\ **Post date:** [December 4, 2020, 12:45pm UTC](https://forums.percona.com/t/checking-permissions-issue-in-mysql-processlist/8346/4 "2020-12-04T12:45:37Z")
Ok from the output it seems you have some uncomitted transactions from long ago. I suggest dealing with that problem first, it is possible it is related to the checking permissions issue