… could cause a memory leak if query cache was used together with InnoDB. Bug fixed #… then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log ….6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… have to start the snapshot while holding a “flush tables with read lock” and the flush operation will take…, maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…-backed write cache), etc., but the principle is basically the same. If we want this transaction to persist after a crash, it…. When a player makes an achievement, your application updates this table with a statement like this: UPDATE achievements SET count = count… application. These are maintained in separate tables and there also exists a users_groups table to define the relationship between them. When…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are cleaned, so may be OS caches. This may reduce performance dramatically. So if you’re bringing server back after crash you…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… if MySQL Server crashes or power goes down. In case crash happens without this option is enabled in most cases table corruption will… know you need to check MyISAM tables after crash and have been running for years survining many crashes. If you enable delay_key…. Cache/Session tables (you can throw them away if it server crashes). You can use multiple of cache tables to avoid concurrency issues. Temporary tables used…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…-8K per table though complex tables can require larger sizes, so this is mainly the problem for smaller servers. Table Cache Merge Tables – Table Cache is allocated… lucky having users using MySQL lightly and not trying to crash/overtake it. Others constantly have to detect and restrict abusers…
Post: Crashes while using MyISAM with multiple key caches
July 18, 2009 By Leave a Comment
… using multiple key caches. It is very rare one would resize single key cache in production and it only triggers crash sometimes, while if you’re using multiple key caches there are often… or change mappings of the tables. No let me put my complain hat on. Looking into this crash bug I see it…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
… change a single row in any table, the query cache entries for every query which accessed that table must be invalidated. If a… unpredictable, and therefore undesirable performance. If the cache is emptied (perhaps due to a restart, crash, upgrade or power loss) then all of the results are invalidated, which can cause very poor performance. Cache invalidation is…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… did I use this solution compared to others: Innodb Tables – This table is getting much more reads than writes so transactional overhead… price to pay for number of benefits – caching data and index in memory -so cached lookups are very fast, clustering by primary…. No recovery worries – checking/repairing large MyISAM tables in case of MySQL/System crash is painful and great to be avoided. Long…
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
… does a lot of CREATE and DROP table for Innodb tables and we’ve discovered DROP TABLE can take a lot of time… large buffer pool. Worst of all this is done while table_cache lock is being held so no other queries can start… which were responsible for poor performance of SHOW STATUS and crash recovery performance over last couple of years and here we…
