Notice: fwrite(): Write of 59 bytes failed with errno=28 No space left on device in /home/rmrk/domains/rmrk.net/public_html/Sources/Cache/APIs/FileBased.php on line 96

Notice: fwrite(): Write of 2000 bytes failed with errno=28 No space left on device in /home/rmrk/domains/rmrk.net/public_html/Sources/Cache/APIs/FileBased.php on line 96
Post-server move thread - Page 2
Main Menu

Post-server move thread

Started by Roph, February 26, 2012, 10:50:40 PM

0 Members and 2 Guests are viewing this topic.

Roph

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
[fright]bringing sexy back[/fright]

Roph

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

[edit] added italics on hopefully ._.
[fright]bringing sexy back[/fright]

Roph

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 ._.

[fright]bringing sexy back[/fright]

Zylos

#28
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.




IAMFORTE

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

Roph

Quote from: Zylos on March 02, 2012, 06:24:55 PM
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 :o
[fright]bringing sexy back[/fright]

Jules



I'd like my super revolutionary breakthrough product now :D

Holkeye

I also would like my breakthrough product :mad:

Jules

Two more of us and we can go signature =o  ^_^

haloOfTheSun

:tinysmile:

EvilM00s

Guess what I did?

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

pacdiggity

it's like a metaphor or something i don't know

Jules

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


AbsoluteIce

なんでやねん

Roph

I just asked them to upgrade this server =o

I've never heard of mol ._.
[fright]bringing sexy back[/fright]

AbsoluteIce

Quote from: Roph on March 03, 2012, 08:05:52 AM
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. ._.
なんでやねん

Roph

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
[fright]bringing sexy back[/fright]

Roph

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. :)
[fright]bringing sexy back[/fright]

D&P3

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.
All of my scripts are totally free to use for commercial use. You don't need to ask me for permission. I'm too lazy to update every single script post I ever made with this addendum. So ignore whatever "rule" I posted there. :)

All scripts can be found at: https://pastebin.com/u/diamondandplatinum3

Roph

Yeah it had to go down for a while for the upgrade =o
[fright]bringing sexy back[/fright]

Roph

If you noticed that freeze just now it's nothing to worry about, was just getting a backup =o
[fright]bringing sexy back[/fright]

Roph

Quote from: Julie on March 03, 2012, 12:02:53 AM
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. :mad:

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 :)
[fright]bringing sexy back[/fright]

D&P3

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.

All of my scripts are totally free to use for commercial use. You don't need to ask me for permission. I'm too lazy to update every single script post I ever made with this addendum. So ignore whatever "rule" I posted there. :)

All scripts can be found at: https://pastebin.com/u/diamondandplatinum3

LoganF

I had this one just a moment ago:

Quote
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.
(Why do I always feel like it's the end of the world and I'm the last man standing?)

Dwarra?

Page created in 11.358 seconds with 21 queries.

Which is funny because the page loaded instantly.