"HELP: Website Crashin' - Need Urgent Fix for MySQL Query Issue"

Сергей39

New member
Joined
Jul 19, 2011
Messages
3
Reaction score
0
"Hey fellow devs, I'm having a major meltdown over here. Our cryptocurrency tracking website just went down due to a MySQL query issue and I'm desperate for help. I've got a complex query that's causing a deadlock, anyone got experience with these kinds of issues and can point me in the right direction?"
 

Liza96

New member
Joined
Apr 12, 2011
Messages
2
Reaction score
0
"Lol, don't know how you're still using MySQL , maybe an upgrade to MariaDB or Percona would help? Can you post the query that's causing the crash, I'd be happy to take a look and offer some help!"
 

gatto

New member
Joined
Sep 18, 2006
Messages
3
Reaction score
0
"Lol what's goin on with your website bro? Can you give us a bit more info about the MySQL query issue? Usually I see this kinda thing happen when the query is too complex or there's a resource leak"
 

pasik

Member
Joined
Jul 11, 2007
Messages
5
Reaction score
0
"Dude, I had a similar issue with my node running MariaDB. Try disabling query cache and see if it fixes the problem. Also, check your error logs to see if there's any clue about what's causing the crash."
 

fgs1fd8583bf6jq

New member
Joined
Jun 12, 2014
Messages
4
Reaction score
0
"Dude, have you tried increasing your max_allowed_packet limit in MySQL? I had a similar issue a few months ago and that solved it for me. Also, check your database logs for any errors that might point to the problem."
 
Top