…I wanted to compare InnoDB performance vs TokuDB. I…innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…First, the baseline configuration plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We …This is, however, only a hypothesis. vCache vs. FlashCache – dirty page threshold Finally, we…_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… –net_write_timeout=30 –backlog=128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread…
Comment: High-Performance Click Analysis with MySQL
December 23, 2008 By 13 Comments
… data compact. 4) MyISAM vs Innodb – if you have read only data you can often get data clustering with MyISAM too by ALTER TABLE … ORDER BY X. It is not same as with Innodb (data is never… to efficiency to storing to the database (MyISAM surely will be bound by sequential disk writes) – this gives convenience of running SQL…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb… myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam… was the same and, WT -vs- WB cache of course showed no…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped…. Compressed mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we upload …we dump schemas: loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_io_capacity = 20000 innodb_io_capacity_max = 40000 #not innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… think default could have been made even larger. Write intensive workload will do a lot better …_files_limit is 5000 by default now vs 1024. innodb_auto_extend_increment is now 64MB instead …good change as trying to create Innodb table but getting MyISAM because Innodb was disabled for some reason was…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…’s blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB‘s scalability as…] [caption id="attachment_4656" align="aligncenter" width="300" caption="Read-Write Results"][/caption] The model predicts that the server will continue…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…engines you’re using – DRBD does not work with MyISAM (check required) so you need to have processes … – hot vs cold. If you’re using decent hardware and care about performance you use O_DIRECT with Innodb …DRBD slave node can’t be called hot because write load often does not touches the same data …
