Papelipe / Tags / MySQL



Right menu

Calendar

Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

MySQL

MySQL Performance Tuning

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.

Slides for Application Clustering with MySQL & Squid

The slides for the talk I presented together with Zak on Application Clustering with MySQL & Squid is now available. The slides are in OpenDocument format so you need OpenOffice.org to view them. Any comments or suggestions welcome.
Update: slides are now also available in PDF format.

MySQL UC 2006 Photos

The first conference day has started and I have uploaded a couple of photos.

The conference center entrance:

MySQL UC entrance


The opening session:

State of the Dophin: Monty, David Axmark, Kaj Arnö


eZ publish faster running on Intel optimized MySQL

I've done some benchmarking today with eZ publish CMS and MySQL running a process inserting articles (objects) into the CMS system. I ran the test on both the standard GCC compiled version of MySQL and the Intel ICC compiled version. The total process was 11.9% faster and the MySQL part was 20.2% faster. So atleast on heavy write operations the ICC compiled version of MySQL is running faster with eZ publish. This is good news for people running write intensive eZ publish sites. When testing with read queries I did not see that much of a difference, I will do more tests on heavy read intensive operations to find where we can gain performance also here.

Speaking at the MySQL Users Conference

I will be speaking at the MySQL Users Conference 2006 in Santa Clara on Wednesday the 26th of April.The topic of the session is Web Application Clustering with MySQL. Zak Greant will be co-presenting with me.