HEX

File: //usr/local/CyberCP/databases/__pycache__/mysqlOptimizer.cpython-310.pyc
o

��h&
�@s.ddlZddlZddlmZGdd�d�ZdS)�N)�dedentc
@sjeZdZddddddddde�d	d
�d�
Zedd
��Zedd��Zedd��Z	edd��Z
edd��ZdS)�MySQLOptimizerz/var/lib/mysqlz/var/lib/mysql/mysqld.logz/var/lib/mysql/mysqld-slow.logz/var/lib/mysql/mysqld.pid�r�i�i��i?B)
�	mysql_dir�	log_error�slow_query_log_file�pid_file�mysql_ram_gb�query_cache_type�query_cache_size�long_query_time�max_connections�	server_idcCs4|dkrdS|dkrdS|dkrdS|dkrdSd	S)
N�@�768M��512M��256Mr�128M�64M�)�innodb_buffer_pool_size_GBrr�./usr/local/CyberCP/databases/mysqlOptimizer.py�mycnf_innodb_log_file_size_MBsz,MySQLOptimizer.mycnf_innodb_log_file_size_MBcCs<t�t�|�|�dkrtt|��dStt|d��dS)Ng{�G�z�?�Gi�M)�math�fabs�ceil�str�int)�gbrrr�output_memory_gb*szMySQLOptimizer.output_memory_gbcCs0t�t|d�d�|d<t�|d�|d<|S)Nr
g333333�?�innodb_buffer_pool_size�innodb_log_file_size)rr$�floatr)�mrrr�
mycnf_make2szMySQLOptimizer.mycnf_makecCstdjdit�|����S)Na�
[mysqld]

# GENERAL #
user                           = mysql
default-storage-engine         = InnoDB
#socket                         = {mysql_dir}/mysql.sock
#pid-file                       = {pid_file}

# MyISAM #
# key-buffer-size                = 32M
# myisam-recover                 = FORCE,BACKUP

# SAFETY #
max-allowed-packet             = 16M
max-connect-errors             = 1000000
sql-mode                       = NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
sysdate-is-now                 = 1
innodb-strict-mode             = 1

# DATA STORAGE #
datadir                        = {mysql_dir}

# SERVER ID # 
server-id                      = {server_id}

# CACHES AND LIMITS #
max-connections                = {max_connections}
tmp-table-size                 = 32M
max-heap-table-size            = 32M
query-cache-type               = {query_cache_type}
query-cache-size               = {query_cache_size}
thread-cache-size              = 50
open-files-limit               = 65535
table-definition-cache         = 1024
table-open-cache               = 2048

# INNODB #
innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
innodb-log-file-size           = {innodb_log_file_size}
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table          = 1
innodb-buffer-pool-size        = {innodb_buffer_pool_size}

# LOGGING #
#log-error                      = {log_error}
slow-query-log                 = 1
#slow-query-log-file            = {slow_query_log_file}
log-queries-not-using-indexes  = OFF
long_query_time                = 30

[mysqldump]
max-allowed-packet             = 16M

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/

r)r�formatrr))�	_metaconfrrr�
output_my_cnf8s
:�:�zMySQLOptimizer.output_my_cnfcCstt|��tjd<t�tj�S)Nr
)r"r'r�defaultsr,)�detectedRamrrr�generateRecommendationsvsz&MySQLOptimizer.generateRecommendationsN)�__name__�
__module__�__qualname__�random�randintr-�staticmethodrr$r)r,r/rrrrrs,
�



=r)rr3�textwraprrrrrr�<module>s