June 18, 2013

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

… Host-Only network 1 Box with http/php, 1 box with …memcacheOpts = array( ‘servers’ =>array( array( ‘host’ => ‘192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ),…/ 100000; $timer->start(); for ($i = 0; $i < 10; $i++) { for ($i = 0; $i < 100000; $i++) { …

Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes

…the two nodes impossible (switch/router failure) [root@percona1 ~]# clustercheck HTTP/1.1 503 Service Unavailable Content-Type: Content-Type: text/plain … daemon: 0 address: gcomm://192.168.70.2:4567 group: trimethylxanthine sst: trivial donor: options: gcs.fc_limit=9999999; gcs.fc_factor=1.0; gcs…

Post: Google's user_statistics V2 port and changes

0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 0 1 row in set (0.00 sec) mysql> select * from information_schema.client_STATISTICS\G *************************** 1. row *************************** CLIENT: 192.168… link to patch for 5.0.67. http://www.mysqlperformanceblog.com/mysql/experimental…

Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6

…-0000-0000-000000000000:-1 130221 17:59:05 …192.168.14.150; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0http://bugs.percona.com/ key_buffer_size=0 read_buffer_size=131072 max_used_connections=0 max_threads=151 thread_count=0 connection_count=0