FreeBSD + MySQL tuning

RT Users
1

We’re currently running 2.0.15 with PostgreSQL, and I’ve spent a fair bit of
time tuning and optimizing this system.

For various reasons, we’re moving over to MySQL when we change to 3.0
(hopefully as of 3.0.4). However, I’ve been unable to find the wealth of
documentation on tuning a MySQL server that I could find with PGSQL.

Does anyone have any pointers to any performance tuning? I’ve read some
minor docs which essentially suggest using linuxthreads, but other than
that, I’ve yet to find anything worthwhile.

TIA…

2

We’re currently running 2.0.15 with PostgreSQL, and I’ve spent a fair bit of
time tuning and optimizing this system.

For various reasons, we’re moving over to MySQL when we change to 3.0
(hopefully as of 3.0.4). However, I’ve been unable to find the wealth of
documentation on tuning a MySQL server that I could find with PGSQL.

Does anyone have any pointers to any performance tuning? I’ve read some
minor docs which essentially suggest using linuxthreads, but other than
that, I’ve yet to find anything worthwhile.

  1. There are issues with threads and freebsd
  2. Jeremy Zawodny has a bunch of good material on the web. Google should
    help.

TIA…

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

3

Thus spake Jesse Vincent (jesse@bestpractical.com) [11/07/03 21:37]:

  1. There are issues with threads and freebsd

Everything that I’ve read has said that FreeBSD works fine using
linuxthreads. Just make sure that you use linuxthreads, and versions of
MySQL in the 4.x range, and you should be okay.

I haven’t tested this yet, I’ve just read it.

  1. Jeremy Zawodny has a bunch of good material on the web. Google should
    help.

Excellent, thanks. I’ll start googling.