Post-server move thread

I'm going to try some more stuff tonight when there are less people on, but the forum will be unavailable for about half an hour or so. Heads up =o

All done, that should hopefully be the end of the freezing ._.

[edit] added italics on hopefully ._.

Eh, the problem here is memory ._.

Innodb helps somewhat with locking since it doesn't lock a whole database table when reading / writing, only the row, but it is more memory intensive. RMRK currently runs on the essential VPS with 768 MB guaranteed ram. If a few people felt like subscribing I would put it into going to the next package up (Essential+). That'd give this box 256MB more guaranteed RAM, which I could give to MySQL to make it behave better ._.

I'll try to see what I can do once I've got some money in. Hopefully some of you rich kids will help out, especially if it's slow loading for you.

In the meantime, minor thing I've noticed: the icons along the side of the threads no longer show whether you've already posted in that particular thread or not. Not an important feature by any means, but wanted to point it out just as well. Also, five most recent posts are out again, though I think that's because of the maintenance from last night.

Page loaded in 0.22 seconds with 19 queries, everything is much faster now!

I'll try to see what I can do once I've got some money in. Hopefully some of you rich kids will help out, especially if it's slow loading for you.

In the meantime, minor thing I've noticed: the icons along the side of the threads no longer show whether you've already posted in that particular thread or not. Not an important feature by any means, but wanted to point it out just as well. Also, five most recent posts are out again, though I think that's because of the maintenance from last night.

Participation icons are a rather expensive thing to display, the forum must check if you've posted in each topic. Though they're disabled for now, it doesn't interfere with the "unread replies" link.

The recent posts on the index aren't as expensive, but since the index is by far the most hit page, their resource usage adds up. Will see how we go

I'd like my super revolutionary breakthrough product now

I also would like my breakthrough product

Two more of us and we can go signature =o 

I did it.

Guess what I did?

It was super, revolutionary, breakthrough and... er... product.

Don't have PayPal
Or money

ohhh Does this mean we can go signature now? or are we just gonna go + and save the excess for lean months? 

What if I payed through MOL, Roph?

Spoiler for:

https://www.mol.com/v5/en/Default.aspx

I just asked them to upgrade this server =o

I've never heard of mol ._.

I just asked them to upgrade this server =o

I've never heard of mol ._.

MOL is kinda off a way for Southeast Asian people to
buy MMORPG cash. But.. There is PayByCash.com
whom I don't know if I can transfer money from there
to paypal. ._.

Server upgraded (currently Essential+ now), I've given a chunk of the ~256MB extra RAM to various mysql caches and pools. Let's see how it works =o

As always please post any huge load times =o

Well I can't say whether the freezing is totally gone yet since this isn't a peak period, but I'm liking how things look so far database-wise.

It may have been because of the server being upgraded or something like that.
But I thought I'd let you know that RMRK was completely inaccessible for me about an hour ago.

Yeah it had to go down for a while for the upgrade =o

If you noticed that freeze just now it's nothing to worry about, was just getting a backup =o

ohhh Does this mean we can go signature now? or are we just gonna go + and save the excess for lean months? 

People only did it one off, not recurring, so signature is a bit out of reach.

I'm bumping this thread cause I've just upgraded from MySQL 5.1 to 5.5. I know that sounds like I was stupidly oudated, but 5.2, 5.3 and 5.4 don't actually exist. I've also fiddled with some more settings.

RMRK has been mostly lock-free, though it has still happened or been reported to me a few times here and there, which is more than the zero times that I'd like.

If you encounter any locking (page loads of 10+ seconds, though subsequent loads are fine) please let me know, and any info like when it happened, what you were trying to load etc helps

I was replying in the How did you come up with your username? thread, and the page took around 90 seconds to actually reply.

Although, even though I testify that it took around 90 seconds, the info at the bottom of the page contradicts me.

I had this one just a moment ago:

   
Page created in 13.993 seconds with 10 queries.

It actually took a lot longer than that. I'd say at least about a minute. So even the information being given back isn't quite so accurate.

Page created in 11.358 seconds with 21 queries.

Which is funny because the page loaded instantly.