SQL_BIG_SELECTS + One.com = Fail?

Unfortunately, Friendship-Bracelets.net went down a moment ago. I’m not exactly sure what I did but I’m sure it was me. I overloaded the MySQL server somehow.

I needed a long query for joining a LOT of tables in my new newsfeed implementation. I got an error from MySQL stating that my query was too long. Therefore I was suggested to run this query to enable longer queries.

SET SESSION SQL_BIG_SELECTS=1

I tried it locally on my computer and it went okay without any fuss. The error message because of long queries went away. I thought: Yay! and uploaded the new newsfeed app to the site and then POW:

User friendship_brac has already more than 'max_user_connections' active connections

What I learnt today? SQL_BIG_SELECTS shouldn’t be enabled on a One.com site with a lot of traffic.

Share Button

4 thoughts on “SQL_BIG_SELECTS + One.com = Fail?”

Leave a Reply

Your email address will not be published. Required fields are marked *


*