1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
CALL mtr.add_suppression("Dictionary file not specified");
#
# Tests for deprecation warnings introduced by wl#6443
#
# System variables
select @@global.profiling;
@@global.profiling
0
Warnings:
Warning 1287 '@@profiling' is deprecated and will be removed in a future release.
select @@local.profiling;
@@local.profiling
0
Warnings:
Warning 1287 '@@profiling' is deprecated and will be removed in a future release.
select @@global.profiling_history_size;
@@global.profiling_history_size
15
Warnings:
Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release.
select @@local.profiling_history_size;
@@local.profiling_history_size
15
Warnings:
Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release.
select @@global.have_profiling;
@@global.have_profiling
YES
Warnings:
Warning 1287 '@@have_profiling' is deprecated and will be removed in a future release.
set @@local.profiling= @@global.profiling;
Warnings:
Warning 1287 '@@profiling' is deprecated and will be removed in a future release.
Warning 1287 '@@profiling' is deprecated and will be removed in a future release.
set @@local.profiling_history_size= @@global.profiling_history_size;
Warnings:
Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release.
Warning 1287 '@@profiling_history_size' is deprecated and will be removed in a future release.
set @wl6443_have_profiling= @@global.have_profiling;
Warnings:
Warning 1287 '@@have_profiling' is deprecated and will be removed in a future release.
# SHOW PROFILE and SHOW PROFILES
SHOW PROFILE;
Status Duration
Warnings:
Warning 1287 'SHOW PROFILE' is deprecated and will be removed in a future release. Please use Performance Schema instead
SHOW PROFILE ALL;
Status Duration CPU_user CPU_system Context_voluntary Context_involuntary Block_ops_in Block_ops_out Messages_sent Messages_received Page_faults_major Page_faults_minor Swaps Source_function Source_file Source_line
Warnings:
Warning 1287 'SHOW PROFILE' is deprecated and will be removed in a future release. Please use Performance Schema instead
SHOW PROFILE IPC;
Status Duration Messages_sent Messages_received
Warnings:
Warning 1287 'SHOW PROFILE' is deprecated and will be removed in a future release. Please use Performance Schema instead
SHOW PROFILES;
Query_ID Duration Query
Warnings:
Warning 1287 'SHOW PROFILES' is deprecated and will be removed in a future release. Please use Performance Schema instead
# --plugin-xyz
INSTALL PLUGIN validate_password SONAME 'validate_password.so';
Warnings:
Warning 1287 'validate password plugin' is deprecated and will be removed in a future release. Please use validate_password component instead
# restarting the server
# Restart server.
UNINSTALL PLUGIN validate_password;
Warnings:
Warning 1287 'validate password plugin' is deprecated and will be removed in a future release. Please use validate_password component instead
# Search for deprecation warnings in error log.
# YMMDD HH:MM:SS [Warning] The syntax 'plugin-validate-password-length' is deprecated and will be removed in a future release. Please use validate-password-length instead.
Deprecation warning count : 1
# Host table deprecation
select count(*) from information_schema.tables where table_name like 'host' and table_schema like 'mysql' and table_type like 'BASE TABLE';
count(*)
0
create table mysql.host(c1 int) engine MyISAM;
insert into mysql.host values(1);
# restart: --upgrade=FORCE
drop table mysql.host;
create view mysql.host as select HOST from mysql.db;
create user 'wl6443_u1'@'10.10.10.1' identified by 'sql';
select count(*) from mysql.host;
count(*)
3
# restart: --upgrade=FORCE
drop view mysql.host;
drop user 'wl6443_u1'@'10.10.10.1';
# restart: --upgrade=FORCE
# End of 5.6 tests
#
# WL#6802: Deprecate the INFORMATION_SCHEMA.PROFILING table
#
SELECT * FROM INFORMATION_SCHEMA.profiling;
QUERY_ID SEQ STATE DURATION CPU_USER CPU_SYSTEM CONTEXT_VOLUNTARY CONTEXT_INVOLUNTARY BLOCK_OPS_IN BLOCK_OPS_OUT MESSAGES_SENT MESSAGES_RECEIVED PAGE_FAULTS_MAJOR PAGE_FAULTS_MINOR SWAPS SOURCE_FUNCTION SOURCE_FILE SOURCE_LINE
Warnings:
Warning 1287 'INFORMATION_SCHEMA.PROFILING' is deprecated and will be removed in a future release. Please use Performance Schema instead
# End of 5.7 tests
|
