I have just gotten an article published on the community section of ez.no entitled Tuning MySQL for eZ publish. The article looks at the different buffers and settings you can tune in MySQL to boost the performance of eZ publish when running on MySQL.
I am interested in getting comments and feedback on your experience on this topic and what can be tuned for futher performance gain.