TiDB Audit Plugin User Guide August 4, 2022 TiDB Audit Plugin User Guide Introduction The TiDB audit plugin records the TiDB server’s activities that are expected to follow auditing regulations of of your organization. For each client session, the plugin records users accessing the server (that is, username and IP address), SQL queries executed, databases and tables accessed, environment variable package, and use the audit plugin. Download the plugin You can download the plugin on TiDB Enterprise Edition Downloads. Deploy the audit plugin After downloading the plugin, you can use either TiDB

TiCDC. – Reduce the possibility of TiCDC replication interruption in the following scenar- ios: project#11 * Replication interruption when the network is unstable * Replication interruption when some performance and stability #24150 – Fix the Region is Unavailable issue that occurs in multiple scenarios project#62 – Fix multiple Region is Unavailable issues that might occur in frequent schedul- ing situations from breakpoints#1080 41 2.2.4 Bug Fixes • TiDB – Fix the issue that the execution result of project elimination might be wrong when the projection result is empty #23887 – Fix the issue of wrong query

this time period. • The default storage directory for plugins is changed from "" to /data/deploy/plugin. • The DM code is migrated to the folder “dm” in TiCDC code repository. Now DM follows TiDB in version transactions’ statements are not included in TIDB_TRX #28670 – Fix the wrong default value of the plugin_dir configuration #28084 – Fix the issue that the CONVERT_TZ function returns NULL when it is given Experimental Experimental Columnar storage (TiFlash) Y Y Y Y Y RocksDB engine Y Y Y Y Y Titan plugin Y Y Y Y Y Invisible indexes Y Y Y Y N Composite PRIMARY KEY Y Y Y Y Y Unique indexes Y Y Y Y Y

version. 2.2.1.1 System variables Variable name Change type Description default_authentication_plugin �→ Newly added Sets the au- thentication method that the server advertises. The default value is Experimental Experimental Experimental Columnar storage (TiFlash) Y Y Y Y RocksDB engine Y Y Y Y Titan plugin Y Y Y Y Invisible indexes Y Y Y N Composite PRIMARY KEY Y Y Y Y Unique indexes Y Y Y Y Clustered STANDARD, COLDLINE) predefined �→ -acl Predefined ACL of the uploaded objects (for example, private, project- �→ private �→ ) When credentials-file is not specified, the migration tool will try to infer the

Experimental Experimental Columnar storage (TiFlash) Y Y Y Y Y Y Y Y RocksDB engine Y Y Y Y Y Y Y Y Titan plugin Y Y Y Y Y Y Y Y Invisible indexes Y Y Y Y Y Y Y N 1TiDB incorrectly treats latin1 as a subset of Chat2Query (beta) in your TiDB Cloud console. To access Chat2Query, go to the Clusters page of your project, click your cluster name, and then click Chat2Query in the left navigation pane. In Chat2Query, you This subsection describes the components in the sample application project. 4.3.2.7.1 Overview The catalog tree for this example project is shown below (some incomprehensible parts are removed): . ￿──

Experimental Experimental Columnar storage (TiFlash) Y Y Y Y Y Y RocksDB engine Y Y Y Y Y Y Titan plugin Y Y Y Y Y Y Invisible indexes Y Y Y Y Y N Composite PRIMARY KEY Y Y Y Y Y Y Unique indexes Y Y STANDARD, COLDLINE) predefined �→ -acl Predefined ACL of the uploaded objects (for example, private, project- �→ private �→ ) When credentials-file is not specified, the migration tool will try to infer the --gcs. �→ predefined �→ -acl The pre- defined ACL of the upload object, such as private �→ and project �→ - �→ private �→ . Azblob command-line parameters Command-line parameter | Description | --azblob

queries in OLAP scenarios Y Y Y Y Y Y E N N N N N RocksDB engine Y Y Y Y Y Y Y Y Y Y Y Y Titan plugin Y Y Y Y Y Y Y Y Y Y Y Y Titan Level Merge E E E E E E E E E E E E Use buckets to improve scan concurrency is empty. 3. Save the .env file. Step 4: Initialize the database In the root directory of the project, run the following command to initialize the database: python manage.py migrate Step 5: Run the the tidb-samples/tidb-python- django-quickstart repository. Connect to TiDB In the file sample_project/settings.py, add the following configurations: DATABASES = { "default": { "ENGINE": "django_tidb"

queries in OLAP scenarios Y Y Y Y Y Y E N N N N N RocksDB engine Y Y Y Y Y Y Y Y Y Y Y Y Titan plugin Y Y Y Y Y Y Y Y Y Y Y Y Titan Level Merge E E E E E E E E E E E E Use buckets to improve scan concurrency is empty. 3. Save the .env file. Step 4: Initialize the database In the root directory of the project, run the following command to initialize the database: python manage.py migrate Step 5: Run the the tidb-samples/tidb-python- django-quickstart repository. Connect to TiDB In the file sample_project/settings.py, add the following configurations: DATABASES = { "default": { "ENGINE": "django_tidb"

FastScan to accelerate queries in OLAP scenarios E N N N N N N N RocksDB engine Y Y Y Y Y Y Y Y Titan plugin Y Y Y Y Y Y Y Y Titan Level Merge E E E E E E E E Use buckets to improve scan concurrency E E N empty. 205 3. Save the .env file. Step 4: Initialize the database In the root directory of the project, run the following command to initialize the database: python manage.py migrate Step 5: Run the the tidb-samples/tidb-python- django-quickstart repository. Connect to TiDB In the file sample_project/settings.py, add the following configurations: DATABASES = { "default": { "ENGINE": "django_tidb"

Fix the issue that TiDB server might consume a significant amount of resources when the enterprise plugin for audit logging is used #49273 @lcwangchao • Fix the issue that the optimizer incorrectly converts accelerate queries in OLAP scenarios Y Y Y E N N N N N N N RocksDB engine Y Y Y Y Y Y Y Y Y Y Y Titan plugin Y Y Y Y Y Y Y Y Y Y Y Titan Level Merge E E E E E E E E E E E Use buckets to improve scan concurrency is empty. 3. Save the .env file. Step 4: Initialize the database In the root directory of the project, run the following command to initialize the database: python manage.py migrate Step 5: Run the