May 24, 2012

Post: Improved InnoDB fast index creation

options: Comment: 1 row in set (0.01 sec) mysql> SETin my previous examples): $ mysqldump -uroot test > dump_unoptimized.sql $ mysqldump -uroot test –innodb-optimize-keys > dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql

Comment: MySQL File System Fragmentation Benchmarks

in general, innodb, and myisam settings and installation configuration of the machine. I am interested in howINNODB Specific options *** innodb_additional_mem_pool_size=20M innodb_flush_log_at_trx_commit=0 innodb_log_buffer_size=4M innodb_buffer_pool_size=304M innodb

Post: Updated msl (microslow) patch, installation walk-through!

innodb‘ ‘–with-csv-storage-engine’ (…) From that output you can learn how to run configure command, which needs to be done prior toto have in your slow log. For example to have microsecond query timing and InnoDB statistics you would need to set this option to

Post: New SpecJAppServer results at MySQL and Sun.

to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sqlspecific. innodb_sync_spin_loops = 40 – This tuning option is rarely used so I’m curious how much speed benefit did it really provide in