At 14:33 08-03-2007, Chris St. Pierre wrote:
We're sharing our Bayesian database (MySQL) between two MX nodes and
the database server has hit a wall. It's underpowered and is no
What engine are you using for MySQL? InnoDB is better for Bayes. Did you
look into MySQL optimization?
Regards,
-sm
Yes, if you have not tuned MySQL you should. If you have the available RAM
you can increase performance significantly. In some ad hoc experiments I did
I increased throughput by a factor of 8 simply by increasing
innodb_buffer_pool_size. Look for sample files such as my-medium.cnf and
my-large.cnf on your system for examples. If your tables are InnoDB and you
are using the default InnoDB settings you are likely hurting performance
(but saving ram).
Gary V
_________________________________________________________________
Play Flexicon: the crossword game that feeds your brain. PLAY now for FREE.
http://zone.msn.com/en/flexicon/default.htm?icid=flexicon_hmtagline
