Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-296

LOCK INFORMATION

        Details

        • Type: Task
        • Status: Closed
        • Priority: Trivial
        • Resolution: Duplicate
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          Hi guys,
          today i received some information at mysql.dev bugs,
          http://bugs.mysql.com/bug.php?id=61261

          it´s about innodb lock table information:
          http://dev.mysql.com/doc/refman/5.5/en/innodb-locks-table.html

          since mysql is less opensource friendly, and i don´t think they will implement more feature soon,
          could we add a 'SHOW LOCK' in mariadb? i don´t know if locks are engine based or database based, but could be very nice to have a wait to get locks informations where a database get locked and dba/users want know why it was locked

          thanks =)

            Gliffy Diagrams

              Attachments

                Issue Links

                is duplicated by

                Task - A task that needs to be done. MDEV-4619 PLUGINS - Add LOCKS information at I_S (lock table / lock functions / lock events and others locks / get_lock function / mdl locks)

                • Blocker - Blocks development and/or testing work, production could not run.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment - - edited

                  There are locks on different levels. Engine internal locks (like row locks) and locks in the sql layer, placed by the mariadb.
                  the server can only show locks that it knows about. it can show table level locks and metadata locks, but not row- or page-level locks.

                  Show
                  serg Sergei Golubchik added a comment - - edited There are locks on different levels. Engine internal locks (like row locks) and locks in the sql layer, placed by the mariadb. the server can only show locks that it knows about. it can show table level locks and metadata locks, but not row- or page-level locks.
                  Hide
                  Permalink
                  rspadim roberto spadim added a comment -

                  could it 'ask' to engine and engine return in a standard method the locks?
                  for example

                  type = field,row,partition,page,table,others,no information from engine
                  values = long text with human engine information

                  Show
                  rspadim roberto spadim added a comment - could it 'ask' to engine and engine return in a standard method the locks? for example type = field,row,partition,page,table,others,no information from engine values = long text with human engine information
                  Hide
                  Permalink
                  rspadim roberto spadim added a comment -

                  please close this one, MDEV-4619 is better explained

                  Show
                  rspadim roberto spadim added a comment - please close this one, MDEV-4619 is better explained

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      rspadim roberto spadim
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - 1 week
                        1w
                        Remaining:
                        Remaining Estimate - 1 week
                        1w
                        Logged:
                        Time Spent - Not Specified
                        Not Specified