how often does your MySql go down? - GoFuckYourself.com

Pharrell · 07-28-2003, 08:05 PM

its been down for an hour ever day for the last week.

is this shit common with all virtual hosting plans?

07-28-2003, 08:05 PM

once every 17 years

Dirty F · 07-28-2003, 08:06 PM

ASk for more connections.

Juicy D. Links · 07-28-2003, 08:07 PM

Never gone down for me I think your host setup is messed up if its going down all the time

Backov · 07-28-2003, 08:08 PM

It also has a tendency to crash if you have heavy volume of INSERT/DELETE transactions and are running MySQL 4.7.xxx (anything before 5.0).

The solution - Linux.

It fragments the hell out of its process memory space on FBSD and Linux has better thread support so doesn't have this issue.

If you're running FreeBSD this may be your issue.

muchmoreporn · 07-28-2003, 08:09 PM

depends who your programmer is.. no more comments

nxventures · 07-28-2003, 08:11 PM

Quote:

Originally posted by muchmoreporn
depends who your programmer is.. no more comments

Incorrect.

TheJimmy · 07-28-2003, 08:14 PM

Quote:

Originally posted by Backov
It also has a tendency to crash if you have heavy volume of INSERT/DELETE transactions and are running MySQL 4.7.xxx (anything before 5.0).

The solution - Linux.

It fragments the hell out of its process memory space on FBSD and Linux has better thread support so doesn't have this issue.

If you're running FreeBSD this may be your issue.

which flavor of linux do you prefer/recommend?

muchmoreporn · 07-28-2003, 08:14 PM

I never have a problem with mine but once I had a programmer that i paid to do some work for me and everything was fucking up every few mins, way too many resources was being used, he claimed it was not his fault, paid him for this job, i got pissed deleted the fucking site and nevered talked to him since, moved my sites from my host, was a huge mess over a project i was trying to make big, and just said fuck it

Pharrell · 07-28-2003, 08:34 PM

Quote:

Originally posted by muchmoreporn
I never have a problem with mine but once I had a programmer that i paid to do some work for me and everything was fucking up every few mins, way too many resources was being used, he claimed it was not his fault, paid him for this job, i got pissed deleted the fucking site and nevered talked to him since, moved my sites from my host, was a huge mess over a project i was trying to make big, and just said fuck it

I am in that position right now!

foe · 07-28-2003, 08:36 PM

hardly ever

foe · 07-28-2003, 08:37 PM

Quote:

Originally posted by muchmoreporn
I never have a problem with mine but once I had a programmer that i paid to do some work for me and everything was fucking up every few mins, way too many resources was being used, he claimed it was not his fault, paid him for this job, i got pissed deleted the fucking site and nevered talked to him since, moved my sites from my host, was a huge mess over a project i was trying to make big, and just said fuck it

that sucks, choose your hosts carefully

Spunky · 07-28-2003, 08:38 PM

Yup time to move

icedemon · 07-28-2003, 08:42 PM

It depends on several things. The way that MySQL is setup. The way the databases are setup. The way the programs access MySQL. The operating system and the computer that it's on. If MySQL is accessed too much at once and not setup right, it'll be down alot.

Arty · 07-28-2003, 08:56 PM

Quote:

Originally posted by Pharrell
its been down for an hour ever day for the last week.

is this shit common with all virtual hosting plans?

What do you mean by down? Causes for that might be different depending on the error... One of the causes might be open connections if that has a small limit especially if the persistent connection used by clients and left open.

pudcat · 07-28-2003, 08:56 PM

what type of errors are you getting? when I've had errors on virtual hosting plans it's always been that it's got too many open connections, ask the server admin to bump it up a bit and it should be sweet...

of course if you're getting some other type of errors then I can't help without the error message

jennycards · 07-28-2003, 11:13 PM

On Linux it is important to have enough RAM. When the OS starts swapping to the harddrive mysql tends to die.

Make you RAM as big as your prick

PbG · 07-28-2003, 11:27 PM

hmmn did'nt know it could go down . . .

Quote:

Originally posted by Pharrell
its been down for an hour ever day for the last week.

is this shit common with all virtual hosting plans?

SYNIKAL · 07-28-2003, 11:39 PM

Should never be down if you got a quality host....

PrettyCarla · 07-29-2003, 12:40 AM

I have bad experiences running MySQL on large web servers with high transfer. There has to be some bug causing that sometimes one (random) table gets corrupted. It can be usually corrected with REPAIR TABLE but is difficult to find it if you are not familiar with your application.

ServerGenius · 07-29-2003, 12:52 AM

lower the idle time-out settings.....they're default redigolous high.
Set it to 60 seconds....this will dramatically lower the amount of
idle threads so with the same amount of threads you'll be able
to process a shitload more queries because threads don't keep
lingering around doing nothing.

DynaMite

ServerGenius · 07-29-2003, 12:58 AM

You can check on your mysql server by connecting through the
shell with the mysql client.

show processlist;

shows you processes you're mysql server is handling......here
you can see how many idle requests are lingering around and
for how long.....you'll see they stick around VERY long meaning
at that point they're not able to take new queries. This is the
most common reason while mysql runs out of processes and
crashes.......increasing the amount of concurent threads helps
but actually you're not solving the problem.....you just give the
problem more space before it becomes critical and you're wasting
valuable system resources..

status;

shows you the status of the mysql server and gives you some
stats info on what's going on...

DynaMite

fris · 07-29-2003, 12:59 AM

the only time shit breaks on your server is if you are a clueless admin, end of story.

xzoom · 07-29-2003, 01:00 AM

Quote:

Originally posted by Pharrell
its been down for an hour ever day for the last week.

is this shit common with all virtual hosting plans?

MySql has never gone down! Maybe it's because I'm on a dedicated server....

Just my

blazin · 07-29-2003, 01:13 AM

Never had problems on dedicated with any of my mainstream applications - except for my client that insists on using Win NT

However I have recently experienced problems on a virtual account I have ( failing to connect )

Gonna move to a dedicated server this week...

tiger74 · 07-30-2003, 01:33 AM

non ever!

think of changing u'r host?

tiger74 · 07-30-2003, 01:37 AM

Quote:

Originally posted by Arty

What do you mean by down? Causes for that might be different depending on the error... One of the causes might be open connections if that has a small limit especially if the persistent connection used by clients and left open.

agreed.

Mr.Fiction · 07-30-2003, 01:40 AM

Quote:

Originally posted by fris
the only time shit breaks on your server is if you are a clueless admin, end of story.

07-28-2003, 08:05 PM	#1
Pharrell Registered User Join Date: Nov 2002 Posts: 63	how often does your MySql go down? its been down for an hour ever day for the last week. is this shit common with all virtual hosting plans?

07-28-2003, 08:08 PM	#5
Backov Confirmed User Join Date: Mar 2001 Location: Cat Detector Van Posts: 1,600	It also has a tendency to crash if you have heavy volume of INSERT/DELETE transactions and are running MySQL 4.7.xxx (anything before 5.0). The solution - Linux. It fragments the hell out of its process memory space on FBSD and Linux has better thread support so doesn't have this issue. If you're running FreeBSD this may be your issue. __________________ <embed src="http://banners.spotbrokers.com/button.swf" FlashVars="clickURL=http://banners.spotbrokers.com" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="120" height="60"></embed>

07-28-2003, 08:09 PM	#6
muchmoreporn Confirmed User Join Date: Mar 2002 Location: Canada Posts: 784	depends who your programmer is.. no more comments __________________ SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

07-28-2003, 08:14 PM	#9
muchmoreporn Confirmed User Join Date: Mar 2002 Location: Canada Posts: 784	I never have a problem with mine but once I had a programmer that i paid to do some work for me and everything was fucking up every few mins, way too many resources was being used, he claimed it was not his fault, paid him for this job, i got pissed deleted the fucking site and nevered talked to him since, moved my sites from my host, was a huge mess over a project i was trying to make big, and just said fuck it __________________ SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

07-28-2003, 08:38 PM	#13
Spunky I need a beer Industry Role: Join Date: Jun 2002 Location: ♠ Toiletville ♠ Posts: 133,987	Yup time to move __________________ *YOUR INFORMATION HERE*

07-28-2003, 08:05 PM	#2
buddyjuf Guest Posts: n/a	once every 17 years

07-28-2003, 08:06 PM	#3
Dirty F Too lazy to set a custom title Industry Role: Join Date: Jul 2001 Posts: 59,204	ASk for more connections.

07-28-2003, 08:07 PM	#4
Juicy D. Links So Fucking Banned Industry Role: Join Date: Apr 2001 Location: N.Y. -Long Island -- Posts: 122,992	Never gone down for me I think your host setup is messed up if its going down all the time

07-28-2003, 08:36 PM	#11
foe Confirmed User Join Date: May 2002 Location: CT Posts: 5,246	hardly ever

07-28-2003, 08:42 PM	#14
icedemon Confirmed User Join Date: Jun 2003 Location: Lutz, FL Posts: 1,022	It depends on several things. The way that MySQL is setup. The way the databases are setup. The way the programs access MySQL. The operating system and the computer that it's on. If MySQL is accessed too much at once and not setup right, it'll be down alot. __________________ Clips4Sale.com

07-28-2003, 08:56 PM	#16
pudcat Confirmed User Join Date: Mar 2003 Posts: 1,169	what type of errors are you getting? when I've had errors on virtual hosting plans it's always been that it's got too many open connections, ask the server admin to bump it up a bit and it should be sweet... of course if you're getting some other type of errors then I can't help without the error message

07-28-2003, 11:13 PM	#17
jennycards Confirmed User Join Date: Feb 2002 Location: European Union Posts: 1,124	On Linux it is important to have enough RAM. When the OS starts swapping to the harddrive mysql tends to die. Make you RAM as big as your prick __________________ Make Money with true niche programs like Adult ECards - Pantyhose Fetish - Men in Pantyhose

07-28-2003, 11:39 PM	#19
SYNIKAL Confirmed User Join Date: Feb 2003 Posts: 1,795	Should never be down if you got a quality host.... __________________ ...........

07-29-2003, 12:40 AM	#20
PrettyCarla Confirmed User Join Date: Dec 2002 Posts: 144	I have bad experiences running MySQL on large web servers with high transfer. There has to be some bug causing that sometimes one (random) table gets corrupted. It can be usually corrected with REPAIR TABLE but is difficult to find it if you are not familiar with your application.

07-29-2003, 12:52 AM	#21
ServerGenius Confirmed User Join Date: Feb 2002 Location: Amsterdam Posts: 9,377	lower the idle time-out settings.....they're default redigolous high. Set it to 60 seconds....this will dramatically lower the amount of idle threads so with the same amount of threads you'll be able to process a shitload more queries because threads don't keep lingering around doing nothing. DynaMite __________________ \| http://www.sinnerscash.com/ \| ICQ: 370820 \| Skype: SinnersCash \| AdultWhosWho \|

07-29-2003, 12:58 AM	#22
ServerGenius Confirmed User Join Date: Feb 2002 Location: Amsterdam Posts: 9,377	You can check on your mysql server by connecting through the shell with the mysql client. show processlist; shows you processes you're mysql server is handling......here you can see how many idle requests are lingering around and for how long.....you'll see they stick around VERY long meaning at that point they're not able to take new queries. This is the most common reason while mysql runs out of processes and crashes.......increasing the amount of concurent threads helps but actually you're not solving the problem.....you just give the problem more space before it becomes critical and you're wasting valuable system resources.. status; shows you the status of the mysql server and gives you some stats info on what's going on... DynaMite __________________ \| http://www.sinnerscash.com/ \| ICQ: 370820 \| Skype: SinnersCash \| AdultWhosWho \|

07-29-2003, 12:59 AM	#23
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,571	the only time shit breaks on your server is if you are a clueless admin, end of story. __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. My Cam Feeds Script / Gallery Scraper / WPXXX Theme / Free Templates

07-29-2003, 01:13 AM	#25
blazin Confirmed User Join Date: Aug 2002 Posts: 2,781	Never had problems on dedicated with any of my mainstream applications - except for my client that insists on using Win NT However I have recently experienced problems on a virtual account I have ( failing to connect ) Gonna move to a dedicated server this week...

07-30-2003, 01:33 AM	#26
tiger74 Confirmed User Join Date: May 2003 Location: on the islands. Posts: 308	non ever! think of changing u'r host? __________________