June 20, 2013

Comment: Interesting MySQL and PostgreSQL Benchmarks

… fine-tuning mysql and solaris. We have years experience with mysql on linux and we had to learn solaris for these benches, with that those sun’s were a great help. They noticed that on solaris MySQL used a lot… if you do io-bound benches you are testing your io-system, and not the CPU, and we wanted to test the CPU.

Comment: Linux schedulers in tpcc like benchmark

…a mixed workload (alternated write intensives, reads, and cpu bound moments, not just huge sustained writes)…which would allow exposing this to consumers (although MySQL offers INSERT DELAYED). Back to the subject,… how it’s used here): does this bench really spreads writes to emulate some randomness …

Comment: Percona XtraDB Cluster reference architecture with HaProxy

… cluster nodes each with 32GB RAM, Intel(R) Xeon(R) CPU E31270 @ 3.40GHz and 146GB 10k rpm HDD ). I think… errors displayed by sysbench when doing the bench : FATAL: error 2003: Can’t connect to MySQL server on ’172.16.29.238…! FATAL: unable to connect to MySQL server, aborting… FATAL: error 2003: Can’t connect to MySQL server on ’172.16.29.238…