… combinations of cores in the kernel, rebooting the server. With FreeBSD 7.0 the only way to avoid the deadlock that was… a FreeBSD 8 machine to test its new scheduler, but actually did not help (minimal). I really believe the combination FreeBSD scheduler + MySQL… assigned dedicated key cache preloading it at startup. (benchmarks I did: http://caligula.mysql.name/core_tests.txt) For the CPU thing…
Comment: PBXT benchmarks
… results with mysql on an 8cpu server – it performed 3!!
times slower than on the same 4cpu server: FreeBSD-6.2/7.0… (quad core) 4GB ram mysql-4.1.22/from FreeBSD ports apache+php tests done with apache benchmark on a web page that… 4 cores: 18-20 requests/s all 8 cores: 5-7 requests/s, whatever did I try to do – nothing really…
Comment: To UUID or not to UUID ?
… these benchmarks comparing PostgreSQL and MySQL performance, which show how bad MySQL scales on multicore + multithread environments: http://tweakers.net/reviews/649/7 The… less clear if the problem is in MySQL or in Linux, since MySQL scales fine in FreeBSD. Well, it seems that finally the…

