What happened ?

Why was there no news on http://www.priorweb.be/nieuws.php ?

:banana: Glad it is back !

mysql probs chez priorweb

indeed
mysql problem :(
server was looping due a serious mysql flood

Everythink back to normal !

How is such a mysql flood problem caused ?

Thanks Tom & Cedric @ Priorweb for fixing the forumsproblems this fast! :ws: :ws:

it was like what? 10-15min? awesome support!

a badly writing script on one of the hosted websites that gets stuck into a loop and causes the mysql server to be flooded with requests in such a way that in becomes impossible to generate the outputs in a timely fashion, thereby slowing down to a crawl and affecting all the sites that use that mysql server

How do you find the site that has the badly written script ?

Looks like finding a needle in a haystack.

every site has its username/password to login to the mysql server
you can check what user is using the most resources :)

that's why we are on a dedicated server now :grin:

http://www.tomshardware.com/

We are not alone !

EDIT ==> toms HW was off for an hour or two ... of course it's back on now

loading kinda slow =)

some mysql stats :p

1.56 Million Queries ?

Correct :)

that's not half bad :)
any other sites @ Priorweb running these sort of stats?

nope :p

Global = 25MQ or 25GB SQL Traffic a day

http://priorweb.be/mysqlstat/mysqlstat.cgi

once we top 250k visits/day we will play catch up ;)

250k visits / day = 2GB Ram or an extra server for MySQL :D

Crazy people :D

the site code has been changed a bit, and HTTP compression has been enabled.

How's the speed of the site? www.madshrimps.be

Very fast john;)

I notice a huge difference when http compression is enabled! :)

news icon any good?

Good idea !

/me don't realy like it.
It's a bit too busy, but I'll probably get used to it and apreciate it later :D

I'm trying out some things to make news easier to read, with a little help of RichBastard it may become very easy.. sort of like at www.hwbot.org

with small icons now I can make them group, where you click on an icon you get a list of the last 30 news item in that category.. or something similar.. still pondering:)

webserver seems to be under heavy CPU load = slow forum&site

Server Load Averages 21.03, 20.10, 19.91

i noticed

seems to be resolved:)
Server Load Averages 0.91, 10.27, 15.83

jep, now its *bliksemsnel* (as fast as lightening ???)

the last few days the website and forum were quite unresponsive -- Cedric from www.Priorweb.be tracked down a php script leak on one of the madshrimps subdomains and the issue has been resolved. The site is back to full speed

We have invested quite a bit of money to speed the site up, we bought a new 1U dedicated server which is now being hosted next to our current 2U unit at the hosting company we are extremely satisfied with: www.priorweb.be

Our older 2U server is a P4 2.4Ghz with 1GB RAM and 2x40GB PATA disks in RAID-1. The last couple of months we have noticed several slowdowns which are caused by the increased traffic to our site. In order to grow and keep the site quick we had to do something, either upgrade our current server, or start from scratch. Finding a fitting CPU for the 2U server was not an easy task, and in the end the cost would not have been worth the speed increase. Instead we opted to buy a new machine, this baby:



A 1U server case with Dual Xeon 3.4Ghz and 2GB; a 3-Ware controller puts two 80GB SATA drives into RAID-1. Powered on, with the fans running at full speed we're getting over 70dBA at 60cm... not a silent machine ;)

The current server will keep running Apache & Webservice, the new one will be dedicated mysql server. I have now moved the website database to the new server and you should notice a speed improvement already, the site loads quicker, and now the 2U server has more resources, and so the forum loads quicker too. This week the forum will be moved over too (no data will be lost *normally*).

Please report any bugs or errors you encounter and we'll try to sort them out ASAP.

the forum database is currently being moved to the new server; so I have either the option to close the forums during the move, or face the fact that some posts will be lost after the move. It started at approx 14:00 GMT+1, can take a while (forum dbase over 600Mb at time of writing)

dunno if its done but it's really fast now

forum has not moved yet; only the site for now

forum move is scheduled for this Friday before noon (GMT+1), the forum will be offline during the move to prevent data loss

forum move has been done a day early, database now running on the new Xeon Dual CPU server

:super:

a PHP script caching engine has been running on the site for last 3 days, anybody notice a speed increase? :)