[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

MySQL+openbsd high traffic server



I know that this is beaten to death.
I  have read many articles about that.
I have searched google to death.
I am not a newbie with databases but not an expert in Mysql.

Mysql Ver 11.18 Distrib 3.23.57 build from packages/ports.

I personaly use a real RDBMS and I dont like mysql but:
I need to create in this box a mysql server as stable as it gets in an
openbsd 3.4 stable
box. I wanna try to not have any linux box in the network.
I do not like to have a linux box just for mysql:( I like Openbsd..

Is there any guide or someone with experience to have all the parameters and
options to do that?
sysctl changes and kernel tuning?( kern.maxfiles=8192 already... and most
things I have grabed from
posts in lists after I searched google). Anything else that helps?
Plus can anyone post a my.cnf optimized for a high traffic mysql that runs
in openbsd?
The default exmples didnt work for me...
That will be a great help indeed.
Is better to include php and mysql build in apache support in openbsd and
how?
I have found many recources but nothing clear.
Even the Mysql's site openbsd notes reffered to Openbsd 2.8 till now..
I have running mysql in the server 3-4 weeks now and I have the "clasic" bad
file descriptor
problem every couple of days again. (I think mysql works better in Openbsd
3.4
so I think may be I have not made the right configuration.Not uses much
memory, runs
smooth and fast, dont crash till now in about 3 weeks in high traffic)
I make some hard links to the default socket every time the mysql server
starts as I need mysql
in apache(chroot)+ postfix(chroot)+ postfix virtual (not chroot) is there a
possibility the bad descriptor
problem to come with that?
Tables from databases needs repair very often.... I must do a
repair/optimize
table thing in whole databases sometimes to restart mysql after the "BAd
file descriptor problem".

Is there a way to make the sql server work in a server that runs 150+ sites
that need sql?
(Mainly forums and portals from 1000-9000 users)
Or I am loosing my time and I must set up  a Linux box for mysql use as I
was doing till now?

I want to give it a shot I do not want to give up so easily but I am
stocked.
I want the linux mysql performance in an Openbsd box no matter what:)
Any help will be apreciated.

Regards,

Chris