Mat Keep posts on the configuration of data nodes in MySQL Cluster 7.2 to achieve optimum performance on the latest generations of multi-core, multi-thread CPU designs. According to Keep, the flexible configuration afforded by the multi-threaded data node enhancements means it is possible to optimize data nodes to use anything from a single CPU/thread up to a 48 CPU/thread server. Co-locating the MySQL Server with a single data node can fully utilize servers with 64 – 80 CPU/threads, and with multiple data nodes per server, but only required for very large servers with 4+ CPU sockets dense multi-core processors, he writes.
(Get More Information . .)