Prevent clipping of column names when exporting diagram

Avatar
Ap
Created

This is my workflow.

1) Right click on a mysql database in the database explorer and choose Diagrams -> Show Diagram...

2) Click the Export Diagram button in the toolbar -> Export to image and choose png.

The image exports but tables with longer column names always end up with the text clipped. The text is not clipped when viewing the diagram in DataGrip, but it is always clipped when viewing the exported png. 

I thought I may get around this by exporting the image as an svg, but doing this always results in nothing more than an empty svg file. DataGrip creates a file, but it is an svg file with no contents. 

How can I export Diagrams to image without having the table's column name text clipped?

Below is an example of how a particular table looks when viewing it in DataGrip (1st photo) vs viewing it in an exported png (2nd photo).

 

Votes

1

Share

12 comments
Avatar
Aleksandr Molchanov
Created

Hi Ap,

There's an issue with diagram export to SVG format reported here:

https://youtrack.jetbrains.com/issue/DBE-17864

As for the export to image formats, we couldn't reproduce this behavior where a single letter is clipped while the diagram is in full size (referring to your screenshots). What's your current DataGrip version?

0
Avatar
Ap
Created

Thank you for looking into it. Here's my version and system info (which I should have included in the first place). I do have the experimental UI enabled, but I tried and had the same results with it disabled too. 

DataGrip 2023.1.1
Build #DB-231.8770.3, built on April 11, 2023
Licensed to Accounts Payable
Subscription is active until September 7, 2023.
Runtime version: 17.0.6+10-b829.9 amd64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
Linux 6.2.0-20-generic
GC: G1 Young Generation, G1 Old Generation
Memory: 2048M
Cores: 16
Registry:
    editor.focus.mode.color.light=6a737d
    ide.editor.tab.selection.animation=true
    debugger.new.tool.window.layout=true
    ide.new.editor.tabs.vertical.borders=true
    ide.experimental.ui=true
    ide.balloon.shadow.size=0
    editor.focus.mode.color.dark=6a737d

Non-Bundled Plugins:
    com.4lex4.intellij.solarized (2.4.0)
    IdeaVIM (2.2.0)
    com.mallowigi (90.0.0)
    com.chrisrm.idea.MaterialThemeUI (8.6.3)

Current Desktop: ubuntu:GNOME

0
Avatar
Aleksandr Molchanov
Created
Thanks for the update.

This is interesting as I'm also running an Ubuntu 21.05 with DataGrip 2023.1.1 on it, and I do not observe this behavior with the diagram export. 

Can I ask you to take a screenshot of the whole diagram window in DataGrip and also, attach an exported file with a graphical extension? This is to cross-check things.
0
Avatar
Ap
Created

Sure, here's a screenshot of the entire window with a diagram open, and a png of the same diagram exported from DataGrip. The text is clipped in the diagram viewer inside DataGrip at some zoom levels too. This isn't really a problem though, because I can zoom in/out to make it not clipped. And below this I included a png of this diagram exported. I've also tried exporting to jpg, and gif, but the clipped text persists. Also tried disabling all installed plugins, including theme and icon plugins, and this didn't make a difference either. Thanks again for looking!

 

A .png export of the above diagram

 

 

0
Avatar
Ap
Created

Bumping this

0
Avatar
Aleksandr Molchanov
Created
Apologies for replying to you late.

This behavior doesn't get reproduced even on machines with the same environment. 

Can you upgrade to 2023.1.2 version and see if this issue is present there?
0
Avatar
263963
Created

insane year later and it still doesnt work, nice :)))))))))))) identical issues

0
Avatar
Dhyan Patel
Created

This issue is still prevalent. I am running windows 11 with the current latest version of datagrips. 

As you can see in the attached SC, letters and words are clearly clipped off. 

The image is a database diagram export of type .png

 

0
Avatar
Aleksandr Molchanov
Created

Hi, 

I tested the diagram export in DataGrip 2025.1.3 and was trying to minimize the table width in the diagram window, but it doesn't seem to allow doing that, taking into account the max length of the column. The same goes for the png export. Please specify your current IDE version and provide the table DDL

 

0
Avatar
Karolina Bozkova
Created

I have the same issue. Here is my IDE and OS info:

IntelliJ IDEA 2026.1.3
Build #IU-261.25134.95, built on June 3, 2026
Source revision: adfd17059a568
Subscription is active until September 10, 2026.
Runtime version: 25.0.3+9-b329.124 amd64137.0.17-261-b86
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
Toolkit: sun.awt.wl.WLToolkit
Linux 7.0.10-201.fc44.x86_64
Fedora Linux 44 (Workstation Edition); glibc: 2.43; desktop: GNOME (GNOME Shell 50.1)
Exception reporter ID: 0804253d4741571-5431-4997-88ad-16c51e2d4821
GC: G1 Young Generation, G1 Concurrent GC, G1 Old Generation
Memory: 4096M
Cores: 16
Registry:
  ide.experimental.ui=true
  ide.ui.new.file.chooser=true
  editor.ux.survey.enabled=false
  llm.chat.agent.codex.install.codex.version=0.137.0
  trace.state.event.service.url=https://api.jetbrains.cloud/trace-status
  llm.chat.agent.codex.install.acp.server.version=0.0.46
  ide.images.show.chessboard=true
Non-Bundled Plugins:
  com.intellij.ml.llm (261.25134.237)
  Subversion (261.25134.203)
  com.intellij.lang.jsgraphql (261.22158.185)
  com.anthropic.code.plugin (0.1.14-beta)
  Statistic (5.2)
  mobi.hsz.idea.gitignore (4.5.7)
  ru.adelf.idea.dotenv (261.25134.203)
  PythonCore (261.25134.95)
  com.intellij.reactivestreams (261.22158.182)
  String Manipulation (9.16.0)
  com.intellij.aqua (261.22158.362)
  intellij.vitejs (261.25134.147)
  com.jetbrains.lang.ejs (261.22158.180)
  mdx.js (261.22158.185)
  com.intellij.angularjs (261.22158.185)
  com.intellij.mcpServer (261.25134.203)
  com.github.deeepamin.gitlabciaid (2.0.0)
  org.sonarlint.idea (12.6.0.84973)
  com.github.dinbtechit.vscodetheme (1.12.0)
Kotlin: 261.25134.95-IJ
Current Desktop: GNOME
0
Avatar
Anastasia Zhukova
Created

Hi Karolina Bozkova,

I see from this thread that the issue has been present for quite some time, but we still haven’t been able to reproduce this exact behavior, which is preventing us from investigating and fixing it. Could you please share a few additional details to help us narrow it down?

  1. Does the issue occur only when exporting the diagram to PNG, while the diagram in itself in DataGrip looks correct?
  2. Does it happen only when exporting large schemas, or does it also occur when exporting a diagram with a single table?
  3. Does the issue occur immediately after opening the diagram and exporting it as is, without any additional actions such as zooming or rearranging the diagram?
  4. Which DBMS are you experiencing this issue with?

Lastly, it would be helpful if you could share the exact DDL for the affected table or tables. I could not reproduce the issue by recreating a structure similar to the one shown in the screenshots above, but the screenshots do not contain the full definition, so potentially important details may be missing.

0
Avatar
Karolina Bozkova
Created

Hi Anastasia Zhukova 

ad 1) The diagram in DataGrip looks correct. Sometimes I have to play with zoom/fit, sometimes not. I even manually resized the table boxes so there is ample space for all the information and column names, but that does not help. The column names are cut off when exporting them to all the image formats: PNG, SVG, SVGZ, GIF, JPG. My settings of the top toolbar: options Key columns, Columns, Virtual foreign keys and Comments are ON. On smaller diagrams, I clicked the "1:1" button; on bigger ones, I clicked the "Fit Content" button to make sure everything is visible in case it influences anything.

ad 2) It occurs regardless of schema size - it affects both large and small schemas. On small schemas that don't have long column names it's just less visible (like part of the last letter is cut off) but it still occurs.
I don't have a single-table schema but I do have some small schemas like 3 tables of 3 columns each, or 2 tables where one has 3 columns and another has 6.

ad 3) Yes. Even on diagrams that look correct right away.

ad 4) MySQL


Honestly, it was really easy for me to recreate the bug - I spun up a amd64/mysql:5.6.51 database in docker compose, added a table with some columns, added it to Intellij as a MySQL data source, and it keeps on happening when I generate the diagram via right click on the db → Diagrams → Show diagram. Granted, the table shows up with column names cut off even in IntelliJ, I have to zoom out/stretch the table to fix it. 

Exported PNG without any changes: 

Fixed diagram in DataGrip (zoomed out, stretched table):

Exported PNG: 

Here is the DDL (too bad I cannot attach it as a file, it's a bit long):

-- we don't know how to generate root <with-no-name> (class Root) :(

create table performance_schema.accounts
(
    USER                char(16) collate utf8_bin null,
    HOST                char(60) collate utf8_bin null,
    CURRENT_CONNECTIONS bigint                    not null,
    TOTAL_CONNECTIONS   bigint                    not null
)
    engine = PERFORMANCE_SCHEMA;

create table mysql.columns_priv
(
    Host        char(60)                                                      default ''                not null,
    Db          char(64)                                                      default ''                not null,
    User        char(16)                                                      default ''                not null,
    Table_name  char(64)                                                      default ''                not null,
    Column_name char(64)                                                      default ''                not null,
    Timestamp   timestamp                                                     default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
    Column_priv set ('Select', 'Insert', 'Update', 'References') charset utf8 default ''                not null,
    primary key (Host, Db, User, Table_name, Column_name)
)
    comment 'Column privileges' engine = MyISAM
                                collate = utf8_bin;

create table performance_schema.cond_instances
(
    NAME                  varchar(128)    not null,
    OBJECT_INSTANCE_BEGIN bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table mysql.db
(
    Host                  char(60)                     default ''  not null,
    Db                    char(64)                     default ''  not null,
    User                  char(16)                     default ''  not null,
    Select_priv           enum ('N', 'Y') charset utf8 default 'N' not null,
    Insert_priv           enum ('N', 'Y') charset utf8 default 'N' not null,
    Update_priv           enum ('N', 'Y') charset utf8 default 'N' not null,
    Delete_priv           enum ('N', 'Y') charset utf8 default 'N' not null,
    Create_priv           enum ('N', 'Y') charset utf8 default 'N' not null,
    Drop_priv             enum ('N', 'Y') charset utf8 default 'N' not null,
    Grant_priv            enum ('N', 'Y') charset utf8 default 'N' not null,
    References_priv       enum ('N', 'Y') charset utf8 default 'N' not null,
    Index_priv            enum ('N', 'Y') charset utf8 default 'N' not null,
    Alter_priv            enum ('N', 'Y') charset utf8 default 'N' not null,
    Create_tmp_table_priv enum ('N', 'Y') charset utf8 default 'N' not null,
    Lock_tables_priv      enum ('N', 'Y') charset utf8 default 'N' not null,
    Create_view_priv      enum ('N', 'Y') charset utf8 default 'N' not null,
    Show_view_priv        enum ('N', 'Y') charset utf8 default 'N' not null,
    Create_routine_priv   enum ('N', 'Y') charset utf8 default 'N' not null,
    Alter_routine_priv    enum ('N', 'Y') charset utf8 default 'N' not null,
    Execute_priv          enum ('N', 'Y') charset utf8 default 'N' not null,
    Event_priv            enum ('N', 'Y') charset utf8 default 'N' not null,
    Trigger_priv          enum ('N', 'Y') charset utf8 default 'N' not null,
    primary key (Host, Db, User)
)
    comment 'Database privileges' engine = MyISAM
                                  collate = utf8_bin;

create index User
    on mysql.db (User);

create table my_db.employees
(
    id          int auto_increment
        primary key,
    first_name  varchar(50) not null,
    last_name   varchar(50) not null,
    middle_name varchar(50) not null
);

create table mysql.event
(
    db                   char(64) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           default ''                    not null,
    name                 char(64)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            default ''                    not null,
    body                 longblob                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          not null,
    definer              char(77) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           default ''                    not null,
    execute_at           datetime                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          null,
    interval_value       int                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               null,
    interval_field       enum ('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND')                                                                                                                                                                                                                                                                                                                                               null,
    created              timestamp                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           default CURRENT_TIMESTAMP     not null on update CURRENT_TIMESTAMP,
    modified             timestamp                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           default '0000-00-00 00:00:00' not null,
    last_executed        datetime                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          null,
    starts               datetime                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          null,
    ends                 datetime                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          null,
    status               enum ('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  default 'ENABLED'             not null,
    on_completion        enum ('DROP', 'PRESERVE')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           default 'DROP'                not null,
    sql_mode             set ('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH') default ''                    not null,
    comment              char(64) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           default ''                    not null,
    originator           int unsigned                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      not null,
    time_zone            char(64) charset latin1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             default 'SYSTEM'              not null,
    character_set_client char(32) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         null,
    collation_connection char(32) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         null,
    db_collation         char(32) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         null,
    body_utf8            longblob                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          null,
    primary key (db, name)
)
    comment 'Events' engine = MyISAM
                     charset = utf8;

create table performance_schema.events_stages_current
(
    THREAD_ID          bigint unsigned                     not null,
    EVENT_ID           bigint unsigned                     not null,
    END_EVENT_ID       bigint unsigned                     null,
    EVENT_NAME         varchar(128)                        not null,
    SOURCE             varchar(64)                         null,
    TIMER_START        bigint unsigned                     null,
    TIMER_END          bigint unsigned                     null,
    TIMER_WAIT         bigint unsigned                     null,
    NESTING_EVENT_ID   bigint unsigned                     null,
    NESTING_EVENT_TYPE enum ('STATEMENT', 'STAGE', 'WAIT') null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_stages_history
(
    THREAD_ID          bigint unsigned                     not null,
    EVENT_ID           bigint unsigned                     not null,
    END_EVENT_ID       bigint unsigned                     null,
    EVENT_NAME         varchar(128)                        not null,
    SOURCE             varchar(64)                         null,
    TIMER_START        bigint unsigned                     null,
    TIMER_END          bigint unsigned                     null,
    TIMER_WAIT         bigint unsigned                     null,
    NESTING_EVENT_ID   bigint unsigned                     null,
    NESTING_EVENT_TYPE enum ('STATEMENT', 'STAGE', 'WAIT') null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_stages_history_long
(
    THREAD_ID          bigint unsigned                     not null,
    EVENT_ID           bigint unsigned                     not null,
    END_EVENT_ID       bigint unsigned                     null,
    EVENT_NAME         varchar(128)                        not null,
    SOURCE             varchar(64)                         null,
    TIMER_START        bigint unsigned                     null,
    TIMER_END          bigint unsigned                     null,
    TIMER_WAIT         bigint unsigned                     null,
    NESTING_EVENT_ID   bigint unsigned                     null,
    NESTING_EVENT_TYPE enum ('STATEMENT', 'STAGE', 'WAIT') null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_stages_summary_by_account_by_event_name
(
    USER           char(16) collate utf8_bin null,
    HOST           char(60) collate utf8_bin null,
    EVENT_NAME     varchar(128)              not null,
    COUNT_STAR     bigint unsigned           not null,
    SUM_TIMER_WAIT bigint unsigned           not null,
    MIN_TIMER_WAIT bigint unsigned           not null,
    AVG_TIMER_WAIT bigint unsigned           not null,
    MAX_TIMER_WAIT bigint unsigned           not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_stages_summary_by_host_by_event_name
(
    HOST           char(60) collate utf8_bin null,
    EVENT_NAME     varchar(128)              not null,
    COUNT_STAR     bigint unsigned           not null,
    SUM_TIMER_WAIT bigint unsigned           not null,
    MIN_TIMER_WAIT bigint unsigned           not null,
    AVG_TIMER_WAIT bigint unsigned           not null,
    MAX_TIMER_WAIT bigint unsigned           not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_stages_summary_by_thread_by_event_name
(
    THREAD_ID      bigint unsigned not null,
    EVENT_NAME     varchar(128)    not null,
    COUNT_STAR     bigint unsigned not null,
    SUM_TIMER_WAIT bigint unsigned not null,
    MIN_TIMER_WAIT bigint unsigned not null,
    AVG_TIMER_WAIT bigint unsigned not null,
    MAX_TIMER_WAIT bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_stages_summary_by_user_by_event_name
(
    USER           char(16) collate utf8_bin null,
    EVENT_NAME     varchar(128)              not null,
    COUNT_STAR     bigint unsigned           not null,
    SUM_TIMER_WAIT bigint unsigned           not null,
    MIN_TIMER_WAIT bigint unsigned           not null,
    AVG_TIMER_WAIT bigint unsigned           not null,
    MAX_TIMER_WAIT bigint unsigned           not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_stages_summary_global_by_event_name
(
    EVENT_NAME     varchar(128)    not null,
    COUNT_STAR     bigint unsigned not null,
    SUM_TIMER_WAIT bigint unsigned not null,
    MIN_TIMER_WAIT bigint unsigned not null,
    AVG_TIMER_WAIT bigint unsigned not null,
    MAX_TIMER_WAIT bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_statements_current
(
    THREAD_ID               bigint unsigned                     not null,
    EVENT_ID                bigint unsigned                     not null,
    END_EVENT_ID            bigint unsigned                     null,
    EVENT_NAME              varchar(128)                        not null,
    SOURCE                  varchar(64)                         null,
    TIMER_START             bigint unsigned                     null,
    TIMER_END               bigint unsigned                     null,
    TIMER_WAIT              bigint unsigned                     null,
    LOCK_TIME               bigint unsigned                     not null,
    SQL_TEXT                longtext                            null,
    DIGEST                  varchar(32)                         null,
    DIGEST_TEXT             longtext                            null,
    CURRENT_SCHEMA          varchar(64)                         null,
    OBJECT_TYPE             varchar(64)                         null,
    OBJECT_SCHEMA           varchar(64)                         null,
    OBJECT_NAME             varchar(64)                         null,
    OBJECT_INSTANCE_BEGIN   bigint unsigned                     null,
    MYSQL_ERRNO             int                                 null,
    RETURNED_SQLSTATE       varchar(5)                          null,
    MESSAGE_TEXT            varchar(128)                        null,
    ERRORS                  bigint unsigned                     not null,
    WARNINGS                bigint unsigned                     not null,
    ROWS_AFFECTED           bigint unsigned                     not null,
    ROWS_SENT               bigint unsigned                     not null,
    ROWS_EXAMINED           bigint unsigned                     not null,
    CREATED_TMP_DISK_TABLES bigint unsigned                     not null,
    CREATED_TMP_TABLES      bigint unsigned                     not null,
    SELECT_FULL_JOIN        bigint unsigned                     not null,
    SELECT_FULL_RANGE_JOIN  bigint unsigned                     not null,
    SELECT_RANGE            bigint unsigned                     not null,
    SELECT_RANGE_CHECK      bigint unsigned                     not null,
    SELECT_SCAN             bigint unsigned                     not null,
    SORT_MERGE_PASSES       bigint unsigned                     not null,
    SORT_RANGE              bigint unsigned                     not null,
    SORT_ROWS               bigint unsigned                     not null,
    SORT_SCAN               bigint unsigned                     not null,
    NO_INDEX_USED           bigint unsigned                     not null,
    NO_GOOD_INDEX_USED      bigint unsigned                     not null,
    NESTING_EVENT_ID        bigint unsigned                     null,
    NESTING_EVENT_TYPE      enum ('STATEMENT', 'STAGE', 'WAIT') null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_statements_history
(
    THREAD_ID               bigint unsigned                     not null,
    EVENT_ID                bigint unsigned                     not null,
    END_EVENT_ID            bigint unsigned                     null,
    EVENT_NAME              varchar(128)                        not null,
    SOURCE                  varchar(64)                         null,
    TIMER_START             bigint unsigned                     null,
    TIMER_END               bigint unsigned                     null,
    TIMER_WAIT              bigint unsigned                     null,
    LOCK_TIME               bigint unsigned                     not null,
    SQL_TEXT                longtext                            null,
    DIGEST                  varchar(32)                         null,
    DIGEST_TEXT             longtext                            null,
    CURRENT_SCHEMA          varchar(64)                         null,
    OBJECT_TYPE             varchar(64)                         null,
    OBJECT_SCHEMA           varchar(64)                         null,
    OBJECT_NAME             varchar(64)                         null,
    OBJECT_INSTANCE_BEGIN   bigint unsigned                     null,
    MYSQL_ERRNO             int                                 null,
    RETURNED_SQLSTATE       varchar(5)                          null,
    MESSAGE_TEXT            varchar(128)                        null,
    ERRORS                  bigint unsigned                     not null,
    WARNINGS                bigint unsigned                     not null,
    ROWS_AFFECTED           bigint unsigned                     not null,
    ROWS_SENT               bigint unsigned                     not null,
    ROWS_EXAMINED           bigint unsigned                     not null,
    CREATED_TMP_DISK_TABLES bigint unsigned                     not null,
    CREATED_TMP_TABLES      bigint unsigned                     not null,
    SELECT_FULL_JOIN        bigint unsigned                     not null,
    SELECT_FULL_RANGE_JOIN  bigint unsigned                     not null,
    SELECT_RANGE            bigint unsigned                     not null,
    SELECT_RANGE_CHECK      bigint unsigned                     not null,
    SELECT_SCAN             bigint unsigned                     not null,
    SORT_MERGE_PASSES       bigint unsigned                     not null,
    SORT_RANGE              bigint unsigned                     not null,
    SORT_ROWS               bigint unsigned                     not null,
    SORT_SCAN               bigint unsigned                     not null,
    NO_INDEX_USED           bigint unsigned                     not null,
    NO_GOOD_INDEX_USED      bigint unsigned                     not null,
    NESTING_EVENT_ID        bigint unsigned                     null,
    NESTING_EVENT_TYPE      enum ('STATEMENT', 'STAGE', 'WAIT') null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_statements_history_long
(
    THREAD_ID               bigint unsigned                     not null,
    EVENT_ID                bigint unsigned                     not null,
    END_EVENT_ID            bigint unsigned                     null,
    EVENT_NAME              varchar(128)                        not null,
    SOURCE                  varchar(64)                         null,
    TIMER_START             bigint unsigned                     null,
    TIMER_END               bigint unsigned                     null,
    TIMER_WAIT              bigint unsigned                     null,
    LOCK_TIME               bigint unsigned                     not null,
    SQL_TEXT                longtext                            null,
    DIGEST                  varchar(32)                         null,
    DIGEST_TEXT             longtext                            null,
    CURRENT_SCHEMA          varchar(64)                         null,
    OBJECT_TYPE             varchar(64)                         null,
    OBJECT_SCHEMA           varchar(64)                         null,
    OBJECT_NAME             varchar(64)                         null,
    OBJECT_INSTANCE_BEGIN   bigint unsigned                     null,
    MYSQL_ERRNO             int                                 null,
    RETURNED_SQLSTATE       varchar(5)                          null,
    MESSAGE_TEXT            varchar(128)                        null,
    ERRORS                  bigint unsigned                     not null,
    WARNINGS                bigint unsigned                     not null,
    ROWS_AFFECTED           bigint unsigned                     not null,
    ROWS_SENT               bigint unsigned                     not null,
    ROWS_EXAMINED           bigint unsigned                     not null,
    CREATED_TMP_DISK_TABLES bigint unsigned                     not null,
    CREATED_TMP_TABLES      bigint unsigned                     not null,
    SELECT_FULL_JOIN        bigint unsigned                     not null,
    SELECT_FULL_RANGE_JOIN  bigint unsigned                     not null,
    SELECT_RANGE            bigint unsigned                     not null,
    SELECT_RANGE_CHECK      bigint unsigned                     not null,
    SELECT_SCAN             bigint unsigned                     not null,
    SORT_MERGE_PASSES       bigint unsigned                     not null,
    SORT_RANGE              bigint unsigned                     not null,
    SORT_ROWS               bigint unsigned                     not null,
    SORT_SCAN               bigint unsigned                     not null,
    NO_INDEX_USED           bigint unsigned                     not null,
    NO_GOOD_INDEX_USED      bigint unsigned                     not null,
    NESTING_EVENT_ID        bigint unsigned                     null,
    NESTING_EVENT_TYPE      enum ('STATEMENT', 'STAGE', 'WAIT') null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_statements_summary_by_account_by_event_name
(
    USER                        char(16) collate utf8_bin null,
    HOST                        char(60) collate utf8_bin null,
    EVENT_NAME                  varchar(128)              not null,
    COUNT_STAR                  bigint unsigned           not null,
    SUM_TIMER_WAIT              bigint unsigned           not null,
    MIN_TIMER_WAIT              bigint unsigned           not null,
    AVG_TIMER_WAIT              bigint unsigned           not null,
    MAX_TIMER_WAIT              bigint unsigned           not null,
    SUM_LOCK_TIME               bigint unsigned           not null,
    SUM_ERRORS                  bigint unsigned           not null,
    SUM_WARNINGS                bigint unsigned           not null,
    SUM_ROWS_AFFECTED           bigint unsigned           not null,
    SUM_ROWS_SENT               bigint unsigned           not null,
    SUM_ROWS_EXAMINED           bigint unsigned           not null,
    SUM_CREATED_TMP_DISK_TABLES bigint unsigned           not null,
    SUM_CREATED_TMP_TABLES      bigint unsigned           not null,
    SUM_SELECT_FULL_JOIN        bigint unsigned           not null,
    SUM_SELECT_FULL_RANGE_JOIN  bigint unsigned           not null,
    SUM_SELECT_RANGE            bigint unsigned           not null,
    SUM_SELECT_RANGE_CHECK      bigint unsigned           not null,
    SUM_SELECT_SCAN             bigint unsigned           not null,
    SUM_SORT_MERGE_PASSES       bigint unsigned           not null,
    SUM_SORT_RANGE              bigint unsigned           not null,
    SUM_SORT_ROWS               bigint unsigned           not null,
    SUM_SORT_SCAN               bigint unsigned           not null,
    SUM_NO_INDEX_USED           bigint unsigned           not null,
    SUM_NO_GOOD_INDEX_USED      bigint unsigned           not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_statements_summary_by_digest
(
    SCHEMA_NAME                 varchar(64)                             null,
    DIGEST                      varchar(32)                             null,
    DIGEST_TEXT                 longtext                                null,
    COUNT_STAR                  bigint unsigned                         not null,
    SUM_TIMER_WAIT              bigint unsigned                         not null,
    MIN_TIMER_WAIT              bigint unsigned                         not null,
    AVG_TIMER_WAIT              bigint unsigned                         not null,
    MAX_TIMER_WAIT              bigint unsigned                         not null,
    SUM_LOCK_TIME               bigint unsigned                         not null,
    SUM_ERRORS                  bigint unsigned                         not null,
    SUM_WARNINGS                bigint unsigned                         not null,
    SUM_ROWS_AFFECTED           bigint unsigned                         not null,
    SUM_ROWS_SENT               bigint unsigned                         not null,
    SUM_ROWS_EXAMINED           bigint unsigned                         not null,
    SUM_CREATED_TMP_DISK_TABLES bigint unsigned                         not null,
    SUM_CREATED_TMP_TABLES      bigint unsigned                         not null,
    SUM_SELECT_FULL_JOIN        bigint unsigned                         not null,
    SUM_SELECT_FULL_RANGE_JOIN  bigint unsigned                         not null,
    SUM_SELECT_RANGE            bigint unsigned                         not null,
    SUM_SELECT_RANGE_CHECK      bigint unsigned                         not null,
    SUM_SELECT_SCAN             bigint unsigned                         not null,
    SUM_SORT_MERGE_PASSES       bigint unsigned                         not null,
    SUM_SORT_RANGE              bigint unsigned                         not null,
    SUM_SORT_ROWS               bigint unsigned                         not null,
    SUM_SORT_SCAN               bigint unsigned                         not null,
    SUM_NO_INDEX_USED           bigint unsigned                         not null,
    SUM_NO_GOOD_INDEX_USED      bigint unsigned                         not null,
    FIRST_SEEN                  timestamp default '0000-00-00 00:00:00' not null,
    LAST_SEEN                   timestamp default '0000-00-00 00:00:00' not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_statements_summary_by_host_by_event_name
(
    HOST                        char(60) collate utf8_bin null,
    EVENT_NAME                  varchar(128)              not null,
    COUNT_STAR                  bigint unsigned           not null,
    SUM_TIMER_WAIT              bigint unsigned           not null,
    MIN_TIMER_WAIT              bigint unsigned           not null,
    AVG_TIMER_WAIT              bigint unsigned           not null,
    MAX_TIMER_WAIT              bigint unsigned           not null,
    SUM_LOCK_TIME               bigint unsigned           not null,
    SUM_ERRORS                  bigint unsigned           not null,
    SUM_WARNINGS                bigint unsigned           not null,
    SUM_ROWS_AFFECTED           bigint unsigned           not null,
    SUM_ROWS_SENT               bigint unsigned           not null,
    SUM_ROWS_EXAMINED           bigint unsigned           not null,
    SUM_CREATED_TMP_DISK_TABLES bigint unsigned           not null,
    SUM_CREATED_TMP_TABLES      bigint unsigned           not null,
    SUM_SELECT_FULL_JOIN        bigint unsigned           not null,
    SUM_SELECT_FULL_RANGE_JOIN  bigint unsigned           not null,
    SUM_SELECT_RANGE            bigint unsigned           not null,
    SUM_SELECT_RANGE_CHECK      bigint unsigned           not null,
    SUM_SELECT_SCAN             bigint unsigned           not null,
    SUM_SORT_MERGE_PASSES       bigint unsigned           not null,
    SUM_SORT_RANGE              bigint unsigned           not null,
    SUM_SORT_ROWS               bigint unsigned           not null,
    SUM_SORT_SCAN               bigint unsigned           not null,
    SUM_NO_INDEX_USED           bigint unsigned           not null,
    SUM_NO_GOOD_INDEX_USED      bigint unsigned           not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_statements_summary_by_thread_by_event_name
(
    THREAD_ID                   bigint unsigned not null,
    EVENT_NAME                  varchar(128)    not null,
    COUNT_STAR                  bigint unsigned not null,
    SUM_TIMER_WAIT              bigint unsigned not null,
    MIN_TIMER_WAIT              bigint unsigned not null,
    AVG_TIMER_WAIT              bigint unsigned not null,
    MAX_TIMER_WAIT              bigint unsigned not null,
    SUM_LOCK_TIME               bigint unsigned not null,
    SUM_ERRORS                  bigint unsigned not null,
    SUM_WARNINGS                bigint unsigned not null,
    SUM_ROWS_AFFECTED           bigint unsigned not null,
    SUM_ROWS_SENT               bigint unsigned not null,
    SUM_ROWS_EXAMINED           bigint unsigned not null,
    SUM_CREATED_TMP_DISK_TABLES bigint unsigned not null,
    SUM_CREATED_TMP_TABLES      bigint unsigned not null,
    SUM_SELECT_FULL_JOIN        bigint unsigned not null,
    SUM_SELECT_FULL_RANGE_JOIN  bigint unsigned not null,
    SUM_SELECT_RANGE            bigint unsigned not null,
    SUM_SELECT_RANGE_CHECK      bigint unsigned not null,
    SUM_SELECT_SCAN             bigint unsigned not null,
    SUM_SORT_MERGE_PASSES       bigint unsigned not null,
    SUM_SORT_RANGE              bigint unsigned not null,
    SUM_SORT_ROWS               bigint unsigned not null,
    SUM_SORT_SCAN               bigint unsigned not null,
    SUM_NO_INDEX_USED           bigint unsigned not null,
    SUM_NO_GOOD_INDEX_USED      bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_statements_summary_by_user_by_event_name
(
    USER                        char(16) collate utf8_bin null,
    EVENT_NAME                  varchar(128)              not null,
    COUNT_STAR                  bigint unsigned           not null,
    SUM_TIMER_WAIT              bigint unsigned           not null,
    MIN_TIMER_WAIT              bigint unsigned           not null,
    AVG_TIMER_WAIT              bigint unsigned           not null,
    MAX_TIMER_WAIT              bigint unsigned           not null,
    SUM_LOCK_TIME               bigint unsigned           not null,
    SUM_ERRORS                  bigint unsigned           not null,
    SUM_WARNINGS                bigint unsigned           not null,
    SUM_ROWS_AFFECTED           bigint unsigned           not null,
    SUM_ROWS_SENT               bigint unsigned           not null,
    SUM_ROWS_EXAMINED           bigint unsigned           not null,
    SUM_CREATED_TMP_DISK_TABLES bigint unsigned           not null,
    SUM_CREATED_TMP_TABLES      bigint unsigned           not null,
    SUM_SELECT_FULL_JOIN        bigint unsigned           not null,
    SUM_SELECT_FULL_RANGE_JOIN  bigint unsigned           not null,
    SUM_SELECT_RANGE            bigint unsigned           not null,
    SUM_SELECT_RANGE_CHECK      bigint unsigned           not null,
    SUM_SELECT_SCAN             bigint unsigned           not null,
    SUM_SORT_MERGE_PASSES       bigint unsigned           not null,
    SUM_SORT_RANGE              bigint unsigned           not null,
    SUM_SORT_ROWS               bigint unsigned           not null,
    SUM_SORT_SCAN               bigint unsigned           not null,
    SUM_NO_INDEX_USED           bigint unsigned           not null,
    SUM_NO_GOOD_INDEX_USED      bigint unsigned           not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_statements_summary_global_by_event_name
(
    EVENT_NAME                  varchar(128)    not null,
    COUNT_STAR                  bigint unsigned not null,
    SUM_TIMER_WAIT              bigint unsigned not null,
    MIN_TIMER_WAIT              bigint unsigned not null,
    AVG_TIMER_WAIT              bigint unsigned not null,
    MAX_TIMER_WAIT              bigint unsigned not null,
    SUM_LOCK_TIME               bigint unsigned not null,
    SUM_ERRORS                  bigint unsigned not null,
    SUM_WARNINGS                bigint unsigned not null,
    SUM_ROWS_AFFECTED           bigint unsigned not null,
    SUM_ROWS_SENT               bigint unsigned not null,
    SUM_ROWS_EXAMINED           bigint unsigned not null,
    SUM_CREATED_TMP_DISK_TABLES bigint unsigned not null,
    SUM_CREATED_TMP_TABLES      bigint unsigned not null,
    SUM_SELECT_FULL_JOIN        bigint unsigned not null,
    SUM_SELECT_FULL_RANGE_JOIN  bigint unsigned not null,
    SUM_SELECT_RANGE            bigint unsigned not null,
    SUM_SELECT_RANGE_CHECK      bigint unsigned not null,
    SUM_SELECT_SCAN             bigint unsigned not null,
    SUM_SORT_MERGE_PASSES       bigint unsigned not null,
    SUM_SORT_RANGE              bigint unsigned not null,
    SUM_SORT_ROWS               bigint unsigned not null,
    SUM_SORT_SCAN               bigint unsigned not null,
    SUM_NO_INDEX_USED           bigint unsigned not null,
    SUM_NO_GOOD_INDEX_USED      bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_waits_current
(
    THREAD_ID             bigint unsigned                     not null,
    EVENT_ID              bigint unsigned                     not null,
    END_EVENT_ID          bigint unsigned                     null,
    EVENT_NAME            varchar(128)                        not null,
    SOURCE                varchar(64)                         null,
    TIMER_START           bigint unsigned                     null,
    TIMER_END             bigint unsigned                     null,
    TIMER_WAIT            bigint unsigned                     null,
    SPINS                 int unsigned                        null,
    OBJECT_SCHEMA         varchar(64)                         null,
    OBJECT_NAME           varchar(512)                        null,
    INDEX_NAME            varchar(64)                         null,
    OBJECT_TYPE           varchar(64)                         null,
    OBJECT_INSTANCE_BEGIN bigint unsigned                     not null,
    NESTING_EVENT_ID      bigint unsigned                     null,
    NESTING_EVENT_TYPE    enum ('STATEMENT', 'STAGE', 'WAIT') null,
    OPERATION             varchar(32)                         not null,
    NUMBER_OF_BYTES       bigint                              null,
    FLAGS                 int unsigned                        null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_waits_history
(
    THREAD_ID             bigint unsigned                     not null,
    EVENT_ID              bigint unsigned                     not null,
    END_EVENT_ID          bigint unsigned                     null,
    EVENT_NAME            varchar(128)                        not null,
    SOURCE                varchar(64)                         null,
    TIMER_START           bigint unsigned                     null,
    TIMER_END             bigint unsigned                     null,
    TIMER_WAIT            bigint unsigned                     null,
    SPINS                 int unsigned                        null,
    OBJECT_SCHEMA         varchar(64)                         null,
    OBJECT_NAME           varchar(512)                        null,
    INDEX_NAME            varchar(64)                         null,
    OBJECT_TYPE           varchar(64)                         null,
    OBJECT_INSTANCE_BEGIN bigint unsigned                     not null,
    NESTING_EVENT_ID      bigint unsigned                     null,
    NESTING_EVENT_TYPE    enum ('STATEMENT', 'STAGE', 'WAIT') null,
    OPERATION             varchar(32)                         not null,
    NUMBER_OF_BYTES       bigint                              null,
    FLAGS                 int unsigned                        null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_waits_history_long
(
    THREAD_ID             bigint unsigned                     not null,
    EVENT_ID              bigint unsigned                     not null,
    END_EVENT_ID          bigint unsigned                     null,
    EVENT_NAME            varchar(128)                        not null,
    SOURCE                varchar(64)                         null,
    TIMER_START           bigint unsigned                     null,
    TIMER_END             bigint unsigned                     null,
    TIMER_WAIT            bigint unsigned                     null,
    SPINS                 int unsigned                        null,
    OBJECT_SCHEMA         varchar(64)                         null,
    OBJECT_NAME           varchar(512)                        null,
    INDEX_NAME            varchar(64)                         null,
    OBJECT_TYPE           varchar(64)                         null,
    OBJECT_INSTANCE_BEGIN bigint unsigned                     not null,
    NESTING_EVENT_ID      bigint unsigned                     null,
    NESTING_EVENT_TYPE    enum ('STATEMENT', 'STAGE', 'WAIT') null,
    OPERATION             varchar(32)                         not null,
    NUMBER_OF_BYTES       bigint                              null,
    FLAGS                 int unsigned                        null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_waits_summary_by_account_by_event_name
(
    USER           char(16) collate utf8_bin null,
    HOST           char(60) collate utf8_bin null,
    EVENT_NAME     varchar(128)              not null,
    COUNT_STAR     bigint unsigned           not null,
    SUM_TIMER_WAIT bigint unsigned           not null,
    MIN_TIMER_WAIT bigint unsigned           not null,
    AVG_TIMER_WAIT bigint unsigned           not null,
    MAX_TIMER_WAIT bigint unsigned           not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_waits_summary_by_host_by_event_name
(
    HOST           char(60) collate utf8_bin null,
    EVENT_NAME     varchar(128)              not null,
    COUNT_STAR     bigint unsigned           not null,
    SUM_TIMER_WAIT bigint unsigned           not null,
    MIN_TIMER_WAIT bigint unsigned           not null,
    AVG_TIMER_WAIT bigint unsigned           not null,
    MAX_TIMER_WAIT bigint unsigned           not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_waits_summary_by_instance
(
    EVENT_NAME            varchar(128)    not null,
    OBJECT_INSTANCE_BEGIN bigint unsigned not null,
    COUNT_STAR            bigint unsigned not null,
    SUM_TIMER_WAIT        bigint unsigned not null,
    MIN_TIMER_WAIT        bigint unsigned not null,
    AVG_TIMER_WAIT        bigint unsigned not null,
    MAX_TIMER_WAIT        bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_waits_summary_by_thread_by_event_name
(
    THREAD_ID      bigint unsigned not null,
    EVENT_NAME     varchar(128)    not null,
    COUNT_STAR     bigint unsigned not null,
    SUM_TIMER_WAIT bigint unsigned not null,
    MIN_TIMER_WAIT bigint unsigned not null,
    AVG_TIMER_WAIT bigint unsigned not null,
    MAX_TIMER_WAIT bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_waits_summary_by_user_by_event_name
(
    USER           char(16) collate utf8_bin null,
    EVENT_NAME     varchar(128)              not null,
    COUNT_STAR     bigint unsigned           not null,
    SUM_TIMER_WAIT bigint unsigned           not null,
    MIN_TIMER_WAIT bigint unsigned           not null,
    AVG_TIMER_WAIT bigint unsigned           not null,
    MAX_TIMER_WAIT bigint unsigned           not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.events_waits_summary_global_by_event_name
(
    EVENT_NAME     varchar(128)    not null,
    COUNT_STAR     bigint unsigned not null,
    SUM_TIMER_WAIT bigint unsigned not null,
    MIN_TIMER_WAIT bigint unsigned not null,
    AVG_TIMER_WAIT bigint unsigned not null,
    MAX_TIMER_WAIT bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.file_instances
(
    FILE_NAME  varchar(512) not null,
    EVENT_NAME varchar(128) not null,
    OPEN_COUNT int unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.file_summary_by_event_name
(
    EVENT_NAME                varchar(128)    not null,
    COUNT_STAR                bigint unsigned not null,
    SUM_TIMER_WAIT            bigint unsigned not null,
    MIN_TIMER_WAIT            bigint unsigned not null,
    AVG_TIMER_WAIT            bigint unsigned not null,
    MAX_TIMER_WAIT            bigint unsigned not null,
    COUNT_READ                bigint unsigned not null,
    SUM_TIMER_READ            bigint unsigned not null,
    MIN_TIMER_READ            bigint unsigned not null,
    AVG_TIMER_READ            bigint unsigned not null,
    MAX_TIMER_READ            bigint unsigned not null,
    SUM_NUMBER_OF_BYTES_READ  bigint          not null,
    COUNT_WRITE               bigint unsigned not null,
    SUM_TIMER_WRITE           bigint unsigned not null,
    MIN_TIMER_WRITE           bigint unsigned not null,
    AVG_TIMER_WRITE           bigint unsigned not null,
    MAX_TIMER_WRITE           bigint unsigned not null,
    SUM_NUMBER_OF_BYTES_WRITE bigint          not null,
    COUNT_MISC                bigint unsigned not null,
    SUM_TIMER_MISC            bigint unsigned not null,
    MIN_TIMER_MISC            bigint unsigned not null,
    AVG_TIMER_MISC            bigint unsigned not null,
    MAX_TIMER_MISC            bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.file_summary_by_instance
(
    FILE_NAME                 varchar(512)    not null,
    EVENT_NAME                varchar(128)    not null,
    OBJECT_INSTANCE_BEGIN     bigint unsigned not null,
    COUNT_STAR                bigint unsigned not null,
    SUM_TIMER_WAIT            bigint unsigned not null,
    MIN_TIMER_WAIT            bigint unsigned not null,
    AVG_TIMER_WAIT            bigint unsigned not null,
    MAX_TIMER_WAIT            bigint unsigned not null,
    COUNT_READ                bigint unsigned not null,
    SUM_TIMER_READ            bigint unsigned not null,
    MIN_TIMER_READ            bigint unsigned not null,
    AVG_TIMER_READ            bigint unsigned not null,
    MAX_TIMER_READ            bigint unsigned not null,
    SUM_NUMBER_OF_BYTES_READ  bigint          not null,
    COUNT_WRITE               bigint unsigned not null,
    SUM_TIMER_WRITE           bigint unsigned not null,
    MIN_TIMER_WRITE           bigint unsigned not null,
    AVG_TIMER_WRITE           bigint unsigned not null,
    MAX_TIMER_WRITE           bigint unsigned not null,
    SUM_NUMBER_OF_BYTES_WRITE bigint          not null,
    COUNT_MISC                bigint unsigned not null,
    SUM_TIMER_MISC            bigint unsigned not null,
    MIN_TIMER_MISC            bigint unsigned not null,
    AVG_TIMER_MISC            bigint unsigned not null,
    MAX_TIMER_MISC            bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table mysql.func
(
    name char(64)   default ''                       not null
        primary key,
    ret  tinyint(1) default 0                        not null,
    dl   char(128)  default ''                       not null,
    type enum ('function', 'aggregate') charset utf8 not null
)
    comment 'User defined functions' engine = MyISAM
                                     collate = utf8_bin;

create table mysql.general_log
(
    event_time   timestamp default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
    user_host    mediumtext                          not null,
    thread_id    bigint(21) unsigned                 not null,
    server_id    int unsigned                        not null,
    command_type varchar(64)                         not null,
    argument     mediumtext                          not null
)
    comment 'General log' engine = CSV
                          charset = utf8;

create table mysql.help_category
(
    help_category_id   smallint unsigned not null
        primary key,
    name               char(64)          not null,
    parent_category_id smallint unsigned null,
    url                text              not null,
    constraint name
        unique (name)
)
    comment 'help categories' engine = MyISAM
                              charset = utf8;

create table mysql.help_keyword
(
    help_keyword_id int unsigned not null
        primary key,
    name            char(64)     not null,
    constraint name
        unique (name)
)
    comment 'help keywords' engine = MyISAM
                            charset = utf8;

create table mysql.help_relation
(
    help_topic_id   int unsigned not null,
    help_keyword_id int unsigned not null,
    primary key (help_keyword_id, help_topic_id)
)
    comment 'keyword-topic relation' engine = MyISAM
                                     charset = utf8;

create table mysql.help_topic
(
    help_topic_id    int unsigned      not null
        primary key,
    name             char(64)          not null,
    help_category_id smallint unsigned not null,
    description      text              not null,
    example          text              not null,
    url              text              not null,
    constraint name
        unique (name)
)
    comment 'help topics' engine = MyISAM
                          charset = utf8;

create table performance_schema.host_cache
(
    IP                                         varchar(64)                             not null,
    HOST                                       varchar(255) collate utf8_bin           null,
    HOST_VALIDATED                             enum ('YES', 'NO')                      not null,
    SUM_CONNECT_ERRORS                         bigint                                  not null,
    COUNT_HOST_BLOCKED_ERRORS                  bigint                                  not null,
    COUNT_NAMEINFO_TRANSIENT_ERRORS            bigint                                  not null,
    COUNT_NAMEINFO_PERMANENT_ERRORS            bigint                                  not null,
    COUNT_FORMAT_ERRORS                        bigint                                  not null,
    COUNT_ADDRINFO_TRANSIENT_ERRORS            bigint                                  not null,
    COUNT_ADDRINFO_PERMANENT_ERRORS            bigint                                  not null,
    COUNT_FCRDNS_ERRORS                        bigint                                  not null,
    COUNT_HOST_ACL_ERRORS                      bigint                                  not null,
    COUNT_NO_AUTH_PLUGIN_ERRORS                bigint                                  not null,
    COUNT_AUTH_PLUGIN_ERRORS                   bigint                                  not null,
    COUNT_HANDSHAKE_ERRORS                     bigint                                  not null,
    COUNT_PROXY_USER_ERRORS                    bigint                                  not null,
    COUNT_PROXY_USER_ACL_ERRORS                bigint                                  not null,
    COUNT_AUTHENTICATION_ERRORS                bigint                                  not null,
    COUNT_SSL_ERRORS                           bigint                                  not null,
    COUNT_MAX_USER_CONNECTIONS_ERRORS          bigint                                  not null,
    COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS bigint                                  not null,
    COUNT_DEFAULT_DATABASE_ERRORS              bigint                                  not null,
    COUNT_INIT_CONNECT_ERRORS                  bigint                                  not null,
    COUNT_LOCAL_ERRORS                         bigint                                  not null,
    COUNT_UNKNOWN_ERRORS                       bigint                                  not null,
    FIRST_SEEN                                 timestamp default '0000-00-00 00:00:00' not null,
    LAST_SEEN                                  timestamp default '0000-00-00 00:00:00' not null,
    FIRST_ERROR_SEEN                           timestamp default '0000-00-00 00:00:00' null,
    LAST_ERROR_SEEN                            timestamp default '0000-00-00 00:00:00' null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.hosts
(
    HOST                char(60) collate utf8_bin null,
    CURRENT_CONNECTIONS bigint                    not null,
    TOTAL_CONNECTIONS   bigint                    not null
)
    engine = PERFORMANCE_SCHEMA;

create table mysql.innodb_index_stats
(
    database_name    varchar(64)                         not null,
    table_name       varchar(64)                         not null,
    index_name       varchar(64)                         not null,
    last_update      timestamp default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
    stat_name        varchar(64)                         not null,
    stat_value       bigint unsigned                     not null,
    sample_size      bigint unsigned                     null,
    stat_description varchar(1024)                       not null,
    primary key (database_name, table_name, index_name, stat_name)
)
    collate = utf8_bin
    stats_persistent = 0;

create table mysql.innodb_table_stats
(
    database_name            varchar(64)                         not null,
    table_name               varchar(64)                         not null,
    last_update              timestamp default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
    n_rows                   bigint unsigned                     not null,
    clustered_index_size     bigint unsigned                     not null,
    sum_of_other_index_sizes bigint unsigned                     not null,
    primary key (database_name, table_name)
)
    collate = utf8_bin
    stats_persistent = 0;

create table performance_schema.mutex_instances
(
    NAME                  varchar(128)    not null,
    OBJECT_INSTANCE_BEGIN bigint unsigned not null,
    LOCKED_BY_THREAD_ID   bigint unsigned null
)
    engine = PERFORMANCE_SCHEMA;

create table mysql.ndb_binlog_index
(
    Position       bigint unsigned not null,
    File           varchar(255)    not null,
    epoch          bigint unsigned not null,
    inserts        int unsigned    not null,
    updates        int unsigned    not null,
    deletes        int unsigned    not null,
    schemaops      int unsigned    not null,
    orig_server_id int unsigned    not null,
    orig_epoch     bigint unsigned not null,
    gci            int unsigned    not null,
    primary key (epoch, orig_server_id, orig_epoch)
)
    engine = MyISAM;

create table performance_schema.objects_summary_global_by_type
(
    OBJECT_TYPE    varchar(64)     null,
    OBJECT_SCHEMA  varchar(64)     null,
    OBJECT_NAME    varchar(64)     null,
    COUNT_STAR     bigint unsigned not null,
    SUM_TIMER_WAIT bigint unsigned not null,
    MIN_TIMER_WAIT bigint unsigned not null,
    AVG_TIMER_WAIT bigint unsigned not null,
    MAX_TIMER_WAIT bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.performance_timers
(
    TIMER_NAME       enum ('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK') not null,
    TIMER_FREQUENCY  bigint                                                             null,
    TIMER_RESOLUTION bigint                                                             null,
    TIMER_OVERHEAD   bigint                                                             null
)
    engine = PERFORMANCE_SCHEMA;

create table mysql.plugin
(
    name varchar(64)  default '' not null
        primary key,
    dl   varchar(128) default '' not null
)
    comment 'MySQL plugins' engine = MyISAM
                            charset = utf8;

create table mysql.proc
(
    db                   char(64) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           default ''                    not null,
    name                 char(64)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            default ''                    not null,
    type                 enum ('FUNCTION', 'PROCEDURE')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    not null,
    specific_name        char(64)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            default ''                    not null,
    language             enum ('SQL')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        default 'SQL'                 not null,
    sql_data_access      enum ('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              default 'CONTAINS_SQL'        not null,
    is_deterministic     enum ('YES', 'NO')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  default 'NO'                  not null,
    security_type        enum ('INVOKER', 'DEFINER')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         default 'DEFINER'             not null,
    param_list           blob                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              not null,
    returns              longblob                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          not null,
    body                 longblob                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          not null,
    definer              char(77) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           default ''                    not null,
    created              timestamp                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           default CURRENT_TIMESTAMP     not null on update CURRENT_TIMESTAMP,
    modified             timestamp                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           default '0000-00-00 00:00:00' not null,
    sql_mode             set ('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH') default ''                    not null,
    comment              text collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             not null,
    character_set_client char(32) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         null,
    collation_connection char(32) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         null,
    db_collation         char(32) collate utf8_bin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         null,
    body_utf8            longblob                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          null,
    primary key (db, name, type)
)
    comment 'Stored Procedures' engine = MyISAM
                                charset = utf8;

create table mysql.procs_priv
(
    Host         char(60)                                               default ''                not null,
    Db           char(64)                                               default ''                not null,
    User         char(16)                                               default ''                not null,
    Routine_name char(64) charset utf8                                  default ''                not null,
    Routine_type enum ('FUNCTION', 'PROCEDURE')                                                   not null,
    Grantor      char(77)                                               default ''                not null,
    Proc_priv    set ('Execute', 'Alter Routine', 'Grant') charset utf8 default ''                not null,
    Timestamp    timestamp                                              default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
    primary key (Host, Db, User, Routine_name, Routine_type)
)
    comment 'Procedure privileges' engine = MyISAM
                                   collate = utf8_bin;

create index Grantor
    on mysql.procs_priv (Grantor);

create table mysql.proxies_priv
(
    Host         char(60)   default ''                not null,
    User         char(16)   default ''                not null,
    Proxied_host char(60)   default ''                not null,
    Proxied_user char(16)   default ''                not null,
    With_grant   tinyint(1) default 0                 not null,
    Grantor      char(77)   default ''                not null,
    Timestamp    timestamp  default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
    primary key (Host, User, Proxied_host, Proxied_user)
)
    comment 'User proxy privileges' engine = MyISAM
                                    collate = utf8_bin;

create index Grantor
    on mysql.proxies_priv (Grantor);

create table performance_schema.rwlock_instances
(
    NAME                      varchar(128)    not null,
    OBJECT_INSTANCE_BEGIN     bigint unsigned not null,
    WRITE_LOCKED_BY_THREAD_ID bigint unsigned null,
    READ_LOCKED_BY_COUNT      int unsigned    not null
)
    engine = PERFORMANCE_SCHEMA;

create table mysql.servers
(
    Server_name char(64) default '' not null
        primary key,
    Host        char(64) default '' not null,
    Db          char(64) default '' not null,
    Username    char(64) default '' not null,
    Password    char(64) default '' not null,
    Port        int(4)   default 0  not null,
    Socket      char(64) default '' not null,
    Wrapper     char(64) default '' not null,
    Owner       char(64) default '' not null
)
    comment 'MySQL Foreign Servers table' engine = MyISAM
                                          charset = utf8;

create table performance_schema.session_account_connect_attrs
(
    PROCESSLIST_ID   int           not null,
    ATTR_NAME        varchar(32)   not null,
    ATTR_VALUE       varchar(1024) null,
    ORDINAL_POSITION int           null
)
    engine = PERFORMANCE_SCHEMA
    collate = utf8_bin;

create table performance_schema.session_connect_attrs
(
    PROCESSLIST_ID   int           not null,
    ATTR_NAME        varchar(32)   not null,
    ATTR_VALUE       varchar(1024) null,
    ORDINAL_POSITION int           null
)
    engine = PERFORMANCE_SCHEMA
    collate = utf8_bin;

create table performance_schema.setup_actors
(
    HOST char(60) collate utf8_bin default '%' not null,
    USER char(16) collate utf8_bin default '%' not null,
    ROLE char(16) collate utf8_bin default '%' not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.setup_consumers
(
    NAME    varchar(64)        not null,
    ENABLED enum ('YES', 'NO') not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.setup_instruments
(
    NAME    varchar(128)       not null,
    ENABLED enum ('YES', 'NO') not null,
    TIMED   enum ('YES', 'NO') not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.setup_objects
(
    OBJECT_TYPE   enum ('TABLE')     default 'TABLE' not null,
    OBJECT_SCHEMA varchar(64)        default '%'     null,
    OBJECT_NAME   varchar(64)        default '%'     not null,
    ENABLED       enum ('YES', 'NO') default 'YES'   not null,
    TIMED         enum ('YES', 'NO') default 'YES'   not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.setup_timers
(
    NAME       varchar(64)                                                        not null,
    TIMER_NAME enum ('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK') not null
)
    engine = PERFORMANCE_SCHEMA;

create table mysql.slave_master_info
(
    Number_of_lines        int unsigned                         not null comment 'Number of lines in the file.',
    Master_log_name        text collate utf8_bin                not null comment 'The name of the master binary log currently being read from the master.',
    Master_log_pos         bigint unsigned                      not null comment 'The master log position of the last read event.',
    Host                   char(64) collate utf8_bin default '' not null comment 'The host name of the master.',
    User_name              text collate utf8_bin                null comment 'The user name used to connect to the master.',
    User_password          text collate utf8_bin                null comment 'The password used to connect to the master.',
    Port                   int unsigned                         not null comment 'The network port used to connect to the master.',
    Connect_retry          int unsigned                         not null comment 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
    Enabled_ssl            tinyint(1)                           not null comment 'Indicates whether the server supports SSL connections.',
    Ssl_ca                 text collate utf8_bin                null comment 'The file used for the Certificate Authority (CA) certificate.',
    Ssl_capath             text collate utf8_bin                null comment 'The path to the Certificate Authority (CA) certificates.',
    Ssl_cert               text collate utf8_bin                null comment 'The name of the SSL certificate file.',
    Ssl_cipher             text collate utf8_bin                null comment 'The name of the cipher in use for the SSL connection.',
    Ssl_key                text collate utf8_bin                null comment 'The name of the SSL key file.',
    Ssl_verify_server_cert tinyint(1)                           not null comment 'Whether to verify the server certificate.',
    Heartbeat              float                                not null,
    Bind                   text collate utf8_bin                null comment 'Displays which interface is employed when connecting to the MySQL server',
    Ignored_server_ids     text collate utf8_bin                null comment 'The number of server IDs to be ignored, followed by the actual server IDs',
    Uuid                   text collate utf8_bin                null comment 'The master server uuid.',
    Retry_count            bigint unsigned                      not null comment 'Number of reconnect attempts, to the master, before giving up.',
    Ssl_crl                text collate utf8_bin                null comment 'The file used for the Certificate Revocation List (CRL)',
    Ssl_crlpath            text collate utf8_bin                null comment 'The path used for Certificate Revocation List (CRL) files',
    Enabled_auto_position  tinyint(1)                           not null comment 'Indicates whether GTIDs will be used to retrieve events from the master.',
    primary key (Host, Port)
)
    comment 'Master Information' charset = utf8
                                 stats_persistent = 0;

create table mysql.slave_relay_log_info
(
    Number_of_lines   int unsigned          not null comment 'Number of lines in the file or rows in the table. Used to version table definitions.',
    Relay_log_name    text collate utf8_bin not null comment 'The name of the current relay log file.',
    Relay_log_pos     bigint unsigned       not null comment 'The relay log position of the last executed event.',
    Master_log_name   text collate utf8_bin not null comment 'The name of the master binary log file from which the events in the relay log file were read.',
    Master_log_pos    bigint unsigned       not null comment 'The master log position of the last executed event.',
    Sql_delay         int                   not null comment 'The number of seconds that the slave must lag behind the master.',
    Number_of_workers int unsigned          not null,
    Id                int unsigned          not null comment 'Internal Id that uniquely identifies this record.'
        primary key
)
    comment 'Relay Log Information' charset = utf8
                                    stats_persistent = 0;

create table mysql.slave_worker_info
(
    Id                         int unsigned          not null
        primary key,
    Relay_log_name             text collate utf8_bin not null,
    Relay_log_pos              bigint unsigned       not null,
    Master_log_name            text collate utf8_bin not null,
    Master_log_pos             bigint unsigned       not null,
    Checkpoint_relay_log_name  text collate utf8_bin not null,
    Checkpoint_relay_log_pos   bigint unsigned       not null,
    Checkpoint_master_log_name text collate utf8_bin not null,
    Checkpoint_master_log_pos  bigint unsigned       not null,
    Checkpoint_seqno           int unsigned          not null,
    Checkpoint_group_size      int unsigned          not null,
    Checkpoint_group_bitmap    blob                  not null
)
    comment 'Worker Information' charset = utf8
                                 stats_persistent = 0;

create table mysql.slow_log
(
    start_time     timestamp default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
    user_host      mediumtext                          not null,
    query_time     time                                not null,
    lock_time      time                                not null,
    rows_sent      int                                 not null,
    rows_examined  int                                 not null,
    db             varchar(512)                        not null,
    last_insert_id int                                 not null,
    insert_id      int                                 not null,
    server_id      int unsigned                        not null,
    sql_text       mediumtext                          not null,
    thread_id      bigint(21) unsigned                 not null
)
    comment 'Slow log' engine = CSV
                       charset = utf8;

create table performance_schema.socket_instances
(
    EVENT_NAME            varchar(128)            not null,
    OBJECT_INSTANCE_BEGIN bigint unsigned         not null,
    THREAD_ID             bigint unsigned         null,
    SOCKET_ID             int                     not null,
    IP                    varchar(64)             not null,
    PORT                  int                     not null,
    STATE                 enum ('IDLE', 'ACTIVE') not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.socket_summary_by_event_name
(
    EVENT_NAME                varchar(128)    not null,
    COUNT_STAR                bigint unsigned not null,
    SUM_TIMER_WAIT            bigint unsigned not null,
    MIN_TIMER_WAIT            bigint unsigned not null,
    AVG_TIMER_WAIT            bigint unsigned not null,
    MAX_TIMER_WAIT            bigint unsigned not null,
    COUNT_READ                bigint unsigned not null,
    SUM_TIMER_READ            bigint unsigned not null,
    MIN_TIMER_READ            bigint unsigned not null,
    AVG_TIMER_READ            bigint unsigned not null,
    MAX_TIMER_READ            bigint unsigned not null,
    SUM_NUMBER_OF_BYTES_READ  bigint unsigned not null,
    COUNT_WRITE               bigint unsigned not null,
    SUM_TIMER_WRITE           bigint unsigned not null,
    MIN_TIMER_WRITE           bigint unsigned not null,
    AVG_TIMER_WRITE           bigint unsigned not null,
    MAX_TIMER_WRITE           bigint unsigned not null,
    SUM_NUMBER_OF_BYTES_WRITE bigint unsigned not null,
    COUNT_MISC                bigint unsigned not null,
    SUM_TIMER_MISC            bigint unsigned not null,
    MIN_TIMER_MISC            bigint unsigned not null,
    AVG_TIMER_MISC            bigint unsigned not null,
    MAX_TIMER_MISC            bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.socket_summary_by_instance
(
    EVENT_NAME                varchar(128)    not null,
    OBJECT_INSTANCE_BEGIN     bigint unsigned not null,
    COUNT_STAR                bigint unsigned not null,
    SUM_TIMER_WAIT            bigint unsigned not null,
    MIN_TIMER_WAIT            bigint unsigned not null,
    AVG_TIMER_WAIT            bigint unsigned not null,
    MAX_TIMER_WAIT            bigint unsigned not null,
    COUNT_READ                bigint unsigned not null,
    SUM_TIMER_READ            bigint unsigned not null,
    MIN_TIMER_READ            bigint unsigned not null,
    AVG_TIMER_READ            bigint unsigned not null,
    MAX_TIMER_READ            bigint unsigned not null,
    SUM_NUMBER_OF_BYTES_READ  bigint unsigned not null,
    COUNT_WRITE               bigint unsigned not null,
    SUM_TIMER_WRITE           bigint unsigned not null,
    MIN_TIMER_WRITE           bigint unsigned not null,
    AVG_TIMER_WRITE           bigint unsigned not null,
    MAX_TIMER_WRITE           bigint unsigned not null,
    SUM_NUMBER_OF_BYTES_WRITE bigint unsigned not null,
    COUNT_MISC                bigint unsigned not null,
    SUM_TIMER_MISC            bigint unsigned not null,
    MIN_TIMER_MISC            bigint unsigned not null,
    AVG_TIMER_MISC            bigint unsigned not null,
    MAX_TIMER_MISC            bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.table_io_waits_summary_by_index_usage
(
    OBJECT_TYPE      varchar(64)     null,
    OBJECT_SCHEMA    varchar(64)     null,
    OBJECT_NAME      varchar(64)     null,
    INDEX_NAME       varchar(64)     null,
    COUNT_STAR       bigint unsigned not null,
    SUM_TIMER_WAIT   bigint unsigned not null,
    MIN_TIMER_WAIT   bigint unsigned not null,
    AVG_TIMER_WAIT   bigint unsigned not null,
    MAX_TIMER_WAIT   bigint unsigned not null,
    COUNT_READ       bigint unsigned not null,
    SUM_TIMER_READ   bigint unsigned not null,
    MIN_TIMER_READ   bigint unsigned not null,
    AVG_TIMER_READ   bigint unsigned not null,
    MAX_TIMER_READ   bigint unsigned not null,
    COUNT_WRITE      bigint unsigned not null,
    SUM_TIMER_WRITE  bigint unsigned not null,
    MIN_TIMER_WRITE  bigint unsigned not null,
    AVG_TIMER_WRITE  bigint unsigned not null,
    MAX_TIMER_WRITE  bigint unsigned not null,
    COUNT_FETCH      bigint unsigned not null,
    SUM_TIMER_FETCH  bigint unsigned not null,
    MIN_TIMER_FETCH  bigint unsigned not null,
    AVG_TIMER_FETCH  bigint unsigned not null,
    MAX_TIMER_FETCH  bigint unsigned not null,
    COUNT_INSERT     bigint unsigned not null,
    SUM_TIMER_INSERT bigint unsigned not null,
    MIN_TIMER_INSERT bigint unsigned not null,
    AVG_TIMER_INSERT bigint unsigned not null,
    MAX_TIMER_INSERT bigint unsigned not null,
    COUNT_UPDATE     bigint unsigned not null,
    SUM_TIMER_UPDATE bigint unsigned not null,
    MIN_TIMER_UPDATE bigint unsigned not null,
    AVG_TIMER_UPDATE bigint unsigned not null,
    MAX_TIMER_UPDATE bigint unsigned not null,
    COUNT_DELETE     bigint unsigned not null,
    SUM_TIMER_DELETE bigint unsigned not null,
    MIN_TIMER_DELETE bigint unsigned not null,
    AVG_TIMER_DELETE bigint unsigned not null,
    MAX_TIMER_DELETE bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.table_io_waits_summary_by_table
(
    OBJECT_TYPE      varchar(64)     null,
    OBJECT_SCHEMA    varchar(64)     null,
    OBJECT_NAME      varchar(64)     null,
    COUNT_STAR       bigint unsigned not null,
    SUM_TIMER_WAIT   bigint unsigned not null,
    MIN_TIMER_WAIT   bigint unsigned not null,
    AVG_TIMER_WAIT   bigint unsigned not null,
    MAX_TIMER_WAIT   bigint unsigned not null,
    COUNT_READ       bigint unsigned not null,
    SUM_TIMER_READ   bigint unsigned not null,
    MIN_TIMER_READ   bigint unsigned not null,
    AVG_TIMER_READ   bigint unsigned not null,
    MAX_TIMER_READ   bigint unsigned not null,
    COUNT_WRITE      bigint unsigned not null,
    SUM_TIMER_WRITE  bigint unsigned not null,
    MIN_TIMER_WRITE  bigint unsigned not null,
    AVG_TIMER_WRITE  bigint unsigned not null,
    MAX_TIMER_WRITE  bigint unsigned not null,
    COUNT_FETCH      bigint unsigned not null,
    SUM_TIMER_FETCH  bigint unsigned not null,
    MIN_TIMER_FETCH  bigint unsigned not null,
    AVG_TIMER_FETCH  bigint unsigned not null,
    MAX_TIMER_FETCH  bigint unsigned not null,
    COUNT_INSERT     bigint unsigned not null,
    SUM_TIMER_INSERT bigint unsigned not null,
    MIN_TIMER_INSERT bigint unsigned not null,
    AVG_TIMER_INSERT bigint unsigned not null,
    MAX_TIMER_INSERT bigint unsigned not null,
    COUNT_UPDATE     bigint unsigned not null,
    SUM_TIMER_UPDATE bigint unsigned not null,
    MIN_TIMER_UPDATE bigint unsigned not null,
    AVG_TIMER_UPDATE bigint unsigned not null,
    MAX_TIMER_UPDATE bigint unsigned not null,
    COUNT_DELETE     bigint unsigned not null,
    SUM_TIMER_DELETE bigint unsigned not null,
    MIN_TIMER_DELETE bigint unsigned not null,
    AVG_TIMER_DELETE bigint unsigned not null,
    MAX_TIMER_DELETE bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table performance_schema.table_lock_waits_summary_by_table
(
    OBJECT_TYPE                       varchar(64)     null,
    OBJECT_SCHEMA                     varchar(64)     null,
    OBJECT_NAME                       varchar(64)     null,
    COUNT_STAR                        bigint unsigned not null,
    SUM_TIMER_WAIT                    bigint unsigned not null,
    MIN_TIMER_WAIT                    bigint unsigned not null,
    AVG_TIMER_WAIT                    bigint unsigned not null,
    MAX_TIMER_WAIT                    bigint unsigned not null,
    COUNT_READ                        bigint unsigned not null,
    SUM_TIMER_READ                    bigint unsigned not null,
    MIN_TIMER_READ                    bigint unsigned not null,
    AVG_TIMER_READ                    bigint unsigned not null,
    MAX_TIMER_READ                    bigint unsigned not null,
    COUNT_WRITE                       bigint unsigned not null,
    SUM_TIMER_WRITE                   bigint unsigned not null,
    MIN_TIMER_WRITE                   bigint unsigned not null,
    AVG_TIMER_WRITE                   bigint unsigned not null,
    MAX_TIMER_WRITE                   bigint unsigned not null,
    COUNT_READ_NORMAL                 bigint unsigned not null,
    SUM_TIMER_READ_NORMAL             bigint unsigned not null,
    MIN_TIMER_READ_NORMAL             bigint unsigned not null,
    AVG_TIMER_READ_NORMAL             bigint unsigned not null,
    MAX_TIMER_READ_NORMAL             bigint unsigned not null,
    COUNT_READ_WITH_SHARED_LOCKS      bigint unsigned not null,
    SUM_TIMER_READ_WITH_SHARED_LOCKS  bigint unsigned not null,
    MIN_TIMER_READ_WITH_SHARED_LOCKS  bigint unsigned not null,
    AVG_TIMER_READ_WITH_SHARED_LOCKS  bigint unsigned not null,
    MAX_TIMER_READ_WITH_SHARED_LOCKS  bigint unsigned not null,
    COUNT_READ_HIGH_PRIORITY          bigint unsigned not null,
    SUM_TIMER_READ_HIGH_PRIORITY      bigint unsigned not null,
    MIN_TIMER_READ_HIGH_PRIORITY      bigint unsigned not null,
    AVG_TIMER_READ_HIGH_PRIORITY      bigint unsigned not null,
    MAX_TIMER_READ_HIGH_PRIORITY      bigint unsigned not null,
    COUNT_READ_NO_INSERT              bigint unsigned not null,
    SUM_TIMER_READ_NO_INSERT          bigint unsigned not null,
    MIN_TIMER_READ_NO_INSERT          bigint unsigned not null,
    AVG_TIMER_READ_NO_INSERT          bigint unsigned not null,
    MAX_TIMER_READ_NO_INSERT          bigint unsigned not null,
    COUNT_READ_EXTERNAL               bigint unsigned not null,
    SUM_TIMER_READ_EXTERNAL           bigint unsigned not null,
    MIN_TIMER_READ_EXTERNAL           bigint unsigned not null,
    AVG_TIMER_READ_EXTERNAL           bigint unsigned not null,
    MAX_TIMER_READ_EXTERNAL           bigint unsigned not null,
    COUNT_WRITE_ALLOW_WRITE           bigint unsigned not null,
    SUM_TIMER_WRITE_ALLOW_WRITE       bigint unsigned not null,
    MIN_TIMER_WRITE_ALLOW_WRITE       bigint unsigned not null,
    AVG_TIMER_WRITE_ALLOW_WRITE       bigint unsigned not null,
    MAX_TIMER_WRITE_ALLOW_WRITE       bigint unsigned not null,
    COUNT_WRITE_CONCURRENT_INSERT     bigint unsigned not null,
    SUM_TIMER_WRITE_CONCURRENT_INSERT bigint unsigned not null,
    MIN_TIMER_WRITE_CONCURRENT_INSERT bigint unsigned not null,
    AVG_TIMER_WRITE_CONCURRENT_INSERT bigint unsigned not null,
    MAX_TIMER_WRITE_CONCURRENT_INSERT bigint unsigned not null,
    COUNT_WRITE_DELAYED               bigint unsigned not null,
    SUM_TIMER_WRITE_DELAYED           bigint unsigned not null,
    MIN_TIMER_WRITE_DELAYED           bigint unsigned not null,
    AVG_TIMER_WRITE_DELAYED           bigint unsigned not null,
    MAX_TIMER_WRITE_DELAYED           bigint unsigned not null,
    COUNT_WRITE_LOW_PRIORITY          bigint unsigned not null,
    SUM_TIMER_WRITE_LOW_PRIORITY      bigint unsigned not null,
    MIN_TIMER_WRITE_LOW_PRIORITY      bigint unsigned not null,
    AVG_TIMER_WRITE_LOW_PRIORITY      bigint unsigned not null,
    MAX_TIMER_WRITE_LOW_PRIORITY      bigint unsigned not null,
    COUNT_WRITE_NORMAL                bigint unsigned not null,
    SUM_TIMER_WRITE_NORMAL            bigint unsigned not null,
    MIN_TIMER_WRITE_NORMAL            bigint unsigned not null,
    AVG_TIMER_WRITE_NORMAL            bigint unsigned not null,
    MAX_TIMER_WRITE_NORMAL            bigint unsigned not null,
    COUNT_WRITE_EXTERNAL              bigint unsigned not null,
    SUM_TIMER_WRITE_EXTERNAL          bigint unsigned not null,
    MIN_TIMER_WRITE_EXTERNAL          bigint unsigned not null,
    AVG_TIMER_WRITE_EXTERNAL          bigint unsigned not null,
    MAX_TIMER_WRITE_EXTERNAL          bigint unsigned not null
)
    engine = PERFORMANCE_SCHEMA;

create table mysql.tables_priv
(
    Host        char(60)                                                                                                                                                    default ''                not null,
    Db          char(64)                                                                                                                                                    default ''                not null,
    User        char(16)                                                                                                                                                    default ''                not null,
    Table_name  char(64)                                                                                                                                                    default ''                not null,
    Grantor     char(77)                                                                                                                                                    default ''                not null,
    Timestamp   timestamp                                                                                                                                                   default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
    Table_priv  set ('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger') charset utf8 default ''                not null,
    Column_priv set ('Select', 'Insert', 'Update', 'References') charset utf8                                                                                               default ''                not null,
    primary key (Host, Db, User, Table_name)
)
    comment 'Table privileges' engine = MyISAM
                               collate = utf8_bin;

create index Grantor
    on mysql.tables_priv (Grantor);

create table performance_schema.threads
(
    THREAD_ID           bigint unsigned    not null,
    NAME                varchar(128)       not null,
    TYPE                varchar(10)        not null,
    PROCESSLIST_ID      bigint unsigned    null,
    PROCESSLIST_USER    varchar(16)        null,
    PROCESSLIST_HOST    varchar(60)        null,
    PROCESSLIST_DB      varchar(64)        null,
    PROCESSLIST_COMMAND varchar(16)        null,
    PROCESSLIST_TIME    bigint             null,
    PROCESSLIST_STATE   varchar(64)        null,
    PROCESSLIST_INFO    longtext           null,
    PARENT_THREAD_ID    bigint unsigned    null,
    ROLE                varchar(64)        null,
    INSTRUMENTED        enum ('YES', 'NO') not null
)
    engine = PERFORMANCE_SCHEMA;

create table mysql.time_zone
(
    Time_zone_id     int unsigned auto_increment
        primary key,
    Use_leap_seconds enum ('Y', 'N') default 'N' not null
)
    comment 'Time zones' engine = MyISAM
                         charset = utf8;

create table mysql.time_zone_leap_second
(
    Transition_time bigint not null
        primary key,
    Correction      int    not null
)
    comment 'Leap seconds information for time zones' engine = MyISAM
                                                      charset = utf8;

create table mysql.time_zone_name
(
    Name         char(64)     not null
        primary key,
    Time_zone_id int unsigned not null
)
    comment 'Time zone names' engine = MyISAM
                              charset = utf8;

create table mysql.time_zone_transition
(
    Time_zone_id       int unsigned not null,
    Transition_time    bigint       not null,
    Transition_type_id int unsigned not null,
    primary key (Time_zone_id, Transition_time)
)
    comment 'Time zone transitions' engine = MyISAM
                                    charset = utf8;

create table mysql.time_zone_transition_type
(
    Time_zone_id       int unsigned                not null,
    Transition_type_id int unsigned                not null,
    Offset             int              default 0  not null,
    Is_DST             tinyint unsigned default 0  not null,
    Abbreviation       char(8)          default '' not null,
    primary key (Time_zone_id, Transition_type_id)
)
    comment 'Time zone transition types' engine = MyISAM
                                         charset = utf8;

create table mysql.user
(
    Host                   char(60)                                           default ''                      not null,
    User                   char(16)                                           default ''                      not null,
    Password               char(41) collate latin1_bin                        default ''                      not null,
    Select_priv            enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Insert_priv            enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Update_priv            enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Delete_priv            enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Create_priv            enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Drop_priv              enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Reload_priv            enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Shutdown_priv          enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Process_priv           enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    File_priv              enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Grant_priv             enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    References_priv        enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Index_priv             enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Alter_priv             enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Show_db_priv           enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Super_priv             enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Create_tmp_table_priv  enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Lock_tables_priv       enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Execute_priv           enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Repl_slave_priv        enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Repl_client_priv       enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Create_view_priv       enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Show_view_priv         enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Create_routine_priv    enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Alter_routine_priv     enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Create_user_priv       enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Event_priv             enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Trigger_priv           enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    Create_tablespace_priv enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    ssl_type               enum ('', 'ANY', 'X509', 'SPECIFIED') charset utf8 default ''                      not null,
    ssl_cipher             blob                                                                               not null,
    x509_issuer            blob                                                                               not null,
    x509_subject           blob                                                                               not null,
    max_questions          int(11) unsigned                                   default 0                       not null,
    max_updates            int(11) unsigned                                   default 0                       not null,
    max_connections        int(11) unsigned                                   default 0                       not null,
    max_user_connections   int(11) unsigned                                   default 0                       not null,
    plugin                 char(64)                                           default 'mysql_native_password' null,
    authentication_string  text                                                                               null,
    password_expired       enum ('N', 'Y') charset utf8                       default 'N'                     not null,
    primary key (Host, User)
)
    comment 'Users and global privileges' engine = MyISAM
                                          collate = utf8_bin;

create table performance_schema.users
(
    USER                char(16) collate utf8_bin null,
    CURRENT_CONNECTIONS bigint                    not null,
    TOTAL_CONNECTIONS   bigint                    not null
)
    engine = PERFORMANCE_SCHEMA;

create view information_schema.CHARACTER_SETS as
-- missing source code
;

create view information_schema.COLLATIONS as
-- missing source code
;

create view information_schema.COLLATION_CHARACTER_SET_APPLICABILITY as
-- missing source code
;

create view information_schema.COLUMNS as
-- missing source code
;

create view information_schema.COLUMN_PRIVILEGES as
-- missing source code
;

create view information_schema.ENGINES as
-- missing source code
;

create view information_schema.EVENTS as
-- missing source code
;

create view information_schema.FILES as
-- missing source code
;

create view information_schema.GLOBAL_STATUS as
-- missing source code
;

create view information_schema.GLOBAL_VARIABLES as
-- missing source code
;

create view information_schema.INNODB_BUFFER_PAGE as
-- missing source code
;

create view information_schema.INNODB_BUFFER_PAGE_LRU as
-- missing source code
;

create view information_schema.INNODB_BUFFER_POOL_STATS as
-- missing source code
;

create view information_schema.INNODB_CMP as
-- missing source code
;

create view information_schema.INNODB_CMPMEM as
-- missing source code
;

create view information_schema.INNODB_CMPMEM_RESET as
-- missing source code
;

create view information_schema.INNODB_CMP_PER_INDEX as
-- missing source code
;

create view information_schema.INNODB_CMP_PER_INDEX_RESET as
-- missing source code
;

create view information_schema.INNODB_CMP_RESET as
-- missing source code
;

create view information_schema.INNODB_FT_BEING_DELETED as
-- missing source code
;

create view information_schema.INNODB_FT_CONFIG as
-- missing source code
;

create view information_schema.INNODB_FT_DEFAULT_STOPWORD as
-- missing source code
;

create view information_schema.INNODB_FT_DELETED as
-- missing source code
;

create view information_schema.INNODB_FT_INDEX_CACHE as
-- missing source code
;

create view information_schema.INNODB_FT_INDEX_TABLE as
-- missing source code
;

create view information_schema.INNODB_LOCKS as
-- missing source code
;

create view information_schema.INNODB_LOCK_WAITS as
-- missing source code
;

create view information_schema.INNODB_METRICS as
-- missing source code
;

create view information_schema.INNODB_SYS_COLUMNS as
-- missing source code
;

create view information_schema.INNODB_SYS_DATAFILES as
-- missing source code
;

create view information_schema.INNODB_SYS_FIELDS as
-- missing source code
;

create view information_schema.INNODB_SYS_FOREIGN as
-- missing source code
;

create view information_schema.INNODB_SYS_FOREIGN_COLS as
-- missing source code
;

create view information_schema.INNODB_SYS_INDEXES as
-- missing source code
;

create view information_schema.INNODB_SYS_TABLES as
-- missing source code
;

create view information_schema.INNODB_SYS_TABLESPACES as
-- missing source code
;

create view information_schema.INNODB_SYS_TABLESTATS as
-- missing source code
;

create view information_schema.INNODB_TRX as
-- missing source code
;

create view information_schema.KEY_COLUMN_USAGE as
-- missing source code
;

create view information_schema.OPTIMIZER_TRACE as
-- missing source code
;

create view information_schema.PARAMETERS as
-- missing source code
;

create view information_schema.PARTITIONS as
-- missing source code
;

create view information_schema.PLUGINS as
-- missing source code
;

create view information_schema.PROCESSLIST as
-- missing source code
;

create view information_schema.PROFILING as
-- missing source code
;

create view information_schema.REFERENTIAL_CONSTRAINTS as
-- missing source code
;

create view information_schema.ROUTINES as
-- missing source code
;

create view information_schema.SCHEMATA as
-- missing source code
;

create view information_schema.SCHEMA_PRIVILEGES as
-- missing source code
;

create view information_schema.SESSION_STATUS as
-- missing source code
;

create view information_schema.SESSION_VARIABLES as
-- missing source code
;

create view information_schema.STATISTICS as
-- missing source code
;

create view information_schema.TABLES as
-- missing source code
;

create view information_schema.TABLESPACES as
-- missing source code
;

create view information_schema.TABLE_CONSTRAINTS as
-- missing source code
;

create view information_schema.TABLE_PRIVILEGES as
-- missing source code
;

create view information_schema.TRIGGERS as
-- missing source code
;

create view information_schema.USER_PRIVILEGES as
-- missing source code
;

create view information_schema.VIEWS as
-- missing source code
;
0

Please sign in to leave a comment.