#acupoftea - mail.ontime-ae.com

System	:	Linux server1.ontime-gulf.com 4.18.0-553.5.1.el8_10.x86_64 #1 SMP Wed Jun 5 09:12:13 EDT 2024 x86_64
Software	:	Apache
Server	:	162.0.230.206
Domains	:	40 Domain
Permission	:	[ drwxr-xr-x ]
	:	/ usr / share / mysql /

216.73.216.49

Home

File 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	Type	Size	Permission	Last Modified	Actions
.	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
..	DIR	-	drwxr-xr-x	2025-10-16 10:59:21
bulgarian	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
charsets	DIR	-	drwxr-xr-x	2025-08-07 11:00:47
chinese	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
czech	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
danish	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
dutch	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
english	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
estonian	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
french	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
german	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
greek	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
hindi	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
hungarian	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
italian	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
japanese	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
korean	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
norwegian	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
norwegian-ny	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
policy	DIR	-	drwxr-xr-x	2025-07-28 05:05:53
polish	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
portuguese	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
romanian	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
russian	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
serbian	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
slovak	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
spanish	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
swedish	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
systemd	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
ukrainian	DIR	-	drwxr-xr-x	2025-08-07 11:01:09
binary-configure	text/x-shellscript	1.13 KB	-rwxr-xr-x	2025-07-28 03:57:47
errmsg-utf8.txt	text/plain	699.67 KB	-rw-r--r--	2025-07-28 03:52:27
fill_help_tables.sql	text/plain	2.06 MB	-rw-r--r--	2025-07-28 03:52:27
magic	text/plain	1.44 KB	-rw-r--r--	2025-07-28 03:52:28
maria_add_gis_sp.sql	text/plain	1.67 KB	-rw-r--r--	2025-07-28 03:57:47
maria_add_gis_sp_bootstrap.sql	text/plain	1.64 KB	-rw-r--r--	2025-07-28 03:57:47
mysql-log-rotate	text/plain	894 B	-rw-r--r--	2025-07-28 03:57:47
mysql.server	text/x-shellscript	12.02 KB	-rwxr-xr-x	2025-07-28 03:57:47
mysql_performance_tables.sql	text/plain	1.91 KB	-rw-r--r--	2025-07-28 03:52:27
mysql_sys_schema.sql	text/plain	605.2 KB	-rw-r--r--	2025-07-28 03:57:47
mysql_system_tables.sql	text/plain	29.86 KB	-rw-r--r--	2025-07-28 03:52:27
mysql_system_tables_data.sql	text/plain	3.25 KB	-rw-r--r--	2025-07-28 03:52:27
mysql_test_data_timezone.sql	text/plain	10.17 KB	-rw-r--r--	2025-07-28 03:52:27
mysql_test_db.sql	text/plain	1.64 KB	-rw-r--r--	2025-07-28 03:52:27
mysqld_multi.server	text/x-shellscript	1.53 KB	-rwxr-xr-x	2025-07-28 03:57:47
wsrep.cnf	text/plain	3.39 KB	-rw-r--r--	2025-07-28 03:57:47
wsrep_notify	text/x-shellscript	4.86 KB	-rwxr-xr-x	2025-07-28 03:57:47

~ ACUPOFTEA - mail.ontime-ae.com