Skip to content
  • Marek Szymczak's avatar
    4359db86
    Bug#21458192 AUDIT API DOES NOT GENERATE EVENTS OF THE 'MYSQL_AUDIT_TABLE_ACCESS_CLASS' CLASS · 4359db86
    Marek Szymczak authored
    Problem
    =======
    Audit API defined events of the 'MYSQL_AUDIT_TABLE_ACCESS_CLASS' class were not generated.
    
    Solution
    ========
    Following events of the 'MYSQL_AUDIT_TABLE_ACCESS_CLASS' class are generated during execution of
    the listed queries:
    
    - MYSQL_AUDIT_TABLE_ACCESS_READ
      - SELECT
      - INSERT ... SELECT (table referenced in the SELECT clause)
      - UPDATE ... WHERE (tables referenced in the WHERE clause)
      - REPLACE ... SELECT (tables referenced in the SELECT clause)
      - HANDLER ... READ
    - MYSQL_AUDIT_TABLE_ACCESS_INSERT
      - INSERT
      - INSERT ... SELECT (table referenced in the INSERT clause)
      - REPLACE
      - REPLACE ... SELECT (table referenced in the REPLACE clause)
      - LOAD DATA INFILE
      - LOAD XML INFILE
    - MYSQL_AUDIT_TABLE_ACCESS_UPDATE
      - UPDATE
      - UPDATE ... WHERE (table or tables referenced in the UPDATE clause)
    - MYSQL_AUDIT_TABLE_ACCESS_DELETE
      - DELETE
      - TRUNCATE
    
    Queries executed from stored procedures or triggers generate exact table access events
    as executed separately.
    Execution of the prepared statement generate events depending on the content of the statement.
    Every event of a given subtype for a table is generated only once during a single query
    or subquery.
    
    Table access event generation does not reflect real I/O operation on a given table. Events are
    generated before the tables are being accessed. Events are also generated, when no real table
    access takes place, but there was intention to do so during preparing tables before the
    execution takes place.
    
    Events are not generated for temporary tables, views, information schema and performance
    schema tables.
    
    Reviewers
    =========
    Marc Alff <marc.alff@oracle.com>
    Ramil Kalimullin <ramil.kalimullin@oracle.com>
    4359db86
    Bug#21458192 AUDIT API DOES NOT GENERATE EVENTS OF THE 'MYSQL_AUDIT_TABLE_ACCESS_CLASS' CLASS
    Marek Szymczak authored
    Problem
    =======
    Audit API defined events of the 'MYSQL_AUDIT_TABLE_ACCESS_CLASS' class were not generated.
    
    Solution
    ========
    Following events of the 'MYSQL_AUDIT_TABLE_ACCESS_CLASS' class are generated during execution of
    the listed queries:
    
    - MYSQL_AUDIT_TABLE_ACCESS_READ
      - SELECT
      - INSERT ... SELECT (table referenced in the SELECT clause)
      - UPDATE ... WHERE (tables referenced in the WHERE clause)
      - REPLACE ... SELECT (tables referenced in the SELECT clause)
      - HANDLER ... READ
    - MYSQL_AUDIT_TABLE_ACCESS_INSERT
      - INSERT
      - INSERT ... SELECT (table referenced in the INSERT clause)
      - REPLACE
      - REPLACE ... SELECT (table referenced in the REPLACE clause)
      - LOAD DATA INFILE
      - LOAD XML INFILE
    - MYSQL_AUDIT_TABLE_ACCESS_UPDATE
      - UPDATE
      - UPDATE ... WHERE (table or tables referenced in the UPDATE clause)
    - MYSQL_AUDIT_TABLE_ACCESS_DELETE
      - DELETE
      - TRUNCATE
    
    Queries executed from stored procedures or triggers generate exact table access events
    as executed separately.
    Execution of the prepared statement generate events depending on the content of the statement.
    Every event of a given subtype for a table is generated only once during a single query
    or subquery.
    
    Table access event generation does not reflect real I/O operation on a given table. Events are
    generated before the tables are being accessed. Events are also generated, when no real table
    access takes place, but there was intention to do so during preparing tables before the
    execution takes place.
    
    Events are not generated for temporary tables, views, information schema and performance
    schema tables.
    
    Reviewers
    =========
    Marc Alff <marc.alff@oracle.com>
    Ramil Kalimullin <ramil.kalimullin@oracle.com>
Loading