REDROOM

Create

Preview: mysql_performance_tables.sql Size: 1.91 KB

//usr/share/mysql/mysql_performance_tables.sql

--
-- PERFORMANCE SCHEMA INSTALLATION
-- Note that this script is also reused by mysql_upgrade,
-- so we have to be very careful here to not destroy any
-- existing database named 'performance_schema' if it
-- can contain user data.
-- In case of downgrade, it's ok to drop unknown tables
-- from a future version, as long as they belong to the
-- performance schema engine.
--

set @have_old_pfs= (select count(*) from information_schema.schemata where schema_name='performance_schema');

SET @cmd="SET @broken_tables = (select count(*) from information_schema.tables  where engine != 'PERFORMANCE_SCHEMA' and table_schema='performance_schema')";

-- Work around for bug#49542
SET @str = IF(@have_old_pfs = 1, @cmd, 'SET @broken_tables = 0');
PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;

SET @cmd="SET @broken_views = (select count(*) from information_schema.views where table_schema='performance_schema')";

-- Work around for bug#49542
SET @str = IF(@have_old_pfs = 1, @cmd, 'SET @broken_views = 0');
PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;

SET @broken_routines = (select count(*) from mysql.proc where db='performance_schema');

SET @broken_events = (select count(*) from mysql.event where db='performance_schema');

SET @broken_pfs= (select @broken_tables + @broken_views + @broken_routines + @broken_events);

--
-- The performance schema database.
-- Only drop and create the database if this is safe (no broken_pfs).
-- This database is created, even in --without-perfschema builds,
-- so that the database name is always reserved by the MySQL implementation.
--

SET @cmd= "DROP DATABASE IF EXISTS performance_schema";

SET @str = IF(@broken_pfs = 0, @cmd, 'SET @dummy = 0');
PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;

SET @cmd= "CREATE DATABASE performance_schema character set utf8mb3";

SET @str = IF(@broken_pfs = 0, @cmd, 'SET @dummy = 0');
PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;

Name	Size	Perms	Modified	Actions
bulgarian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
charsets DIR	-	drwxr-xr-x	2026-02-05 23:02:08	Edit Download recursive recursive
chinese DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
czech DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
danish DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
dutch DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
english DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
estonian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
french DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
georgian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
german DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
greek DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
hindi DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
hungarian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
italian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
japanese DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
korean DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
norwegian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
norwegian-ny DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
policy DIR	-	drwxr-xr-x	2026-01-31 17:44:55	Edit Download recursive recursive
polish DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
portuguese DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
romanian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
russian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
serbian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
slovak DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
spanish DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
swedish DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
systemd DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
ukrainian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
binary-configure	1.13 KB	lrwxr-xr-x	2026-01-31 17:15:45	Edit Download recursive recursive
errmsg-utf8.txt	810.92 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
fill_help_tables.sql	2.04 MB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
magic	1.44 KB	lrw-r--r--	2026-01-31 10:47:56	Edit Download recursive recursive
mariadb.logrotate	1.82 KB	lrw-r--r--	2026-01-31 17:15:45	Edit Download recursive recursive
maria_add_gis_sp.sql	1.67 KB	lrw-r--r--	2026-01-31 17:15:44	Edit Download recursive recursive
maria_add_gis_sp_bootstrap.sql	1.64 KB	lrw-r--r--	2026-01-31 17:15:44	Edit Download recursive recursive
mini-benchmark	9.37 KB	lrwxr-xr-x	2026-01-31 17:15:45	Edit Download recursive recursive
mysql.server	12.02 KB	lrwxr-xr-x	2026-01-31 17:15:45	Edit Download recursive recursive
mysqld_multi.server	1.53 KB	lrwxr-xr-x	2026-01-31 17:15:45	Edit Download recursive recursive
mysql_performance_tables.sql	1.91 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
mysql_system_tables.sql	29.86 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
mysql_system_tables_data.sql	3.25 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
mysql_sys_schema.sql	604.96 KB	lrw-r--r--	2026-01-31 17:15:45	Edit Download recursive recursive
mysql_test_data_timezone.sql	10.17 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
mysql_test_db.sql	1.73 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
wsrep.cnf	3.39 KB	lrw-r--r--	2026-01-31 17:15:45	Edit Download recursive recursive
wsrep_notify	4.86 KB	lrwxr-xr-x	2026-01-31 17:15:45	Edit Download recursive recursive

Directory Contents