Per Engelbrecht wrote:
It's complete then :)
I would say yes. I tested it on different platform I have, run the
benchmark, tests, etc. Load a good amount of data in there and so far so
good! Obviously more testing would be good, but at first glance, it does
look very good so far.
datasize, maxproc and openfiles values should then be ... ?
Value really varies for your setup. But you can't run the full tests, or
benchmark test with the default value. You can however run individual
tests and they will terminate well, but the run-full-test will not until
you increase the openfiles value and change the login.conf.
I send emails about this before and it's in the archive. But what I did
here, not that it's the best setup, I just did it to test well, I
modified /etc/my.cnf with:
# The following options will be pass to safe_mysqld
[safe_mysqld]
open-files=1772
That's the maximum that you can have there in the default setup without
any changes. If you try to have more, you will get an entry in your log
error.
And in the /etc/login.conf, I put a section for the _mysql user as:
# Setting used by MySQL daemon
_mysql:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=4096:\
:openfiles-max=8192:\
:stacksize-cur=8M:\
:localcipher=blowfish,8:\
:tc=default:
I am not saying this is the best possibility, you should really adjust
for your server resources and what you are doing and the load you expect
to have. So, please adjust for your need, but I strongly recommend to
have an entry for it in there. I will save you from the errorno 9 of
mysql. (:>
Read the:
man 5 login.conf
and adjust for your specifics, you will be better off doing it now!
But it worked for me. (:>
Now, I can finally do sub query! (:> I was really starting to miss that
a lots!!!
Regards,
Daniel
