MySQL has a great feature called “Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number of things you need to know. First let me clarify what MySQL Query… not the problem. Finally I do not want to hack wordpress to support eaccelerator cache or memcached. Well honestly speaking if…
Comment: When should you store serialized objects in the database?
January 22, 2010 By 47 Comments
… described pretty well in the Friendfeed link in my article. Wordpress is a completely different kettle of fish. They don’t… want it to run anywhere. There’s lots of optimizations possible with wordpress that will probably never be included. I don’t… objects, I loose all my tools I’m used to (mysql cli, etc). I then have to create new tools (which…
Comment: MySQL Query Cache
January 17, 2010 By 70 Comments
As a non MYSQL guy, I am pretty lost after reading this, but because I am running my own server for Wordpress I need to optimize my speed settings. Is it possible for you to give me the ini file settings for wordpress for my situation? Thanks
Post: How to generate per-database traffic statistics using mk-query-digest
September 16, 2009 By Leave a Comment
… database per customer organization … or wordpress-mu type of apps). For example, take the following single MySQL instance with multiple (identical) databases… reaching it’s capacity and the next most useful performance optimization is to migrate a database to a different server, you…
Post: Percona welcomes Ryan Lowe and Vladimir Fedorkov
January 13, 2009 By 3 Comments
… an Alexa top 1000 site with a sharded MySQL backend, worked in aerospace, worked in telecom, and …’s clients. He also contributed some improvements to Wordpress, and he blogs here and on Pablowe. Vladimir … our clients? It’s not all about query optimization.) Vladimir is also the leader of one of …
