…to what I need). Tables looks like: CREATE TABLE…table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT… innodb_write_io_…myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call… the backing store to be written to at a more constant and…table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT … myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
…) and get just about 80 deletes per second while converting table to MyISAM I get about 600 deletes per second and about 4000…. You may also be surprised to see MyISAM being significantly slower than Innodb – in this case the table is small and fully fits… Innodb could delay writes and do all the changes directly in memory. MyISAM however had to perform number of random writes to the key file and…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
…MyISAM Does Not Scale, or it does quite well – two main things stopping you is table…to mysql directly as explained here to create key caches. Now you can use much more simple command to assign tables to…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… instead of having files created using direct IO they were buffered in OS cache and so writes to files were serialized until they…_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover skip-grant-tables Amount of rows… with RAID controller cache set to Write-Through and then to Write-Back. 1. Baseline – misalignment on the partition table, no LVM and no alignment…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…tables and does specified number of inserts going to random tables. I used default MySQL settings for MyISAM (table…DIRECT for Innodb. The tables were sized so they are considerably larger than amount of memory in box so full table…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… a lot. The third is IO Subsystem – directly attached storage with plenty of spindles and … any writes be prepared to handle deadlocks which may happen. Third you would like to review your table …no OS changes and have no changes done to application which was written keeping MyISAM tables in…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… MyISAM tables are used. There is read-ahead functionality but usually it is not able to drive number of outstanding request significantly. For write… capacity with SAN (this applies to directly attached storage too) is to really understand what you’re trying to scale and analyze things appropriately…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…write something instructional to the client about it. Preparing to report findings I should mention here a bit about how I write the report to… indication that it’s time to convert MyISAM tables to InnoDB. (But then again, … small adjustments to the direction we’re going, communicate to the client how…
Post: Living with backups
November 6, 2008 By 28 Comments
…MyISAM tables which have dedicated buffers only to store indexes, while the actual data is always read from disk. The active portions of tables… order to change you will just need to write to …DIRECT flag, the file needs to be aligned to the file system block size, so usually it means the size has to…
