MySQL and FreeBSD native threads

Justin Bastedo justin.bastedo at gmail.com
Sat Jan 14 16:08:31 PST 2006


I've been using MySQL 5 now for about 6 months in a productin
environment and haven't had any problems. Our co-located master server
replicates to an inhouse slave. and neither has given us any problems.

Uptime: 6355651 Threads: 2 Questions: 143125480 Slow queries: 0 Opens:
0 Flush tables: 2 Open tables: 55 Queries per second avg: 22.519

>uptime
 5:42PM  up 129 days,  4:17, 1 user, load averages: 0.03, 0.03, 0.00

seeing a mild load, nothing too heavy, and mainly inserts and selects
and has been really stable.

Justin

On 1/14/06, Michael Bowerman <michael.bowerman at gmail.com> wrote:
> A while ago, I was planning to move my MySQL server over from Linux to
> FreeBSD.  But, I was scared off by some blogs and the MySQL website
> that said that FreeBSD threading had some problems dealing with high
> loads, since some calls were not threadsafe.
>
> So, my question is this: has FreeBSD threading improved since the 4.x
> line?  It seems to me like a lot of work has gone into this area since
> then.  But, I haven't been able to find any updated information on 5.x
> and 6.x.
>
> I'm trying to move completely to FreeBSD on my home network.  So, I'd
> prefer to make the switch.
>
> My server has a very small load and the data isn't exactly mission
> critical (simple web stuff).  So, even with the threading problem, it
> would probably still meet my needs.  But, it's mostly a matter of
> worry free life cycle.  I don't like to spend a lot of time on
> maintenance (or wondering if it's my code, or the server), except for
> upgrades.
>
> Thanks for your thoughts,
> Mike
> _______________________________________________
> freebsd-database at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-database
> To unsubscribe, send any mail to "freebsd-database-unsubscribe at freebsd.org"
>


--
Justin Bastedo At Gmail Dot Com
--------------------------------------------------
http://www.thebastedo.com


More information about the freebsd-database mailing list