… –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 11 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: 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 …
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… and it is only writes which suffer overhead of DRBD. If you’re using MySQL with Innodb (and running MyISAM with DRBD makes… there is a lot of synchronous writes which are fully serialized because group commit in Innodb was broken in 5.0 and… overhead besides network IO we’re speaking about 300 microseconds vs 5000 microseconds and DRBD overhead can be well below 10…
