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?

once every 17 years

ASk for more connections.

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

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.

depends who your programmer is.. no more comments

Incorrect.

which flavor of linux do you prefer/recommend?

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!

hardly ever

that sucks, choose your hosts carefully

Yup time to move :glugglug

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.

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.

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 :)

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 :)

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

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

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.

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 :2 cents:

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

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

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

Just my :2 cents:

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

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

Gonna move to a dedicated server this week... :)

non ever!

think of changing u'r host?

agreed.

:1orglaugh