… STAT connection_structures 327 STAT cmd_get 319992973 STAT cmd_set 51710845 STAT get_hits 280700485 STAT get_misses 39292488 STAT evictions 849165… threads 4 END Here’s an easy “top” emulator for memcached: watch “echo stats | nc 127.0.0.1 11211″ If… must do it via PHP: watch ‘php -r ‘”‘”‘$m=new Memcache;$m->connect(“127.0.0.1″, 11211);print_r($m…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…hack wordpress to support eaccelerator cache or memcached. Well honestly speaking if performance would be… Table level granularity in invalidation – If table gets modification all queries derived from this …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
… process have. Here you can see it has couple of memcached connections. Few MySQL connections (to the same host, which if… stream functions not from libmysql or memcache.so, which means it is not MySQL or memcache connections leaving last candidate as the… server-status if you’re running apache. This way you will see the URL which that process is processing and so get…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
…in a while. Here’s the current status: We created a conference committee. We … just the mad scientist topics. So, please get your creative juices flowing, and submit … geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, Big Data, SSD storage, …
Post: Worse than DDOS
August 18, 2008 By 5 Comments
…takes another angle. Default file handler means file gets locked while PHP request is being served. In…offending processes you can find from apache “server-status” will be just waiting on file to be …looking for. Things are much easier with say memcached session storage – this does not cause any locks…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
… statement takes, i am now trying to get it to work by running show session status before and after the SQL, but… database server†to “it’s the RAID controller†to memcached, the load balancer, the switch, the network, the connection pool…
