| 1 |
# |
| 2 |
# Testing unloaded compression provider: bzip2 |
| 3 |
# |
| 4 |
# Innodb_have_bzip2 reflects that the provider is not loaded |
| 5 |
SHOW GLOBAL STATUS WHERE Variable_name = "Innodb_have_bzip2"; |
| 6 |
Variable_name Value |
| 7 |
Innodb_have_bzip2 OFF |
| 8 |
# Innodb_compression_algorithm cannot be set to bzip2 |
| 9 |
SET GLOBAL Innodb_compression_algorithm = bzip2; |
| 10 |
ERROR 42000: Variable 'innodb_compression_algorithm' can't be set to the value of 'bzip2' |
| 11 |
show warnings; |
| 12 |
Level Code Message |
| 13 |
Warning 138 InnoDB: compression algorithm bzip2 (5) is not available. Please, load the corresponding provider plugin. |
| 14 |
Error 1231 Variable 'innodb_compression_algorithm' can't be set to the value of 'bzip2' |