Many in the MySQL community are snobbish about using MyISAM (not using it that is) and that if not using … – you should not use MyISAM. If you have a huge number of concurrent writes and selects and query performance must be consistently fast in this use case – you should not use MyISAM. If none…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…write_lock_countblogpercona.commanual memlockblogpercona.commanual min_examined_row_limitblogpercona.commanual myisam_block_sizeblogpercona.commanual myisam_data_pointer_sizeblogpercona.commanual myisam…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…performance improvement is marginal however WB cache brings single thread random write performance…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… details available Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow certain rules like… be invalidated with remote writes which makes even less efficient. So this configuration would unlikely be well performing compared to other setups…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 53 Comments
… of one another so it is easy to write the queries, some of them it turn used … and derived tables MySQL 5.0 will fail and perform very inefficiently in many counts. MySQL has two ways …) ENGINE=MyISAM DEFAULT CHARSET=latin1 So how would you get number of comments left by the given user ? mysql> …
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
….php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total records: 10000000; write rows per sec… affects table scan performance nadly – MyISAM suffers worse than Innodb – Innodb extent allocation works (perhaps would be good option for MyISAM as well…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…performance for small application. As load increases you might convert certain tables to MyISAM and other storage engines for performance… into account while using MyISAM tables. Recovery. MySQL was running stable for …causing unexpected slowdowns. delay_key_writes Whatever way you enable this option …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance… a backlog of asynchronous writes, but writing synchronously. Although write performance is comparable with …supports the MySQL Backup API which was originally implemented in MySQL 6.0….
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…stage and performance parameters may vary a lot in next releases) Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –…–table-cache=512 –net_read_timeout=30 –net_write_timeout=30 –backlog=128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… does it mean MyISAM variables are not important ? Not really. You still have some tables in MyISAM format in “mysql” database. Plus HEAP…) which can help significantly. delay_key_write Delay updating indexes for MyISAM tables. Good for performance but tables will be badly corrupted on…
