K_N

I'm working on getting a new server ready. This one is tiny and weak. In around 9-10 days the new one should be online and ready to go, then I'll just have to make a copy of everything here, drop it over there and switch the domain name over and it'll be nice and fast.

Those kind of bans are generally reserved for literal spam accounts - ones that sell pills and stuff. So they keep trying to post about their pills and whatever for sale and don't register a new account because they think their ads are working and everyone can definitely see them.

KK, just PM me with them when you have em.

The site is cached by Cloudflare. If you need the cache purged just let me know.

I mean, technically since we have root control over the server I can ban entire countries, continents or ISPs. I doubt we'll do that.

Same thing as a shadowban basically. The account holder doesn't know it but none of their content is visible to anyone else.

Technically all of the above and more. Whether or not they'll be used is up to mr. admin.

Have it pre-ordered to arrive Saturday. Pokemon games are literally the only thing I pre-order.

Bandwidth is fine, the problem is actually the CPU usage. Forums like this are super high in database calls which spikes the CPU big time. I've already upgraded this virtual server to the best my provider offers, but unfortunately they don't offer much, so I'm in the midst of finding better hardware to put us on. As for paying, I'm fine. I mean it's always welcome, but I don't necessarily need any - plus i dunno what luuv/admin wants on his site - I offered to do this for free anyways. We just haven't moved anything yet because I'm trying to make sure the hardware I move us on to will actually support us before I do all the work moving things over.

I updated something that should make it way faster now.

Update: I installed a caching system for PHP Bytecode (I don't expect anyone to know what that means). Forum go faster.

Two licenses.

It's okay you get a tax certificate.

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.

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.

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

Do you not know what MariaDB is? It's a dropin fork of MySQL to free it from Oracle...

Because this software was made before Hadoop was invented.

Here's the deal: As far as decent forum software goes, there's not a lot that's actively developed anymore. SMF kinda sucks, but it kinda sucks the least. One of the problems it has, is scaling issues - meaning the more people using it, the slower it gets. Until they update it to be usable with the newest version of PHP (the programming language it's made in) it's pretty taxing on a server. All I can do to mitigate the speed is throw more money at it and give us more RAM/CPU speed.

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.

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.

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.

If you want better hosting you gotta pay me.