…MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2. Updates involving non-transactional…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
….5.30-23.7.4 for MySQL on April 17, 2013. Binaries …for the case when DROP TEMPORARY TABLE statement was used, but it will still replicate in case DROP TABLE statement is used on a temporary table…). Upstream bugfix for bug #59354 triggered a regression that could cause transaction conflicts. Bug …
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
… of eBay implemented true-VARCHAR support for MEMORY tables for MySQL 5.0. Although this patch…; Also we modify the sysbench non-transactional INSERT test to insert strings of…tables are still used for temporary tables where the MEMORY tables with dynamic row format could be used instead: for…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… these tables. Thus, I claimed, there’s no alternative but to eliminate temporary tables. This problem may not exist for row-based replication in MySQL… within one transaction on the master, the temporary table was not safe for replication. I’m pretty sure this is a bug. The temporary table shouldn…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… really. You still have some tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables which may become MyISAM if… and other storage engines transaction logs, slow query log or general log. flush, flush_time Flushing (closing) of tables after query is…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… 16-32Mb so it is large enough to accommodate indexes for temporary tables which are created on disk. innodb_buffer_pool_size This… transactions even in case MySQL Server crashes. Value 2 only cause data loss with full OS crash. table_cache – Opening tables can be expensive. For…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… or memory to store temporary table, but let us ignore them for a moment. The…take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat…TABLE_ROWS_READ: 610954 SELECT_COMMANDS: 181243 UPDATE_COMMANDS: 0 OTHER_COMMANDS: 0 COMMIT_TRANSACTIONS: 181243 ROLLBACK_TRANSACTIONS…
Post: InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
…tables | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…MySQL will crash when one of internal memory allocations would unexpectedly fail. To give you couple of hints: Temporary Tables…transaction and doing a lot of updates, or simply keeping transaction…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…for both transactional and no transactional statements. After 5.5.9 the cache was splitted in two, binlog_cache_size to hold transactions…end. Conclusion MySQL can creates temporary files even thought those temporary files are…of your temporary tables increases. We have our own plugins for both system…
