Showing entries 1 to 2
Displaying posts with tag: MySQL-innodb (reset)
InnoDB In a Complete Locked Mode

Today morning, we had a weird issue in one of the staging OLAP server (ETL); where all the InnoDB threads were locked and waiting on a signal condition for about[...]

Notes from InnoDB status, architecture and new features

Here is the notes from “InnoDB status, architecture and new features” by Heikki Tuuri and Ken Jocobs.

  • Introduction
    • fast
      • row-level locking, MVCC -> high concurrency & throughput
      • high performance CPU, memory and I/O architecture
      • efficient indexing (covering)
    • reliable
      • automatic crash recovery
      • integrated referencial integrity and transactions
      • online backup
      • well written, well tested and large user community
[Read more]
Showing entries 1 to 2