Robuta

https://jahfer.com/posts/innodb-locks/ A Comprehensive (and Animated) Guide to InnoDB Locking | Jahfer's Blog Musings on software development that you didn't ask for. guide tocomprehensiveanimated https://jira.mariadb.org/browse/MDEV-6076 [MDEV-6076] Persistent AUTO_INCREMENT for InnoDB - Jira auto incrementmdevpersistentinnodbjira https://jira.mariadb.org/browse/MDEV-28305?attachmentViewMode=gallery [MDEV-28305] Innodb assertion - DICT_TF_HAS_DATA_DIR(table-flags) (was: Falha ao tentar iniciar... https://forums.mysql.com/read.php?22,664301,664361,quote=1 MySQL :: Re: InnoDB page_cleaner Error mysqlinnodbcleanererror https://jira.mariadb.org/browse/MDEV-18237 [MDEV-18237] InnoDB: Unable to drop FTS index aux table and further errors (possibly bogus) - Jira https://jira.mariadb.org/browse/MDEV-29986?workflowName=MariaDB+v4&stepId=6 [MDEV-29986] Set innodb_undo_tablespaces=3 by default - Jira by defaultmdevsetinnodbundo https://jira.mariadb.org/browse/MDEV-28512?workflowName=MariaDB+v4&stepId=6 [MDEV-28512] InnoDB: Assertion failure in file ./storage/innobase/dict/dict0mem.cc line 147 - Jira https://jira.mariadb.org/browse/MDEV-4616 [MDEV-4616] Crash after InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts is back - Jira https://forums.mysql.com/read.php?146,680505,680507,quote=1 MySQL :: Re: MySQL Router - After client machine rebooting, Cannot connect to MySQL InnoDB Cluster https://forums.mysql.com/read.php?22,384707,384896 MySQL :: Re: innodb memory usage vs swap memory usagemysqlinnodbvsswap https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html MySQL :: MySQL 5.7 Reference Manual :: 14.17.2 Monitoring InnoDB Mutex Waits Using Performance... https://forums.mysql.com/read.php?22,704532,704677 MySQL :: Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29 https://jira.mariadb.org/browse/MDEV-33503 [MDEV-33503] innodb_log_files_in_group is quietly ignored - Jira log filesin groupmdevinnodb https://forums.mysql.com/read.php?22,9970,10019 MySQL :: Re: Locks in a InnoDB table in amysqllocksinnodbtable https://bugs.mysql.com/bug.php?id=113 MySQL Bugs: #113: Mysql hangs on multi table update on innodb table. mysqlbugshangsmultitable https://forums.mysql.com/profile.php?22,14726662 MySQL :: MySQL Forums :: InnoDB mysqlforumsinnodb https://confluence.atlassian.com/bamboo/bamboo-mysql-innodb-log-file-size-824351240.html Bamboo MySQL InnoDB Log File Size | Bamboo Data Center 12.1 | Atlassian Documentation log file https://forums.mysql.com/read.php?22,707371,707371 MySQL :: Does InnoDB have anything equivalent to the BRIN index in Postgres? https://jira.mariadb.org/browse/MDEV-23397 [MDEV-23397] Remove deprecated InnoDB options in 10.6 - Jira mdevremovedeprecatedinnodboptions https://bugs.php.net/bug.php?id=80319 PHP :: Bug #80319 :: No error if the lock time exceeds innodb_lock_wait_timeout https://jira.mariadb.org/browse/MDEV-8396 [MDEV-8396] InnoDB: Assertion failure in file fil0crypt.cc line 2052 - Jira https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-innodb-usage.html MySQL :: MySQL 8.4 Reference Manual :: 25.2.6.3 NDB and InnoDB Feature Usage Summary https://jira.mariadb.org/browse/MDEV-30065 [MDEV-30065] "mariadb-install-db --enforce-storage-engine=InnoDB" fails with InnoDB errors - Jira https://forums.mysql.com/read.php?22,19755,38288 MySQL :: Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB create tablemysqlerror https://jira.mariadb.org/browse/MDEV-28980?workflowName=MariaDB+v4&stepId=6 [MDEV-28980] InnoDB: Failing assertion: len = MAX_TABLE_NAME_LEN - Jira mdevinnodbfailingassertionlen https://forums.mysql.com/read.php?177,696377,696647 MySQL :: MySQL Forums :: InnoDB clusters mysqlforumsinnodbclusters https://dev.mysql.com/doc/refman/9.1/en/innodb-performance-read_ahead.html MySQL :: MySQL 9.1 Reference Manual :: 17.8.3.4 Configuring InnoDB Buffer Pool Prefetching... https://jira.mariadb.org/browse/MDEV-27031 [MDEV-27031] InnoDB: Assertion failure in file... mdevinnodbassertionfailurefile https://bugs.mysql.com/bug.php?id=29261 MySQL Bugs: #29261: repeatable innodb and myisam corruption mysqlbugsrepeatableinnodbmyisam https://jira.mariadb.org/browse/MDEV-24049 [MDEV-24049] InnoDB: Failing assertion: node-is_open() in fil_space_t::flush_low - Jira https://jira.mariadb.org/browse/MDEV-25297?attachmentViewMode=gallery [MDEV-25297] InnoDB: Failing assertion: trx-roll_limit = trx-undo_no in trx_rollback_start - Jira https://forums.mysql.com/read.php?107,30871,31809,quote=1 MySQL :: Re: Full text in INNODB full textmysqlinnodb https://forums.mysql.com/profile.php?22,1303938 MySQL :: MySQL Forums :: InnoDB mysqlforumsinnodb https://forums.mysql.com/read.php?22,700227 MySQL :: What is InnoDB Reading and Writing when It's Idle? reading and writingwhat ismysqlinnodb https://forums.mysql.com/profile.php?177,16528940 MySQL :: MySQL Forums :: InnoDB clusters mysqlforumsinnodbclusters https://jira.mariadb.org/browse/MDEV-33229 [MDEV-33229] ERROR "InnoDB: Records in wrong order" with nopad collation - Jira https://forums.mysql.com/read.php?50,56364,56364 MySQL :: COUNT(*) on innodb count onmysqlinnodb https://jira.mariadb.org/browse/MDEV-25018 [MDEV-25018] [FATAL] InnoDB: Unable to read page (of a dropped tablespace) - Jira https://dev.mysql.com/doc/mysql-shell/9.7/en/configuring-production-instances.html MySQL :: MySQL Shell 9.7 :: 8.4.2 Configuring Production Instances for InnoDB Cluster Usage https://forums.mysql.com/read.php?22,705921,705923 MySQL :: MySQL Forums :: InnoDB mysqlforumsinnodb https://sipb-noc.mit.edu/munin/sql.mit.edu/unique-key/mysql_innodb_semaphores.html Munin :: sql.mit.edu :: unique-key :: mysql innodb semaphores muninsqlmituniquekey https://jira.mariadb.org/browse/MDEV-26551?workflowName=MariaDB+v4&stepId=6 [MDEV-26551] InnoDB crash on multiple concurrent SHOW TABLE STATUS - Jira show tablemdevinnodbcrash https://christiantrieb.blogspot.com/2023/07/oracle-mysql-live-webcast-beginners.html ORACLE Datenbank: ORACLE MySQL Live Webcast: Beginner's Guide to Implementing InnoDB ClusterSet... Kommende Woche , Donnerstag , den 20. Juli 2023 findet um 18:00 Uhr (CEST) der englischsprachige ORACLE MySQL Live Webcast zum Thema " Begin... beginner s guidelive webcast https://dev.mysql.com/doc/refman/9.1/en/information-schema-innodb-table-reference.html MySQL :: MySQL 9.1 Reference Manual :: 28.4.1 INFORMATION_SCHEMA InnoDB Table Reference reference manualinformation schemamysql https://jira.mariadb.org/browse/MDEV-25297?attachmentOrder=asc [MDEV-25297] InnoDB: Failing assertion: trx-roll_limit = trx-undo_no in trx_rollback_start - Jira https://forums.mysql.com/read.php?22,19755,516533 MySQL :: Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB create tablemysqlerror https://forums.mysql.com/read.php?168,420586,425819 MySQL :: Re: check for InnoDB Plugin + max no of concurrent threads the Innodb plugin can create https://dev.mysql.com/doc/dev/mysql-server/latest/classdd_1_1system__views_1_1Innodb__tablespaces__brief.html MySQL: dd::system_views::Innodb_tablespaces_brief Class Reference mysqlddsystemviewsinnodb https://jira.mariadb.org/browse/MDEV-31875?attachmentViewMode=list [MDEV-31875] ROW_FORMAT=COMPRESSED table: InnoDB: 2048 bytes should have been read. Only 0 bytes... https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html MySQL :: MySQL 5.7 Reference Manual :: 14.21.3 Setting Up the InnoDB memcached Plugin https://jira.mariadb.org/browse/MDEV-11068?attachmentSortBy=dateTime [MDEV-11068] Review which innodb_compression_algorithm to support in binary packages - Jira https://bugs.mysql.com/bug.php?id=10 MySQL Bugs: #10: SELECT on myisam and innodb empty tables, with unique key, not null columns, fa https://dev.mysql.com/doc/refman/9.7/en/innodb-disk-management.html MySQL :: MySQL 9.7 Reference Manual :: 17.11 InnoDB Disk I/O and File Space Management https://forums.mysql.com/list.php?22,page=8 MySQL :: MySQL Forums :: InnoDB mysqlforumsinnodb https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-config-table.html MySQL :: MySQL 5.7 Reference Manual :: 24.4.9 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table https://forums.mysql.com/read.php?22,668719,668797 MySQL :: Re: How to disable write cache in every way on mysql / innodb? how to https://jira.mariadb.org/browse/MDEV-10918 [MDEV-10918] InnoDB 5.7 aborts on AIO initialization failure - Jira mdevinnodb https://forums.mysql.com/read.php?21,652770,652882 MySQL :: Re: Still disable InnoDB in MySQL 5.7 mysqlstilldisableinnodb https://jira.mariadb.org/browse/MDEV-26932?workflowName=MariaDB+v4&stepId=6 [MDEV-26932] upgrade wizard never finishes at Phase 9/10 and hit "InnoDB: Upgrade after a crash is... https://jira.mariadb.org/browse/MDEV-37467?workflowName=MariaDB+v4&stepId=3 [MDEV-37467] InnoDB Instant ALTER TABLE is not crash safe - Jira alter tablemdevinnodbinstant https://dev.mysql.com/doc/refman/9.7/en/innodb-monitors.html MySQL :: MySQL 9.7 Reference Manual :: 17.17 InnoDB Monitors reference manualmysqlinnodbmonitors https://jira.mariadb.org/browse/MDEV-32554 [MDEV-32554] mon_lock_wait_current_count test causes innodb.monitor failure - Jira https://jira.mariadb.org/browse/MDEV-31607 [MDEV-31607] ER_DUP_KEY in mysql.innodb_table_stats upon RENAME on sequence - Jira https://jira.mariadb.org/browse/MDEV-15886?workflowName=MariaDB+v4&stepId=6 [MDEV-15886] InnoDB deadlock - Jira mdevinnodbdeadlockjira https://jira.mariadb.org/browse/MDEV-32873?workflowName=MariaDB+v4&stepId=6 [MDEV-32873] Test innodb.innodb-index-online occasionally fails - Jira mdevtestinnodbindexonline https://jira.mariadb.org/browse/MDEV-6113?workflowName=MariaDB+v4&stepId=6 [MDEV-6113] merge 5.7 innodb - Jira mdevmergeinnodbjira https://jira.mariadb.org/browse/MDEV-15223 [MDEV-15223] Document that InnoDB's native partitioning was not merged into MariaDB - Jira https://jira.mariadb.org/browse/MDEV-21347 [MDEV-21347] innodb_log_optimize_ddl=OFF is not crash safe - Jira https://jira.mariadb.org/browse/MDEV-34422 [MDEV-34422] InnoDB writes corrupted log on macOS and AIX due to uninitialized log_sys.lsn_lock -... https://forums.mysql.com/read.php?177,683787,683787 MySQL :: Upgrading MySQL InnoDB Cluster Metadata innodb clustermysqlupgradingmetadata https://calcite.apache.org/javadocAggregate/org/apache/calcite/adapter/innodb/package-tree.html org.apache.calcite.adapter.innodb Class Hierarchy (Apache Calcite API) tree: package: org.apache.calcite.adapter.innodb apache calciteclass hierarchyadapterinnodbapi https://dev.mysql.com/doc/mysql-shell/8.0/en/configuring-production-instances.html MySQL :: MySQL Shell 8.0 :: 7.4.2 Configuring Production Instances for InnoDB Cluster Usage https://bugs.mysql.com/bug.php?id=8364 MySQL Bugs: #8364: innodb count(*) description, "table" should be "index" mysqlbugsinnodbcountdescription https://forums.mysql.com/read.php?22,12604,16912 MySQL :: Re: InnoDB and FULLTEXT mysqlinnodbfulltext https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting-datadict.html MySQL :: MySQL 8.4 Reference Manual :: 17.20.4 Troubleshooting InnoDB Data Dictionary Operations reference manual https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html MySQL :: MySQL 8.0 Reference Manual :: 10.5.5 Bulk Data Loading for InnoDB Tables https://forums.mysql.com/profile.php?22,14771633 MySQL :: MySQL Forums :: InnoDB mysqlforumsinnodb https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-auto-increment.html MySQL :: MySQL Shell 9.7 :: 8.5.7 InnoDB Cluster and Auto-increment mysql shellinnodb cluster https://jira.mariadb.org/browse/MDEV-9130?attachmentSortBy=fileName [MDEV-9130] InnoDB uses non-covering index on bool column when estimate is 50% of the table - Jira https://forums.mysql.com/read.php?168,420586,420586 MySQL :: check for InnoDB Plugin + max no of concurrent threads the Innodb plugin can create https://forums.mysql.com/profile.php?22,261296 MySQL :: MySQL Forums :: InnoDB mysqlforumsinnodb https://forums.mysql.com/profile.php?22,7871939 MySQL :: MySQL Forums :: InnoDB mysqlforumsinnodb https://forums.mysql.com/read.php?104,407783,411346 MySQL :: Re: I need converter innodb to myisam i needmysqlconverterinnodbmyisam https://jira.mariadb.org/browse/MDEV-4697 [MDEV-4697] UPDATE_TIME field for XtraDB / InnoDB - Jira update timemdevfieldinnodbjira https://bugs.mysql.com/bug.php?id=114472&files=1 MySQL Bugs: #114472: MySQL replica encounter error when master and replica innodb_strict_mode=OFF https://forums.mysql.com/read.php?22,678639,678708 MySQL :: Re: mysql 5.6 InnoDB: Error (Duplicate key) writing word node to FTS auxiliary index table. https://bugs.mysql.com/bug.php?id=113738 MySQL Bugs: #113738: Test innodb.resurrection_logs failing if built with sanitizer https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-tablespaces-brief-table.html MySQL :: MySQL 9.7 Reference Manual :: 28.4.25 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table https://forums.mysql.com/read.php?149,706198,710288 MySQL :: Re: Restore plan for mysql innodb cluster mysqlrestoreplaninnodbcluster https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-schema.html MySQL :: MySQL 9.7 Reference Manual :: 17.16 InnoDB Integration with MySQL Performance Schema reference manual https://forums.mysql.com/read.php?22,668719,668774 MySQL :: Re: How to disable write cache in every way on mysql / innodb? how to https://jira.mariadb.org/browse/MDEV-19543 [MDEV-19543] Deprecate and ignore innodb_log_checksums - Jira mdevdeprecateignoreinnodblog https://forums.mysql.com/read.php?107,428270,428270 MySQL :: InnoDB Full Text Search (FTS) full text searchmysqlinnodbfts https://forums.mysql.com/read.php?22,686358,686358 MySQL :: Understanding InnoDB rw-lock stats mysqlunderstandinginnodbrwlock https://forums.mysql.com/read.php?146,677108,685162,quote=1 MySQL :: Re: Mysql InnoDB Cluster - Router - Pre-auth socket failure x.x.x.x:x: client auth timed... innodb clusterpre auth https://forums.mysql.com/read.php?22,13726,13843,quote=1 MySQL :: Re: Record locking INNODB record lockingmysqlinnodb https://jira.mariadb.org/browse/MDEV-28864?attachmentOrder=desc [MDEV-28864] Assertion `trx_id = create_id' failed in innodb_check_version() - Jira https://jira.mariadb.org/browse/MDEV-31234?attachmentViewMode=gallery [MDEV-31234] InnoDB does not free UNDO after the fix of MDEV-30671, thus shared tablespace... https://jira.mariadb.org/browse/MDEV-21422?attachmentViewMode=gallery [MDEV-21422] InnoDB: Assertion failure in file... mdevinnodbassertionfailurefile https://forums.mysql.com/read.php?21,707675,707675 MySQL :: MySQL 8.0: Still using MyISAM ? It is time to switch to InnoDB ! it is time to switch