File: statement_digest_charset.result

package info (click to toggle)
mariadb-10.0 10.0.32-0%2Bdeb8u1
  • links: PTS, VCS
  • area: main
  • in suites: jessie
  • size: 476,064 kB
  • sloc: cpp: 1,400,131; ansic: 832,140; perl: 54,391; sh: 41,304; pascal: 32,365; yacc: 14,921; xml: 5,257; sql: 4,667; cs: 4,647; makefile: 4,555; ruby: 4,465; python: 2,292; lex: 1,427; java: 941; asm: 295; awk: 54; php: 22; sed: 16
file content (14 lines) | stat: -rw-r--r-- 991 bytes parent folder | download | duplicates (12)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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 ДОЛЕН_регистър_утф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;