Anders J wrote:
My self have experienced mixed issues with MysSQL on OpenBSD and also
read and heard about performance and stability problems with MySQL on
OpenBSD.
I use it for years (7+) without issues. The only one I recall was with
3.23.46, yeap, really old, where the database restart itself running out
of resources then, but that's really old stuff. I mean really old and
that was on OpenBSD 3.0 then. The only issue always been configurations
issues, like limits on tables, login.conf stuff, and the like.
So i'm a bit nervous implementing this on OpenBSD (Should i use FreeBSD
instead)?.
Use what you are comfortable with, but OpenBSD sure can do the job just
fine.
Has anyone a positive experience with 3.9+ MySQl
mysql-server-5.0.21.tgz
<ftp://ftp.sunet.se/pub/OpenBSD/3.9/packages/i386/mysql-server-5.0.21.tgz>(or
later)?
As stated above. No problem here and with plenty of mirror as well. Just
upgraded to 5.0.22 a few days ago (see below for some stats) in less
then a minute using pkg_add -u as well and restart MySQL. Really easy to
manage I tell you. I even have PF running on that box as well obviously
to protect it and the box is really efficient in resources I tell you.
Nothing wrong with it, use it as you see fit.
# uptime
3:53PM up 9 days, 10:34, 1 user, load averages: 0.21, 0.15, 0.14
# ps -auxw | grep mysql
_mysql 1794 4.2 17.6 441240 367056 ?? S 11Jun06 539:55.12
/usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/mysql
--user=_mysql --pid-file=/var/mysql/---.com.pid -
mysql> status;
--------------
mysql Ver 14.12 Distrib 5.0.22, for unknown-openbsd3.9 (i386) using
readline 4.3
Connection id: 879766
Current database:
Current user: [EMAIL PROTECTED]
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.22-log
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysql/mysql.sock
Uptime: 9 days 10 hours 34 min 58 sec
Threads: 6 Questions: 4092255 Slow queries: 0 Opens: 0 Flush tables:
1 Open tables: 540 Queries per second avg: 5.021
--------------
