astral bison
Hi! Last month, I started using a MacBook Pro M2 (16 gb) and I thought I could start with Laravel Sail and Docker.
After high MYSQL load with lots of jobs on Laravel Horizon it seems that MYSQL service chrashes. I think it's ran out of memory.
Is there a way to reserve more memory to that specific service?
astral bison
It seems that the BLOCK I/O is getting high too fast
hidden niche
You are using redis and not mysql for your cache/queue, right?
muted cloud
Have you checked the logs for the mysql service?
astral bison
You are using redis and not mysql for your cache/queue, right?
Yes, I'm using REDIS as the queue driver
astral bison
Have you checked the logs for the mysql service?
I checked the logs with docker logs mysql_container and I didn't found anything usefull. It says: -Starting XA crash recovery... -XA crash recovery finished. I do have to restart the containers to make them work again.
In my horizon.php configuration file I have one of the queues with a max of 45 processes (it was at the top). I lowered it to a more reasonable number (like 10) and the bug disappeared. But, I have this configuration in production and it works fine. Also, I used to test this in a local Linux laptop (without docker) and worked. Is it that docker cannot handle this high workloads? Or maybe is my MacBook Pro M2 extra expensive computer?
muted cloud
Have you tried using https://orbstack.dev/ in stead of the regular Docker Desktop? I don't know if it'll fix this issue, but in my experience OrbStack is a lot faster, especially in the I/O department.
astral bison
Have you tried using https://orbstack.dev/ in stead of the regular Docker Deskto...
I'll give it a try!! Thank you 😆