"DB Nightmare: MySQL Crashing on High Load, Need Help!"

[ivanko69]

"Hey guys, I'm at my wit's end here. I've got a MySQL database that's been serving a high-traffic crypto trading platform, but it's constantly crashing under load - I'm talking multiple times a day, resulting in a ton of downtime for my users. Anyone else had to deal with this or have any suggestions on how to optimize my setup?"

 

[Рушан]

"Dude, I feel you. We've had issues with MySQL crashing on high load too. Have you tried increasing the innodb buffer pool size and tweaking the query cache?"

 

[Hovhannes]

Anyone experienced with latest news?

 

[mlatysheva]

Thoughts on opportunities?

 

[sayrus383]

Anyone experienced with new trends?

 

[aviaprom]

"Hey OP, what's your average query complexity and execution time? Have you considered scaling up your DB instance or implementing some read replicas?"