…=0 innodb-stats-sample-pages=256 innodb-stats-update-need-lock=0 innodb-status-file innodb-strict-mode innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb_thread_sleep_delayblogpercona.commanual Innodb…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… ON innodb_stats_sample_pages 8 innodb_strict_mode OFF innodb_support_xa ON innodb_sync_spin_loops 30 innodb_table_locks ON innodb_thread_concurrency 0 innodb_thread_sleep_delay 10000 innodb_use…
Comment: Percona Server 5.1.47-rel11.0
June 25, 2010 By 13 Comments
…€“with-plugins=partition,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,innodb_plugin,myisam,myisammrg –with-big-tables –without-debug… my.ini add options default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict_mode=1 it work Percona server 10…
Comment: Percona Server 5.1.47-rel11.0
June 24, 2010 By 13 Comments
…€“with-plugins=partition,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,innodb_plugin,myisam,myisammrg –with-big-tables –without-debug… my.ini add options default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict_mode=1 it work Percona server 10…
Comment: Innodb row size limitation
April 9, 2011 By 11 Comments
Starting with the InnoDB plugin InnoDB checks this and won’t let you even create the … plugin and now InnoDB checks that you can’t possibly exceed the size if: 1. You’re using innodb_strict_mode = 1. 2. or…
Comment: Innodb row size limitation
April 7, 2011 By 11 Comments
Starting with the InnoDB plugin InnoDB checks this and won’t let you even create the … plugin and now InnoDB checks that you can’t possibly exceed the size if: 1. You’re using innodb_strict_mode = 1. 2. or…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… MySQL 5.0 mainly error control was improved, such as strict mode was added to change famous MySQL behavior of cutting too… catching such errors. If MySQL is started with Innodb tables disabled accesses to Innodb tables will simply result in errors. The other… it beating up people is performing Innodb conversion…. By default MySQL substitutes storage engines so if Innodb is disabled MyISAM is used…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… 0 seconds behind, running, no errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute… 0 seconds behind, running, no errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…, but I see that Galera strictly requires innodb_autoinc_lock_mode=2 and tries to manage innodb_autoinc_lock_mode / auto_increment_offset – For deadlocks…
