Reminder note on changing MySQL variables live and without restarting the service.
mysql> show global variables where variable_name like '%engine%';
+---------------------------+--------+
| Variable_name | Value |
+---------------------------+--------+
| engine_condition_pushdown | ON |
| storage_engine | MyISAM |
+---------------------------+--------+
2 rows in set (0.00 sec)
mysql> SET GLOBAL storage_engine=InnoDB;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables where variable_name like '%engine%';
+---------------------------+--------+
| Variable_name | Value |
+---------------------------+--------+
| engine_condition_pushdown | ON |
| storage_engine | InnoDB |
+---------------------------+--------+
2 rows in set (0.00 sec)
Very simple, but I can never remember this and it tends to be buried somewhere in MySQL's massive documentation.
mysql> show global variables where variable_name like '%engine%';
+---------------------------+--------+
| Variable_name | Value |
+---------------------------+--------+
| engine_condition_pushdown | ON |
| storage_engine | MyISAM |
+---------------------------+--------+
2 rows in set (0.00 sec)
mysql> SET GLOBAL storage_engine=InnoDB;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables where variable_name like '%engine%';
+---------------------------+--------+
| Variable_name | Value |
+---------------------------+--------+
| engine_condition_pushdown | ON |
| storage_engine | InnoDB |
+---------------------------+--------+
2 rows in set (0.00 sec)
Very simple, but I can never remember this and it tends to be buried somewhere in MySQL's massive documentation.
No comments:
Post a Comment