… printed for the deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum) if used. Instructions for disabling the SHM… Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused the server to crash in some scenarios due… crash on IA32 systems. Bug Fixed: #803865 (Laurynas Biveinis). Using the innodb_lazy_drop_table option led to an assertion error when…
Comment: Can MySQL temporary tables be made safe for statement-based replication?
May 28, 2008 By 8 Comments
…’t be transaction safe if it is MyISAM and if InnoDB, I will be messing up with the common tablespace which… that goes against the very first reason of using temporary tables. Most of us use temporary tables (there are more reasons also) because we…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
….16-22.0 and get all the InnoDB bug fixes each of these releases contain. Using xtrabackup to back up older MySQL… and leave them behind. With this bug fixed, innobackupex will use temporary files instead of files in the current working directory. Bug… fix, innobackupexnow safely ignores file not found errors for non-InnoDB tables. Bug Fixed: #859546 (Lachlan Mulcahy) When the –incremental and…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… dealing with temporary tables (unless they are used to populate normal tables using SQL). On the Master you can do filtering using binlog-do… altering tables. If you have Innodb tables you’re normally OK because you can use –skip-innodb on the filtering slave and default-storage-engine=BLACKHOLE to ensure all Innodb tables are created…
Post: InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
… | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of… | NO | +————+———+———————————————————–+————–+—-+————+ 4 rows in set (0.00 sec) By default InnoDB is not compiled as storage engines. Perhaps it is related… not too hard to fix, you just need to use –with-plugins=innodb (or max, or max-no-ndb, which includes set…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… application (storing billions of rows in tens of thousands tables) Innodb was better choice mainly because of thouse other behaviors … well… it server crashes). You can use multiple of cache tables to avoid concurrency issues. Temporary tables used in batch processing and other means…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases… server gridlock one way or another. If you’re just using Innodb tables and you’re not actively changing users, stored procedures… (which are stored in MyISAM tables anyway) you can consider using –no-lock option with Percona Xtrabackup. Many other tools have…
Comment: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
Jay, Jeremy I guess “how much to use for Innodb Buffer Pool” is the question answer to which may depend … for MySQL and OS needs and give the rest to Innodb Buffer Pool is good but how one would know how… or disk based temporary table. Another thing you need to keep into account is caching Innodb logs. As IO to Innodb logs is…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… response time and will continue press reload. Plus, especially for Innodb tables throughput may drop dramatically – you may see it to… queries concurrently. If you have these queries doing large sorts, using temporary tables or having other significant memory requirements you may well…
Comment: How much memory can MySQL use in the worst case?
February 14, 2009 By 17 Comments
Brice, it surely seems that something weird is going on with InnoDB. I’ve personally built systems where temporary InnoDB tables are created and dropped like mad, and not seen this behavior. You shouldn’t be using that much memory for 300 tables.
