22-Performance Data¶

¶

Performance_schema basic

1. Create 1 database and 1 super table with full data types

2. Create 20 tables under the super table and insert 10 rows data into each table

3. Query all data from the 20 tables

4. Create a TMQ topic and a consumer to consume data from the topic

5. Create and drop a database in a separate thread to generate transaction actions

6. Check the performance_schema tables:

    - perf_apps

    - perf_connections

    - perf_consumers

    - perf_queries

    - perf_trans

7. Check perf_trans table structure