MyBB Requests

More of an MySQL help thread then mybb

Submitted by Blowjob, , Thread ID: 2764

Thread Closed
Blowjob
Closed Account
Level:
0
Reputation:
26
Posts:
2.16K
Likes:
189
Credits:
2.53K
12-04-2015, 08:24 AM
This post was last modified: 12-04-2015, 08:29 AM by Blowjob
#1
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 Smile


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

RE: More of an MySQL help thread then mybb

Tropical
Fulltime Member
Level:
0
Reputation:
35
Posts:
1.04K
Likes:
54
Credits:
117
12-04-2015, 08:58 AM
#2
I kept seeing that error like every time you refreshed on FB
Wonder why this keeps popping up? :noh:
Blocking Spotify Advertisements

YouTube

RE: More of an MySQL help thread then mybb

Blowjob
Closed Account
Level:
0
Reputation:
26
Posts:
2.16K
Likes:
189
Credits:
2.53K
OP
12-04-2015, 08:59 AM
#3
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.

RE: More of an MySQL help thread then mybb

Sozin
Nan Ihier Gelair Mordor
Divine
Level:
0
Reputation:
91
Posts:
2.33K
Likes:
375
Credits:
11K
12-04-2015, 09:02 AM
#4
If you using InnoDB, try changing to MyISAM
Do not let your difficulties fill you with anxiety, after all it is only in the darkest nights that stars shine more brightly. - Ali(a.s)

Developer( PHP, Python, C++, HTML+CSS, JS I am available for Hire. Message Me for details.

1
Tropical

RE: More of an MySQL help thread then mybb

Blowjob
Closed Account
Level:
0
Reputation:
26
Posts:
2.16K
Likes:
189
Credits:
2.53K
OP
12-04-2015, 09:07 AM
This post was last modified: 13-04-2015, 04:27 AM by Blowjob
#5
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

Users browsing this thread: 1 Guest(s)