Per Engelbrecht wrote:
I know these values depend on setup, utilization and more, but if you
had the-perfect-blend for a "workhorse" for this new port, it would be
nice. You've done some testing already. That's all.
I posted what I used for now. But really it depend on your setup. May be
you have a ultra busy server that work with 10 table and two database
only, or a less busy server for a farm of web servers that use 200
database with 50 table each. So, in both cases, the value will be way
different as in one case the optimum would be cache may be and the
other, you will run out of openfiles, but not in the first case. So,
really, there isn't 'the-perfect-blend for a "workhorse" '. I don't know
of one anyway that wouldn't need to be change for some setup. Plus it
depend if you use it only with mysql only on the server or like many
people with multiple stuff. What memory you have will also affect the
size you can assign to various cache, etc.
To many variable, I can't think of the perfect one.
If anyone have that on the list, then may be they can share their inside
and how they got to it. I don't.
Daniel
