…data pages – it also contain adaptive hash indexes, insert buffer, locks which also take some time. …other buffers, which may have other performance benefits as well. Tuning your VM to be less eager to…Innodb system. If you have fair amount of MyISAM, Archive, PBXT, Falcon or other storage engines …
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… significant gains. This is not to mention specific tuning for Benchmark which could be performed on database engine level. As Josh now… sweet spots come from. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM, Multi Value inserts, Query Cache, Merge Tables…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… Text Search solutions and compare their performance. Even if you missed the webinar,…my RAM, and then when I tested MyISAM FT index, I reallocated that memory…indexes stay up to date with changes (inserts, updates and deletes)? That’s a … Solr, I was able to fine tune search and I still feel there…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…, which can destroy performance. It can happen on a server with MyISAM tables, if there are…_method=O_DIRECT. We could also tune the OS, but in my experience …user | | NULL | 6318 | user | Sending data | insert into tableB… | 6322 | user | update | insert into | 6327 | user | | NULL | 6328 | user …
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… table based slow query log in production while tuning one of the systems. It is pretty nice… you require. Doing so however may affect your performance – updating table with a lot of indexes may …I found even if I convert table to MyISAM, disable concurrent inserts and run long reporting query on the …
