presshos
September 17th, 2019, 01:01
با سلام
با استفاده از MySQLTuner مقادیر زیر پیشنهاد شده لطفا دوستانی که تجربه دارن یه بررسی بکنید
با تشکر
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
Control warning line(s) into /var/lib/mysql/server.mihanh54.com.err file
Control error line(s) into /var/lib/mysql/server.mihanh54.com.err file
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
Increasing the query_cache size over 128M may reduce performance
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries which have no LIMIT clause
Performance schema should be activated for better diagnostics
Consider installing Sys schema from https://github.com/mysql/mysql-sys for MySQL
Consider installing Sys schema from https://github.com/good-dba/mariadb-sys for MariaDB
Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
Variables to adjust:
query_cache_size (=0)
query_cache_type (=0)
query_cache_size (> 512M) [see warning above]
sort_buffer_size (> 256K)
read_rnd_buffer_size (> 256K)
tmp_table_size (> 64M)
max_heap_table_size (> 64M)
performance_schema = ON enable PFS
innodb_buffer_pool_size (>= 23.0G) if possible.
innodb_log_file_size should be (=1G) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
innodb_buffer_pool_instances(=15)
با استفاده از MySQLTuner مقادیر زیر پیشنهاد شده لطفا دوستانی که تجربه دارن یه بررسی بکنید
با تشکر
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
Control warning line(s) into /var/lib/mysql/server.mihanh54.com.err file
Control error line(s) into /var/lib/mysql/server.mihanh54.com.err file
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
Increasing the query_cache size over 128M may reduce performance
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries which have no LIMIT clause
Performance schema should be activated for better diagnostics
Consider installing Sys schema from https://github.com/mysql/mysql-sys for MySQL
Consider installing Sys schema from https://github.com/good-dba/mariadb-sys for MariaDB
Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
Variables to adjust:
query_cache_size (=0)
query_cache_type (=0)
query_cache_size (> 512M) [see warning above]
sort_buffer_size (> 256K)
read_rnd_buffer_size (> 256K)
tmp_table_size (> 64M)
max_heap_table_size (> 64M)
performance_schema = ON enable PFS
innodb_buffer_pool_size (>= 23.0G) if possible.
innodb_log_file_size should be (=1G) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
innodb_buffer_pool_instances(=15)