We ship out mySQL on our appliances in enterprise level scenarios. We
often
like to start the AUTO_INCREMENT for several tables at 10,000 -- this way
we
can reserve the lower 'block' of IDs for our own internal and 'default'
use
so all customers have the same basic database schema. It also
Turn off the hyperthreading. You're not going to see superior performance
with hyperthreading enabled, you're just going to create a massive
thread-thrash with 16 logical cpus running 16 threads with not nearly enough
resources to cover them.
- Original Message -
From: Christian
If you're using 4 or 8 cpus, I highly recommend considering Solaris 10.
It's free and it's true threading implementation and fine grained locking
increase scalability and even out cpu load on multi-cpu systems much better
than my RHEL 4 U2 (Linux 2.6) systems do. Their benchmarks back up my