li15130686553 发表于 2023-10-27 11:41:19

mgr 数据库使用内存一直在上涨,是不是内存泄露了。

PC 信息: 16C , 32G

数据库关键参数配置: innodb_buffer_size 一开始 21G ,目前已经调整到了12G
                                 join_buffer_size   由 默认调整到了 16M
                                 sort_buffer_size   由 默认调整到   4M
状态查看:
show global status like '%open%tables%';

Open_tables1798             由4000 变道了 现在 不到2000
Opened_tables356472


show variables like '%table_open_cache%';

Variable_nameValue
table_open_cache4000
table_open_cache_instances16


找到了 排名执行次数最多的慢sql 语句,发给开发来做优化了,刚发的还没有优化。
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA1kAAAEGCAYAAACXRl84AAAgAElEQVR4Aey9aZAWVZo2PH/eb955Z3q+rztmpvud7tZWUUQEZJFF9kVQdqgCqoCiFqqoXWTfBNkEQQqaTREQQVZZZacEWUQWEdFu21Gn7W3WmJmYNWIiJiYm4nxxHbzTk0k+ez75ZD55VUTWycyz3ec+1zl5X3mfPM/vffd731fO4//++X3qJw89qh56pLVq0bIND+qAGCAGiAFigBggBogBYoAYIAaIgSQx8HtuBOvhx55QQTvue+hR9YMf3s+DOiAGiAFigBggBogBYoAYIAaIgUBj4B6SBQ9W4AjWgy0DrUSSP5JfYoAYIAaIAWKAGCAGiAFigBgQDNxDsrBEMEgkix4sglXAypBYIAaIAWKAGCAGiAFigBgIAwbuIVn4BisoJIsEi4MoDIOIMhKnxAAxQAwQA8QAMUAMEAMmBgJLsu7jEkEukeRaY2KAGCAGiAFigBggBogBYiCEGAgkyaIHi28CzDcBPCceiAFigBggBogBYoAYIAbChIHAkSx6sDiAwjSAKCvxSgwQA8QAMUAMEAPEADHgxEBaJKtn32cUjrYdu3n6/RY9WASoE6C8JiaIAWKAGCAGiAFigBggBsKGgZRJ1sDBo9WGTTv1Udc41zOSRQ8WB0/YBg/lJWaJAWKAGCAGiAFigBggBtwwEAiSRYJFcLqBk/eIC2KAGCAGiAFigBggBoiBMGIgZZKF7d2f6j1QLxds/cSTGXuyuESQAyeMA4cyE7fEADFADBADxAAxQAwQA7EwkBLJAqmaOu0FNWfecn0MG1WcEcmiB4vAjAVM3ic2iAFigBggBogBYoAYIAbCioGUSJb5PRa+y8rkmyx6sDhowjpoKDexSwx4i4Hde46r27e/VlOnLYj7WzBIgyNo+n+gxaPq9a371PXrn2v5bt78Uh081JyWnJ269EwqX7LpgqarZORJFg/JlMU03o5V6pP6JAaSx0BKJAuerOq6WRlvfEEPVvIdRDBTV8RAODHQ3HxTG9wgBf0HDnM1nKtrp1tpYFim0tez5ixV757/0Mp/5f2fqZdWrFcw+M1ycI37V69+ptPeuvWVOn36A1VR2WhLB4IDWSG3mT/WuaQX4hMrTEScUH6yRrXUEUumZO6vadpi6UzKg25wv+VjbZNqu7OebdsPWLq9fPmOQl+cv3Ar5bI2bNyhywFhc9ZhXiebzsyT6fmQYYXqnXcuKuAHegOhhJzp6iyePMniIV4ZjAvnvMl+Y7/lEwZSIln4Hsv0ZqXjySLB4gDKpwHEthDPsTBgkiwYxW7p3thxyDL4UyFZMG5h6MLgheGLA94T3Dt48JxVFwjW0aPvWWmFAAi5WLpsrZVWSFOyJKuouELt3HXUOs6eva7rQWjeRzq3tpv3kjWqRW4zb6rnQrIuXvxYywndiQfqypVPVeduvRLKa9YJHQvxMMl0OuRj0eLVWocvrdxgyeDWZrd0pkxenwMb0kYQSODI1Fm7Dl0seb2oO1k8eFEXy+AcTgwQA9nCgK8ki0sECeRsAZnlEltBw4BJsmDQO+WDYSqGKwzpZElWrz6DtCGOPKMKJljlwqhHPbhfNeV5fR8kCte4373XACstvFi4j/qFGKRKspztEfKC0BmX6DpZoxoy40hUXrx4kdPUN4jSps1v6bJPnLicUvnDRxbpfOl4ruLJKXFetFnKSicEToVQzZi5yNINdLZv/ynd9lgvEdKpD3mSxUO65TMfnxfEADHgBwZSIlk9+gxSrzRttZYLrv3pdlVRNTWpzS9IsAhoPwDNOoizoGBASNbJU+9rQxRLA03Z5i9Yoe9LPAzLccXl+h6MWhixkl48XiAIYtTD+DbTIO3iJWu0d6bxubk6r5AuZ91IK2WKgZxNkmUuV4THbc/ek7ZlZmJUr3x5ozp37obWAdI5CZsb4QBhvHDhts4D0njoULONUIoOJXQjWYiDLkVfQlJxP175UpbIhVDIm9yTenGNfq1vnKMuXbpj9bNJXKQ8hHIu5ZhlSxxCKR8eOOhVPJpYAgm9SzzCZGQw0+PcxKkzDnpCmSbBHPjMCNuyQvQN2mzmBeFHP8lLBshq6kHwsHhJky4LdSAtPLhOzGPZrCyFRdvf3HnEhi2zXp7z+UAMEAN+YiAlktVv4HCLYMkPEtc2zE5IsrhEkKD2E9Ssi3gLAgaEZM2Zt0wboiA1plxCrsSIFeNc8omhD6NSPAnidRIygKWAI0cX28qVOkyPl9wzQxi1MF7Fc5MtkiXfK8HYxjLC5nfvfkcm9UImMaohD0gWNo0QA3ztum1W+xCPQ9ohMsO43rvvlEXQYHQ7jXHJIwRF9C33EYqsQl4SlQ8yu//AaS0T+gjtA9FFWU5Z5RrtQvuETOK+9KvIhhBlozzJZ5ZtpkNdaCuWOiIt9Iu0QrbM77ukrHgymPowdWL2g6RBvb37DtIH7qEd0m/oDxxyLXiGZ0xIEXSANCIrxgLKiYcHc4mr6EF0L+TVxJbIypDPBWKAGPAbAymRLHyTlepBgkVQ+w1q1kfMBQEDQpbgecI5jE35dkW8UW+/fVbvqAfjV4x+eB9wDYMf7RBvgWk4wlsgRjXSwsjEG3xsTiBtlzpML4PEIRQCAdncrs20yZyLwYvQTC9GtrQdoRj7IIJIK0a1achjKSTSIb8QJskn5cNYR7z5HZV46MRgl7QSipyib7mPUOJ27Tqq5UqmfNGz6FHKc8oq1+YSz6PHLug2ihdH6jd1KPmkXFNOSSeYwfI9SQedOMm5lBVPBskvofSN1CX33cJVq1/V7cHSS4mXZZiCZ2njzl3HrDTS12fOXNP3pE4TDwtfXKXLljYCO+h7vHAQfKBOeXkxoaTKKl9kMcMBA4fpMXD/gy3vSTd+YqUqn1x/z30zP8/5nCEGiIFEGMgqyeISQQIwEQAZT4zkKwaEZDU0ztXLtmDgiuEvu8NhGZ94lMToFxICAxm6Ee+K5BV9wbCc+vw829Is1AFDF2nE+M81yRJ5zVB0AxlxX4xqED8zHWRHmySdkASkEcNcvBjw3uA4fuKyziNGvVkezsXIF32b8RIHkpVs+aLnZEmWWZ+0WwiM1C/XSGu2WfI604GAI514iySdYEe8P25lOWWQvBImipd0sUIh86LvWLKaHjGp08SD9IfoWcYNSJb0PULxlEqbY8nVs/dA1bR2q4Kn2SRaIFe4D6IVKy/v87lFDBADyWAgaySLHiwCMBkAMg1xkq8YECIBQxHECW/d8ZYd7QUxuHz5E30uBrMYoYiHh0uMZqRDXvEEuekLm17Am4F0yIdvu4KyXBDf3+BbIfGqiKGPUMiTm1GNdooOa+tnal1JXsSJ8Y6lZtjtznm8vnW/q5Hspm/RqZASpEm2/CCQLNGT6FPaI21FiHum/iSN6F7SyH0JTZ3IvXih86cFpE7BdyxZzTJFJpNkOfUsbbs7lu7t/2XL17n2v1kPvFkm0RKCRS8Wn0smTnhOPKSLgayQLHqwCMh0Acl8xE6+YECMSTEUhTjJ0i7ZcEKMRTFC0X4x8KUMM06+1Xl++gv3GJGy25t4s+TbrXgbX8jSLrPOdPpA2mEa6/C2yfc3aG/h2En6+x2nh8rNqIYMznRisCMOy8FwHctTF6sNIqepU6SFrCC0KBMeoWTLdxr/Uq8pK+45r3FP2i06E9nkOlY+Z7pY3iEhSOLVSUYGkV9CeFCRz+3HlWUpq/QB6kFafH8HnMI7tXDR3WV+om+UgzROr5vUh1D0ImMH95x6Frlk+aCZP5VzIVrYNh+EiwSLz6BU8MO0xEs8DHhOsujBIuDiAY5xxEdUMCAESQxFEB0Yl+Jtcm52IEYo9AOD3/T8mCRJNtIAeTG/RUIeqVOWForRi/tm2tLyOi0HZBE5skGyZLdEMcKlbUJmxPMiRrX5DY4sD4OMaBvyQn84pBzRkehY7sObgnO3QwiKU9/yLZd8+2b2Qbzynca/1GnKinvOa9yTdgupEtnk2sxnejKd6eTaJBzxvskSGd1kMONwjnpj6VlIvbwwkBcJ8o0Z8su3VKJvkRUEUOoCBqEf4BT3RC+m3p16ljzAB7AiZaHdzt0MJS5WKESLBMt9zMTSG+9TX8RAfAx4SrJIsOIrm2CkfoiB6GBACI9pKAq5EEMeeBCjU4xQwYh4IWDgCsmQODFCsVQOP6aLHdrEEAb5kvQI4/0YsXi8UC7khKGLcsxvXOQ80Y8KSzsQipyyTBLlnjh5xSYn7jlJFu45d5wzy0M8DilfZMY9px6qa+xb5ksekVO+5Yn3Y8TJlO80/qUep6zOa6STfpQ2imxyjTTYDAJ58a3RipUbddud6dDPshEK9Ic+EzyYZCYZGUR+MzT1gB8jdupMCKB8awhcQobTpz/QsqNewTfSinfT2deox9SLXOOem55FDyBa8JDhQN24fnrQcAsnZlt4Hp05mH3Nvs41BjwjWVwiSDDnGsysnxgMEgbcSJYYofBGiaxiKIoRKvfFsJXlfHJfQue3LzCqsV03vs+SNBLCmwDjGMYuDFAJzTf+Up8Y4s7QNHilXDOUdiA078NrJr9jBQN4w8Y3leyqJ2UK2Zg9Z4m1tTnSOssSmczy8TtWpjGPc9wz05jnIqeUhRC6wX033SUq3834R31SvtTtvMZ9abe0U2STa6TBskUhTNhBEvfc0sGDk8zvZEEOkclNBjPOPMfOlSBXgh8QJSfeQPYgI/oO9YBE4beucC5eKpTp/J0s4MP0foleBB/IE0vPGAeCL8gGGc1dNs028JzPCGKAGPATA56QLBIsgtZP0LIu4i0KGJClWFhy53V7Qa7EWN786m7Py/daXpbHMU8MEAPEADEQNgxkTLK4RJCgDxvoKS8xG2QMYEmYeJ3MZYVey4zf2sISPvNbLa/rYHkca8QAMUAMEANRxUBGJIseLA6cqA4ctpvYzxYG8BtNstSKBIg4yxbOWC6xRQwQA8RAdjGQNskiwcpuxxD41C8xQAwQA8QAMUAMEAPEADEQTgykRbK4RDCcnc1Byn4jBogBYoAYIAaIAWKAGCAGso+BlEkWPVjZ7xQCnzomBogBYoAYIAaIAWKAGCAGwouBlEgWPVjh7WgOUvYdMUAMEAPEADFADBADxAAx4A8GkiZZJFj+dAiBTz0TA8QAMUAMEAPEADFADBAD4cZAUiSLBCvcncxByv4jBogBYoAYIAaIAWKAGCAG/MNAQpLFb7D86wwCn7omBogBYoAYIAaIAWKAGCAGwo+BuCSLHqzwdzAHKfuQGCAGiAFigBggBogBYoAY8BcDMUkWCZa/HUHgU9/EADFADBADxAAxQAwQA8RAfmDAlWRxiWB+dC4HKfuRGCAGiAFigBggBogBYoAY8B8DriSLHeF/R1Dn1DkxQAwQA8QAMUAMEAPEADGQHxggyfphfnQkByT7kRggBogBYoAYIAaIAWKAGAgGBkiySLIUB2MwBiP7gf1ADBADxAAxQAwQA8RAfmCAJIskiySLGCAGiAFigBggBogBYoAYIAY8xABJlofK5JuH/HjzwH5kPxIDxAAxQAwQA8QAMUAMZIIBkiySLL61IAaIAWKAGCAGiAFigBggBogBDzFAkuWhMjNhu8zLtyXEADFADBADxAAxQAwQA8RAfmCAJIski28tiAFigBggBogBYoAYIAaIAWLAQwyQZHmoTL55yI83D+xH9iMxQAwQA8QAMUAMEAPEQCYYIMkiyeJbC2KAGCAGiAFigBggBogBYoAY8BADJFkeKjMTtsu8fFtCDBADxAAxQAwQA8QAMUAM5AcGSLJIsvjWghggBogBYoAYIAaIAWKAGCAGPMQASZaHyuSbh/x488B+ZD8SA8QAMUAMEAPEADFADGSCAZIskiy+tSAGiAFigBggBogBYoAYIAaIAQ8xQJLloTIzYbvMy7clxAAxQAwQA8QAMUAMEAPEQH5ggCSLJItvLYgBYoAYIAaIAWKAGCAGiAFiwEMMkGR5qEy+eciPNw/sR/YjMUAMEAPEADFADBADxEAmGPCEZK1p2qKuX/9c3b79tbp69TNV3zjHxoR37zmu4xAvB/KI4DNmLrLlr66dbsUhTaJ4KYchBwMxQAwQA8QAMUAMEAPEADFADPiJATeukjHJWrX6VU2sRo4u1sRo4YurNJHqP3CYRZQOHmpWr6x5TfXuO8g62rbvrOPHFZfr9BWVjfp61pyl6tatr1SvPoOSivdTgayLA5YYIAaIAWKAGCAGiAFigBggBgQDsbhMxiTrzJlrCkRLKkJ4+fInauq0Bda95uabtmsz7abNbymQMPPe+Qu31PwFK/S9RPFmPp4T8MQAMUAMEAPEADFADBADxAAx4BcGYnGVjEmWswEPtHhUe6ImlFRZxAlLBM+du6E9VjdvfqnMpYJYSrh23TYrLcrbt/+UlSZRvLN+XnNQEQPEADFADBADxAAxQAwQA8SAHxiIxVU8J1lgcydOXLZIU+u2nbSnCssAsVxQlhPOmbdMp4FgJumCMsx75rkoyu2exDHkgCIGiAFigBggBogBYoAYIAaIAT8w4MZLcM9TkrV02Vr9fVbnbr0skuXWuDd2HLKWCMYSTIhXoni38h9p9bjq3XdAoI4BA59VJZPKAyVT0HQUFXmeHTJcjSueSCwEbIzmAn8jC8aoUQVjiYVvsDCySze1+Tt/HEl9jC0ar4YOHxXJtudi7AW5TtgKg54dSixE/BlBu9F/O/6JDp1jjjs3viH3YnEVz0gWvsHChhWjCibEJVgQCAQK32nhHIJ5vVzwh/c9qB58+NFAHa0eb6cnzaDJRXn8x0m79k+qPv2eDhQ+iQP/cQCdd+nWU3Xr3otY+Ga+7nr/g2rd7//vSOqjZ+9+qkOnrpFsO+cf+/wDgvVYm/bEQsDsOL9xSrvRPi780P/9Dz4Sc9wJoXILY3EZT0jW2KIyhW+tEDornzd/uTpy9LztvvmBmHkuefNx4wt0HN6cSRsZRteFDU9r16fie3uJj2jgo237Tgpvztjfd/u73ff/XDX9r/8nkvp4smt31ap1u0i2nfi3z3ewFWBQUi92vURNH7Qbw9P/sbhMxiQLnit4sMzdBM2BgK3cEY9vsnB//MQqfS3fZDm3PcQ3W0jfrkMXnT5RvFlXkM85WMIzWLKNI5IsYkEwRpJlxwJJFkmWjI0ohyRZ9nkhqlig3RgeHMTiKhmTLLjI5AeGzVCWA2JwlJbXqUuX7uh0+NHil1ast72hMX/AC+mQ3hxUieLNtEE952AJz2DJNoZIsogFwRhJlh0LJFkkWTI2ohySZNnnhahigXZjuHDgxlUyJllRBX+q7eZgCddgSbV/U0lPkkUsCF5IsuxYIMkiyZKxEeWQJMs+L0QVC7Qbw48Dkqwf+tOJHCz+6DkMkzFJFrEgOCXJsmOBJIskS8ZGlEOSLPu8EFUs0G4MPw5IskiybEszozqZ+dlukqzwT5xe4YUky44FkiySLK/GVpjLIcmyzwth7stMZCfJCj8OSLJIskiyfMKATLYkWeGfOKUvMw1JsuxYIMkiycp0TOVDfpIs+7yQD32aThtIssKPA5IsnwxsDpbwD5Z0Jkm3PCRZxILggiTLjgWSLJIsGRtRDkmy7PNCVLFAuzH8OCDJIsmiJ8snDMiDgiQr/BOn9GWmIUmWHQskWSRZmY6pfMhPkmWfF/KhT9NpA0lW+HFAkuWTgc3BEv7Bks4k6ZaHJItYEFyQZNmxQJJFkiVjI8ohSZZ9XogqFmg3hh8HJFkkWfRk+YQBeVCQZIV/4pS+zDQkybJjgSSLJCvTMZUP+Umy7PNCPvRpOm0gyQo/DkiyfDKwOVjCP1jSmSTd8pBkEQuCC5IsOxZIskiyZGxEOSTJss8LUcUC7cbw44AkiySLniyfMCAPCpKs8E+c0peZhiRZdiyQZJFkZTqm8iE/SZZ9XsiHPk2nDSRZ4ccBSZZPBjYHS/gHSzqTpFsekixiQXBBkmXHAkkWSZaMjSiHJFn2eSGqWKDdGH4ckGSRZNGT5RMG5EFBkhX+iVP6MtOQJMuOBZIskqxMx1Q+5CfJss8L+dCn6bSBJCv8OCDJ8snA5mAJ/2BJZ5J0y0OSRSwILkiy7FggySLJkrER5ZAkyz4vRBULtBvDjwOSLJIserJ8woA8KEiywj9xSl9mGpJk2bFAkkWSlemYyof8JFn2eSEf+jSdNpBkhR8HnpCsNU1b1PXrn6vbt79WV69+puob59gM9xkzF9niq2unexqfDnj9zsPBEv7B4hVmSLKIBcFS1EnWfT/5iXq81QNqYM+HVYd2DyqSLJIsGRtRDkmy+IwA/mk3hh8HGZOsVatf1cRq5OhiTZwWvrhKk63+A4fp63HF5fq6orJRX8+as1TduvWV6tVnkCfxYZmIOVjCP1i8whpJFrEgWIoyyQKpapzQSi2pfdw6VhY9rF79o/+tnw2io6iET3btrlq1JsmKSn/HaydJFp8RwAftxvDjIGOSdebMNQWiZU4Yly9/oqZOW6Dvbdr8ljp4qNkWf/7CLTV/wQpP4s16g3zOwRL+weIVvkiyiAXBUlRJ1sMPP6AWVLW2yJUQLZCsXX/6B6p3txa2Z4boK59DkizOC4JvkixiAVig3Rh+HGRMsmRSkPCBFo9qT9WEkir9kNy957hau26b7YG5b/8phSWGyJNpvNQb9JCDJfyDxSuMkWQRC4KlqJKs8lGPaoIFogVChWWD8GxNf+ZBTbJwH/dET1EISbI4LwjOSbKIBWCBdmP4ceA5yYLn6sSJy9bDESRKCJVMIOY98zydeMljhsP7P6Juv/VkoI6Pd3dWP9//VKBkCpqOoiLPnd1d1M/2EQtR6e947fx0bzeFI16afIz76nAX9csjXdQv9ne2tf3Gqjbq5IN/qOM+2RusOTzb/YA54ZM9XW36yHadLD+YGIOtcGdPF2IhYHac3+OFdqO/43PHi94v1/aUZC1dtlZ/n9W5W6+ckqz5VR3UP57rxoM6IAaIAWIgRBj4zdYn1NkWf8g+C1Gf8VlLW4MYIAbyAQM3d3ZXT3TobPEX03mT7rlnJAvfYGFDi1EFE2wCZrocMFF+t4a3fuwhtXNJx0Adu5c/qY6s6xMomYKmo6jIs3dlV3WoqRexELAxmgv8HVjVXb29unvksHDl9c7q2vbO6t2NT9rafmjG4+rY/X+o4w6v7mSLy0X/+FnnwTU91b6Xu0WqzX7qN0x1wVbY81JnYiHizwjajf7a8XMq2+klmm68Ipl7bjupe0KyxhaVqZs3v1QInYLkYuOLR1s+oPp1bxGoY1CfVqq8uG+gZAqajqIiz/CB7dTEwh7EQsDGaC7wVzj0STV2eOfIYWHapMfUq/Pa6QPn44Y8ohrGt1KbJrdUe3/wf9Sa6W3UoN4PR0ovxaOeUiOeeSJSbc7FmAtDnbAVBvdrTSxE/BlBu9FfO/6pJx+6h8M4OU2s61g7qWdMsuC5ggdLdhN0CuCsGFu8I327Dl10YzKNd9aHa5Isf4EZhodWkGQkySI+BY9RJVkgUCuee9wiWkK4Xp/SUu39/h9o0iU6ikpIksV5QbBOkkUsAAskWf7iIBOSFcuhlDHJwnI+/Aix82huvmkxQtOFdunSHVVaXmfFgRRlGu8kWiRZ/gJTHgwMk9M7SVZyeooCnqJKsqRvTY/W+tlt1crih9WWP/79SL7BJ8nivCDjgiSLWAAWSLL8xUEmJCvWp00ZkywnwQnCNUmWv8CUBwPD5PROkpWcnqKAp6iTLOnjYf0f0csDR3e4T23+I5Is0QvDaM4VJFnR7HfneCfJ8hcHmZIst53USbJ8WvPLweLvYHFOVkG6JskiFgSPJFl2LJBk8ZssGRtRDkmy7PNCVLFAu9FfHAjJwu/UuR3xnEjwZJFk+USo3CYEDhZ/B4tbHwTlHkkWsSBYJMmyY4EkiyRLxkaUQ5Is+7wQVSzQbvQXB0KyHnz4UeV2JCJZa9dts30KtW//KUVPlk/Ei4PF38ES5EmZJItYEHySZNmxQJJFkiVjI8ohSZZ9XogqFmg3+osDIVnxyFSsuKxtfBGrwlze5zdZ/gIzqhNguu0mySI+BTskWXYskGSRZMnYiHJIkmWfF6KKBZIsf3GQCcmKtVM6PVn0ZEVyJ69cTtokWf5OnLns60R1k2TZsUCSRZKVaMxEIZ4kyz4vRKHP3dpIkuUvDjIhWXAsue2UTpJFkkWS5RMGZBIlyfJ34hS9BzEkybJjgSSLJCuI49RvmUiy7POC3/oPSn0kWf7iIFOS5baCjyTLJwObg8XfwRKUSdJNDpIsYkFwQZJlxwJJFkmWjI0ohyRZ9nkhqlig3egvDkiyfni/becON9aIe/wmy19gRnUCTLfdJFnEp2CHJMuOBZIskiwZG1EOSbLs80JUsUCS5S8OSLJIsri0zyfPYzYndZIsfyfObPZlpmWTZNmxQJJFkpXpmMqH/CRZ9nkhH/o0nTaQZPmLA5IskiySLJIsYiAPMCAPXJIs+0OUJIskS8ZGlEOSLPu8EFUskGT5iwOSLJIsGth5YGDTk+XvxBnkBzRJlh0LJFkkWUEer37JRpJlnxf80nvQ6iHJ8hcHJFkkWSRZJFnEQB5gQB7mJFn2hyhJFkmWjI0ohyRZ9nkhqlggyfIXByRZJFk0sPPAwKYny9+JM8gPaJIsOxZIskiygjxe/ZKNJMs+L/il96DVQ5LlLw4CS7IKx05Sa5q2qHfPf6hD565/u/ccV7dvf207kF7SmT/gdfXqZ6q6droVhzSJ4qUcCbm7oL/ADNrE5Lc8oxonq9HTa5I+iuc9pyqWzEk6fSple5V2SNGzJPQ+EHqSLPtcRZJFkuX3/B3E+kiy7PNCEPvID5lIsvzFQSBJ1tRpC9T165+rDRvfVJcvf+JKsg4ealavrHlN9e47yDratu+sidS44nJNvioqG/X1rDlL1a1bX6lefQYlFS/EygxJsvwFph+TTVDrKF71snru09/m5VG8cjmJVhhW3vMAACAASURBVJaJFkmWfa4iySLJCupc76dcJFn2ecFP3QepLpIsf3EQSJL1QItHLa9Tc/NNV5KF+yBjJhGS802b31IgYXKN8PyFW2r+ghX6XqJ4M5+ck2T5C8wgTUp+y1J55FReEiwhjlUnzqth5QUkW1kiWyRZ9rmKJIsky+85PIj1kWTZ54Ug9pEfMpFk+YuDQJIsITYIY5EsLBU8d+6G9ljdvPmljYhhKeHaddtsJGvf/lNWmkTxZv1yTpLlLzD9mGyCWkfDh19oklWyebMaVjIiqWNsVZEqm1aRVNpky/Qy3cj6clXx9lEbeRzftJpEKwtEiyTLPleRZJFkBXWu91Mukiz7vOCn7oNUF0mWvzgIJclq3baT9lRhGSCWCy58cZUmW3PmLdPECiTK/D4LRMm8Z54LiXK7J3EISbL8BWaQJiU/ZXl2dF+LiIxdOFsNKR6c1FFYMVqVNZYklTbZMrORrmjFUlV/43OrjdXnrqhRU6vVwGefDOzhZ/97URdJln2uIskiyfJiXIW9DJIs+7wQ9v5MV36SLH9xEEqSZZIfOX9jxyFriaAbYTLvmeeS3+2exCF8slMbhUkqSEdVyUA17/miQMkUJP2EUZYpS+daBKTqhamqclp5Ukf93Bo1c8m0pNImW2a20lXNa1R1R09Y7ZRlhEENqzc0hWqMTa0eoZ6vGRkqmbM5VhuGdFHbvvedSOpjZn2Bapg8NJJtzyamwlg2bIXq0kHEQsDsOL+xRLvRXzt+wph+6okOd/eLMDlFJue/993vfV+ZR4uWbWxL91IpPNZyQWcZ8FwhLe6DMHm9XLD1Yw+pwf1aB+oY+Ux7PWkGTS7Kkz5OStau0eSj/trP1ajSkUkfxdVFqnJaRdLpUyk7W2knrlii6j/4NMBk63dattoL1wM17hONrwkFPVTJmJ6hkjlRmzKJL+7SQr32nT+IpD7KivqqscO7RLLtmWAmH/OCYI16tgOxEDA7zm+s0W5M3z5Lp6/69Wit7n/wkbQ5kJPr4DrrJGve/OXqyNHzNqHNzSzMcxGQG1/46yJN15Ud9Xzl+w5rw77y6OmUlv6FZbmgcwni8Emj1NhFcwN5lL65yyKA/fs+Hprvx7hc0D7XcbkglwtG/bmC9sNjAiORurDPD1HTB5cL+tv/oVwu2H/gML0lO77JAokaP7FKX8s3Wc4t3PHNFrZwb9ehi06fKF6ImRnymyx/gRm1iU/aW/f+J9qwL9nyeiRIlpN0Bem6cFajRbKGFA8JjXFCkmWfq0iySLJkfo1ySJJlnxeiigWSLH9xEEqSBfJTWl6nLl26oze8wG9qvbRivc2zZf7YMNIhvUmaEsWbaXFOkuUvMKM4AT4z9CnLqB+3dCFJVpKbfmSLmGGbeflObPSMepKsLOyE6Mc4J8kiyfIDZ0GvgySLNgwwSpLlLw4CT7KcZCdX1yRZ/gIz6A+sbMg3oqbEMupH1ZeTZOWYZIG81b1/R/fJhDWrSLJIskKDAZmfikc9pUY8Q5Il+ohySJJFGwb4J8nyFwckWT+83+bhikXiSLL8BWYUH4ZFy5dog77hwy9TIlggA2H9JitbXiivyq08ekb3ScXet0NjYHO5oH2uoieLJCuKzxNnm0my7POCUz9RuSbJ8hcHJFkkWaExHvN9EizbuUcb9FNOXiDJCoAXC0Rt0tbtuk9qL34YmnFCkmV/iJJkkWTl+7MjmfaRZNnnhWR0lo9pSLL8xQFJFklWaIzHfJzwzDbVXLiuDfqy7TtJsgJCsopWLtN9gm+zBvRvG4qxQpJlf4iSZJFkmfNsVM9JsuzzQlRxQJLlLw4yJVnm/hFXr36mqmune7uFe6zle37f53JBf4EZtQlw4NPtLWO+eOUykqyAkKyCGXVWvwwtGUGSFcLvskiySLKi9jxxay9JFm0Y4IIky18cZEKynDuhY0d17JTu6e9k+U2mYtVHkuUvMN0eEvl8b3h5oWXMj3q+miQrICRrWOkoq18KZz1HkkWSFQoMyFzJjS/43BIskGQRC8ACSZa/OMiEZMX6zV+SLJ8MEQ4WfweLPKyyEY5dOPeuMX/n12ro+CEkWQEhWfguq/bybd03E9atDYWBzeWC9nmBnix6srIxZ4etTJIs+7wQtv7zSl7ajf7iIBOStXvPcbV23Tbb5nz79p+iJ8urwZCoHA4WfwdLov7IJH7S63c3WKg++37KBAtEgLsLDk5Lb8nsQlh5+IQmWRUHjpBk+fQCKZOx5MxLkkWS5cREFK9JsvLHXsgEv7Qb/cWBkKzefQcotyPW6jncB8la07TFRrJwj54snwwRDhZ/B0smE1uivFPOXNSGfNlb+9IiCyRZ2SNZJVte131Td+Vjkiyf5rZE4yWVeJIskqxU8JKvaUmy8sdeyASjtBv9xYGQrAcfflS5HSRZ3+w+yG+y/AVmJpNI2PIO6P2YNuKxgx1+9DYZ74ozDUlW9kiW/H4Z+mfgwI6BJ1pcLmifq0iySLLC9kzIhrwkWfZ5IRs6DkOZJFn+4kBIVjwyFSuOywVz/FaXg8XfwZKtCXTohGEWySqc1UiSFaDvsUBmR02rtvpnaOlokqwcz3upjkOSLJKsVDGTj+lJsvLDXsgUm7Qb/cVBJiSLG1/k2NjgYPF3sGQ6ucXKXzhnmmXEYzc7p5cqmWt6srLnyRpaMtzqn8J500iycjzvxRpHse6TZJFkxcJGlO6TZOWHvZApZmk3+ouDTEiWcwv3hS+u4hbumQ6AVPJzsPg7WFLpm1TSTty4URvxNe/dTItggYSRZGWPZEG/NRdv6j6auGE9SRZJVuAxIPMPt3DPj2eE9GcmIUkWsQD80G70FweZkCwsIzR/jPjSpTuqtLyOG19kMhGmkpeDxd/BkkrfpJK28tgZbcBX7D9CkhWwpYLiRZx88Jjuo8kHjwfewOY3WfZ5gZ4serJSmY/zNS1Jln1eyNd+TtQu2o3+4iBTkuX2vRZ3F/TpTS8Hi7+DJdHklW58w0d/qQ34CT9dT5IVUJJVsvlV3Uf1H3xKkuXT/JbueHLmI8kiyXJiIorXJFn5YS9kil3ajf7iILAkq3DsJL0//LvnP7xnn3inC+3q1c9Ude10217ypostnXgne+Tugv4CM9OJJCz5BxcO0MY7dq4bM38mSVZASVbRkkVWPw18pnOgiRY9Wfa5iiSLJCssz4NsykmSZZ8XsqnrIJdNkuUvDgJJsqZOW6CuX/9cbdj4prp8+ZN7SJbzY7BZc5bqj8F69RmkiVam8U6ChWuSLH+BGeRJykvZRk+rsYz3EVXjSLICSrJGNU62+mlYxRiSrBB5s0iySLK8nLPDWhZJFm0YYJcky18cBJJkPdDiUcsr1dx88x6SFWtbw/kLVuh8mcaTZPkLwrA+tLyQe3zTK9p4r3//k7QJFje+yO6mF9Dv0PFDVeOnv9F9NXbBLJIskqxAY0DmJm58wWeZYIEki1gAFkiy/MVBIEmWSXLcSFasH+ha07RFk6xM48365ZyeLH+BKQ+GfA8r3r67oULl4ZMkWQH1YsnmFzXnr2mSVbJ5U6ANbC4XtM9V9GTRk5Xvz5Fk2keSZZ8XktFZPqYhyfIXB6ElWUKohASBWMk98zydeMljhk92aqMwSQXpqCoZqOY9XxQomYKknzDI0nj9M2241771lqqcVp72UT+3Rs1cMi3t/JnUHZW8de+c0n1Vd/p8oMfc1OoR6vmakYGW0c+x2TCki9r2ve9EUh8z6wtUw+ShkWy7nxgLQ12wFapLBxELAbPj/MYO7UZ/7fgJY/qpJzp0tlbnmbwi3XNPdxeM5ckSQiVCmsTKPE8nXvKYYevHHlKD+7UO1DHymfZ60gyaXJQnOZyMHNNfG+3Y9GL88kVqVOnItI/i6iJVOa0i7fyZ1B2VvKWvvqb7q+HGLwI1DzjH24SCHqpkTM9Ay+iUOZvXxV1aqNe+8weR1EdZUV81dniXSLY9m5gKY9kgWKOe7UAsBMyO8xtLtBuTs8+86pd+PVqr+x98JHwka+26bTah9+0/ZfNkZRJvkis553JBf12s+eimd7ZpZF25RbJG1k7icsGALxccu3i+1V+Dhj0V2CWDXC5on6u4XJDLBZ1zbxSv4TGB4RjFtrPN386JXC74rS78wEUolwtmurFFovxCrMyQJMtfYPoB/lzXUbximTba6298nhHB4sYX2d/4Ajoe1VBhkawRleMDa6yQZNnnKpIskqxcz/VBqJ8kyz4vBKFPciEDSZa/OAglyXJu0b7wxVV6C/d2Hbpo71am8Sa5knOSLH+BmYvJx+86y97ap432KcebSbIC7sWSzS8aP/6l7rNxi+aRZIVkh0GSLJIsv+f2INZHkkUbBrgkyfIXB6EkWSA+5o8NX7p0R5WW19mWD2YaL+RKQpIsf4EZxIdUPJkG9G6lBhcNTumou/KxNthLt71BkhUSklXTfFX3WclrW0iySLICiwGZq7iFO59bggWSLGIBWCDJ8hcHgSdZQnJyHZJk+QtMeTCEIXz66SdU9TfGNzaxSOr45Nt0RS8tIckKCcmq2Pu27t+q42cDa2BzuaB9rqIni56sMDxHsi0jSZZ9Xsi2voNaPkmWvzggyfrh/TYPWCwyR5LlLzCDOkG5yTWq4dsNLJIiWAYRq738kRpRVUySFRKSNXH9ek2yGm59QZJFT1ZgMSDzFD1ZfG4JFkiyiAVggSTLXxyQZJFkBd5QkIdEUMOi5Uu04d344Zdq9LSalI5hJSMyJljc+MKfjS+g57EL51qeymdH9gzk2KEny/4QpSeLnqygPjv8lIskyz4v+Kn7INVFkuUvDkiySLICaSgGaVJKJEvZG7u04T3l9HueECbZZCGVsLBitCprLMlZ/anIGua02GpfvJUja0sCOXZIsuwPUZIskqxEc3gU4kmy7PNCFPrcrY0kWf7igCSLJCuQhqLb5BDUe1POXNaGd9muPTkjOSRZ/nmzGj/6Svf3uMULAzl2SLLsD1GSLJKsoD47/JSLJMs+L/ip+yDVRZLlLw5IskiyAmkoBmlSiidL/x6PqOc++Y02uic0vUKSFZJvqzLxplWfvaT7e9LW7YEcOyRZ9ocoSRZJVrw5PCpxJFn2eSEq/e5sJ0mWvzggySLJCqSh6JwYgno9eMzT2uDGErLCedNJsiJAssp3H9B9PuXkhUCOHZIs+0OUJIskK6jPDz/lIsmyzwt+6j5IdZFk+YsDkiySrEAaikGalOLJMvq5SotkebFLYLoeFi4X9G+54IR1a3Wf44eJ42EjV3EkWfaHKEkWSVauxmKQ6iXJss8LQeobP2UhyfIXByRZJFmBNBT9nHQyqato5XJtcNdf+0XOvFggZiRZ/pGsMQtm6T6f+ulvVcXegwobnyR7jF+9KuvjjSTL/hAlySLJymSOz5e8JFn2eSFf+jXVdpBk+YuDTEnWjJmL1PXrn6vbt79WV69+pqprp6vf++73vq/Mo0XLNkn9FlWs36gKwn3+Tpa/wEx14shV+rJdu7XBXXX8XZKsCCwVBKEdWT1R97nsMphqWDDruawSLZIs+1xFkkWSlavnQ5DqJcmyzwtB6hs/ZSHJ8hcHmZCsccXlmlxVVDZqDjVrzlJ169ZXJFl+DRgOFn8Hi1u/Vjd/oA3u0h27SLIiQrJAtMavWqmqTpxL6Wi8/UuNlYnrN5Bk+fhDxiRZJFluc3fU7pFk5d5eCALmaDf6i4NMSNamzW+pg4eabU6q8xdukWT5NZA4WPwdLM5+HdC7leXRKF69iiQrQiQrnW/nKg4c1XipPHKGJIskK6sYkLmqeNRTasQzJFmijyiHJFm5tReCgj3ajf7iIBOStXvPcbV23TYbydq3/xRJll+DiYPF38Hi7NchRc9aJKtw9lSSLJKsuBiYuGG9xkvjrS+zamBzuaB9XqAniyTLOXdH8Zokyz4vRBEDaDPtRn9xkCnJWtO0xUayQLz4TZZPb2k5WPwdLM5JefT0WotkDa8YE9fATsfzkUoebnzh38YXqfSLmXbsNxtm4BuuZwv6Z41okWTZ5wWSLJIs59wdxWuSLPu8EEUMoM20G/3FgZCsJ7t2V25HvD0nQKhyRrKmTlugPwjDjhtyNDfftBjfwGdGqHPnbui4mze/VK9v3WfFoVGdu/VShw4163h8SIbzB1o8aktjNp4bX/gLzDBMgONXv6xJVt0HP8spwYIhT5IVfJKFLf5lk4xRU6eQZPn0MookiyQrDM+TbMtIkkUbhiTLfwwIyWrVup1yO0ye4TzP6XLB+QtWqJOn3le9+w6yjqd69rdI0sWLH6vXtuzRxKlv/8F668NFi1db8W+/fVZ/UNbysbaqbfvO6syZa/cQMbPBJFn+gzPbD51Myy/fvV8bzZXHzpJkcalgUhgAIQfRGv9K9rZypyfLPleRZJFkZTrX50N+kiz7vJAPfZpOG+jJ8hcHQrJMPpHseU43voALDSzPTdgJJVXaQ9WuQxcrHh+PyS4duA/vF9JJfuxFf/nyJ9a13JeQJMtfYKYzefidp/a9G9pgLn3jzaQMbHPpmNfn9GQF35OFPq86ckpjpmL/EXqy6MnKGgZkLuTGF3xuCRZIsogFYIEky18cZEKynFu4L3xxlX9buINgXbhwW2EpIAgTlvthCSBIEZYSYptDIUgIQaJkOeHwkUU6j7k8cFTBBH3PzGOek2T5C0x5MAQ1HNCvjTaW4ZUoevklkix6spLCQMmrr2nc1F/9NGsGNj1Z9rmKnix6soL6HPFTLpIs+7zgp+6DVBdJlr84yIRkCXeRHyO+dOmOKi2v82fji5Uvb1Rv7jyilwoWjp2klwNiCSCEAskSQiVEybwnJEviELrdM+NJsvwFZpAmJTdZhk4YZpGsgpkNSRnYXnuvzPLoyQqHJ2vckgUWbgYN654VokWSZZ+rSLJIstzm8KjdI8myzwtR639pL0mWvzjIlGSZPETOc7K7YHXtdO2JwlJAk1CJUOY9N0Lldk/yIuzU4XGFpRdBOiaN7a1m1hcESqYg6SebspQvnW8ZyyXTKlVJ3cScHlXTK9TUFxpyKkOudRCG+kvnPWfhpnROY1bGbk3ZM6quYnBWys7mmMpW2VMGtFdb/78/iqQ+GquGqcqJT0ey7dnCU1jLha1QVtSXWAiYHec3nmg3+mvHFwzrrje8MPlEpuc5IVlCkhCCUHm9XLBN64f1jzrihx2DcowZ1lk1TB4aGHmCohc/5CjfuEEby/VX76ixlYU5P0AwamZPybkcQdBF0GVo/PALjZ3SV1ZmZezCkCor6pOVsv0YW17XUdLjUbXlj/9PJPUBgjWxsEck2+41jsJeHmyFscO7EAsBsuFygSnajf7a8M/0b69atGxt+3wp8CSrW/e+6vLlO+rZoaMtwc3NLsxzaQw3vvDXRSqu6XwNy/cd0oby5COnc75UEMsGuVwwHMsF0VdTTpzX2CnbtYfLBX3Y/ILLBblcMF+fQ6m0i8sFaQMBL1wu6C8OQrtc8MSJy3p3QXMLdvkmC8TK3MJ9yLBC/c3WnHnLLFJmbuHevdcAvYX7ho07rHghZxLymyx/gZnKwyMXaWsvfXTXG7F1G0kWN71ICQPYjRIbptS8d4MkiyQrKxiQORFLkfC2XK4ZRvc5RpIV3b43xz1Jlr84CC3JcvsxYRAuIUXOHyN2/mqyMz820TB3G5RyJCTJ8heY5qQQtPOBA57QRjIM5eIVS1MysM3NKrw8pycrPJ6sohVLLfwMHNjBcwOYG1/Y5yp6skiygvYMyYU8JFn2eSEXfRCEOkmy/MVBaEmWkB+/QpIsf4EZhMkolgzDJo20jOSC6bUkWfRkpYSB0VOnWPgZVjGGJCvL3iySLJKsWHN5lO6TZNGGAd5JsvzFAUnWD++3vF/xCBtJlr/ADPLDr3DOtG+N5EkjUjKwvfRemWXRkxUeTxb6rfHjX2kMjVs0jySLJMtzDMj8yeWCfG4JFkiyiAWSLP8xQJJFkpW1B7xM7vkWTvjpT7WBjO+yTKKTy3OSrHCRrCnnrmgMTdr6hufjL+rLBQcPbqOKanqr8Q191djKXqp8+BNq8x/9vk3PbVr9SP34R99Xf/anf6r+5E/+hAd1QAwQA4HDAOYnzFOYr7yyo+jJ8pdokWSRZHk2eL2aBIJeTsXBY9pArjx4nCSLSwXTwkD5W3s1hqacuez5+IsyyRpT1l2VzX7WdjRU9lRb/+w7amC/VqpH5we10UJiRWJJDBADYcIAyBbmr0ztI5Iskqyklu/FW9qXjTguF/QXmJlOJNnMX/f+J9pALnl1S1oGdjY8XvRkhcuTNf6V1RpD2DxlQJ/WGT84TbxHlWSNHNPJIlfwZBVM7KY9WSBZ237w/2rvFgyVMBlWlJVEgBggBgQDmL/MuT6dc5Isf21ZerLoycp40KYz0MOaZ9CzT1rGcdHyFz0jWUPHD1Ejyoapwikj1bj6AjVh2tiUjoq5E1XdkqqU8qRaB9On1ifx9FW6craFo4kzxqtxxR1jH+M7qqKJT6rxJZ3V+NLOamJFVzWpopsqreqmJrkcdc8PUPXTnnaNc0ufL/caVo5Uz71SoOqWDlOlNU9Z7Z9a0U3t+NF31dOFnUmwuCSMGCAGQo2BHn0etea2RHN36ZSnVFl1d1Vec/eoqO2hqp7rrWYtHK4q6nt4dkxu6KkqG3upKVN7q5rpfVTNjL6qblY/1bB+RuSPgor+njuOfu+73/u+Mo8WLdt4Xkk2vFXxyoQnS4AalLCyobeaOX9Y4ORKXj89VEXd3YEugxQDteq54B7VK2ss43jmrsVq3huNatGe59XSgzPUssOzUj5WHJutVp2ep9Y0L+ARIR288u5iC0fLL76qNp2s4JGBDjaerFCrTtToY92parX23Gy16vxL6pV3l6hNr09Ue1r8qWrd6eFQG1fyNpshPRvEQHQx0LZTi1A8K+beOG8947BiI6rH9A+ueM5/8pJkDS/rFQpg01jLrrG6/NJr1mTxSvNCEqMIESOvifCM23eXnS764CjnlgwIFuY8IVnLz76oFl/ZoZZc2WUdK99aqXY98kP1/R/8GUkWvRjEADEQagxgHguanbfxRLnacLxcbXinXP30aKlaeGm3ZSdFlVxJu6ddu0aSFc+DJXGjqvoEDthBG2iZyLPxZLnacLJcrcdAPV4R2OOFq0f05DHt1idq8f4ZauHu59XcNxrVrNfr1MxXa1I+pm+qVc//dIqqf6VS1b5UoaYsnaQqF05QpXPHq0lzi5M+piwqVY0rqpNOn0rZTJt8P6Siq9rjxzWW6s5dUBMqusY+yruo8ZM6q/GTuqjiiU+qcRM6qbHjO6qx4zq5HpOr+qqqKX1d42LlyYf7NStLVMOBTar+7dfU5I0rVdmq+api82o14+UF6o0H7w+1YUXPRXQ9F+x79r0TA8nO12PGdVSF4zqowrHtVeGY9qqwsL0qGvekqq9/Ro0uaJ+VY8KiBotg1Zw8q8bPKov0Mbx0MEmWEKl4Ybv2j9wFKYAakGNccWfV2PBsYORJWS+FHVRBYXYGerYmkJoTZ/QEUn3suCpqLAzMUTpzgqp5oTIw8gRJN0GVZfLWzRpLjR//Mu2HXUFRV+U8yqc8rSZPefqe+850+XZd9vJsVX/wdVW3b72qaSpTk+cPVZULh6mZLz1HkkXvBUk2MZA3GMjEvhlX1ClrJGtc9VDVeOsL/Vyrv/qxGj9zUuRtEpKsJDe+AMnKBNjZyJvNwZINeROVOa5+tKp+56RquPFzVdq0NHD6hvwNNz7TE8jkHVsDNXmQZAWH8CZL6ia9PE9jCcsKimpHpoT38bMrVP21n1n5ZWlC1MOpH/9CzfzgpJp9Zb91LHxrjdrRqlXeGFjOt9q8pqeDGIgWBhLZUvHis2k3yktoPIdKVswNlI2U7HPZ63QkWSRZKRl38QZvJnFl6166x2CsOX5KjWscEwj50Lax5QMsGcualgVqAiHJCh/JKp5dauFp4pJpSeN8TFlfVf/+x1beqBMrZ/un3vlCTf/whppx44Ka/uFVNe/wCbWj1eMkWfRkEAPEQF5gIBNbK1skS1ZmYD6ueH1joOwjr4lTKuWRZJFkJW3cZTKwY+Utnlqkqk+d+9ZgvPMbVX/51rfXn/5Wla1/OacyiuzFs8stuSYsrA/UJEKSFT6ShYm64drdzS8qtmxIGuNTDt39LhAPs8o9b6ny9S/ZjuotTap2S5PtnjNNPl5POXxEVb9zQlUd2G9r+9QVi9UbDz2UF8YVPRbR8liwv9nfbhgQmySdMBska+LymZZtNOXQ4UDZRqkQomykJckiyUrauEtnQMfLU77xFWtgwmCEq3nCCzV6gFa89lPV+PHXVnz16WZV/Pz4nMmKdpSueVHL03jn14GbREiywkmyqo+f1piqPnYyKWyXbVpjjYnJb7ovWZ08t1RVzS0LHEaz8QAzyyxZNkNhGS+O8leb1KQVc1TpmsXquaUL1faf3EeSRS8GMUAM5AUG4tlVieK8JllFDYWq8ZPf6OdS3XvXVfHUsZF79pjPIed5ZEnWjJmL1PXrn6vbt79WV69+pqprp8fdAaTb0KdV7clzwTrgAWp+L1gyJamjxo++tIzF5z76SpVvbrpnYE6cX6O/0TKXA+WyD+qvfXp3Irl04x5ZnQPL72uSrHCSrMlvbtOYwrd+iR6OExbWWWOm+vipmBiMKsnCmCtbt9wiWkK4nntpidpGkpUXxqXbW33eo7cnahhI9KyIF1+xfoWndqNpy5UsnRbzueS3TRSU+jIlWW5cJfC/kzWuuFyTq4rKRk2sZs1Zqm7d+kr16jMoJtEaPGuWZeCYRj/PM/uRuepj76gJc+Pvile28RVlDuRc63zKkaOBm0hIssJJsrSn5Zsfahxb9WxMojW2arBquPn5XUL2wSd6S9xYD5EokyzoBB6tsg0vq8nbN2uPVu3zlWrrn32XJINeDGKAGMgLDMQjUbHiiqaOOPkFjAAAIABJREFUUzUnjU8zPP6B4PJNawJnF8V6Rvp5PxOSFYurBJ5kbdr8ljp4qNlGqM5fuKXmL1hhu2du6d6pX1eFtaZBOqqPHFHPnTwVKJlS0U/5hpeTHpTj51Soyr17ct/Wt99Wxc8XJS23X4OZJCucJGvC/CnWyxt4qmI9IGveOWWlm7RyXlz8RZ1kOcdc1YSBJFlZMq5//OP71I4dB9WNG1/oF5cXL36sSkom2wzZadPm2VaN4Nr0PPTvP0idPn1V58fKkoMHz6qOHZ+00jz0UAu1e/c7+kUo4i9c+OieOszy5HzQoCFq2bImXTbKl/sSot6zZ6/peiE/2oH2SLxbmEhWyOd2nDt3I2a5ieRs3bqNmjy5TsuHVTeNjbNilgWZk+kT9BH0CFnxgjlR29Ef6BdJ7+wj1Juon930yXvpeSFjPSdi3S/fsNp6fuAldeONzzy1pdxWIjnn4aheZ0KyYnGVwJOs3XuOq7XrttkI1b79p9Sapi22eybJ6tizU1zDJhcAmvj8WNWwuDpwcuVCF1GvkyQrnCQLuG38xkMFj63bQ7Ji293f08LDcfLWxLs2kWTZsUCSlZ4hl4wBvHPnYW14r1+/Tc2YsUAb7jDa+/QZoIlARUWtjj9w4LSOP3LkvL4uLByv40Egrl79uT4WLFiuSRHyHz9+0SISyIt7IExmHd2797bSOGUFEQEhAClBXifJARGRelEm5Ed6hM6y5DoZWVGWecyevUiXu337AddyE8mJuiE72oC2QMZEJCtRnwwZMlKXB5Jltn3r1r2uMkIG9AdkMPsI/SK6SdTPko6hN2PR7Tnhdq94xiRVc/Y9i2A13v6lmvzaOtqNPv7GaSYkKxZXCQXJchIqNMZ5jyTLbqxEncgEuf0kWeHFas2Z8/ohWHvxul7mhqVuckx5+23rAVl1OLllqiRZdiyQZHlj2DkNZJAOGP27dx+zjG14M0wiAMMd1+IhAjHC9caNO3SeuXOX2NKjjr17j+t7Ut+lSx+rLVv2xKxD0plh7979Vfv2nXQekBQnyRJSYHrVQCQuXbpj1WOWh/NkZI2VR0ilMz6RnEg/bNhorT8hZE6StXz5WvXuuzcV+iOZPoHu0QcgWyLP+fMf2nR07NgFtW3bPh0vfdbU9JqVXvoV9aEMuY7Vz1IPQ2/Gojwf4oXVJ89azw68oJvyznE1YW6V4st5+/Mh23ZdpiTLyUvAVfKSZHXq3kVNbCwO1DFp6kRV/0JNoGQKmo6iIk/F9Emqdt4UYiFgYzQZ/E3Zvdv2MHT75rD+0oeq5PmSpPq3ana5mjK7Iqm0ycgX9jSTK0erlU+0tAxEGnreGHowqHv06K0Ne9GpEBGQGNzDMj0nwYGBL8QMRjrKEOMcebAUDZtSSZlmeHfp4DHtVRFvmRnvdu5GslauXH8P0YBMkM2tDNxLVVbkwfJJtCdWmeZ9NznN+Fgka8uW3Xq5JshQMn0C8gmdm2WDXJreQ3j5Dh9u1mnq6qZrvZjkbvXqTTb9Jepnsy6eZz7+3J4Rse5hpUTlxibreUC70V87fmxloWrVup16smt318N05jjP3Zw/oSFZqS4X/NH9D2lFQVk8qANigBjwCgOdBgxWZUfeVdWX77geZccuqK4jx3LeyXDupXGXuXEXT4f4bgfGufn9kxtxMEmWszwhEiBBzjjkk2PUqLH3xDvTy7WbDE6SgLSJSJaUJ2E8WZFG4quqGpKS1U1OqcsszyQ7ZrzbuVufONOJLkCmnHG4lnaY9Uoe8Ya5yR6vn93q4b3kx2esZ4Xz/phNb6p23Xrz2ZHhsyPTZ32Llq1j9oGTWJnXIFRuXCXwnqxYH5PF2/jCbDjP74/57Rp1Q90QA8RAEDFAIy55Iy5VXcGDAnKF73ZGjCi0jPVUjG/kQ36UY3q2RBb51gnfEoHMyVI1IV4IYfxLegndZHCSBKQ1SRbIg1muSTCQNpGsSHPy5BXtyRI5EoVucpp53MiOGe88j9UnZjopUzyLZpycSxpTB079uclOkpW98RbE+ZUyef/cj8VVAk+ynNsiLnxxlZ7c23XoQvKQ5I8zc0B5P6CoU+qUGMgeBsRoZOit8QdjHkY6CFJBQbGN5CS7jKxr1+6WFwxLAuP1kXxPtXjxKp1OyBfC4cML7snrRgASLRcEgTPLxbdTIlMysoqM2KxD8iUK3eQ087iRHTPePI/XJ5IOfYU+Q9+5kVpJx+WC3o4X0WsmIZ8T2XtOBEm3sbhK4EkWlGj+wBfWI5eW15FgkWARA8QAMZCnGMjEqGHe2IamECy3ZXGyIYJ4nfAdFTwcsvEF9CpL2uChwrmp6759ByhsfPHKK5ut+8XFpboMIVlmerdzN/IiJAjfkEkeeJ7ibXyBdPFklXIQYuc9fFcWj7yY6XHuJqeZJhWSFa9PUKZ44rDbYyIZZeMLs8+wWyL6Ufo1mX4228Lz2OMpGd0EiQhQluwSPjeuEgqSRWBkFxjUL/VLDBADQcJAMsYL06Rm/MlOddg23PT81NRM1eRFyIxzC3f5lgekBd4uGOwgTWYZ4pWSZYjOLdwz2fgCxMJtC3e35YaCiWRkRVpZahhvO3gp0wzTJVnm7oIoL1Gf4Le+0PYbN/5CYYt5U+fisTN3F0SZblu4g8iJ/In6WdIxTG18xdJXkOZVyuL/c54kK0/fBHMw+T+YqHPqnBjwBgOxDBbeT9/wAzlyO0AYRK/OH6mtrZ1mxYl3xq0MITwgN9ihD0vbkA4/IOxclih1uYWxyIvzx4ixS188r04ysqJ+8fIkSwJF5lhySrzUj1DuITR3F8S1my5xT/pEvqdySydlg4TJ7oIoU/oAedAP6A/nss54/WzKy/P0x5vojs8Eb54JYdUjSRZJFpdcEQPEADEQKAyIgcIwcyOPOqQOiYHcYSCs5IBye0MOSbJoXAXKuOLA9mZgU4/UY5gxQKMwd0YhdU/dEwPeYSDM8zBlz9yOIMkiySLJIgaIAWIgUBigkeedkUddUpfEQO4wQKKSOVEJsw5JsmhcBcq4CvNgouzRnkzZ/971P43C3BmF1D11Twx4hwE+F7x7LoRRlyRZJFkkWcQAMUAMBAoDNPK8M/KoS+qSGMgdBsJIDCizd8SQJIvGVaCMKw5u7wY3dUldhhUDNApzZxRS99Q9MeAdBsI6B1Nub+wHkqwUSNYDLR5VJaXVasPGN9WV93+mpk5bYCMoieKdoO3UpadauGiVeuedi+rU6au2spC2c7de6tChZr3NK7ZixTnqcJbDa28GQyp6bNu+s2p8bq46eKhZ/5ClM2+ieGf6RFgA1pzb+DY33yQWUhi/Tp17dZ2o7xLFO+VY07RFYwr9ffXqZ6q+cY6tn80fPER8de10W7yzvDBe08jzzsijLqlLYiB3GEhkFyaKd87fpeV1+oe48Xy4efNLbY+aaYaPLLrHVkBaMw3P/bMZSbJSMNJg/OBX5hECtE6SlSjeCWz9GxaHmtXefaeUm8H89ttntRHf8rG2Ckb7mTPX1Otb93GwpNBnTp17dY3+Ajne/sZBjQVnuYninekTYWH+ghXq5Kn3Ve++g6zjqZ79iYUAYCFR3yWKN7GwavWrmliNHF2s+3bhi6s0vvoPHKavxxWX6+uKykZ9PWvOUv1bOL36DMorLNAozJ1RSN1T98SAdxhIZBcmijefD3gO4HmCeR/3+/YfrJ8Xixavtub/CSVV+iWdaSvg3CyH5yRZgQSE6UVyI1mJ4p3AlvQYZE6S1a5DF21MYcBIPrzBvnz5E+ta7jP0b8CIrqXvxMMk9yVMFC/pJJT0blhAGtzfvec4+z4ApEr6TMJEfZcoXspBiBcpIFrmPYx5eaGzafNb+sWLGX/+wi0FEm7eC/s5jTzvjDzqkrokBnKHAZn/MSdnajfOm79cv9w153fYBaZtgGeF05400/PcX3uRnqw0jTa3wWKC1y3+zZ1H1NGj791jDLkZ1uLyNQfoqIIJepCa9fDc3wHj1HcskiXpYsXDzW++fZL0blhAHCbRCxdu6+UBwBaWjmI5qeRjmFscQP+x+k76JlZ8LCwgH8Y/3lzKyxbgYO26bbZ+37f/lK5b6smHkEZh7oxC6p66Jwa8w4A5H7vZhYniY9mNyIcVD1gy3tA413om4Dlz8eLH1pLzc+duqIHPjLDizfp4nn27gSTLR5KFtbTlkxvuAbub8SUkyxwEbvfMeJ5nf8A4dRyLREm6WPGz5yxxnfjcsICyVr68UWGyhdu/cOwkPbFiOanUw9D/vnfqPFbfSbpY8bGwgHzwXJ04cdnqZ5AslCNlInS7Z8aH8ZxGnndGHnVJXRIDucOAOf+mQ7Lc7EY8A1AWDufKBzxP9uw9qQYPLdAHVkeAdJly8Nw/e4Eky0eSFQvYbsaXG6FyuxerTN73ZxDFIlGi/0Txkk5CNyxInBliswNMsFhWat7nuT/97qbnRH2XKN5Z5tJlazWZNj2WboTK7Z6zrLBd0yjMnVFI3VP3xIB3GDDn3nRIlpnfeS6eLDwrnHFyje+4UK+shpD7DP2xFUiyAk6yuFzQn4GQ7oSTiEQlinfWm6whLoQbobMMXucGM4n6LlG82W/ADZYJYomweR+EissFvTOAaExSl8QAMZBNDJjzt9ckC2XjeWCudjDrk/NE9Uo6ht7bDiRZASVZ3PjCe7BnYwJJRKISxTtlcjPEu3Xvqy5fvqOeHTraMrjxVgoTJz1ZwcGJW9+Z/ZsoXtKOLSrT394hlHsScuMLGoTZNAhZNvFFDHiLAZm7ESYiO4nily1fp44cPW97LoBk4adkpB58g1VbP9O6drMlJS3D7NsPJFk+kiy3tbUAeSzjy9zCvXuvAXrnsQ0bd1iDhwMk+wMkkY4TkahY8bG+w4mFBbypghfD3M6f32Tlvv9NfMTqO0kTK97EAjxX8GABN5LPDJ1buGOLd6TPN7IdVkNvyJCR2pCKJz8MqcbGWSpeGj/itmzZrbGze/exnMviR3uzUQf6En2ejbJZprdkJ1f6NOfvRCTKLd60G2X+ly3c3ZYLbtt+QNuK+Nkf2AuwG/hNVu5sBZIsH0lWrF1iYhlfzh8jRn5z+aA5eHmem0EUi0RJf8SKj7WjXLJYwO6CmEClHoa56X9T77H6TtLEijexgAciHrTOw9yS1/wxYvxuHx7CUke+hLkyiPAW2Kl7uUZcIrmyTbJWr95kkw87iy1b1pRQLqfcVVUNmmA988xQ9dBDLdSPf3yfmjFjgQ6dad2uk0lfUFCkcLjl9+vezJkL9XeN6MMbN75QO3YcTLqNyciIcr0kWf37D1KnT1+1+hjnBQXFlg4RX1o6xbpORsZcpQFGoG/oHXqCoV9SMtkm+7Rp86xd8IBlXJvyduz4pDp48KzOj5dJOMc9Mw3GhNRx4cJH99RhpsU5dHj27DVdZixMpFqmsw7z2pyToYdYL9CQzi3eaTfix+kx7yPt9euf37MREmxE5IG+kOb06Q8UXtKbcvDcP3uBJCtNkkWQ+gdS6pq6JgaihQHTSMnVOTw8qXp5/CBZQvZAjsaPL1MwLFOVE0bk3r3HLWN10KAh2iibNKnKuhdP78708MzBoDPzwMA+cuS87Z4Zn+3zlSvX6zZVVtZrIgmZQVpS1VU8OdFmr0hW69Zt1NWrP1cbN+5Q7dt3Urh+4YWXdBukjuXLsRnOz3Om03i6cMbt3HlYY2L9+m2awAOnMPz79Bmg5a+oqNXxBw6c1vHACvRZWDjeat/x4xd1ngULluuXCciP9FLX4sV3f6z99df32uqA7iSNGYL4QX848FIBsqFOhJIu1TIlX6yQz65oPbuc/U2SRZLFNxzEADFADAQKA7EMFj/vB51kiS5gtML4hNEq9xKFIFlekg03kpVIhmzGw8iGTubOXWLTSXFxqTaqhbRkKoOXJKuu7u6OsSACplwnT15RTU2v2e6Z8UE8h/6hGxNj8FLhniyV3bp1r76W9nbv3ltfg2SiTXJttl3yCIkCCTt//kNLN0LcnP0uOpJ402OGMuAZkjSplin5YoVOo5vX0SJdJFk0rgJlXHECitYExP5mf7thIJbBkuh+13Z/rv7+TFf1j+e6JTyube9oGVZu5cYiWVjyhLfyMBix3AiERfKLJ8tcbuRc4mQamsjnXL4Ub/kfyhVPltSJEHWIcZqoTLQLMsgBo1fkFvKBeuDpQrkgKziamrbc006kdysPMjj1J0u/pDynXpD+1Vd3WcvloNtZsxZadcryM+SH7PBKde3a3Yo39SHGtBjjZhw8GL1799f5pExZboZlZOgPSZ8oHnKgv7DUDedYEidlSxkmFlB+LJlBllHGokUvW/VLGRKa/S/EFnnMQ0gM8sSrG21euHBFzLqkznRC6K1Hj97aGyf5QXwgp7wMQP85sYx44AB5hHQ624M0glNgQdIjj+AY7ZZ6zRDeTTM/4pAf9yRdqmVKvlih2/zGe9F57pFkkWSRZBEDxAAxECgMxDJYEt1/tsePE5IrIWA/22v/tsNZNowv04BDPN6uwwjDtz64xvcyuBbDUYw8EB4Y+P36DbxniRoMOjEckQZLl/C2HobpsGGj9XcWEu+UyTSyzThT1mTKRDlm20RuMV4RL+3EskS01zROnekhr2moQjZTJlzDqMZSL5QHGXGOe9IOpIcuZHkfdAIZoBekgYEMoxx5UQbSw8sj+c3QTR4zXs6x+QdkQJmoB2XCkyHx8JwgvmfPvjoe/QoiJfFoM5a5IR5L/JAWZUg8ZEabEA+ZQSKdxELSIoSHBeQH39ps2bJH48GMj9X/SIN6Ub+pr3h1z5z5go1QmvV4fQ6CDVkgn5QNPTh1AX2K/qQPzbGA9ps4NNOjXMEl0kk9ZujMjzjUh3IkXaplSr5YIQlVdAiVW1+TZNG4CpRx5QZS3ov2JMX+j17/xzJYEt3PticLhjLe0JtywFAUo06MPDMeRiLIgtyDESeGI97um0uVkAaGPL5nkfRmiHqchiniYSiKcZpMmShH0iO/yI0Q14g3v9nCPVNuZ3oxiJFODlMmN88SiA3KFIKK9ObSMGcd+FYGhvrkyXWaFMFjBK+U1GeGbvKY8XLepctTuiy5duZDv0lfIQ0IzJtvHtJkG9eQf8SIQksGZ/+gb82la9JmfB8mdTpDYAwE6NixC7r8w4ebLeLkLF/y4j50Y24KkU7dUp6XIXQGcgVdmroiyYrevB7FZzlJFkkWSRYxQAwQA4HCgJdGXrplmSTBLANLrGR5GIxsHDBykUaIgZneeQ/pxXBHPinDDE0CZJYVy8g2lwsmUybSmHWIjAhRnzMe90y5nemd5ATpTf0h3o0cvvfebUsXSI96pb3OOnAfG0G8++5NLUu8neTcSJ2UC5IMIoNrLN0DmQEBMPUvaXFPdCL3zNAZD/nNdpplmufxyjTLh3zwaoFg4r6zfNyDbp0EBvfN+szzZOs25Uj3XLyDkM/cJRHlgXiZuhKZBZdcLkgSlg+kjCSLxlWgjKt8GFRsAx8OxEBmGEjXqPMyn0kSpFwY7zAYR40aa5EBGIpCDoQYSHqEYgTLPRi8uIdrGM9OQ1PSuYVuRrZz44tkykQ5YsyiHpFbDHBnPNKYcjvToz2IN2U29edGesSrY3qyRI9uMtXUTFXDhxfoOmC8r1ixTveFWaeco2z0k/lNF+KcG19gaeC2bfstb5azHShD+gr5US+8Zygf12iz6AzXzv4BQTLzI02sAx5Mt+WP8CiKZ9NZPjxDThml/FTqljxeh8AA5MNPBjjLdm5iId+kQQ9IKxtfyDXubd9+QOtc9O/ctAL1oE9M76FZr+DQjIfOTW9yqmWa5bud81mQ2bMg7PojySLJIskiBogBYiBQGHAzVvy+Z5IEqRtv12E0gmTB0GtomKGvhRwI+YBhiHj5JkuMZJRjkhUs70J5yA/vCg5sJz19+vx7jFLkNY1spMX3S5cvf2IjTMmUiXK8JFlCXuB5EQPYqT94LhJ9kyV6RFtFl0Ji5Pso1CEkC0RC+sYZoiwsoYOOkN5tC3fIJCQL8ZDPJItSZ7xvskQ+Z//gGjiAxw3f2uEaIbyOLVs+eo/cKEewgO+70L/4Fg73gDtn+dAz2mfqDGnkSFR3tr/JQv3QJbAPYioHyDJkFMIDnSNOtnA39QnCg/abW7ibuMULBdRhbuEOTAgGobdLlz62iDBwAJ3hQJ2yhbupw0Rlin6TDcNOEih/ZiSRJIvGVaCMKw7ozAY09Uf95QMGkjVgspnOSRKkLmyWAMMPBwxmvAmHQYl4GIgw+mCoyY51SAODWfIj3vRu4AeBYezjvpRpppd8CGEMIp0csX6MOFGZKMc0VkVuMXCd8ajblNuZHsbr8eOXdBps9oD0Tv2B/EEXZjvNb4iQ3jR23eowf9w23nJB0Zm5tBPGN/oOsko8PEHYyAIyQZebNr2pz8VIR1qzTiwtBMmT/MgnOsM9yG96JpEf91C31FFbO83KL+VIiH4zly9eufKp7Qd6zfLF64ZyzUN0mKjubO4uiPaYMpnnpn6w0Uc83bhhxjk20F4Za8CEuSwR/Y8xZf7+m3M3TycmpB9jlSl9lWyYD/Mx25C+XUGSRZJFkkUMEAPEQKAwkKwBw3Tfei6oC+qCGAgeBkhQ0ico+aA7kiwaV4EyrvJhULEN0Z5U2f+Z9z+NxeAZi+wT9gkxkDoG+DzI/HkQZh2SZJFkkWQRA8QAMRAoDNCYS92Yo86oM2IgeBgIM0Gg7JkTRJIsGleBMq44qDMf1NQhdRh2DNBYDJ6xyD5hnxADqWMg7HMx5c/MniDJIskiySIGiAFiIFAYoDGXujFHnVFnxEDwMECSkhlJCbv+SLJoXAXKuAr7gKL80Z5Q2f/e9D+NxeAZi+wT9gkxkDoG+Ezw5pkQVj2SZJFkkWQRA8QAMRAoDNCYS92Yo86oM2IgeBgIKzmg3N6QQ5IsGleBMq44sL0Z2NQj9RhmDNBYDJ6xyD5hnxADqWMgzPMwZc/cjiDJIskiySIGiAFiIFAYoDGXujFHnVFnxEDwMECikjlRCbMOSbJoXAXKuArzYKLs0Z5M2f/e9T+NxeAZi+wT9gkxkDoG+Fzw7rkQRl2SZJFkkWQRA8QAMRAoDNCYS92Yo86oM2IgeBgIIzGgzN4RQ5IsGleBMq44uL0b3NQldRlWDNBY9NZY/PTTTxX+4ukV8UgXL02249q1a6du3bql/ud//kcfqK+5uVl98cUXScuVKD3q+Ju/+Ru1d+/epMvMdrtZvrd4D5I+wzoHU25v7AeSLJIskixigBggBgKFgVwbScuXL1f//M//rIkJDH4Y+WPGjMmZUS4kSQvk8q+hoSGubJI/nl4zIVmnTp2ySfVf//Vf6urVqwqEJl6dzrjt27frcm7fvq22bt2q8/7iF79Q//mf/5l0Oc70zrY//fTT6r//+7+1fM76ee0v2QFugBX8IdyyZcs9/dytWzfdV4j/h3/4h3vipc82bdqky0n0oqCiokL9/d//vU4LHIDUO3EKuRCHP8wDixcvjlmv1B8rJFnxhqyEVY8kWTSuAmVchXUgUe5oT6Tsf2/7P5bB4sd9MdZgXB0+fFhduHBBe1Vg6A8bNixtYysT2RctWqRJB4jHX/3VX2nj7+jRo9Y9EId45TuJhltaFJrIQHXLh3tCskQmECyQ07/7u7+7x4CNVYZZTiLSGK8MZ1wybXfm4XX2ydbx48c1joVQ/+pXv9LXK1assLCM8fYf//EfmvBgHDY1NVlxZh8hnZC1eBgGmcI4xoGxdP78eV0nQinvwIED+t61a9d0GswDwHKiMSb5nWFYnw1PrP9Yddj5V6rD9q9Vx11/ozq+9beqw5u/U60XHFYd3/ydvsa9Ni+dVz+4r4W2I/+8VSfVZtlZKz3i2/30lvpRm246vvWc/Va+n/QrUo/WbbSuHxo9NXe26H0t1GOz9+j2QmYc7V/7XN3fu0DLJLrAPfTng4MnW3K3rFyt77Wauu3bdn+jL5RDkkWSlTtgU/fUPTFADLhgwGmo+Hn9L//yL9oIM99uw/DDn2mM4a06CA+8XPhzexOPN/Mw6PD3r//6r7Y34siPQwgJ3pzDwEvUViENJhGBrCjHfPs+a9YsqyzJY9YFYmTWBRlNAxVv/LGsDn8o15nezCsky5QJbccfiKqkhTEMfclyQNOLIDLqTIYsch9loHz8XblyxfJGQK/PP/+8VYeZXsqSEAQa5eDPbKtTLsiIeyJ3or6C/mWZI8qG3qA/yf/rX/9a3bhxw7qW+1EO//3f/93mmUIf4s/E2fXr1/W4MvvCTWefffaZLsvZr860Mo5Nj9lvf/tbBVkkLa7/6Z/+ybqWPDt37rTuSdpkwjCTLCEcjy87pzq88eu7xGLX36gOW79SbV953yIaj5Sv0M+xNsub7xKNXX+tWjVsVh12/EZ13PXXOi308OePtFMd3viVJjNtV17UpA0Ers2KCzl9DmqC9A25emz6G6r961/odrTf+peaQJpk8EdtuyukEd3gGu2X6yc23FE45Joky+UBH9ZBQbm9fZtOfVKfxEBuMJCM8eKW5pG2D6mF7zSoRScaEx4Nr026x2gSI/7ixYv3xDmNQhje+INxjbfisrxQiIYYZ+abepCLSZPu1iv5JV7yjxs37p66zbYKiZB6ECdv5EFoZsyYoZxEUfLAWwBZxWsgpANlmAaqvPGHTOYb/1gk0I1koUwQTxitIj/OQTp3796tyRf0AUMa8UOGDFHQO/6WLVumr3FfZMe59A/yoa04cG7WYaYvLi5Wn3/+uS4T51h6hnLwh3Q4x4H88cpM1Fei/23btqmFCxfqNqIPpHy0+S//8i+ta7kf5RD9gT4XHSxYsED3i4kx4Ofrr7/WLygQ6STUyAvyg74Tkmb2q5QtoXjPzLFj4gXpUJZZhmDOJH9SXjJhWJ8h2nvz5u/UExs/0QTIJBoPDKnW5EOIxOOLjus0P+7YT93fZ4z64eNd9TXuSxqQavlIAAAZnklEQVTRg0lIJO6+boNzSrJ+9EQvLfeP2vW4p62Q7Se9C612PDxhoYJuOr75W4s8asK566+110979e5rYaUnySLJyim4ZeAxzI0xS71T70HEQDLGi1uatt0fS0iuhIBN3znZMvCkLFkq6GZQiaEtaXFtvvEWI1Hyfvnll7Y35GKswdBDGc78MBbxt27dunvkkjoRilFoGooTJ05UMFolnZP0SB7xzmHpE4xJeAAkD+oW41JkQZskHvJi+Z9cm6GzPolDHhjKuBb9mB4B1Ac5JL1bOSI70ogOz549a+WBns0yzPTI47zGPbOtIpfpccM5/qT9ifoKdaCdot+ZM2dqctqzZ09LTmkjw3uXIkJvwBbIqCzLk75G3548eVITc3hUkUb0DA8X4mXMmf3qpudE+HJiA9cih9ThVm68e0GcX5ORSZbIIUR6k2QJKRKSJCQLywLbrbn27bK5b7xDSGfVeV8L9cTmzywSgiWEVlyO7PH/+2Ar9fiSU9rrJm2SUNoKmeGZ08shv2mXLBXEMkqnR07yk2TlqFNzDSrWT+OaGCAGgoqBeEZLvLhMPVmpkiwY36Y8ppEHo9vtT4w15DXzS92md8ksW86FNJgkCx6an/3sZ9ZyQalX0kgeKQOhs35TdniX3P5Mec2y3IxXqUNIlnzr4laulOVWjim7m8FrxqOcRNdIgz+kw7nIJYQK94R4CSF06srZVyDGMPZBAn7+85+rlStX2nCBMnnE1oH0mYl96WuTUAv5hZcY+oQH0iT+Zr+66TsRvpDHWYbIIePWrdx494I6xyaSKx2SpT088Ohs+6WCV8vNkwVPD5bhCQkRgpZInmzGazmxDHLnX6mfDJjgSiixpBDx5vdoP+rQRxNEkiwSqZy/KcjmAGHZJAvEQH5hIJ7Rks04WXKU7HJBJ+kwDTQY3X/7t3+rPUzwMsnRv39/bSAmMtxjtVMMUiFQSId7qA8bZODaaUxKHrNMZ/2m7FjCiL+5c+dackP+wsJCV7LgrE/qAcESI1iWamFJnehCQknvVo4pu5vBa8ajnETXSGO2NR7JkqVrTl05SRbKhDcR8suyTyzJlHYxjE2wQKLwZ34nBX259bWpdxDbeH9uOhcMOscOypH0GEfAkFy7ySFxyYRhfTalQ7KcxEl7h77x+ogeTI+YpMcmGBKfi9DZVnxPJrKJJwsyyj2QLeQRWblckCTLAoOAgmF+GaXsT/ZnPmEgGeMlW2mc3zOhHvm+yrnxRbzlgvKdjyx/QjnmNvDJGO5ubRQSYRqKzrLEcJU0kkeWWSVaLijEA1uqiwxYmiX55Z6EbuTIufGFmw5RnrmpgVs5IjvqcjN4zXikSXSNNPhDOpyL1yrRckHoGOlxmMY+rj/66CO1f/9+Kx4bc+BvypQp1j3Jy/BbwiX9LWTW1A2wAcLzF3/xF5YO9+zZo/UKLJWUlOglmfhmUA5EYjMaXJtlyblgUDyUuI/0zo0vzOvVq1frOs08Ul4yYVjnZSfxMMnRQyMbtE0ppEO8UdpDBY/QG79WbVact0gJ0kEP8PxobxA2u1je/M3OhX+tdyDMpZ7avnzZ2rDj7u6If23JLiQL8mF3QWkz9CEy4zstuc+NL0i4LGAIQBjSQCcGiIEgYSAZ4yVbacSAhkcCGzTAEJRvQUxCAKMbfyBeMOqQHkahbGwhb9r/8R//UccjHeJlKZmTGEm9COO1TUiEECikhdcEZYMo4MA5/iSN5El24wuQMHz7gnajPOgBW2nH2iFPjOVEW7jDqwXZRGfQze9+9zurvVKOyI22iew4T4dkiVcObYBhjnLwh3JxjkPkMvUnHjjEJ+orlIV2bdiwQW88grzmN1rcXfBbYiU6B2nBH3QjJElCSSMboQAv6D9g0iS7kk5CZ79iDP7bv/2bNQ5A3FAGDtSFcvEH3EkZ8oLB3MIdfWm+LJG0yYRBmldTkSUuyfpmu3UhFkKy7usxQnV4/UuLcLTf9kvrHGTF9Gzh2twEA0QlFfm8TIut580dAbEDorTN3Fre3FXQJF+QhVu4k1zlDMBeDgaWRTJADOQ/BpIxXrKZJpkfI4axB0+WuYU7jDpTLnhzYNDhD4YajHiJT2S4SzpnKKTDJCIgf/IDq9iBTYxHIWzIA1mvfvP7VSBPpmGJOvBnEg9zC3cQCHzzZZJMUy4hR7qQb9qKupyeL+SXLdyR9je/+Y1tq3Mpx2ybtBf1pUOysAQUusffmjVrtP5xbrbVlAttjbWFu7TZSYjxTZy5hTsIt7mFPjDA3QXtRAv4j/UnegZ+gCPgFX/ASywMIg/+zH7du3evJr9Lly61xp3zx4jdcAocSp3OvhTZkg35vMr/5xX6GJt+yO+BmUsLufEFyRfJFzFADBADgcJAsgZMLtM5SVIuZWHddgOe+qA+goIBkqz8J1ktxs7WSySxTPKxuQf074hht0EsjSTJonEVKOOKE1L+T0jsY/ZxIgwExUCKJwdJFg35ePhgHPEBDCSa6xifB8/D+1qox2bvufu92TcbfbTf8hfqJwNLSLII8DwAOIkyJ3JiIK8wEAYDlSSLRnQYcEoZc4tT2pjRtjHpyaJxllfGGSe0aE9o7P/86H8ahrk1DKl/6p8Y8AYDfCblxzMp3X4kySLJIskiBogBYiBQGKCB542BRz1Sj8RAbjGQrnHOfPlBzkiyaFwFyrjixJIfEwv7kf2YCQZoGObWMKT+qX9iwBsMZDIPMm/4n6MkWSRZJFnEADFADAQKAzTwvDHwqEfqkRjILQZIlMJPlDLpQ5IsGleBMq4yATPzRnsyY//nT//TMMytYUj9U//EgDcY4HMpf55L6fQlSRZJFkkWMUAMEAOBwgANPG8MPOqReiQGcouBdAxz5skfYkaSReMqUMYVJ5f8mVzYl+zLdDFAwzC3hiH1T/0TA95gIN05kPny4/lJkkWSRZJFDBADxECgMEADL3UDr7Fxljp37obKhu6GDBmpbt/+Om7ZiIcM2ag/lTK3bNmtbt36Su3efSznsqQiN9Omjvkw6IxkKT/IUrr9SJJF4ypQxlW6QGa+aE9k7P/86v9cG08lJZPVhQsfaWJx12B/R3Xs+GSgjfZ4JAvkCyTI7UiGmGWbZK1evckm29Wrn6lly5pS1ndVVYMmWM88M1Q99FALnb++fkbSfffjH9+nZsxYoBDGwmBBQZHCESue9/0lS8DOjRtfaPxgzGLsxuuD/v0HqbNnr+n0yLdjx0Fbf6PvR40aq1Duu+/ezJis89mUX8+mVPuTJIskiySLGCAGiIFAYSCekZTtuIqKWm2Awcjq0aO3GjRoiDpy5Lw6f/5DmzGWbTlSLT8eyTLLgocnVS+PHyRLyB7I0fjxZZrkpion+mzv3uM2IxuG9MKFK2z3TH2Y5+hrkOpJk6p0emk3QkkHoxx4kGuG/pIqU9+LF6/SY/X11/dqcgyShf5r3bqNa/+AQF29+nN9gEyvX79N50co5QJDeBlx5cqnOkwVg1KOhKka5UyfX6SMJIvGVaCMK04w+TXBsD/Zn+lgQAyUXIQnT15RGzfusIwuyADj7Pr1zxWMulzIlEyd+UKypK19+gzQBjNIr9xLFMJAztQoNutwI1lmPM9zR7Cg++PHL+qXH9IP8oJk7twlrpiR+GnT5lnxKOPSpTvWNTxdQtJAtjLFUzrzH/Pkz3OTJIskiySLGCAGiIFAYUCMplTDhzp2Vo13fqWe+/S3CY/SYxcsw0rq6d69t357XVxcek/c1q17bV4SGGBNTa9p8oVzLEHq2rW7LR+MOZAzxF+8+LEqKCi24mG8vfrqLnX69FUdD4/LrFkLrXjIBNIgS6Gc5ZvLnrC8bvv2A0l9k4V63QxHc4kk6kTdohchG6Y8Bw+etS3DQxvNb7JM+VBevOV/KFc8WVInQtRhEl4s2cQ91AWPBb6/kqV9aBPuyyGymHKhHni6UAby42hq2nJPO9FepJWyEOIaMjn1JzJJeU69JKoT8sM7hvyoB3gwcQTdJeuJM3UXhXPozMSyiVO39q9cuV7rGOkkXnAj12aI/jDLN+OSPSdhyh/ClE5fkmTRuAqUcZUOiJkn2pMY+z//+j9ZA8aZ7rF+AxOSKyFgk9/90DK0pBwx0kwjTOJgLJtEAAbYgQOnVfv2nVTPnn21cYy34pK+rm66NpyLiiZpIrBo0cuacMlbchhvWLpUWVmvvx8CYYPRKKQBBiHiUTaW0IGQSf1IA9KGMlBev34Ddf0SLzK4hcjjNBxBLlH3zJl3SR7IIK7FiyR6AeEx6zPLgT6E2CANZEebIOuwYaN12yXeKZdTtxLvlBUEBPegD+gF7RXygzw4N2XCPVMuxEs7UQbai3jpb2lnrGuU5yYTcIDy0G6cQ05pQ6I60c9oB/KiDJQPb6rknznzBQXCKtcMv/Weoe/M/pb+MzFh6gv3zf5GHPLjnplOzp3ly/1UQj6f8u/5lEqfkmQ5SNbuPcfVmqYtMYkH4pqbb8aMT0X5maQdVTBBu7gxCQwfWZRzeTJpS67yJurrXMnFeqM9KbP/73c1eJIxbDL1ZImRJka2WScMNJPEOI21ESMKtbGG73qQz+mFwT0sSwL5wjmMO5AQqcNZN9Kay55ghKNOlC/LnnBP8oPAmPLJfWeIek3DFPEw7vH9mZnWJDAimxmP+kBY5B5kExIFuc0lWEgDgrZz52ErveRD6NStxJmywruIOsw2ox4noXG2zZQL9Ti/2TLjpZ3S/85ryGXK5NYP0k9CUBPViSWoIKSTJ9fptvXu3V9/XyQ6YPgtqXLqAn1n9rf0F3TuTItr3Ece6V/cQ37cc0vvLN8tTaJ7nM+j/TzPK5IFsoFBEeuIR55kICQyvDMlWaZseEC9885FNfCZESmTpJOn3lfb3zioWj7WVj3Q4lE1tqhUH9KORGHjc3NV5269YtYLmconN8SMT1S+F/EVlY3qwoXbuj+hq0OHmuPKnGqdifo61fKgs9OnP7Dwh/OxRWWWDoOg01TbxPTRfkDkqv8TGS7Zik91uaBprEEmzO9yDyTFnO/lXIgIjDvTGBQDUfJLemeIeJTx3nu3bYYh7qVLsiA7lqRh2aFZn8gnspl6d95DPmmbGLNmWTg3DWKzLKR3k90kqijbWR6uzXwox1kH0phyxYuXNiGEfM5r3EN+KSOWztE3ydaJMl944SW9kx1kTWaHPFN3UT6HXSB9AT1IfwlunbrJ9XJB2FywY9DPYtPAfsvmPAubVZYsY3zXN86x1Qe7ROaqmze/VK9v3WeLT0Zm1IG8d/F7W8EJEK9NM2YusslUXTvdlj6RTPHKTjcuW3rKK5LlVC46fOq0BbbOc6ZxXicyvL0gWSLTUz37qw0bd+jBlgiUTjnRNjPPmzuPqKNH30u6rRgQixavttLDO4e2ST0vrdygH7hy7XfY0DhXD9iFL65Sbdt3VtDV22+fVWfOXNOk0gt5EvV1KnW069BF62vT5rdUpy49tcyQHROpeBpzrdNU2sO0JFe5xIDTOPLzOtbGF1ieZ258gTlYjHHIJ54sEDVcY+lgLGMP8TAOzXgxEKVMGEZiqDvb7+ZBiWXwO/OaJEHiUB7mKmxdLfdgeIl8IpvEIUR9yCP3oA+RF3oyyY+kiRWiHmd658YXIqMsp3QrC+WYRjfSmHIlipd2Sh84r1GeqT+3fnDzZMWTqaZmqho+vEDrEW1bsWKdTa9u7eS9u94t56YV2MIf/W16gE1dSX+Z8RjvTq+r5EFZzr6TuGRD086CDXPwULN+OQ67BvaMk9R4Oe+uWv2qtktGji7Wth1sErSp/8Bhlq2Hee21LXu0XdW3/2CdPhWZ58xbpgnTkGGFuoy167bFtR3HFZdrGfASHW2dNWepxnuvPoOSlslLHaGsbOqJJMvn5YIAuJAsAcq27QfUiROXLYDJ/XghyhHjPV66ZOOcJCvZfNlKh4EPwmKWDyLjpj8zTSrnXpIsIYXOt1LwOGLSSUUupiXBiToGkjVgspFODDEY5OYW7ljSZRr4mIuwGYb5LY75TRYMOeTBN1eQE98QwTPz1FM99TWMN9QhbXAa9FheB68GvmdCGoTI37Llo1oOL7/Jku/HQLJAEhoaZmjDR+QT2ZzfZJnL/6APIVnYDAIEDPmhHxzYJnv69PlWe6XdCJFOSBbSQmeXL39iM3Che7QZdUJGXMMD9Morm60yUY7TKDblShQv7UQIuYQwlZVV63PcQ/lmHViumOibLDM9yjBlAoZQBja7EJIFgo10OPhNVuzlgiDz0KW5hTt0h36D7oDrS5c+tl6GQL8YkzjMLdyBC9G3GaJsZ9+Z8cmcg1RhPhf7ZUJJlWUPwKMDnGdrvgeJA4Ewy0d9YoNCFrQRskka2CupyIy0pq0GGwhlmu2UshEirZQv989fuKXmL1ihZUgkk+TxMsymniJHsgAAeH3EtYmJHa5J6TAY3jt3HbXcpxiwGAgS7+bJwj2zvO69BljpJZ+EAJ8AXO65gSpWmc4lkfJ9GOTGIWWinpdW4MPpu8s/8Kam39NDbfGQI1Z5sdoJfaBsLOMrLa+zykP6fftPaVc4Hq441q7bbsVDLqeL2Om2FtnxRiPWIK1rmKVGFoy3yv3/2zuDFqmOII5/oOAhuXkIuQUinhIJMUgOgibeEkFzVXPcKBgFUUGymJAcsgHxIl78Pn6JDb8XfuN/a3t33uzM252d7cPQM9XdVdXV9fpVdXXXQFeeGGPyBL7D6pEXOzge8WMO2ZWRD/uPmVt2huD5zt37e/pXXM4XcNrXT85hyoux5dHDxNu/d6ds03RgjPEyZZvMtMda9vLl/j8j5tnFQHb9Iftf/cNiEiu4BtMuM+xhvKVxVw18DELqxQ+eGzd+mhmDmb2PNstmFyRTn2s3zlxG9OQNo9Zsh7TBIXIekIdOFjD+EBjnATh4a3v7UTLOXAsZa8rKtjgi4AEf7XVOrAdPNYqTr3n1jlMnC7xk/gOHDiX4k4bZBWnjOFMP5tFknqGhXOtxwZ5d8GAnS91J2WUGT47AMif+7xnt87mhX2aoVI8smdOca+GLlL7ztbVyI5bTSNA4rvUb2shDBwgbEAcn6WN3LMIzbdNGBhc4q50rDWycuvGM7YitRpt5PIlnynKVcprUydrZ+nj3/ZvzR/rQd1khorx1ognN4rUSqkWQTHhGkfjNAn/p6++GkK7hVaNGKIIKCH+GGQmzcj8Koz3r6xhaPPnwSWMMTvDYHhrwzUd61HN8EL44vsaYa33KBp5VcnAcNE5DwvUoHO15eAn9IgfK5PGLi18Ov7+98v8ujvUZtpb3Kg/htSSkzVwxRup4cDE2bHfvlwdDfYbK4dFdG+f6+x9uDjzTn3oXwTHzIC1KFhocMnh4+uyvXenapspUOCVzAW2PgBIZ4zfygh+cN/DKe/bt37uTtWk6sIgRc1JtWd/SGD8pPjrdw43wLp8un5PUAe1B7Zpcq1uwrF/1d6JIae9id8iftBLW4q/C6J+2JHhaMPFjd6WtCTxhSd8+LZh1U5SrlNOkTtZRHSz7LSs8XoJ18rnbg4Mlbupp5++cbGEojCHXaigTejXMSXtDwjgV9s+yxZNKS0nbMTjBY3v6wDcfaVGvwQ6s8l35YIyp+LU9Bn6OE5yEfDnqKH52I6RPmTSMTm39+mS4X0X9rdt39kTX7FvlIbyWOI98hNd+OJY5Jto9evz77jeXrw59kFfuqNT+Y+ZB2pY4mLd/vjskNGH8/+y8nTltVab2YZ5wqFJXawietvCD82W/XnbnalN14CSNorG0eb67k9UN+LH60tudTV3BtmKd1r7INbsFy/pVfnfTOROetZyXhLX4q7CWQ9WCOZaWjZ2wpG+fFsy6VZerltOZc7I4ykdGP4xaXpJ+nKic7BasGsr2ryWKaP8saYfCJKweF6y4/J04geVv+OYj3lrf4jv5mOdkVXzQefjbixlN8Cd96umTNMiAiOyN9tBHfrPUITOknXXpJOPQ/PHn69lRTegln4c96OCsc+3ioVzFV0vrk6/Wd3QN55SHlvo6B8BY8IjGVVnAe6XL75Rni2aHdcdrE3TgNBikPI/dyTqbhvNp0M/O43roJu9y1mTtC0/KADuu44LYDXlSxncE8H5c8IPNMIWczpyTRaiU1OdGsxAqL0uVrhrewHlIDopkYUSDw/7zypahXBNfjMEJnjT24TudnFpfDfzKB2NMQ7+2HxPJSvrIIWlwj4r7VMqHo3Q89AdFZrjgTOZF21MaJVTeyO3Vq3ezaJaLmHJpRbJIXe/dtDrXtf+YeZA/wsskufC3JdG97e1/B3iVKYttPcZpP/Q050N4Lz8siF0WmyuLbiCuh4HY56HPQ9eB5XTAJA/aL7l5zBUDTqhM+S7jLjcb26073XWDHz443bMIz/XUDXYNtl+OM8e3jokv4G8qOU3qZK3jnSyMWp2sCxe/GtKCoxAqAYZ3vZOFM6DhXg1lFIYkEN6/oeR/ED4698kMp7gp0/EgKkMSjrrDMAYneOQJvPCdTk6tr3wnH/TnQXn2/O+Z81nbez/psDtZSb+O9dr1H4dxmrZTJws4bevHHQXveLVSuOO86GRRD/85bsO+zo33yLzXBL/pyFQna8w8yDd9mUfwcYTRe2npSFaZwj/6mDtb4uNoJnrIfTFg3DtDrz797PN9srJPL/frUZfJ6ZRJN+yWM+y6/Lr8ug6shw5kMq1M4c5JF97/dTN5le+s1lWEip8NbVO4Y99hdyzCc03hjt0ETumQWI4rFP6uKdyrXUa7eTyJa1XllHL6D1+HXay/X0ZcAAAAAElFTkSuQmCC

问题是: 为啥 我调整了这些参数后,Open_tables 会变少,看其他人解释说,open_tables 似乎和这些关系不大,求解释。








yejr 发表于 2023-10-27 15:33:57

补充几个信息:
1. 什么版本
2. my.cnf配置
3. mysqld进程内存消耗从多少涨到多少
4. 查看下面几个数据
select event_name,SUM_NUMBER_OF_BYTES_ALLOCfrom

memory_summary_global_by_event_name

    order by SUM_NUMBER_OF_BYTES_ALLOC desc LIMIT 10;

select event_name, SUM_NUMBER_OF_BYTES_ALLOC from

memory_summary_by_thread_by_event_name

    order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20;

li15130686553 发表于 2023-10-28 15:44:36

yejr 发表于 2023-10-27 15:33
补充几个信息:
1. 什么版本
2. my.cnf配置


root@performance_schema 03:41:59>select event_name,SUM_NUMBER_OF_BYTES_ALLOCfrom
    ->
    ->   memory_summary_global_by_event_name
    ->
    ->   order by SUM_NUMBER_OF_BYTES_ALLOC desc LIMIT 10;
+--------------------------------------+---------------------------+
| event_name                           | SUM_NUMBER_OF_BYTES_ALLOC |
+--------------------------------------+---------------------------+
| memory/sql/THD::main_mem_root      |         119328450733152 |
| memory/temptable/physical_ram      |            65065471361216 |
| memory/innodb/memory               |            13695319856168 |
| memory/mysqld_openssl/openssl_malloc |            12590189587542 |
| memory/sql/String::value             |             2867819142280 |
| memory/sql/hash_join               |             2694224319960 |
| memory/sql/TABLE                     |             2403680130583 |
| memory/sql/test_quick_select         |             1237054862744 |
| memory/mysys/IO_CACHE                |            362257393448 |
| memory/sql/Row_data_memory::memory   |            176959463210 |
+--------------------------------------+---------------------------+
10 rows in set (0.00 sec)

root@performance_schema 03:42:16>
root@performance_schema 03:42:16>select event_name, SUM_NUMBER_OF_BYTES_ALLOC from
    ->
    ->   memory_summary_by_thread_by_event_name
    ->
    ->   order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20;
+-------------------------------------+---------------------------+
| event_name                        | SUM_NUMBER_OF_BYTES_ALLOC |
+-------------------------------------+---------------------------+
| memory/innodb/memory                |               31132935352 |
| memory/innodb/memory                |               22228308000 |
| memory/sql/Log_event                |               14081100725 |
| memory/innodb/memory                |               13536202080 |
| memory/sql/dd::infrastructure       |               13138399888 |
| memory/sql/Sid_map::Node            |               12164665576 |
| memory/innodb/memory                |                9869635408 |
| memory/sql/Gtid_set::Interval_chunk |                5027081056 |
| memory/sql/Sid_map::Node            |                3988104932 |
| memory/innodb/memory                |                3493758992 |
| memory/innodb/memory                |                3399600480 |
| memory/innodb/ha_innodb             |               986669008 |
| memory/sql/dd::String_type          |               860577448 |
| memory/innodb/std                   |               469203128 |
| memory/sql/String::value            |               469152288 |
| memory/sql/MYSQL_LOCK               |               417083448 |
| memory/sql/Gtid_set::Interval_chunk |               408813168 |
| memory/innodb/std                   |               370458324 |
| memory/innodb/std                   |               370186164 |
| memory/innodb/std                   |               369935360 |
+-------------------------------------+---------------------------+
20 rows in set (0.01 sec)

root@performance_schema 03:42:16>\s
--------------
mysqlVer 8.0.32 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id:          63282582
Current database:       performance_schema
Current user:         root@localhost
SSL:                  Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:      ;
Server version:         8.0.32 MySQL Community Server - GPL
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8mb4
Db   characterset:    utf8mb4
Client characterset:    utf8mb4
Conn.characterset:    utf8mb4
UNIX socket:            /data/mysql.sock
Binary data as:         Hexadecimal
Uptime:               115 days 2 hours 10 min 9 sec

Threads: 63Questions: 794371227Slow queries: 38535150Opens: 362664Flush tables: 96Open tables: 3715Queries per second avg: 79.886
--------------

li15130686553 发表于 2023-10-28 15:46:44

li15130686553 发表于 2023-10-28 15:44
root@performance_schema 03:41:59>select event_name,SUM_NUMBER_OF_BYTES_ALLOCfrom
    ->
    -> ...


authentication_policy=mysql_native_password
server_id=1
basedir=/usr/local/mysql
datadir=/data
socket=/data/mysql.sock
pid-file=/data/mysqld.pid
lower_case_table_names=1
log_error=/data/error.log
default-time_zone='+8:00'
back_log=1024
binlog_checksum=CRC32
character_set_server=utf8mb4
collation_server=utf8mb4_0900_ai_ci
binlog_expire_logs_seconds = 259200
general_log_file=/data/general.log
slow_query_log=1
slow_query_log_file=/data/slow.log
log_queries_not_using_indexes=ON
log_throttle_queries_not_using_indexes=0
long_query_time=3
# Disabling symbolic-links is recommended to prevent assorted security risks
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
transaction_isolation=READ-COMMITTED
enforce_gtid_consistency=on
gtid_mode=on
log_bin=binlog
#log_slave_updates=on
log_replica_updates=on
# mgr settings
loose-plugin_load_add='mysql_clone.so'
loose-plugin_load_add='group_replication.so'
# group_replication
disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY"
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "10.0.xx.xx:33061"
loose-group_replication_group_seeds= "10.0.xx.xx:33061,10.0.xx.xx:33061,10.0.xx.xx:33061"
loose-group_replication_bootstrap_group=off

max_connections=4500      
max_allowed_packet = 1073741824
max_connect_errors = 100000
skip_name_resolve = on

#binlog
##gtid
log_bin=on
#gtid_mode=ON
#enforce-gtid-consistency = ON
binlog_format = ROW
sync_binlog = 1
open_files_limit=65536


innodb_buffer_pool_size=22548578304
innodb_buffer_pool_instances=8
innodb_data_file_path=ibdata1:12M:autoextend
innodb_redo_log_capacity=2147483648
innodb_thread_concurrency=16
innodb_io_capacity =10000
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

li15130686553 发表于 2023-10-28 15:47:45

li15130686553 发表于 2023-10-28 15:46

authentication_policy=mysql_native_password
server_id=1


改完参数后今天 还算正常,从内存从76% 到了 76.3% 。

li15130686553 发表于 2023-10-28 15:50:20

li15130686553 发表于 2023-10-28 15:46

authentication_policy=mysql_native_password
server_id=1


参数用的是 set @@global.xxx = xx 改的。 没有在这个my.cnf 中体现

yejr 发表于 2023-10-28 22:20:41

li15130686553 发表于 2023-10-28 15:50
参数用的是 set @@global.xxx = xx 改的。 没有在这个my.cnf 中体现

1. 建议启用jemalloc,参考:https://greatsql.cn/docs/8032/user-manual/4-install-guide/1-install-prepare.html

2. 看起来你的这个数据库业务中挺多垃圾SQL的,抓紧优化吧,参考: https://greatsql.cn/docs/8032/user-manual/10-optimze/2-3-slow-query-diag.html#_2-%E5%88%A9%E7%94%A8pt-query-digest%E5%88%86%E6%9E%90%E6%85%A2%E6%9F%A5%E8%AF%A2sql

li15130686553 发表于 2023-10-30 08:59:19

yejr 发表于 2023-10-28 22:20
1. 建议启用jemalloc,参考:https://greatsql.cn/docs/8032/user-manual/4-install-guide/1-install-pre ...

感谢感谢: 第一条,建议启用 jemalloc ,目前内存使用正常,经过了2天的观察。
               第二条,嗯,垃圾SQL 是很多,三方的成熟的产品,业务和开发不反馈,我只能,定时发一下,运行缓慢的top10。:(

yejr 发表于 2024-12-3 17:55:25

li15130686553 发表于 2023-10-30 08:59
感谢感谢: 第一条,建议启用 jemalloc ,目前内存使用正常,经过了2天的观察。
               第二条 ...

可以参考这篇文章的思路再分析排查一下 https://mp.weixin.qq.com/s/gGUUmjH4SBh8_-l5GoOExA
页: [1]
查看完整版本: mgr 数据库使用内存一直在上涨,是不是内存泄露了。