… during regular operations and is not ACID compliant. MyISAM and InnoDB may perform … in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version…TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…
Post: Why ALTER TABLE shows as two transactions in SHOW ENGINE INNODB STATUS
July 1, 2012 By 4 Comments
… not ACID). The largest part of ALTER TABLE not being completely crash safe in MySQL is the MySQL server manipulating FRM files. The only MySQL storage engine I’m aware of having fully crash safe DDL is MySQL Cluster (NDB). Proving that MEMORY is/isn…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… tables at onces, which typically make system extremely slow and also can use up all allowed connections or run out of memory… MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL is not really ACID even with Innodb tables… table or any other statement – it is table open which is important. There are other problems which you may experience related to MySQL…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…, and it can’t be because we used MyISAM tables which are not ACID complaint. Plus we only measured Power to keep… a look at MySQL 5.1.23 vs 6.0.4 results for 10GB data set which “fits in memory“. The cut… to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… tables though benefit of these is minor. Also make sure you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% of memory is a…_at_trx_commit=2 If you’re not concern about ACID and can loose transactions for last second or two in…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…ACID-compliant design and advanced MVCC architecture, and adds features, more tunability, more metrics, more scalability on many cores, and better memory… INFORMATION_SCHEMA.XTRADB_ENHANCEMENTS. This table contains information about the …existing MySQL-5.1.30 installation http://www.percona.com/mysql/…
Comment: MySQL Query Cache
May 10, 2008 By 70 Comments
… for mysql that is not ACID safe. something to work with high update scenario, the cache is NOT dropped with every table change… need to modify in application every place where an expensive mysql query is being done. i would rather prefer a transparent…-memory caching. or a set of APIs that first query the memcached/JCS/EHCache and if nothing is found, query the MySQL…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
… partition. It is an in-memory shared-nothing system, and tables are partitioned across multiple servers …scaling a synchronously replicated, active-active master, fully ACID, always-consistent database to a 40-server… services for VoltDB. We’re focused on MySQL software and services. I am not a …
Comment: Jeremy Cole on MySQL Replication
June 13, 2006 By 12 Comments
… was at the MySQL conference in May and attended Jeremy’s presentation on… updating different tables/rows, but if sync_binlog = 1 (which is a requirement for true ACID integrity)–doesn… how InnoDB updates are propagated between the in-memory-buffer–>innodb-log-files–>innodb “tablespace” (.ibd) file…
