时区显示EDT和SYSTEM表示什么？时区可以修改吗？
show variables like '%time_zone';rlwrap: warning: rlwrap appears to do nothing for mysql, which asks for
single keypresses all the time. Don't you need --always-readline
and possibly --no-children? (cf. the rlwrap manpage)
warnings can be silenced by the --no-warnings (-n) option
+------------------+--------+
| Variable_name | Value|
+------------------+--------+
| system_time_zone | EDT |
| time_zone | SYSTEM |
+------------------+--------
本帖最后由 驭无殇1998 于 2024-6-11 14:45 编辑
我配置的不是你这样的喔。这个修改没影响的吧
你这个应该是跟随系统时间的意思吧
我这用官方配置是这样的：
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAn8AAAEWCAIAAACYP2ajAAAgAElEQVR4Ae2dva7cNtqAp13fQG4jRWAkLlwEQW5hu4WBICdwlXrjcoF4gS1iu0iKvYC14WobI5vKjYsUnzsXzvE26TZpposPEkMfSIrUyz+J0mjmUJxHCHI0FH9ePtTwGUqa8W6/aPvqq686NghAAAI+ga+++movNiYKHw+vNkMgOJPFSb3a7m5ZTbypNnMSESgETkggmLOYKE7InqbWJBCcyfsjbNh3zQGjLgicOYFgzsK+Z34+bLf7wZm8P8K23L5fsUEAAhCICMhpKjpIAgQ2Q0CeycfYX2jfY4RCnRCAAAQgAIEzIYB9z2Sg6SYEIAABCFREAPtWNBiEAgEIQAACZ0IA+57JQNNNCEAAAhCoiAD2rWgwCAUCEIAABM6EAPY9k4GmmxCAAAQgUBEB7FvRYBAKBCAAAQicCQHseyYDTTchAAEIQKAiAti3osEgFAhAAAIQOBMCRfa9qnjr2CAAAQhAAAJbI4B9tzZixAsBCEAAAtsngH23P4b0AAIQgAAEtkYA+25txI4T7+Xzt3+699vtJ38cp/rN1HouHL79onvvk+7LF5sZGAKFQHMEsG96SM0sfPdV+mhzqe8ePvrtT/d+u3Hv6vuZfSsA9cfde6py89+N6xF8YQx5Dr/8fvveb7efv5uJZ1H2Lz9Jq/Hbv6t0Zc3HQ73/faxSvv15SJne+7n7VNfz3t+n87adI4e67V7TuzoI1G/f//30n8ePv/vuu8c//i/18NeRMBZI5UgtX0+1i9d8BaAKzXfUjpfGkOVwSvsmF6Y/WPUaAfe61R79VMi46zpVfEqrySaOOgJ1Vg6HOsflPKKq2L7/U979zm3Yt8ozssC+Lm6lwGta+x4cw+ntGyxn1Srt791/u657oVau5qKxkscXOtF1sOtMTpHAbpaAsW+AOpubAxBYk0C99v3pP0a8j3/86Ue1i33XHPfV6sK+q6F0FSWVIO3b37J9kb7mjH0dycmdJOrJUmSAwBoE6rXv1U8/Pv7PT/pqsxbx+vZ99/3zq9v2fuTtJ79//8tA1Enl0ua58ejqocigs777/snboYZHV66G75/k7qEWr//0YuvGo98vh6DUnq757RDJL388zMSgy6nm9N3Kdw+fqOeq9KNVss6CS7KjTVw+f3vjnopnFJTpw0jfh7G4ce/t7Sd/BL3uuiGD6YJD7eOZfJWLYYpDtPb9/om+U+6FOgSZ6cVkeDqDucgcLMjiK89fftLJa85BBnOB2rtMrdfNMj146srcQv6h677Uz2Spyn/u972cP3fuDvR7X8x+dCsdZ7CCt+2aaD81i35Lr1/xizCCDCqjODoSZBK1bUfx+vrzjz/+/GueThNM2F2LQMX2He7yHsW+ZvZ0TwOpZ47EA0FGKrcf9cbqnxjyHkrqn9DxatAe6rrOOSkcp2gSDzMMr1X9RmxDWqflMSg5GYN8ckrlv/3kd/nck9/TKet0E01kQInPB0P0OngB2R1JjMXQR5UrkSFVj6swv5OLYYqDP3Dmw5k8YdJB+r3IR1V2xEjRLHyNNn4QBdNW009XDSLXy2UnYM+pXWfs+6lWr8rzRa9es68ueutNra39/+SHAJsr+zcdp7SveyhMtiIymAVr/+CYy+Pf6j4wyD76F19/rLfP/zXrqbZs3zkAAUHgbO1rZuFhFXj56ve7z4fv25jp1XwJR6/D3hkBuKeg+/n3kVsxq3XwILZXV3+691uf+dXVIFGZLoYhvasze8/ZhsXfPXxy9fCVexA3DLLTttYPM7/ts/2iO+59jDCN57Q00UQClPnyUuLx4EwTulM3hkVkT9KhNr248SQ7WGl66dRMDEPmTAZhX9Pl8NtZ070Y2jh4T0s0cKertOjKc6oGY1/zBLVz5A/mMa5POmN6kz40bRep8nOAi6Rkx1Qoi/dyfWzvZ9smXKMmw/CNqZ/1rW4bYdd16wVp177It2QsyTOPwHnb9551UgStl6tcYHkuNAtTucrsOr1M7L+0E0/WxkbSxFGjUYI2gVg/5S9o26KhnnUNvmszlWSsYyse/vpN9CryXBuGbcumm0jFE+TUL/ODZesv+RvUHBfJZLADmlZvf0cgOB8yVcVtzk0Z9+v40b6tvH3NQtYITO4bQSYqT1VV2KPE16XMwtdfyHZ+orGvk7HTrVvirxtkYV/IBoGZBM7Wvl33qr/pe+Pe27vP3RK252cmWbH8UvnVUrjXTHpiFTdlVYb+huuj3+4+uTJ3cPV12mCOHhsxUWFnl4DDAl2V/OWPu/7l8WHNrQ6n40w1mc852kQClPkUIj402OaSTSSubPfX+WUNo4Nl6y/5m4xBFsxkMPbVqIMLzrpwWS9kO4v33WLR7ARf/+0Kn3lOKVO60FRufOZa7C3oLvaKnVkXn/u+a6dKiar0VGB9p+zFZ2NfuVyW0a4c5OJxoiAEJgicsX0VmXfqgrP+oQlzkdnRSkhlnn314lgtnf+4e+/qezV3q1uhyqZSKq693I5dcqnj8bpZH5U3ns2++NCQcUmiuUzOqSYSoI5hXxVwdrASvckmZbo55M9k6AfiD3MzXhA2JU9mXysnd5XY3IJ1y74N2Td4aqwfAtvBYUT0nlrOYt8ACi+3TeDM7esGT8vSPjNlHpvyF5Gpta9/Rde78mwuRT76/fKVWfWq+m8/V/dlUysnF0a8owPTwo7NbW5F334unhD2LwsfvvadbCJhXy2qVDfTYov7FVPwU8LB8o+Ov0rHIMpkMvT2faeQJp6Gm/+5SjQ5Y1ct+/RVWbVjbKS//iuXnlJU2apTkpte++qFtWwrW//UAdeRMKMOLPy1kNSV5+zad70gw9h4DYE1CZyrfX/5/a76ipF7Xkk9pSx1G7xUyL21b/8UbvyskLOOucj88El/sVq9fHSlJm55L7lgKM1DxQ/101L2undfzD4I1vfCrePFyizjkkS76ZyTTVhQluQvanUoSYqm0k2YGtS3jMIvdNmiU4Nl85X8TccgSmYyDPa11/PFZzX3cW2sF6KNhbvGjsY6I/ZVhz7pvh3/lsxS+5rKv3xhH4la1BV1odguZOMK1KcH+3Mi6mjmqasR+64SpA7s5399/rH6yhHPPMfjRMqhBCq2r/25DfdrV/2O/8XfhQD0ZBpcs5W/cmylIqr37WuWlWENj4Z7uqaG4GlncedY1Dyxq3yg7hyHS+3+E0MQg2++jEtci7pTcQ1O86YXcQYn+GQG7xPGVBPmmsFIE93UYLneZHcmY5jM4Nm3MyH5I6JW5GO9yAZXeMC/S2rudLpv/sgrz8Eh+SvQ8SF54bpk7Zu7qypdON6h4Jp5ogtm+StuKr/3SfepeA7LyFW2aPo1QDBrZb+G98RD0eMRDkeNfNWXjvjK70CFvZUInKt9u+7y1dVtO13Gv41QYF/1xJP7CYu4BrNWFhO0EqGvxtIxNAtQT2m26PAbF+ZHKl6pfwzAqXH6yvOkddR3l4fH09TaLmjC/BaHI/no7V3v+ef+mkGsJSd43RXvd0tMZtGLicGyMPJ/J7s5mSGwr70WckN83lI/CSJ++STuRT6+giNKOf560UjIWybaen74u/13FLSBnJZWsK9YjDpxzhLbeAymB/994X3VOHgya9q+BwdpQXb2G7/Y1yFhZy0CFdt3+LWNsb21QFAPBCAAgYDAzy/0peeP+bmNAAwvVyCAfVeASBUQgEBjBIaLzh/j3sbGtpbuYN9aRoI4ILBxAqn7tfLqdPgkc9Xd7Z+3+vzrFz/zQ1dVj9R2g8O+2x07IodAVQSasm9VZAmmSQLYt8lhpVMQgAAEIFA1Aexb9fAQHAQgAAEINEkA+zY5rHQKAhCAAASqJoB9qx4egoMABCAAgSYJYN8mh5VOQQACEIBA1QSwb9XDQ3AQgAAEINAkAezb5LDSKQhAAAIQqJoA9q16eAgOAhCAAASaJIB9mxxWOgUBCEAAAlUTwL5VDw/BQQACEIBAkwSwb5PDSqcgAAEIQKBqAti36uEhOAhAAAIQaJIA9m1yWOkUBCAAAQhUTQD7Vj08BAcBCEAAAk0SwL5NDiudggAEIACBqglg36qHh+AgAAEIQKBJAti3yWGlUxCAAAQgUDUB7Fv18BAcBCAAAQg0SQD7NjmsdAoCEIAABKomgH2rHh6CgwAEIACBJglg3yaHlU5BAAIQgEDVBLBv1cNDcBCAAAQg0CQB7NvksNIpCEAAAhComgD2rXp4CA4CEIAABJokgH2bHFY6BQEIQAACVRPAvlUPD8FBAAIQgECTBLBvk8NKpyAAAQhAoGoC2Lfq4SE4CEAAAhBokgD2bXJY6RQEIAABCFRNAPtWPTwEBwEIQAACTRLAvk0OK52CAAQgAIGqCWDfqoeH4CAAAQhAoEkC2LfJYaVTEIAABCBQNQHsW/XwEBwEIAABCDRJAPs2Oax0CgIQgAAEqiaAfaseHoKDAAQgAIEmCWDfJoeVTkEAAhCAQNUEsG/Vw0NwEIAABCDQJAHs2+Sw0ikIQAACEKiaAPatengIDgIQgAAEmiSAfZscVjoFAQhAAAJVE8C+VQ8PwUEAAhCAQJMEsG+Tw0qnIAABCECgagLYt+rhITgIQAACEGiSAPZtcljpFAQgAAEIVE0A+1Y9PAQHAQhAAAJNEsC+TQ4rnYIABCAAgaoJYN+qh4fgIAABCECgSQLYt8lhpVMQgAAEIFA1Aexb9fAQHAQgAAEINEkA+zY5rHQKAhCAAASqJoB9qx4egoMABCAAgSYJYN8mh5VOQQACEIBA1QSwb9XDQ3AQgAAEINAkAezb5LDSKQhAAAIQqJoA9q16eAgOAhCAAASaJIB9mxxWOgUBCEAAAlUTwL5VDw/BQQACEIBAkwSwb5PDSqcgAAEIQKBqAti36uEhOAhAAAIQaJIA9m1yWOkUBCAAAQhUTQD7Vj08BAcBCEAAAk0SwL5NDiudggAEIACBqglg36qHh+AgAAEIQKBJAti3yWGlUxCAAAQgUDUB7Fv18BAcBCAAAQg0SQD7NjmsdAoCEIAABKomgH2rHh6CgwAEIACBJglg3yaHlU5BAAIQgEDVBLBv1cNDcBCAAAQg0CQB7NvksNIpCEAAAhComgD2rXp4CA4CEIAABJokgH2bHFY6BQEIQAACVRPAvlUPD8FBAAIQgECTBLBvk8NKpyAAAQhAoGoC2Lfq4SE4CEAAAhBokgD2bXJY6RQEIAABCFRNAPtWPTwEBwEIQAACTRIosu+eDQIQgAAEIACB9Qhg3/VYUhMEIAABCECgjAD2LeNELghAAAIQgMB6BLDveiypCQIQgAAEIFBGoMi+XRPb6+a2JoaFTkAAAhA4RwLnZd+WRvj169ctdYe+QAACEDgrAjPs28DSsaWhbWA4tt6Flk4n+gIBCJyYwDz77re8NbZYfP369ZZHY99A/Cd+r9IcBCDQEgHsu9XRbMBe+y1vjX2Y2+rbgLghsFkC2HerQ4d999e6Yd+tvnOIGwJ1EMC+bhwuH9za7S6eudd2R6XfenBpX9byF/vur3XDvrW8E4gDAtskgH3tuOXk22Hf/TG2Bj492FOHvxCAAARmE8C+PbJnF7vMCnfMvqpUyZZYUieGKvsBIJG3a8Be+y1vrH1TZyVpEIBAKYHd/0XbPtpMZaPT/dM7u93N+y9F0Zf3b+7uPBUJY7sqc3nusZryx8amS997k051F6JVTt+sJSldtOn2jcb96qKcLmFkODRNfzT23qZGq3hsvJLrvRiJXzeiOhH2YWbcs07BuT0bO506NghAAAITBFaybyzf/X7SAfthmzmtDgVn7I1Ml1q3RnuXD245t3Z6m1r7+rqcbV8tXt2kUbBfnQkh9f9Re02wj3BHCXt/U8f1tp6zR+Pfm9MnZ99CrU71yu/jzFcjp1PHBgEIQGCKwDr2NdOcm6L7mTr5x03fRbmj1c9++ZadLgf/dd2zi+j685R9k90MEouUeqB9x4BqjZlRUgCHvR6nn6Dd7ffADtvLl/L6xvLB2E9+31cFkbHvy6f379xU8dmo0nHoboxnSRcsSs2eTh0bBCAAgWkCa9g3NU/uJzd/wk9lX1Zvqiadlpsu1aPO/XI3Xvh23ehTVyUr3ThPl94OtK/q5NM7gbBe3r/pUgbiw54mE+p4ZfB9G8Gf9Np3MGYqCC9umUEdmLM5JkFQM17mTqeODQIQgEABgRXsq2a+BbNZ2YS5oOJ9ZstNl/qys5263eVnm5D6O6xkY7OWpGTG5XD7vnx6x1swapc5hIO73J7O4Hfx5v2X0msZmIcnp+073K9IBeHiLmhel7/p4SgoVZ4ldzp1bBCAAAQKCBxsXzN/2xl+QqnyMuD0TJqaf/fLt4npUrlv0GoBOpXFM7dvMe9VUcWH2ze4qBwgHl4OewanHsRhcFYGnx6yjH3NOnx356kJ4ql6HG90G8KW7Qw9Cvsqcx2yP3E6dWwQgAAExggcal81t+22vfbVeBa519jXN+u1rn33/dNK2kiRQwcPDXuqhFlvipuoUUmda+X/Ze1rwrlzP77vq5VqP+iNhDOo12QqLTdSZXwI+3ZsEIDAAQQOs6+exRPT5L5gCwyQKLGyBEamS6tMs/q89eDS7KTXXMEj0QF8W1WQXPLyoLWvNkw6YJ1656l41spnPxTtzTYkpCpMLzYT4zeelLevKZcYfRX21KNWOs/N+/ejrH2nVopePzVWMqjkgQAEIJAkcJB9zTM+cpo082NqzrYK2NttImtfR8FKx1Y49TdnX2FaJ1aV5l50wybSSy86DzBSFQ5Vm8e7wq8Py+P+/pS99tGmiBv5DHv9tWoVpF5t6gxyRFUtXvao2oUJU/GHQdgluu1D1Kw5ocQJo30b2tbkEgv9qJ7ChNzp1LFBAAIQKCBwkH33eounSZM+8f/pKX1hxbl250yXwrKd3HLpOo9e9l6o39+4uJh/C/ma7GsUdceIuScegp8eqhzzkfRx+0YqtR8C1JWW0Ki6D1HqSNtrHJpzOnVsEIAABAIC12ffvb+pGTScVf0ch74qmS6VXdXyM2fZXLr+WpI2bn/lOZuxy2+28XwOeSRhr35dN6y2/QsIg0T9vZv3X7oE/Q0lddlWjoU7ul9xS8Rva396Z3fzvnreSixk3Qq8+ETRtfjfTpbfv7KNLf1bcjp1bBCAAAQyBFa2r1mFRNO/b4F+GaOmVpXfTrFqjncv9npbc7ZUP++QgWDcqYK0F4dz8kym62vQ9tmr3r6qJbVrK8y1LNNXsa+05t7/yahBom7v6R2jWZegiqgrzXZQ7GvPxjrx0P9l7OvOCLdjGtJnlu5ccMDGYTPYwy9f6s8UXk/0N7K8FFt6/t+R06ljgwAEIDBF4Aj29Sbuvd3spKhe24ky+jlBdcDoo88+5LT1LP+bmy5T/7CgEWH6U4QQqvaub1hh3859JUkUUYmZ7Rrsu+83z77eC5UhSrDFDvmbtK9oqT8DRIDuxBK5XAQqTWfwy6lX+oxyZfQp5apy5Wfv5E6njg0CEIBAAYHrsK+bKCP77t3mJks99a8wWc57SDW5xvV+98qI1654B9KBfc0Bk3nJveCh4nAvYa8B2t5tvoz65CijTJD7Jn+c4qpfvpOI36tMBi73VSZtULnKFwlhXlOpl7pKf7BvxwYBCBxA4PT21ROl1amYNfdy8+bHla4/n2a6TNr3gAHKFk3Yy6PW4/S0YxFHGUWC2M1mtwcO+ZuI36tuCFxFZE8Ym8U7cfQLm8M7YrMfYfl+mtOpY4MABBolcAT7pq/XqlQ7Qe7FpifLRBG5shHZD9htbLpM2EtpKrWF3BVzP80pN2W6I6hrX/yvLOg+JU+G7BF9IOLgd/iA86gv2tjp1LFBAAKnJXAE+6anuXjG3594a2y6zNg3FJXgLq0UZFOH7jzVV3SDI2qQ+qPrjlcifq8B97EsfT6pvDpL/rBX3eovGjudOjYIQOC0BFaw734jW2PT5ZS9ah+VBuI/7VuV1iAAgaYIYN+tDmcD9tpveWvsw9xW3wbEDYHNEsC+Wx067Lu/1g37bvWdQ9wQqIMA9q1jHOZHgX3317ph3/nnLCUgAIGBAPYdWGxrD/vur3XDvtt6vxAtBGojUGTf161stdE/JJ5WxoR+QAACEDhHAkX2PUQSlIUABCAAAQhAICCAfQMgvIQABCAAAQgcnQD2PTpiGoAABCAAAQgEBLBvAISXEIAABCAAgaMTwL5HR0wDEIAABCAAgYAA9g2A8BICEIAABCBwdALY9+iIaQACEIAABCAQEDiKfd+8efP61yv+gwAEIAABSeDNmzfBFMzLsyWAffmUAAEIQOBEBLDv2bo27jj2PdG7Tn7+ZR8CEDhPAtg3ltDZpmBf7AsBCEDgRASw79m6Nu449j3Ru+48P+nTawhAQBLAvrGEzjYF+2JfCEAAAicigH3P1rVxx7Hvid518vMv+xCAwHkSwL6xhM425bj2/edfdrvd7s+PU4b78R/v73a7v/x72Zvwh799uNvt3v/bq6Lijz+bzqzzpEPl21MQgAAE1iDg7PvsQs2NF89S6rn85qPsMT+/riVdiZ+RVxUSOK59X2ulJRVr9LnYdti36GPHGvMFDUEAAmsRcPbt8votl6+pBPtWaNaSkI5s31///Wf1Ce+zf4YaePXXD5LpqVVyWHZ+Hta+hzOkBghA4GACg32z+p0hX+xbIrlq8xzbvlfpi8+HXXae/TkU+x48a8xmTosQgEBEQNg3o9858sW+1Zq1JLCj2zd58Tlx2dlco1YLZbV5V6T1oT8/Nsvl3e6Df/zw65WpNs7Wl0/VoG4Se634K/K+FW9hbT46mDpL7jG7fsmCXpA28mScI8XHKvy1/4hTHicqhQAEroWAtG9Svwn5mmvUdsrwrjP79331q4++uRQzv67OT+qbNfUFh0RJdo9O4Pj2/TW+yByl/PiP98XjV9o0H/71RytC7cX3P/jQ818gy4Ia1NlmzK0+kJpL4mErwpQ6g8tvtC2CTL51jT7FpwfTU9HKaJxRcROkCtz2ParQdGRmnMngSYQABI5NwLNvF6s2Srn85iPh29Cvs+3rV6BfZR79Orp7aOAE9r1yS7r+zJ687BxkMOZzgjEXcwL7Bld4SmpI5XH21Z8AvMVx+JkgaFG/7PUpJR20EpTyj8bF+xTZd13EytisemfHeewphvohAIEkAd++kX4j+YaKCjLMtK+fXdXt2zhsjddHJXAK+75OOcZ5LjxHTWb5ZSQtWuebPv+IfQtrCBblXoV60Skl+mv0GSLwqLCv37VEVX0XojjDjyn2MrXXdw9movJEJalQQ+zkgQAEjk8gsG+g38Ct4dRvDssvI/k6TahUF7GXl/3cuvaJFsMIeL0mgZPY1/OcvnYqF3PqjB8usdq7G+KrwJ4XvcvRwnPza+hvl9qFo2zFeXGIpt8TLdpIxDs2ZT4d2NDfsTgTxXVUnn0NK/PJYGmcqBcCELgWAqF9Pf16qrTTvFZmMBG5a9G+Tyfs6+Qd1Jb72rGNgL9HInAa+4qFoxaGrxNzL3O327n7o1pRbukpvehU5yUuqsH7TOA/xuWtLxOWzb1vE/r07stOxJkoXmJfB8rBYQcCEKiSQGRfod+EfJ0w7fI1eMp5gX2duY+kFKotJnAi+7qLz1owzrJabAnVzbRvWQ2+8u2C261KPZ0HC9ZSASf0Ke07FWei+Lh9ZeVVzjW5jymkQ+A8CcT2dfrNytfzZcK37vjE2pebvMVePE3GU9m3X2h++P4H8sHjjH21coZfyPK8aEUoE2OrpWoQDzzrSnSeQcmywv6itP8poUBvCX1KQU7FmSgeBKli8D6alDwLdp7THL2GQIUEEvbt9fvRRx/tdm6Ja6Z/s/R1drVPSQ1PKfsujrObFFdrQs+n8QytpAiczL79xWfx5Rnr0eAKsFFU9NRVeMPVk6W5omvv4GZqUDc73EVak8ctfO3zTUMrfSW2TpPBFc+YOKFPad+pniaKT9m3v6ggf03s8WdDNzNxVjgrERIEzoFAyr69fneRfDu3LpYyzj91ZT1uv/Fr3Cur7VOEz59dDC5PGYK04xE4nX2tJ5ILSr2e658F+Oyf/vIu8cMasSxNkdEa3v/bK71StI8cBCr1dG4+GciohLnzSkvo07OvXblm4kwUn7SvWw3bbqHec5jE6eNGCSTta/Xr1qhywtfr1f7dffFs9L6vKmaNq0p89M2lfunXKyvkgSuJ+tT7J7RvXlobfSMRNgQgAIFZBNL2PfW0T3tVEMC+7gI4OxCAAASOSwD7VuG9OoLAvsd9s836XExmCECgbQLYtw7xVREF9sW+EIAABE5EAPtW4b06gsC+c991/qNY7lkn+dQxd7ghAAEIpAhg3zrEV0UU2HeufckPAQhAYCEB7FuF9+oIAvsufBe1fXeK3kEAAscggH3rEF8VURTZ9w0bBCAAAQhAAALrESiy79zPgHy+q+KTFUFAAAKVEdjv95VFRDjXRgD7Xht6GoYABM6NAPY9txEf6S/2HYHDIQhAAAJrEsC+a9LceF3Yd+MDSPgQgMB2CGDf7YzV0SPFvkdHTAMQgAAEDAHsy5ngCGBfh4IdCEAAAsclgH2Py3dTtWPfTQ0XwUIAAlsmgH23PHorx459DwV6+eDWbre79eDy0IooDwEItE4gY18zi7jfrb145nHwj/YH/URX1OwwH3kAK32xPfvqfxs6ODtPBzduHfuejj4tQWDjBGL7mn/s3tflswv3ed7ML2LCu3xwy8/cdV2UaeOUziT8g+y72+2SP8RxzF/buN7z7HpbP5Nzkm5CoFkCgX21eiOZDr3XE87I8T4n89KAbEN7h9o3KWDsu6EzgFAhAIGTEfDsO+XerpvOoSPHvicbwDUbWsG+sYAD+5pTw9yPMFdQMueUlxyXkinx3Q1duL/7IT8suhNTZhBh9EXEpZ0032zrul5XfHFzMjwZf2k0uh+yoKxwt3MBqvpGgpTNyRpkzTIP+xCAQDkBaVlzGxIAAAuASURBVF9/5kjWYd6pk28+94ZOVkJipQTWsW8gYGlffYa5s+fywYV+PMnM654R+s95Ji1dSjFMnmd+dr9yU2A3+MccVrKyYRWe4pnWdX2uK4uaG4u/6MQJqfgIemi2uxaiYBITODikorjJBIHzIiDs67/FMhjsfDK8eVMZw/d/Kg9p1RFYzb5SwMK++gxzahq6H58uOqU/x3Kl0v6Lc8vzuj99RQx9ijyfZeNDkPGeKSrq6rwPDS4+udScbG48/jiIKCWMSnbfZvbS+pBkP/w6Dg7JNstfCEBAEBjs67/jRJZwt3+3iuVCmCO9JolykVAZgTXt6wQc2le6yPY/PPf0aytEPfmnStllm/RGbArvZAwbsr60bemAEplsoN7fVD6//UQOnSHfnF9+VjjpzIkKg04ngjR3mHquiRpSRTw0vIAABCYJLLCvrlO/JaO7S7Y53p2WxKb+rmlf9/yzsK85LeRlXofHm+J1PufUkVLReTbk1eem+J+pLiqQfJTBC8aFGO0kKvO0lfp0kHpyQjQ3FX8Ug58QR6RTPNnrEjI5LuRBMYcFSbfrRsgPglcQgEARgcG+wcRRUtoqOHp3p97QJRWS51oJrGZfp97Xv14J+9pFl52/5XmjzyWToHbloV4GiVLReRYlBDwTx0XDNrNOmnZLorLgTZTIMd5cooANavqvKeyT02l+kqpIJqfaFFGmDk/HQg4IQGCKgLDvoreZKRReF1xU1VSoHD82gXXsK9Ub2dd0QU/uyqbCC/qcUa/VQZE+dDouFZ9nQhtDwWEvLjCxGB2KxnuJyg61byqauOFkiokmAqeBRJ8kZGq2G31dE0iTwZAIAQhMEhD29W6QTRZ0GeQb2Sam3tD2GH+rJbCCfQP1ZuyrCETniE649eDBxfBEckzKL+W/0rnHXVFWIHVKx6HEPbBreye7Bc2Nx5+IwiSZliL32oiCA14HE0H6HwIWhpSNlQMQgIAiIO2bmBGnIaXeu8l5aboqclwzgUPtG6vXt++zC+el8Olg3XM9zYuvvhgcY6USZ59Jkldjnl24V4n8Cbd4choZk1xtrpe5DL4M/eZG488EY8r4tQ5ZDdZsUIkgffv2b2cH0Sjd1Tc0xB4EIDCDgG9f+1E5WH2o96d5a6s3snzbpd65qXXNjIjIem0EDrJvUr2+ff0buAlZaE/E6UYf5r5veNScgcFVbFnAO2ET52uiTZ0kT/PsiESt+0WXNpeNPxnIEIS9Nd7/HbrgZ/EZJoIM7KtanRdSMk4SIQABSSCyrz7ov9X8u3D+G9k/ZmtOvaHtMf5WS+D49h3vuj5tfDWMF+AoBCAAga0SSNt3q70h7oMIXLN9/XXjQT2hMAQgAIHKCWDfygfolOFdq331wne4VnrKftMWBCAAgZMTwL4nR15vg9djX3crA/XWe2oQGQQgsDYB7Ls20Q3Xdz32rRhY8PyDe6jpWj4nVBVMxYNGaBDYCAHsu5GBOkWY2PcUlGkDAhCAQPR9X5CcNQHse9bDT+chAIFTEmDte0ralbeFfSsfIMKDAATaIYB92xnLg3tSZN8387c9GwQgAAEIQAACGQJF9u1mbv6/cTSzMNkhAAEINEqAtW+jA7ukW9h3CTXKQAACEFhAAPsugNZqEezb6sjSLwhAoDoC2Le6Ibm+gLDv9bGnZQhA4MwIYN8zG/Cx7mLfMTocgwAEILAiAey7IsytV4V9tz6CxA8BCGyGAPbdzFAdP1Dse3zGtAABCEBAE8C+nAiOwPXY1/wrC/yzvm4Y2IEABM6BwGL7un+ZRv30fOpX5yczSLyTmSczyNrYX0bgFPaN/xFfM7TYd9mYUQoCENgogWX21VOonS8Ts2eQ5GWPQXmHg6I692SGuE5SFhA4gX3N8KY+rS2IlyIQgAAENktgiX21DL0JNEjxbKnRBBkkrvhQkBK87LouTpEVsr+UAPZdSo5yEIAABGYSWGDflPv8NP+Vikgveexi2QsxzhvYdTKDVx0vDiBwXPuaZa/7N3J3u11/Qvgj7FbHOrnPbj7rxSmys/Jo8lSTmc0ZKYMx+7KgrDC4uzISpGxF1iBrlnnYhwAEzpNA3r5q5vAWuD2gpEj9RP+VKqcqc9OPmZNM3XHWwNWTGc5z3I7S6+PaV4eshzM4r/T54E41k0M8TGBOFyVHewaZLPaVPb/cYXNtJGhkAlgYlzxH7Rk5NDC424Z9hJAmIuYwBCCwbQLz7evPlbb3Qao/eY0cDA711YlUsWvb4tqzILHmbk32tVpz6hPuC6+lxOeITpF6HseUdG9Q3KvSFPAE79dxcEjjAXMUAhDYPIHZ9vUnGdf/zGxjL+2JudQVUTuTtU1m8KrjxUEEKrKvd8J44tM99E6L+NzLnVdpOl5lKkuiQpvaKzkqYo/3cSdqSBVJx0MqBCBwDgSOY99gujQTT7CW0HQzU9IweU1mOIdBOlUft2NfKUhzitjPefKvp/AcxPgM0ynx2SqT40K9s00xc1iGYveLQsqFSjoEINAQAd+++VljuO43mFFikKly3+bRafGMJmdRm9VfRqQqy61ORA3sLiCwZfsu1Jo54/0TU6f5SQqmTDbF/DbFKZ46vGA8KAIBCDRMwLev7KiaTPzpxRwVk8yQXc5MI76Mp7Sy2sJysrkhCPYOJLBN+5pPcOEpUoTCWDIqOnIG9++IlF7lqSz3iyIhEwQgcG4E5ts3uVyV85XcH3Dm5qNUbi/Ne9HXl0obmmJvIYGN2nepfjPutddeAil759yUfZeGtHDgKAYBCGyPwAL7JvSrZiY3WaVmppHZyJvVNECvttRV5iDD9qhXGvEJ7Jt6Hso/AxKnj87gzi93jgyXZkyZ4bU+aVIXbgR4U8avdTismxwqDIMKX6uCfpRLQhqaZw8CEGiewBL7BjNoPBOZlGFiC2ai0Zktrm2yueYH6VQdPIV97XPu6jGk/gzR54NzZeIE8L2mafhlVJI5q0qfbupPSZt9+Ovi6E87e2Q4m1VjiSAD+84PSfeL/0EAAudCIG/fCQJyshtmrKGQP715c5cp6hWaqs2bW72SQ4vsHUrgNPY9NErKQwACEGiAwGL7NtB3uhAQwL4BEF5CAAIQOBYB7HssshusF/tucNAIGQIQ2CYB7LvNcTtK1Nj3KFipFAIQgEBMAPvGTM42pT37yucJ7PNT6i+PDpztSU7HIVALAexby0hUEEd79q0AKiFAAAIQSBHAvikqZ5qGfc904Ok2BCBwegLY9/TMq20R+1Y7NAQGAQi0RgD7tjaiB/SnyL5v5m97NghAAAIQgAAEMgSK7NuxQQACEIAABCCwHgHsux5LaoIABCAAAQiUEcC+ZZzIBQEIQAACEFiPAPZdjyU1QQACEIAABMoIYN8yTuSCAAQgAAEIrEcA+67HkpogAAEIQAACZQSwbxknckEAAhCAAATWI4B912NJTRCAAAQgAIEyAti3jBO5IAABCEAAAusRwL7rsaQmCEAAAhCAQBkB7FvGiVwQgAAEIACB9Qhg3/VYUhMEIAABCECgjAD2LeNELghAAAIQgMB6BLDveiypCQIQgAAEIFBGAPuWcSIXBCAAAQhAYD0C2Hc9ltQEAQhAAAIQKCOAfcs4kQsCEIAABCCwHgHsux5LaoIABCAAAQiUEcC+ZZzIBQEIQAACEFiPAPZdjyU1QQACEIAABMoIYN8yTuSCAAQgAAEIrEcA+67HkpogAAEIQAACZQSwbxknckEAAhCAAATWI4B912NJTRCAAAQgAIEyAti3jBO5IAABCEAAAusRwL7rsaQmCEAAAhCAQBkB7FvGiVwQgAAEIACB9Qhg3/VYUhMEIAABCECgjAD2LeNELghAAAIQgMB6BLDveiypCQIQgAAEIFBGAPuWcSIXBCAAAQhAYD0C2Hc9ltQEAQhAAAIQKCOAfcs4kQsCEIAABCCwHoH/B2GKBc9B2teVAAAAAElFTkSuQmCC
应该配置文件加上这个配置重启一下就行了：
default_time_zone = "+8:00"
驭无殇1998 发表于 2024-6-11 14:44
我配置的不是你这样的喔。这个修改没影响的吧
你这个应该是跟随系统时间的意思吧
我的系统是使用默认配置的，SYSTEM应该是根据操作系统的时区而生成的。 EDT代表的是东部夏令时（Eastern Daylight Time），这是美国东部和加拿大东部地区在夏季使用的时区。EDT比协调世界时（UTC）慢4小时，也就是UTC-4。
中国使用的是东八区的时间，也就是协调世界时加上8小时（UTC+8）。因此，当美国东部处于EDT时，中国比EDT快12小时。这意味着如果北京是上午9点，那么在EDT下美国东部应该是前一天晚上9点。
===
设置时区要结合业务需求和实际情况而定，一般在国内会选择 东八区，即 +8:00 网上有说就是当参数设置time_zone=system的时候，查询timestamp字段，会调用系统的时区做时区转换，有全局锁__libc_lock_lock的保护，导致线程并发环境下，系统性能受限。如果将time_zone=’+8:00’则不会调用系统时区，则不会触发系统时区转换，使用mysql自身转换，大大提高了性能。 banjin 发表于 2024-6-12 10:45
网上有说就是当参数设置time_zone=system的时候，查询timestamp字段，会调用系统的时区做时区转换，有全局 ...
是有这个问题。 banjin 发表于 2024-6-12 10:45
网上有说就是当参数设置time_zone=system的时候，查询timestamp字段，会调用系统的时区做时区转换，有全局 ...
前几天看到一个文章，说是备节点无法修改时区的问题。 banjin 发表于 2024-6-12 10:45
网上有说就是当参数设置time_zone=system的时候，查询timestamp字段，会调用系统的时区做时区转换，有全局 ...
对对! TIME_ZONE= SYSTEM 自然要去查系统时区,那么这个系统时区是指SYSTEM_TIME_ZONE吗?
页:
[1]