More of an MySQL help thread then mybb

Okay well eh..

MySQL is taking all the ram, we have 1GB

and it's werid because I've ran a forum with more people, more members and posts, and less ram and it has never done that.

So pretty much we get an error saying "Lost connection to MySQL server during query"

And I know thats all MySQL. I'm not sure what to do. I installed xcache and now it's using 3.75 MB on an average basis instead of 9MB.

But still-- what the hell?

It's on a VPS by the way.

nginx using php-fpm with mysql.

A complete list of my applications

My my.cnf (mysql config)

please help its very annoying and just werid..


(5.3.10-1ubuntu3.17)Ubuntu 12 (64bit) using MySQLi 5.5.41

---

@AmN @Aoki

Help me with this


http://i.imgur.com/SFGVn7y.png

I kept seeing that error like every time you refreshed on FB
Wonder why this keeps popping up? :noh:

12-04-2015, 08:58 AM

Tropical Wrote: I kept seeing that error like every time you refreshed on FB
Wonder why this keeps popping up? :noh:

:rly:I said why in the thread.

Some shit is going on with mysql, thus its eating all my ram, and i don't understand why because I've had a forum with more people/active guests with less ram no problem.

If you using InnoDB, try changing to MyISAM

12-04-2015, 09:02 AM

AmN Wrote: If you using InnoDB, try changing to MyISAM

Crap, I never looked to see what I was using (worry)

Changed it. Let's hope it worked.

---

so far it hasn't but then again, im not really trying lol.


Anyways I just found out that I'm not always thinking about everything, and forgot about installing something to get the real ip from the visitors instead of Cloudflare's IP.\
Fixed the cloudflare ip bug.

I'll update you if it keeps happening

---

This might have been the problem



Filesystem Size Used Avail Use% Mounted on
/dev/simfs 50G 50G 156K 100% /
none 512M 4.0K 512M 1% /dev
none 103M 1.1M 102M 1% /run
overflow 1.0M 0 1.0M 0% /tmp
none 5.0M 0 5.0M 0% /run/lock
none 512M 0 512M 0% /run/shm