Hi everyone I am using wordpress and drupal, and i converted databases from MyISAM to InnoDB, mysql tunning script gives below results…, which almost uses, as many sites of both drupal and wordpress are running, can any one please guide me, is it…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1 with no problems in most cases…, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even… application rather than your site which exists in single installation – Wordpress, vBulletin etc. With such software, if you’re not upgrading…
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
…on MySQL Sandbox to set up a little throw-away MySQL instance –…| +———————-+————————————————————–+————+—–+———+ | 1262633894049058504 | mpb_wordpress.wp_posts.post_status | 2 | 35 | 70.0000 | | 1262633894049058504 | mpb_wordpress…
Post: MySQL Performance Blog now uses Sphinx for Site Search
February 15, 2008 By 52 Comments
I never liked how build in Wordpress search works. it shows full documents rather than snippets it … used Google search if I wanted to find something on MySQL Performance Blog. Today we have published new search functionality for… which is based on Sphinx. We have developed it as WordPress plugin which will be available as open source software in…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… great feature called “Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number of things you… not the problem. Finally I do not want to hack wordpress to support eaccelerator cache or memcached. Well honestly speaking if… lets speak a bit about Query Cache configuration and mainance. MySQL Manual is pretty good on this: Query Cache Query Cache…
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… to run anywhere. There’s lots of optimizations possible with wordpress that will probably never be included. I don’t think… 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
Comment: Cache Performance Comparison
October 4, 2007 By 74 Comments
… rebuilt my homeserver, it’s running Wordpress/Mysql5/PHP5; now utilizing Varnish for HTTP accel, MySQL Query Cache (Unix Socket) on the database, and then the WP-Cache plugin for Wordpress. Seems I need…
Comment: MySQL Query Cache
October 11, 2009 By 70 Comments
…Since WordPress uses MySQL, almost every page load results in various MySQL queries for logins, post content, categories and so on. It … request so we begin with enabling the cache within the MySQL server. Basically, all you need to to is to activate… query cache in MB, for example 20M. To change the MySQL configuration file, you’ll probably need root access which wonâ…
Comment: MySQL Query Cache
November 22, 2008 By 70 Comments
…Since WordPress uses MySQL, almost every page load results in various MySQL queries for logins, post content, categories and so on. It … request so we begin with enabling the cache within the MySQL server. Basically, all you need to to is to activate… query cache in MB, for example 20M. To change the MySQL configuration file, you’ll probably need root access which wonâ…
