just a heads up, for mysql
on new openbsd 3.4 just did the make build for src with OPENBSD_3_4 Tag
and mysql port from anoncvs today because I was
starting to see the infamous errorcode 9 with the beta port of mysql
If I run mysqlcheck -A against a lot of databases...
about the last database it comes back errors...
Error : File './*****_drupal/vocabulary_node_types.MYD' not found
(Errcode: 9)
Error : Got error9 from storage engine
error : Corrupt
If I run mysqlcheck only against the database(s) shown with errors
then it is okay. If I keep doing it I lock up mysql and have to kill
it...
So I checked ports and saw mysql-server-5.0.51a and replaced 5.0.51
but unfortunately,
still seeing it after updating package to
yes I am starting mysql with a file limit
It could be just a configuration issue on my side,
but I recommend others look into looking at mysql port
on 3.4 to see if they get the tmp 9 error when doing database
optimizations and tests...
btw,
per some suggesions on http://www.openbsdsupport.org/mysql.htm
here is how I am starting mysql in my /etc/rc.mysql
su -c _mysql root -c '/usr/local/bin/mysqld_safe --open-files-limit=2048
--log-slow-queries &' > /dev/null & echo -n ' mysql'
and I setup the mysql in login.conf and changed /etc/sysctl.conf
