June 19, 2013

Comment: How Percona diagnoses MySQL server stalls

… 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…