… multiple thread to do inserts in multiple tables would not be bound by table locks and would be… key_cache to the thread local space. Happily MyISAM allows you to create multiple key caches . We … changes we got insert rate to MySQL close to 200K rows/sec using standard multi value inserts which is …
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… use memcache + another mysql instance (or simply the database which is not replicated) to log updates in heap/myisam/archive table and… mentioned you can use MyISAM or HEAP tables for this purpose, how do you deal with Table Locks in this case – the… “shadow table” trick – use two tables insert into one and process and truncate another. MySQL offers atomic RENAME TABLE call which can…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
…before – MyISAM Does Not Scale, or it does quite well – two main things stopping you is table locks and …with one CPU as global lock was held during IO duration, In MySQL 4.1 the lock is held only …very significant. For CPU bound workload with 16 Cores Inserting data to about 20 tables I’ve seen …
Post: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
January 18, 2007 By 15 Comments
… you could use LOCK TABLES but it is not efficient. The reason REPLACE could be efficient for ISAM and MyISAM, especially for… will insert NULL value, as col1 is undefined at this stage. INSERT ON DUPLICATE KEY UPDATE is newer feature which came in MySQL 4.1 by advice one of MySQL big users…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb …16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size …#Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> max_…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM and… – Partitioning. Unfortunately MySQL 5.5 leaves the huge bottleneck for write workloads in place – there is per index rw lock, so only one thread can insert index entry at the time, which can be…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
…table. No matter if it’s InnoDB or MyISAM, you’d usually ALTER TABLE `huge_table` CHANGE `… 2. mysql> FLUSH TABLES WITH READ LOCK; Query OK, 0 rows affected (0.00 sec) — 3. mysql> ^Z [1]+ Stopped mysql …latin1 1 row in set (0.00 sec) mysql> INSERT INTO `huge_table` (text) VALUES (‘test’); ERROR 1062 …
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 …which is used to store query execution time and lock time does not store fractions of the second. … I found even if I convert table to MyISAM, disable concurrent inserts and run long reporting query on the log…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… into two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at… #*** MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover user=root…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
July 22, 2011 By 117 Comments
… Require Transactions Yes frequent select queries Yes frequent insert,update,delete Yes Row Locking (multi processing on single table) Yes Relational base… can conclude which has to be chosen either innodb or MyISAM. http://developer99.blogspot.com/2011/07/mysql-innodb-vs-myisam.html
