May 26, 2012

Post: MySQL Query Cache

…hack wordpress to support eaccelerator cache or memcached. Well honestly speaking if performance would be… not work with transactions – Different transactions may see different states of the database, depending …good on this: Query Cache Query Cache Status Query Cache Configuration I would just …

Post: Debugging sleeping connections with MySQL

… connections does this process have. Here you can see it has couple of memcached connections. Few MySQL connections (to the same host… or memcache.so, which means it is not MySQL or memcache connections leaving last candidate as the only choice. I also could see… which you can use is server-status if you’re running apache. This way you will see the URL which that process…

Post: An update on Percona Live MySQL Conference & Expo 2012

…update in a while. Here’s the current status: We created a conference committee. We created a…NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, Big Data, SSD storage, data …spread the word about this event. We’ll see you in Santa Clara …

Post: Worse than DDOS

… offending processes you can find from apache “server-status” will be just waiting on file to be unlocked… can get that file and use fuser to see what other processes are using that files – these … looking for. Things are much easier with say memcached session storage – this does not cause any locks …