17 lines
1.3 KiB
Plaintext
17 lines
1.3 KiB
Plaintext
DROP DATABASE IF EXISTS pfs_charset_test;
|
||
CREATE DATABASE pfs_charset_test;
|
||
USE pfs_charset_test;
|
||
SET NAMES cp1251;
|
||
TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
|
||
CREATE TABLE äîëåí_ðåãèñòúð_1251a (s1 INT);
|
||
CREATE TABLE ÄîËåÍ_ðåãèñòúð_1251b (s1 INT, s2 INT);
|
||
SET NAMES utf8;
|
||
Warnings:
|
||
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
||
CREATE TABLE ДОЛЕÐ<E280A2>_региÑ<C2B8>Ñ‚ÑŠÑ€_утф8 (s1 INT);
|
||
SET NAMES latin1;
|
||
SELECT * FROM performance_schema.events_statements_summary_by_digest
|
||
WHERE digest_text LIKE 'XXXYYY%' LIMIT 1;
|
||
SCHEMA_NAME DIGEST DIGEST_TEXT COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED FIRST_SEEN LAST_SEEN QUANTILE_95 QUANTILE_99 QUANTILE_999 QUERY_SAMPLE_TEXT QUERY_SAMPLE_SEEN QUERY_SAMPLE_TIMER_WAIT
|
||
DROP DATABASE pfs_charset_test;
|