1install plugin mysqlx soname "mysqlx.so"; 2call mtr.add_suppression("Plugin mysqlx reported: .Failed at SSL configuration: .SSL context is not usable without certificate and private key.."); 3call mtr.add_suppression("Plugin mysqlx reported: .SSL_CTX_load_verify_locations failed."); 4call mtr.add_suppression("Plugin mysqlx reported: 'Delayed startup failed. Plugin is unable to accept connections.'"); 5call mtr.add_suppression("Plugin mysqlx reported: 'Invalid server state'"); 6call mtr.add_suppression("Plugin mysqlx reported: '.*: Internal error executing query'"); 7call mtr.add_suppression("Can.t open and lock privilege tables: Server shutdown in progress"); 8RUN create user xplugin@localhost identified by 'xplugin' 9 100 rows affected 11RUN create user session@localhost identified by 'session' 12 130 rows affected 14RUN grant all on *.* to session@localhost 15 160 rows affected 17Mysqlx.Ok { 18 msg: "bye!" 19} 20ok 21RUN show variables like 'mysqlx_idle_worker_thread_timeout%' 22Variable_name Value 23mysqlx_idle_worker_thread_timeout 60 240 rows affected 25RUN show variables like 'mysqlx_max_allowed_packet%' 26Variable_name Value 27mysqlx_max_allowed_packet 1048576 280 rows affected 29RUN show variables like 'mysqlx_max_connections%' 30Variable_name Value 31mysqlx_max_connections 100 320 rows affected 33RUN show variables like 'mysqlx_min_worker_threads%' 34Variable_name Value 35mysqlx_min_worker_threads 2 360 rows affected 37RUN uninstall plugin mysqlx 38While executing uninstall plugin mysqlx: 39Got expected error: Command not supported by pluggable protocols (code 3130) 40RUN show variables like 'mysqlx_idle_worker_thread_timeout%' 41Variable_name Value 42mysqlx_idle_worker_thread_timeout 60 430 rows affected 44RUN show variables like 'mysqlx_max_allowed_packet%' 45Variable_name Value 46mysqlx_max_allowed_packet 1048576 470 rows affected 48RUN show variables like 'mysqlx_max_connections%' 49Variable_name Value 50mysqlx_max_connections 100 510 rows affected 52RUN show variables like 'mysqlx_min_worker_threads%' 53Variable_name Value 54mysqlx_min_worker_threads 2 550 rows affected 56RUN SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS,PLUGIN_TYPE,LOAD_OPTION from information_schema.plugins where PLUGIN_NAME LIKE 'mysqlx%' 57PLUGIN_NAME PLUGIN_VERSION PLUGIN_STATUS PLUGIN_TYPE LOAD_OPTION 58mysqlx 1.0 ACTIVE DAEMON ON 590 rows affected 60Mysqlx.Ok { 61 msg: "bye!" 62} 63ok 64uninstall plugin mysqlx; 65ERROR: Connection refused connecting to HOST:PORT 66install plugin mysqlx soname "mysqlx.so"; 67show variables like 'mysqlx_idle_worker_thread_timeout%'; 68Variable_name Value 69mysqlx_idle_worker_thread_timeout 60 70show variables like 'mysqlx_max_allowed_packet%'; 71Variable_name Value 72mysqlx_max_allowed_packet 1048576 73show variables like 'mysqlx_max_connections%'; 74Variable_name Value 75mysqlx_max_connections 100 76show variables like 'mysqlx_min_worker_threads%'; 77Variable_name Value 78mysqlx_min_worker_threads 2 79set @@global.mysqlx_idle_worker_thread_timeout=70; 80set @@global.mysqlx_max_allowed_packet=4048576; 81set @@global.mysqlx_max_connections=500; 82set @@global.mysqlx_min_worker_threads=50; 83show variables like 'mysqlx_idle_worker_thread_timeout%'; 84Variable_name Value 85mysqlx_idle_worker_thread_timeout 70 86show variables like 'mysqlx_max_allowed_packet%'; 87Variable_name Value 88mysqlx_max_allowed_packet 4048576 89show variables like 'mysqlx_max_connections%'; 90Variable_name Value 91mysqlx_max_connections 500 92show variables like 'mysqlx_min_worker_threads%'; 93Variable_name Value 94mysqlx_min_worker_threads 50 95uninstall plugin mysqlx; 96install plugin mysqlx soname "mysqlx.so"; 97RUN select user(),current_user(),@@bind_address 98user() current_user() @@bind_address 99session@localhost session@localhost * 1000 rows affected 101RUN show grants 102Grants for session@localhost 103GRANT ALL PRIVILEGES ON *.* TO 'session'@'localhost' 1040 rows affected 105RUN install plugin mysqlx soname '$MYSQLXPLUGIN' 106While executing install plugin mysqlx soname '$MYSQLXPLUGIN': 107Got expected error: Command not supported by pluggable protocols (code 3130) 108Mysqlx.Ok { 109 msg: "bye!" 110} 111ok 112RUN select user(),current_user(),@@bind_address 113user() current_user() @@bind_address 114xplugin@localhost xplugin@localhost * 1150 rows affected 116RUN show grants 117Grants for xplugin@localhost 118GRANT USAGE ON *.* TO 'xplugin'@'localhost' 1190 rows affected 120RUN install plugin mysqlx soname '$MYSQLXPLUGIN' 121While executing install plugin mysqlx soname '$MYSQLXPLUGIN': 122Got expected error: Command not supported by pluggable protocols (code 3130) 123Mysqlx.Ok { 124 msg: "bye!" 125} 126ok 127call mtr.add_suppression("Plugin mysqlx reported: 'Session error: Session was killed"); 128call mtr.add_suppression("Plugin mysqlx reported: 'Error executing CREATE USER IF NOT EXISTS mysqlxsys@localhost'"); 129call mtr.add_suppression("Plugin mysqlx reported: 'Authentication account could not be created, mysqlx plugin will be inaccessible.'"); 130uninstall plugin mysqlx; 131# restart: --loose-mysqlx_idle_worker_thread_timeout=70 --loose-mysqlx_max_allowed_packet=4048576 --loose-mysqlx_max_connections=500 --loose-mysqlx_min_worker_threads=50 132ERROR: Connection refused connecting to HOST:PORT 133show variables like 'mysqlx_idle_worker_thread_timeout%'; 134Variable_name Value 135show variables like 'mysqlx_max_allowed_packet%'; 136Variable_name Value 137show variables like 'mysqlx_max_connections%'; 138Variable_name Value 139show variables like 'mysqlx_min_worker_threads%'; 140Variable_name Value 141install plugin mysqlx soname "mysqlx.so"; 142show variables like 'mysqlx_idle_worker_thread_timeout%'; 143Variable_name Value 144mysqlx_idle_worker_thread_timeout 70 145show variables like 'mysqlx_max_allowed_packet%'; 146Variable_name Value 147mysqlx_max_allowed_packet 4048576 148show variables like 'mysqlx_max_connections%'; 149Variable_name Value 150mysqlx_max_connections 500 151show variables like 'mysqlx_min_worker_threads%'; 152Variable_name Value 153mysqlx_min_worker_threads 50 154SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS,PLUGIN_TYPE,LOAD_OPTION from information_schema.plugins where PLUGIN_NAME LIKE 'mysqlx%'; 155PLUGIN_NAME PLUGIN_VERSION PLUGIN_STATUS PLUGIN_TYPE LOAD_OPTION 156mysqlx 1.0 ACTIVE DAEMON ON 157uninstall plugin mysqlx; 158# restart: --plugin-load=mysqlx.so --mysqlx_idle_worker_thread_timeout=70 --mysqlx_max_allowed_packet=4048576 --mysqlx_max_connections=500 --mysqlx_min_worker_threads=50 159show variables like 'mysqlx_idle_worker_thread_timeout%'; 160Variable_name Value 161mysqlx_idle_worker_thread_timeout 70 162show variables like 'mysqlx_max_allowed_packet%'; 163Variable_name Value 164mysqlx_max_allowed_packet 4048576 165show variables like 'mysqlx_max_connections%'; 166Variable_name Value 167mysqlx_max_connections 500 168show variables like 'mysqlx_min_worker_threads%'; 169Variable_name Value 170mysqlx_min_worker_threads 50 171uninstall plugin mysqlx; 172show variables like 'mysqlx_idle_worker_thread_timeout%'; 173Variable_name Value 174show variables like 'mysqlx_max_allowed_packet%'; 175Variable_name Value 176show variables like 'mysqlx_max_connections%'; 177Variable_name Value 178show variables like 'mysqlx_min_worker_threads%'; 179Variable_name Value 180SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS,PLUGIN_TYPE,LOAD_OPTION from information_schema.plugins where PLUGIN_NAME LIKE 'mysqlx%'; 181PLUGIN_NAME PLUGIN_VERSION PLUGIN_STATUS PLUGIN_TYPE LOAD_OPTION 182install plugin mysqlx soname "mysqlx.so"; 183uninstall plugin mysqlx; 184# restart: --max_connections=151 185install plugin mysqlx soname "mysqlx.so"; 186# restart: --max_connections=151 187RUN select user(),current_user(),@@bind_address 188user() current_user() @@bind_address 189root@localhost root@localhost * 1900 rows affected 191Mysqlx.Ok { 192 msg: "bye!" 193} 194ok 195uninstall plugin mysqlx; 196# restart: --max_connections=151 197install plugin mysqlx soname "mysqlx.so"; 198# restart: --max_connections=151 --mysqlx_idle_worker_thread_timeout=70 --mysqlx_max_allowed_packet=4048576 --mysqlx_max_connections=500 --mysqlx_min_worker_threads=50 199RUN show variables like 'mysqlx_idle_worker_thread_timeout%' 200Variable_name Value 201mysqlx_idle_worker_thread_timeout 70 2020 rows affected 203RUN show variables like 'mysqlx_max_allowed_packet%' 204Variable_name Value 205mysqlx_max_allowed_packet 4048576 2060 rows affected 207RUN show variables like 'mysqlx_max_connections%' 208Variable_name Value 209mysqlx_max_connections 500 2100 rows affected 211RUN show variables like 'mysqlx_min_worker_threads%' 212Variable_name Value 213mysqlx_min_worker_threads 50 2140 rows affected 215Mysqlx.Ok { 216 msg: "bye!" 217} 218ok 219uninstall plugin mysqlx; 220# restart: --plugin-dir=MYSQL_TMP_DIR/ 221INSTALL PLUGIN mysqlx soname "mysqlx.so"; 222ERROR HY000: Can't open shared library 223# restart: 224install plugin mysqlx soname "mysqlx.so"; 225uninstall plugin mysqlx; 226# restart: --plugin-load=mysqlx.so --mysqlx_idle_worker_thread_timeout=70 --mysqlx_max_allowed_packet=4048576 --mysqlx_max_connections=500 --mysqlx_min_worker_threads=50 227RUN show variables like 'mysqlx_idle_worker_thread_timeout%' 228Variable_name Value 229mysqlx_idle_worker_thread_timeout 70 2300 rows affected 231RUN show variables like 'mysqlx_max_allowed_packet%' 232Variable_name Value 233mysqlx_max_allowed_packet 4048576 2340 rows affected 235RUN show variables like 'mysqlx_max_connections%' 236Variable_name Value 237mysqlx_max_connections 500 2380 rows affected 239RUN show variables like 'mysqlx_min_worker_threads%' 240Variable_name Value 241mysqlx_min_worker_threads 50 2420 rows affected 243RUN uninstall plugin mysqlx 244While executing uninstall plugin mysqlx: 245Got expected error: Command not supported by pluggable protocols (code 3130) 246RUN show variables like 'mysqlx_idle_worker_thread_timeout%' 247Variable_name Value 248mysqlx_idle_worker_thread_timeout 70 2490 rows affected 250RUN show variables like 'mysqlx_max_allowed_packet%' 251Variable_name Value 252mysqlx_max_allowed_packet 4048576 2530 rows affected 254RUN show variables like 'mysqlx_max_connections%' 255Variable_name Value 256mysqlx_max_connections 500 2570 rows affected 258RUN show variables like 'mysqlx_min_worker_threads%' 259Variable_name Value 260mysqlx_min_worker_threads 50 2610 rows affected 262RUN SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS,PLUGIN_TYPE,LOAD_OPTION from information_schema.plugins where PLUGIN_NAME LIKE 'mysqlx%' 263PLUGIN_NAME PLUGIN_VERSION PLUGIN_STATUS PLUGIN_TYPE LOAD_OPTION 264mysqlx 1.0 ACTIVE DAEMON ON 2650 rows affected 266Mysqlx.Ok { 267 msg: "bye!" 268} 269ok 270RUN show variables like 'mysqlx_idle_worker_thread_timeout%' 271Variable_name Value 272mysqlx_idle_worker_thread_timeout 70 2730 rows affected 274RUN show variables like 'mysqlx_max_allowed_packet%' 275Variable_name Value 276mysqlx_max_allowed_packet 4048576 2770 rows affected 278RUN show variables like 'mysqlx_max_connections%' 279Variable_name Value 280mysqlx_max_connections 500 2810 rows affected 282RUN show variables like 'mysqlx_min_worker_threads%' 283Variable_name Value 284mysqlx_min_worker_threads 50 2850 rows affected 286RUN set @@global.mysqlx_idle_worker_thread_timeout=70 287 2880 rows affected 289RUN set @@global.mysqlx_max_allowed_packet=4048576 290 2910 rows affected 292RUN set @@global.mysqlx_max_connections=500 293 2940 rows affected 295RUN set @@global.mysqlx_min_worker_threads=50 296 2970 rows affected 298RUN show variables like 'mysqlx_idle_worker_thread_timeout%' 299Variable_name Value 300mysqlx_idle_worker_thread_timeout 70 3010 rows affected 302RUN show variables like 'mysqlx_max_allowed_packet%' 303Variable_name Value 304mysqlx_max_allowed_packet 4048576 3050 rows affected 306RUN show variables like 'mysqlx_max_connections%' 307Variable_name Value 308mysqlx_max_connections 500 3090 rows affected 310RUN show variables like 'mysqlx_min_worker_threads%' 311Variable_name Value 312mysqlx_min_worker_threads 50 3130 rows affected 314RUN uninstall plugin mysqlx 315While executing uninstall plugin mysqlx: 316Got expected error: Command not supported by pluggable protocols (code 3130) 317RUN install plugin mysqlx soname '$MYSQLXPLUGIN' 318While executing install plugin mysqlx soname '$MYSQLXPLUGIN': 319Got expected error: Command not supported by pluggable protocols (code 3130) 320Mysqlx.Ok { 321 msg: "bye!" 322} 323ok 324RUN show variables like 'mysqlx_idle_worker_thread_timeout%' 325Variable_name Value 326mysqlx_idle_worker_thread_timeout 70 3270 rows affected 328RUN show variables like 'mysqlx_max_allowed_packet%' 329Variable_name Value 330mysqlx_max_allowed_packet 4048576 3310 rows affected 332RUN show variables like 'mysqlx_max_connections%' 333Variable_name Value 334mysqlx_max_connections 500 3350 rows affected 336RUN show variables like 'mysqlx_min_worker_threads%' 337Variable_name Value 338mysqlx_min_worker_threads 50 3390 rows affected 340RUN uninstall plugin mysqlx 341While executing uninstall plugin mysqlx: 342Got expected error: Command not supported by pluggable protocols (code 3130) 343RUN show variables like 'mysqlx_idle_worker_thread_timeout%' 344Variable_name Value 345mysqlx_idle_worker_thread_timeout 70 3460 rows affected 347RUN show variables like 'mysqlx_max_allowed_packet%' 348Variable_name Value 349mysqlx_max_allowed_packet 4048576 3500 rows affected 351RUN show variables like 'mysqlx_max_connections%' 352Variable_name Value 353mysqlx_max_connections 500 3540 rows affected 355RUN show variables like 'mysqlx_min_worker_threads%' 356Variable_name Value 357mysqlx_min_worker_threads 50 3580 rows affected 359RUN SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS,PLUGIN_TYPE,LOAD_OPTION from information_schema.plugins where PLUGIN_NAME LIKE 'mysqlx%' 360PLUGIN_NAME PLUGIN_VERSION PLUGIN_STATUS PLUGIN_TYPE LOAD_OPTION 361mysqlx 1.0 ACTIVE DAEMON ON 3620 rows affected 363Mysqlx.Ok { 364 msg: "bye!" 365} 366ok 367drop user xplugin@localhost; 368drop user session@localhost; 369uninstall plugin mysqlx; 370