mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
14 lines
991 B
Text
14 lines
991 B
Text
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;
|
||
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
|
||
DROP DATABASE pfs_charset_test;
|