Found another solved thread here : https://discord.com/channels/564160730845151244/1220320274982109245
As he shown i also had my redis going at 90+% CPU tho i'm on 1.5.7.
Looking at the container i think the issue is that my redis container was updated by WatchTower and made the container recreate itself.
With that recreation i think appwrite send A LOT of request to redis tho all the previous data was erased because of the recreation of the redis container
A "fix" for this is to just restart all the appwrite stack (compose) and the CPU will go down.