…options: Comment: 1 row in set (0.01 sec) mysql> SET…in 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
July 9, 2008 By 28 Comments
…in general, innodb, and myisam settings and installation configuration of the machine. I am interested in how…INNODB 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!
April 20, 2008 By 17 Comments
…innodb‘ ‘–with-csv-storage-engine’ (…) From that output you can learn how to run configure command, which needs to be done prior to…to 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.
November 12, 2008 By Leave a Comment
… 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] sql… specific. innodb_sync_spin_loops = 40 – This tuning option is rarely used so I’m curious how much speed benefit did it really provide in…
