cardinal_pythonlib.tools.estimate_mysql_memory_usage
Original code copyright (C) 2009-2022 Rudolf Cardinal (rudolf@pobox.com).
This file is part of cardinal_pythonlib.
Licensed under the Apache License, Version 2.0 (the “License”); you may not use this file except in compliance with the License. You may obtain a copy of the License at
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an “AS IS” BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
Script to check the (approximate) memory usage of a running MySQL instance.
From: https://dev.mysql.com/doc/refman/5.0/en/memory-use.html
However,
innodb_additional_mem_pool_size
deprecated in 5.6.3 and removed in 5.7.4; https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
- cardinal_pythonlib.tools.estimate_mysql_memory_usage.add_blank_row(table: PrettyTable) None [source]
Adds a blank row to
table
.
- cardinal_pythonlib.tools.estimate_mysql_memory_usage.add_var_mb(table: PrettyTable, vardict: Dict[str, str], varname: str) None [source]
Adds a row to
table
forvarname
, in megabytes.
- cardinal_pythonlib.tools.estimate_mysql_memory_usage.get_mysql_vars(mysql: str, host: str, port: int, user: str) Dict[str, str] [source]
Asks MySQL for its variables and status.
- cardinal_pythonlib.tools.estimate_mysql_memory_usage.main()[source]
Command-line processor. See
--help
for details.