# Тоо many system locks since latest update to  5.7.28-31

**URL:** <https://forums.percona.com/t/many-system-locks-since-latest-update-to-5-7-28-31/7331>\
**Category:** Percona Server for MySQL 5.7\
**Created:** [December 4, 2019, 5:05am UTC](https://forums.percona.com/t/many-system-locks-since-latest-update-to-5-7-28-31/7331 "2019-12-04T05:05:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![narodmon](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/narodmon/32/1286_2.png) [@narodmon](https://forums.percona.com/u/narodmon)\
**Post date:** [December 4, 2019, 5:05am UTC](https://forums.percona.com/t/many-system-locks-since-latest-update-to-5-7-28-31/7331/1 "2019-12-04T05:05:35Z")

</div>

Good day.  
We are using Percona in our non-coomercial IoT Project narodmon (public monitoring project).

After the last update (via yum on CentOS 6.9) to 5.7.28-31 we have many sql system lock errors 1205 for simple UPDATE and INSERT (eg UPDATE only 1 field in row based on PK) commands which were not previously observed.  
First, of course, I check mysql slow log (2sec+) - and see nothing.  
Well, in the next step, I register all active mysql processes for all users on mysql after each error 1205 and see nothing again.  
Only 1-2 active processes on other tables that are not included in UPDATE / INSERT.  
Then I implement the 2nd attempt to start INSERT / UPDATE 2-3 seconds after error 1205 and write all processes in mysql before and after it and I see nothing that could block it.

Another problem after latest update is indexes of the most usable tables are broken… process list shows what in a simple select from the table without joins in 1000 rows analyzed 1000000 rows wtf ?  
I can fix it only after doing ALTER TABLE … ENGINE = TokuDB any other commands like CHECK, OPTIMIZE, ANALYZE helps nothing.

innodb\_file\_per\_table = 1  
[default\_storage\_engine](http://pm.narodmon.ru/url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.7%2Fen%2Fserver-options.html%23option_mysqld_default-storage-engine) = TokuDB  
innodb lock wait timeout = 60  
[max\_heap\_table\_size](http://pm.narodmon.ru/server_variables.php?filter=max_heap_table_size) & [tmp\_table\_size](http://pm.narodmon.ru/server_variables.php?filter=tmp_table_size) = 64M  
Qcache = ON

If you need more system or status variables - ask me.  
Thanks for your time.