MYSQL

Contoh Konfigurasi server MySQL dan MariaDB:

シックス , MYSQL
0
1346

Berikut ini contoh konfigurasi untuk server MySQL / MariaDB:


[client]
port	=  3306

[mysqld] port=  3306 #Server
max_allowed_packet  =  1M 
sort_buffer_size = 256K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 16K
log_error = "mysql_error.log" #InnoDB innodb_data_home_dir = "D:/xampp/mysql/data"
innodb_buffer_pool_size = 2G
innodb_log_file_size = 250M
innodb_log_buffer_size = 16M
innodb_flush_log_at_trx_commit = 1 #MyISAM key_buffer_size = 128M
myisam_sort_buffer_size = 128M

0 Comments

×