… network 1 Box with http/php, 1 box with memcache or mysql started PHP script Zend framework libmemcached PECL…’ => ’192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client‘ => array( ‘compression‘ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $frontendOpts, $memcacheOpts);…
Post: Large result sets vs. compression protocol
December 20, 2007 By 6 Comments
… in PHP‘s MySQL interface (which for reference maps to mysql_real_connect() function in MySQL C API) has a $client_flags parameter since PHP 4…’re interested in a specific one, MYSQL_CLIENT_COMPRESS. This flag tells the client application to enable compression in the network protocol when talking to…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression…shards (adjust to your number of nodes) php genconfig 20 > shards.ini Running the test…my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… storage for the virtual machines. Baseline: The MySQL command line client was used to execute the a script… was approximately 23GB of data. After loading, ICE compressed this data to about 2GB. The test virtual…of data. Shard-Query includes a loader (loader.php) which can be used to either split a…
