1call mtr.add_suppression('InnoDB: Resizing redo log');
2call mtr.add_suppression('InnoDB: Starting to delete and rewrite log files');
3call mtr.add_suppression('InnoDB: New log files created');
4#
5# Ensure the plugin isn't loaded.
6#
7SELECT * FROM mysql.plugin WHERE dl like 'libdaemon%' ORDER BY name;
8name	dl
9#
10# Enable the plugin...
11#
12#
13# Simulate loading a plugin libary with multiple entry points.
14# This will test the DISABLE to ensure all rows are removed.
15#
16INSERT INTO mysql.plugin VALUES ('wicky', 'libdaemon_example.so');
17INSERT INTO mysql.plugin VALUES ('wacky', 'libdaemon_example.so');
18INSERT INTO mysql.plugin VALUES ('wonky', 'libdaemon_example.so');
19#
20# Ensure the plugin is now loaded.
21#
22SELECT * FROM mysql.plugin WHERE dl like 'libdaemon%' ORDER BY name;
23name	dl
24daemon_example	libdaemon_example.so
25wacky	libdaemon_example.so
26wicky	libdaemon_example.so
27wonky	libdaemon_example.so
28#
29# Ensure the plugin is loaded.
30#
31SELECT * FROM mysql.plugin WHERE dl like '%libdaemon%' ORDER BY name;
32name	dl
33daemon_example	libdaemon_example.so
34#
35# Ensure the plugin is replaced.
36#
37SELECT * FROM mysql.plugin WHERE dl like '%libdaemon%' ORDER BY name;
38name	dl
39daemon_example	liblibdaemon_example.so
40#
41# Disable the plugin...
42#
43#
44# Ensure the plugin isn't loaded.
45#
46SELECT * FROM mysql.plugin WHERE dl like '%libdaemon%' ORDER BY name;
47name	dl
48#
49# Attempt to load non-existant plugin
50#
51Warning: mysql_plugin is deprecated and will be removed in a future version.
52ERROR: Cannot read plugin config file NOT_THERE_AT_ALL. File does not exist.
53#
54# Attempt to use non-existant plugin.ini file
55#
56Warning: mysql_plugin is deprecated and will be removed in a future version.
57ERROR: Cannot read plugin config file daemon_example. File does not exist.
58#
59# Attempt to omit the plugin
60#
61Warning: mysql_plugin is deprecated and will be removed in a future version.
62ERROR: No plugin specified.
63#
64# Attempt to omit DISABLE|ENABLE
65#
66Warning: mysql_plugin is deprecated and will be removed in a future version.
67ERROR: missing operation. Please specify either '<plugin> ENABLE' or '<plugin> DISABLE'.
68#
69# Attempt to use bad paths - datadir
70#
71Warning: mysql_plugin is deprecated and will be removed in a future version.
72ERROR: Cannot access datadir at '/data_not_there/'.
73#
74# Attempt to use bad paths - basedir
75#
76Warning: mysql_plugin is deprecated and will be removed in a future version.
77ERROR: Cannot access basedir at '/basedir_not_there/'.
78#
79# Attempt to use bad paths - plugin_dir
80#
81Warning: mysql_plugin is deprecated and will be removed in a future version.
82ERROR: Cannot access plugin_dir at '/plugin_not_there/'.
83#
84# Attempt to use bad paths - mysqld
85#
86Warning: mysql_plugin is deprecated and will be removed in a future version.
87ERROR: Cannot access mysqld path '/mysqld_not_there/'.
88#
89# Attempt to use bad paths - my_print_defaults
90#
91Warning: mysql_plugin is deprecated and will be removed in a future version.
92ERROR: Cannot access my-print-defaults path '/my_print_defaults_not_there/'.
93#
94# Missing library
95#
96Warning: mysql_plugin is deprecated and will be removed in a future version.
97ERROR: The plugin library is missing or in a different location.
98#
99# Bad format for config file
100#
101Warning: mysql_plugin is deprecated and will be removed in a future version.
102ERROR: Cannot read plugin config file daemon_example. Bad format in plugin configuration file.
103#
104# Missing base_dir option
105#
106Warning: mysql_plugin is deprecated and will be removed in a future version.
107ERROR: Missing --basedir option.
108#
109# Missing data_dir option
110#
111Warning: mysql_plugin is deprecated and will be removed in a future version.
112ERROR: Missing --datadir option.
113#
114# Missing plugin_dir option
115#
116Warning: mysql_plugin is deprecated and will be removed in a future version.
117ERROR: Missing --plugin_dir option.
118#
119# Show the help.
120#
121mysql_plugin  Ver V.V.VV Distrib XX.XX.XX
122Copyright (c) 2011, 2021, Oracle and/or its affiliates. All rights reserved.
123
124Enable or disable plugins.
125
126Usage: mysql_plugin [options] <plugin> ENABLE|DISABLE
127
128Options:
129  -?, --help          Display this help and exit.
130  -b, --basedir=name  The basedir for the server.
131  -d, --datadir=name  The datadir for the server.
132  -p, --plugin-dir=name
133                      The plugin dir for the server.
134  -i, --plugin-ini=name
135                      Read plugin information from configuration file specified
136                      instead of from <plugin-dir>/<plugin_name>.ini.
137  -n, --no-defaults   Do not read values from configuration file.
138  -P, --print-defaults
139                      Show default values from configuration file.
140  -m, --mysqld=name   Path to mysqld executable. Example: /sbin/temp1/mysql/bin
141  -f, --my-print-defaults=name
142                      Path to my_print_defaults executable. Example:
143                      /source/temp11/extra
144  -v, --verbose       More verbose output; you can use this multiple times to
145                      get even more verbose output.
146  -V, --version       Output version information and exit.
147
148
149mysql_plugin  Ver V.V.VV Distrib XX.XX.XX
150