You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

716 B

数据库调优

#Create Date : 20240121
#high  				
[client]					
port	=	35017			
socket		= MySQL		
###################                              
[mysqld]
innodb_buffer_pool_size = 16G # InnoDB缓存池大小::服务器物理内存大小(70%)
innodb_log_buffer_size = 128M # 日志缓存区
tmp_table_size = 64M # 临时表(适当增大其大小可以减少磁盘I/O)
max_heap_table_size64 = 64M # 临时表(适当增大其大小可以减少磁盘I/O)
query_cache_size = 64M # 关闭或调整Query Cache(由于Query Cache可能会占用大量内存,对于读密集型的应用,可以考虑关闭或减低设置)
tmp_table_size = 67108864 # 等于64M ,推荐使用字节数