mysql> SELECT * FROM `test`.`global_variables`; +--------------+----------------+---------------------+---------------------+---------------------+ | variable_key | variable_value | created_at | updated_at | expires_at | +--------------+----------------+---------------------+---------------------+---------------------+ | a | b | 2024-08-10 13:19:52 | 2024-08-10 13:19:57 | 2024-12-31 17:01:01 | +--------------+----------------+---------------------+---------------------+---------------------+ 1 row in set (0.02 sec)
查询数据库中的时区变量
1 2 3 4 5 6 7 8
mysql> show variables like '%time_zone%'; +------------------+--------+ | Variable_name | Value | +------------------+--------+ | system_time_zone | | | time_zone | SYSTEM | +------------------+--------+ 2 rows in set (0.02 sec)
[root@localhost cd37e7e6668415a1b84ed97109bd785d1530f4662ef0caca45305a3b6ebf1b02]# head -n 10 cd37e7e6668415a1b84ed97109bd785d1530f4662ef0caca45305a3b6ebf1b02-json.log {"log":"Thank you for using GitLab Docker Image!\n","stream":"stdout","time":"2024-06-18T06:44:47.985803963Z"} {"log":"Current version: gitlab-ce=17.0.2-ce.0\n","stream":"stdout","time":"2024-06-18T06:44:47.985835222Z"} {"log":"\n","stream":"stdout","time":"2024-06-18T06:44:47.985839079Z"} {"log":"Configure GitLab for your system by editing /etc/gitlab/gitlab.rb file\n","stream":"stdout","time":"2024-06-18T06:44:47.985842175Z"} {"log":"And restart this container to reload settings.\n","stream":"stdout","time":"2024-06-18T06:44:47.985845291Z"} {"log":"To do it use docker exec:\n","stream":"stdout","time":"2024-06-18T06:44:47.985848156Z"} {"log":"\n","stream":"stdout","time":"2024-06-18T06:44:47.985851212Z"} {"log":" docker exec -it gitlab editor /etc/gitlab/gitlab.rb\n","stream":"stdout","time":"2024-06-18T06:44:47.985876118Z"} {"log":" docker restart gitlab\n","stream":"stdout","time":"2024-06-18T06:44:47.98588256Z"} {"log":"\n","stream":"stdout","time":"2024-06-18T06:44:47.985885686Z"}