CODEWITHSUNDEEP
mysqlraspberry-piinnodb
Bela_b
Bela_b

Reputation: 131

Mysql Innodb reads are too high on raspberry

we have got some raspberry devices running small webservers with mysql database. They are literally clones and we are monitoring them through MySQL Workbench. Some of them has this high innodb read problem, these machines so slow they cant even serve the minimal API content which is based on database. You can see the high value on right hand side, down below: InnoDB disk reads. The client program is a python one. Any idea how to get it back to normal?

I tried to change some global variables, but here are the innodb read connected ones:

innodb_encryption_threads....... 0
innodb_purge_threads............ 4
innodb_random_read_ahead........ OFF
innodb_read_ahead_threshold..... 56
innodb_read_io_threads.......... 4
innodb_read_only................ OFF

Upvotes: 0

Views: 49

Answers (0)

Related Questions