God Damn Database Error (1 Viewer)

SgtSlick

Member
Joined
Jul 29, 2002
Messages
202
Fuck me!! I swear to god, nearly 99 out of 100 times i click on a fucking link in these forums i get a fucking database fucking error!! ARGGGGHHHH. sorry guys i know it isnt ure fault but its sssooooo frutrating, i have to hit refresh about a million times. Today had been the worst day of it ever.

-SgtSlick :(
 
T

tactic

Guest
sorry.. we are trying..

but when nearly half a million pages are viewed per day it does strain the server
 

fatmuscle

Active Member
Joined
Jul 6, 2002
Messages
3,707
Location
Hornsby
Gender
Male
HSC
2001
when we get our new server (AFTER PEOPLE KINDLY DONATE TO US) we'll ahve a server t ourselves and no erros
 

BlackJack

Vertigo!
Joined
Sep 24, 2002
Messages
1,230
Location
15 m above the pavement
Gender
Male
HSC
2002
I'm wondering... If each error still sends an email... :rolleyes:, mightn't that have flooded the address the night after the english advanced exams (92 ppl clicking refresh)? Inbox must have swelled to 15000 or so...

Also, is the reason (in the other thread, suggestions) to the server sending a new page to the user every time, for the purposes of tracking??? The user tracking page updates every minute, and might lots of other functions be based on that (eg. updating number of posts, and code for saying 'this post has been edited on... which doesn't say if edited quickly)??
 

ben

Member
Joined
Jul 9, 2002
Messages
489
out of curiosity - what exactly in the maximum number of connections??

is it like 1 every 1 second or something??
 

BlackJack

Vertigo!
Joined
Sep 24, 2002
Messages
1,230
Location
15 m above the pavement
Gender
Male
HSC
2002
Let's use tactic's half a milllion page views... and explore into something I know nothing about...
average page view is ~5.787 pages a second. Peak hour flow might be 5 times that (conservative w/o limit), looking at the user number... so ~28.935 pages a second.
The largest page might be the index, 99.3kb when saved into drive.
The school section page aruond 77kb...
A full page thread 80kb w/ poll...
A thread w/ 2 posts 30kb...
The reply page is around 27 kb...

At peak hour, av. theoretic Flow could range from 781 ~ 2,865 kb/sec??? But with most users just viewing threads, the mean would be near the top end... 2,300... (assuming everything is reloaded from the server, everytime)
No wonder the server crashes...

1) Big THanx :) This forum is like a giant empire... hard to manage.
2) How'd you get this for free? :D The site's doin' pretty well, looking at the load.
 
T

tactic

Guest
mysql default is 100 connections
that means.. that a any given point in time there are 100mysql connections available

apache well i dont know its default.. but it has been reduced because it chews all the resources
 

ben

Member
Joined
Jul 9, 2002
Messages
489
100 mysql connections - wow and it still gets clogged

that's amazing! it doesn't feel like there are that many people around a time.. but i guess this server is sharing with other web sites?
 

blake

Member
Joined
Jul 26, 2002
Messages
143
Originally posted by SgtSlick
Fuck me!! I swear to god, nearly 99 out of 100 times i click on a fucking link in these forums i get a fucking database fucking error!! ARGGGGHHHH. sorry guys i know it isnt ure fault but its sssooooo frutrating, i have to hit refresh about a million times. Today had been the worst day of it ever.

 

saladsurgery

kicking the cack
Joined
Jul 26, 2002
Messages
943
Location
over there
Gender
Male
HSC
2002
Originally posted by fatmuscle
when we get our new server (AFTER PEOPLE KINDLY DONATE TO US) we'll ahve a server t ourselves and no erros
who's doing the donating?
you want my money?
you've found a sponsor?
we'll have dodgy javascript and popup traps?

bloody sterling effort fellas.

another not (wrong thread, but still): lazseeker aint working... the page is just coming up blank.


There seems to have been a slight problem with the Bored of Studies database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


goddamn those things... and so i click "Submit Reply" again.
and again...
and again...
and again...
and again...

(each "and again was an error... sorry guys, i know it's not your fault)
 

Lazarus

Retired
Joined
Jul 6, 2002
Messages
5,965
Location
CBD
Gender
Male
HSC
2001
LazSeeker will be up and down a bit over the next couple of days, should be fine after that.
 
Joined
Aug 10, 2002
Messages
193
but the problem is when ever one person access the site its hitting the database at lest 2+ times...

need to redesign the site!!!

and this vbulleting is known for killing mysql servers
 

saladsurgery

kicking the cack
Joined
Jul 26, 2002
Messages
943
Location
over there
Gender
Male
HSC
2002
hmmm.... you guy probably get one "damn database errors!!!" complaint for every 10 database errors... and as you're doing this in your own time, out of your own pockets, along with uni degrees, i for one agree with tactic (some other thread). thanks.
 

ben

Member
Joined
Jul 9, 2002
Messages
489
Originally posted by iptteacherssuck
but the problem is when ever one person access the site its hitting the database at lest 2+ times...

need to redesign the site!!!

and this vbulleting is known for killing mysql servers
is phpbb better than vbulletin in terms of clogging up mysql

it's just I need to set up a forum for this tour thing and I don't know what one to use on my server... thanks
 

wogboy

Terminator
Joined
Sep 2, 2002
Messages
653
Location
Sydney
Gender
Male
HSC
2002
Hey the database problem seems to have disappeared lately and the forums are working fine. Have you updated the server Laz?

P.S. I only hope I'm not speaking too soon.
 

sukiyaki

emptiness
Joined
Nov 9, 2002
Messages
1,505
Location
westie
Gender
Female
HSC
2003
Originally posted by saladsurgery
hmmm.... you guy probably get one "damn database errors!!!" complaint for every 10 database errors... and as you're doing this in your own time, out of your own pockets, along with uni degrees, i for one agree with tactic (some other thread). thanks.
yeh havent anyone though of it this one pplz actually took time to install the forums and manage the whole big site for the hsc students and in return they dont really asked for nothing?
and even pay for it too !



newaiz phpbb? i fink [froums] si good but the worst ones thats clogs up bandwidth is ironboard 0_o
 

Lazarus

Retired
Joined
Jul 6, 2002
Messages
5,965
Location
CBD
Gender
Male
HSC
2001
<img src=http://www.boredofstudies.org/mark/ouch.jpg>



<img src=http://www.boredofstudies.org/mark/ouch2.jpg>
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top