Victory Road Archive

You are viewing an archive of Victory Road.

Victory Road closed on January 8, 2018. Thank you for making us a part of your lives since 2006! Please read this thread for details if you missed it.

Victory Road Network Support → Soooo... How 'Bout Those "MySQL Errors"

Page 1 of 1

1. FreezeWarp said on February 2, 2011, 03:13:14 PM (-08:00)

Kyurem
2,186 posts

No, seriously, getting a touch frustrated that just a week and a half ago (after the server move even) each of my projects was running great - and now each is encountering an increasing rate of MySQL connection errors. Even VRC somehow got worse.

...So, yeah, this is beyond my control nor is it in my power to change anything; will someone deal with this soon? You know, like, NOW?

Likes 2 – emperorempoleon2, Cat333Pokémon

2. Ningamer said on February 2, 2011, 03:16:25 PM (-08:00)

Giratina
3,415 posts

Do you guys actually know the source of the problem?

....If no...

Blame KYA.

3. JJ said on February 9, 2011, 07:15:17 PM (-08:00)

Charizard
127 posts

Just an idea, but why don't you change the server??

4. LiteTheIronMan said on February 9, 2011, 07:19:48 PM (-08:00)

Shaymin
2,854 posts

MySQL drops are the bane of my existence. They happen infrequently in the VRIM alpha and very frequently on VR. And it's beginning to make me want to go to the server host location and beat the machines operating it to death, then slap Cat and ICEE with a fish wrapped in newspaper obituaries.

Likes 4 – Shiny, randoguy101, emperorempoleon2, RK-9

5. Cat333Pokémon said on February 9, 2011, 10:59:06 PM (-08:00)

Administrator
10,307 posts

If I had to elect one thing that has put a hinderance on my outlook of 2010, this would be it. I have hated the server for nearly fourteen months now. It never worked right, and I honestly don't know what the best option is. Financially, moving is just way too expensive for me because moving hasn't seemed to take less than a week, and some hosts charge at the end of each month regardless of when you start your hosting. Currently, I pay $124 every month (with much of it recovered by advertising) for hosting. I really feel like I'm not getting my money's worth, either.

6. KingOfKYA said on February 10, 2011, 03:27:03 AM (-08:00)

Volcarona
523 posts

Am 1 week ago (looks at mine craft server). It uses 1GB of ram. Whats the exact error. I am really not on enof to see them. edit: nevermind

Turning it off right now see if problem goes away.

7. Ningamer said on February 10, 2011, 03:28:54 AM (-08:00)

Giratina
3,415 posts

Quote:
Originally Posted by KingOfKYA View Post
Am 1 week ago
Quote:
Originally Posted by KingOfKYA View Post
mine craft
Quote:
Originally Posted by KingOfKYA View Post
enof
No wonder we're getting so many errors.

Likes 9 – LiteTheIronMan, OMGITSJAD, Cat333Pokémon, randoguy101, Alakazamaster, AuraKshatriya, Shadow, Shiny, RK-9

8. randoguy101 said on February 10, 2011, 04:25:45 PM (-08:00)

Volcarona
688 posts

Quote:
Originally Posted by KingOfKYA View Post
Turning it off right now see if problem goes away.
This explains some things.

If the MC server really is a problem, we can always move back to Jared's IP, but I doubt it's the case as the site has been running as well as it did before you started hosting it.

Likes 2 – OMGITSJAD, JC

9. Cat333Pokémon said on February 10, 2011, 10:47:17 PM (-08:00)

Administrator
10,307 posts

I honestly doubt the Minecraft server is behind the MySQL errors. Minecraft doesn't use the databases or have much of an affect on anything other than where it resides.

10. KingOfKYA said on February 10, 2011, 11:38:34 PM (-08:00)

Volcarona
523 posts

if only it was as simple as that.^

I just fixed the mine craft issuse. Its not that it was using too much cpu or mem. its just we ran out of ram so the server was swaping.

Also freeze make sure on your vm you have mod_cache on but disabled for disk cashing, because disk I/O is the bottleneck we have on this server.
As well as set the sysctl variable vm.swappiness to 0 so the vms use swap as a last resort.
https://help.ubuntu.com/community/SwapFaq

Page 1 of 1

User List - Contact - Privacy Statement - Lycanroc.Net