SHOW GLOBAL VARIABLES; production: left, development: right
30 lines
MariaDB [phs_p]> SHOW GLOBAL VARIABLES;
MariaDB [phs]> SHOW GLOBAL VARIABLES;
+----------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+----------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
| Variable_name | Value |
+----------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+----------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| alter_algorithm | DEFAULT |
| alter_algorithm | DEFAULT |
| analyze_sample_percentage | 100.000000 |
| analyze_sample_percentage | 100.000000 |
| aria_block_size | 8192 |
| aria_block_size | 8192 |
| aria_checkpoint_interval | 30 |
| aria_checkpoint_interval | 30 |
| aria_checkpoint_log_activity | 1048576 |
| aria_checkpoint_log_activity | 1048576 |
| aria_encrypt_tables | OFF |
| aria_encrypt_tables | OFF |
| aria_force_start_after_recovery_failures | 0 |
| aria_force_start_after_recovery_failures | 0 |
| aria_group_commit | none |
| aria_group_commit | none |
| aria_group_commit_interval | 0 |
| aria_group_commit_interval | 0 |
| aria_log_file_size | 1073741824 |
| aria_log_file_size | 1073741824 |
| aria_log_purge_type | immediate |
| aria_log_purge_type | immediate |
| aria_max_sort_file_size | 9223372036853727232 |
| aria_max_sort_file_size | 9223372036853727232 |
| aria_page_checksum | ON |
| aria_page_checksum | ON |
| aria_pagecache_age_threshold | 300 |
| aria_pagecache_age_threshold | 300 |
| aria_pagecache_buffer_size | 134217728 |
| aria_pagecache_buffer_size | 134217728 |
| aria_pagecache_division_limit | 100 |
| aria_pagecache_division_limit | 100 |
| aria_pagecache_file_hash_size | 512 |
| aria_pagecache_file_hash_size | 512 |
| aria_recover_options | BACKUP,QUICK |
| aria_recover_options | BACKUP,QUICK |
| aria_repair_threads | 1 |
| aria_repair_threads | 1 |
| aria_sort_buffer_size | 268434432 |
| aria_sort_buffer_size | 268434432 |
| aria_stats_method | nulls_unequal |
| aria_stats_method | nulls_unequal |
| aria_sync_log_dir | NEWFILE |
| aria_sync_log_dir | NEWFILE |
| aria_used_for_temp_tables | ON |
| aria_used_for_temp_tables | ON |
| auto_increment_increment | 1 |
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| auto_increment_offset | 1 |
| autocommit | ON
| autocommit | ON