Jump to content
UnevenEdge

about half of the time the boards load for me and half the time they don't


Recommended Posts

Posted

sometimes when i click a subforum it works and othertimes it just spins and gives me a 500 error

 

It is more of a Bandwidth issue that is causing this, it seems to also happen when there is more than 25 Logged in users that the WHOLE BOARD goes down.

Posted

what is this hosted on? a peanut?

It's hosted on a quad core xeon with 3GB of RAM on dual NIC 1 TB uplinks.

 

SMF has some database scaling issues and they either need to be found and fixed or I need more RAM.

Posted

It's hosted on a quad core xeon with 3GB of RAM on dual NIC 1 TB uplinks.

 

SMF has some database scaling issues and they either need to be found and fixed or I need more RAM.

 

unless you're using a certain DB platform, i'm not sure how much i could help

Posted

unless you're using a certain DB platform, i'm not sure how much i could help

It's MariaDB.

 

The problem isn't the database itself though, it's SMF's non-scaling queries.

 

For another $12 a month or so I could put another 3GB in this and just deal with it though.

Posted

I would love to be using PHP 7's interpreter or HHVM, but SMF is not PHP7 ready yet, so we're stuck on 5.6's slower single-core bullshit.

Posted

It's MariaDB.

 

The problem isn't the database itself though, it's SMF's non-scaling queries.

 

For another $12 a month or so I could put another 3GB in this and just deal with it though.

 

MariaDB? why is this using a RDBMS? this could probably just run on Hadoop or something

Posted

MariaDB? why is this using a RDBMS? this could probably just run on Hadoop or something

Because this software was made before Hadoop was invented.
Posted

b..but MariaDB first came out in 2009 and Hadoop was 2006....either way doesn't really matter it is what it is

Do you not know what MariaDB is?

 

It's a dropin fork of MySQL to free it from Oracle...

Posted

Do you not know what MariaDB is?

 

It's a dropin fork of MySQL to free it from Oracle...

 

i know what MariaDB is. the MariaDB project didn't come around until 2009. unless this place is old enough to have started on actual MySQL and then moved over to Maria in which case ok

Posted

i know what MariaDB is. the MariaDB project didn't come around until 2009. unless this place is old enough to have started on actual MySQL in which case ok

SMF is ancient. The first unofficial release was in 2003.
Posted

Like, there's no difference between MariaDB and MySQL as far as anything running in PHP is concerned. It all just uses the mysqli API.

Posted

SMF is ancient. The first unofficial release was in 2003.

 

then ok, it migrated to Maria at a later point, probably after Sun bought out MySQL and Oracle bought out Sun, which is fine. big data wasn't really a thing until like 2012 anyway

Posted

then ok, it migrated to Maria at a later point, probably after Sun bought out MySQL and Oracle bought out Sun, which is fine. big data wasn't really a thing until like 2012 anyway

No, nothing "migrates" to MariaDB.

 

MariaDB is literally a drop in for MySQL. It's API compatible. It's purpose is so you can use MySQL applications without having to deal with Oracle.

 

SMF is a MySQL application. I'm running it on MariaDB.

Posted

No, nothing "migrates" to MariaDB.

 

MariaDB is literally a drop in for MySQL. It's API compatible. It's purpose is so you can use MySQL applications without having to deal with Oracle.

 

SMF is a MySQL application. I'm running it on MariaDB.

 

but dealing with Oracle is great...shit now i have to license my post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...