… work with the system which needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM… get over 200K of inserts/sec. This time I worked with Innodb tables… it was a different system with different table structure, not…
Post: Beware of MyISAM Key Cache mutex contention
August 12, 2008 By 10 Comments
… working with the client loading data to MyISAM tables at very high rate. Hundreds of millions rows are loaded daily into single MySQL instance with… use multiple cores efficiently to get good insert rate… or so it seemed. In reality inserting in parallel into different tables when indexes…
Post: Stored Function to generate Sequences
April 2, 2008 By 17 Comments
… NOT NULL, PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 insert into seq values(‘one’,100); insert into seq values(‘two’,1000); This…_increment with Innodb tables to avoid short term “table level locks” which innodb sets when Insert is happening in the table with auto… but it may still become the bottleneck for application with high sequence use rate. For such heavy duty apps I would use another…
Post: Beware large Query_Cache sizes
March 23, 2007 By 3 Comments
… queries both for MyISAM and Innodb tables mysteriously stalling for few seconds with “NULL” in State …? If you set query_cache_size relatively high at 256MB or more. It can …of thousands queries being invalidated by single insert – this typically happens if you have …should affect query cache hit rate…
