Mysql server not able to stay running on anything but Linux?
NMH
drumslayer2 at yahoo.com
Wed Oct 12 15:12:42 PDT 2005
--- Justin Bastedo <justin.bastedo at gmail.com> wrote:
> Here at my work we are running a mysql 5.0 server on
> FreeBSD 5.4 using
> the AMD Dual Core 64 chips.
>
> current load is as follows:
> [MYSQL]
> Uptime: 1338832 Threads: 2 Questions: 15846788 Slow
> queries: 0 Opens:
> 0 Flush tables: 16 Open tables: 58 Queries per
> second avg: 11.836
>
> [FREEBSD TOP]
> last pid: 29924; load averages: 0.00, 0.00, 0.00
> up 35+01:59:20 16:24:01
> 49 processes: 1 running, 48 sleeping
> CPU states: 0.5% user, 0.0% nice, 0.5% system,
> 0.0% interrupt, 99.0% idle
> Mem: 156M Active, 1250M Inact, 176M Wired, 214M Buf,
> 2086M Free
> Swap: 2048M Total, 44K Used, 2048M Free
>
> Versions:
> >mysql -V
> mysql Ver 14.12 Distrib 5.0.12-beta, for
> portbld-freebsd5.4 (amd64) using 4.3
>
> >uname -a
> FreeBSD db 5.4-RELEASE-p7 FreeBSD 5.4-RELEASE-p7 #0:
> Wed Sep 7
> 14:12:34 CDT 2005
> user at db:/usr/obj/usr/src/sys/BLITZ4SMP amd64
>
>
> Our queries per second avg has been going up
> consistently and we have
> yet to have any problems. We haven't had any
> crashing though I can't
> quite say how the thread level is comparing to
> yours.
>
> I agree i would look into upgrading to 5.4-STABLE
> and see how that treats you.
>
> As far as my experience the only real advantages
> I've found that linux
> has over FreeBSD is the type of file systems. Some
> of the file systems
> they support may give better performance to
> particular types of table
> types, but that is more if you have a stable db
> server that is hitting
> a bottle neck.
>
> --
> Justin Bastedo At Gmail Dot Com
Hi Justin
Right now here are our stats.. As you can see.. we
beat it up pretty good.
[MYSQL]
Uptime: 174044 Threads: 396
Questions: 140154383 Slow queries: 16
Opens: 2622 Flush tables: 1 Open tables: 1189
Queries per second avg: 805.281
[FREEBSD TOP] (BSD 4.11-STABLE)
last pid: 40914; load averages: 0.65, 0.69, 0.74
436 processes: 5 running, 431 sleeping
CPU states: 0.5% user, 22.1% nice, 8.1% system,
0.4% interrupt, 69.4% idle
Mem: 483M Active, 3046M Inact, 291M Wired, 136M Cache
Buf, 6070K Free
Swap: 8192M Total, 68K Used, 8192M Free
NMH
The Large Print Giveth And The Small Print Taketh Away
-- Anon
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
More information about the freebsd-database
mailing list