…to hack wordpress to support eaccelerator cache or memcached. Well honestly speaking if performance would be …the query – Query Cache does simple optimization to check if query can be cached. As I …pretty good on this: Query Cache Query Cache Status Query Cache Configuration I would just mention …
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 28 Comments
… and you can use your favorite tools to check what that process is doing. [root@w1 ~]# netstat -ntp… not from libmysql or memcache.so, which means it is not MySQL or memcache connections leaving last candidate…another great tool which you can use is server-status if you’re running apache. This way you…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
… tuning, I check the top-sql as query-digest shows. Check the plan and indexes involved. I want to check how much resources this SQL statement takes, i am now trying to get it to work by running show session status… database server†to “it’s the RAID controller†to memcached, the load balancer, the switch, the network, the connection pool…
