May 26, 2012

Post: What to tune in MySQL Server after installation

…memory Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive workloads especially for … on hardware and mix of storage engines, while per session variables are typically … workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which may be great …

Post: Shard-Query EC2 images available

files for the demos, if you want to reload on your favorite storage engine or database About the cluster ForInnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb