…database per customer organization … or wordpress-mu type of apps). For example, take the following single MySQL instance with multiple (identical) …most useful performance optimization is to migrate a database to a different server, you know exactly which database to move (db3) and how much …
Post: How to generate per-database traffic statistics using mk-query-digest
September 16, 2009 By Leave a Comment
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…MySQL Performance optimization tasks but there are number of things you need to know. First let me clarify what MySQL… problem. Finally I do not want to hack wordpress to support eaccelerator cache or memcached….to use query cache ? Third party application – You can’t change how it works with MySQL to…
Comment: When should you store serialized objects in the database?
January 22, 2010 By 47 Comments
…to columns. The problem with when you choose to convert, is that you can’t easily get statistics such as how…, they want it to run anywhere. There’s lots of optimizations possible with wordpress that will probably …all my tools I’m used to (mysql cli, etc). I then have to create new tools (which …
