… new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL… stricter: in the default SQL mode, a duplicate index will throw a warning instead of a note. In strict mode, it will throw… are engine-dependent, like redundant suffixes for secondary keys in InnoDB. As some of this redundancies could be necessary, depending on…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…network interface bonding in balance-rr mode; this is the only NIC bonding mode which will allow you to …also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are going …-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… copying failure. Bug fixed #1170806. innobackupex would fail if the SQL_MODE was set to ANSI_QUOTES. Bug fixed #945161. Missing space…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 2, 2013 By 10 Comments
…, the cache settings allow for two distinctly different modes of operation and use cases. ‘innodb_only’ appears to be handlersocket like, where… protocol that accesses existing innodb buffer pool and real time data (good for quick simple lookups where the SQL overhead is significant…’ covers both (although favors traditional mode as it goes to the cache first). The default is ‘innodb_only’ which is something to…
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
…:/work/MySQL Datafiles/” default-character-set=latin1 default-storage-engine=INNODB sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION…=7M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=3499k innodb_buffer_pool_size=339M innodb_log_file_size=50M innodb_thread…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… `PRIMARY` of table `test/iz` trx id 0 42313619 lock_mode X locks rec but not gap waiting Record lock, heap… InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query id 728899 localhost root Sending data select sql… InnoDB 166 mysql tables in use 1, locked 0 MySQL thread id 8078, query id 728898 localhost root Sending data select sql…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…0 innodb-status-file innodb-strict-mode innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use-sys-stats-table innodb-…skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 …
Post: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 6, 2006 By 51 Comments
… article comparing locking hints in MySQL and SQL Server. In MySQL/Innodb LOCK IN SHARE MODE and SELECT FOR UPDATE are more than… SHARE MODE modifiers effectively run in READ-COMMITTED isolation mode even if current isolation mode is REPEATABLE-READ. This is done beause Innodb can… missing in Innodb locking.? In my oppinion few rather important peices missing in Locking implementation of Innodb are: Lock table Innodb can lock…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | 5610 | | PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | 10000 | 1556 | | SQL_MODE | | NO_ENGINE_SUBSTITUTION | | INNODB_OLD_BLOCKS_TIME | 0 | 1000 | | LOG_ERROR | /mnt/data…. sql_mode has NO_ENGINE_SUBSTITUTION value by default which is good change as trying to create Innodb table but getting MyISAM because Innodb…
