…EXCEPT a specified set of databases and tables. With this method, every event is still… top-level master, you leave all filters disabled; on the relay master you add binary …MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…TABLE fast index creation (merge sort). For the MyISAM tests I used a 10GB key buffer. I used ALTER TABLE DISABLE…TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…Locks – MySQL Replication SQL Thread executes queries same as any other thread and it has to grab the locks needed for query execution – either row level locks for Innodb or table locks for MyISAM and … to disable binary logging with SET SQL_BIN_LOG=0 before you run ALTER TABLE query. …
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you …than that. I found even if I convert table to MyISAM, disable concurrent inserts and run long reporting query on … slow log queries which is used if log table is locked. One thing which would be rather handy …
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… query which should be executed without exclusive table locking. Even on 16 threads we’re getting …MySQL 4.1 the change to key cache locking was done so disk IO is not done while lock is held, while lock…a problem is benchmark run with disabled key_cache (=0). Results for MyISAM with key_buffer_size=…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… done in MyISAM table. So why was this done, being pretty bad for MySQL Performance and concurrency ? The reason is – replication. In MySQL before…_locks_unsafe_for_binlog option with caution. Note disabling binary logs is not enough to trigger relaxed locks. You have to set innodb_locks…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…for your Innodb tables but there are other things you need OS cache for – MyISAM tables (mysql database, temporary etc… not all kernels work quite well with swap disabled and there are other reasons against it. … to play with. Finally you can try locking MySQL in memory by using –memlock – just be …
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow certain rules like enabling external locking, disabling query cache and… time for large tables. Furthermore as I remember MySQL simply was not repairing corrupted tables in this configuration even if myisam_repair is set…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… inserts into a MyISAM table. The inserts were not…disabled by default.) However, that turned out not to be the cause; the table… of execution. The MySQL manual actually says this…lock on the table like this: Locked – read Low priority read lock But on INSERT…SELECT, you’ll see this: Read lock…
Post: MyISAM concurrent insert
June 13, 2006 By 12 Comments
…Some results for MyISAM table, query…disabling concurrent-insert with –skip-concurrent-insert can improve MyISAM performance. As I said the reason of bad scalability is rw-locks and currently MySQL developers are working on CPU-depended rw-locks implementstation, this will be available in MySQL…
