Konfigurasi my.cnf untuk RAM 1GB

my.cnf
samsul@keket:~$ cat /etc/mysql/my.cnf
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
 
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0
 
[mysqld]
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking
 
#tuning
skip-name-resolve=1
skip-innodb
default-storage-engine=MYISAM
join_buffer_size = 256k
wait_timeout=20
max_connections=30
local-infile=0
 
bind-address		= 127.0.0.1
 
key_buffer		= 2M
max_allowed_packet = 2M
thread_cache_size = 16k
 
myisam-recover         = BACKUP
 
query_cache_limit	= 2M
query_cache_size = 2M
 
log_error = /var/log/mysql/error.log
 
# tuning
log_slow_queries = /var/log/mysql/mysql-slow.log
 
expire_logs_days	= 10
max_binlog_size         = 100M
innodb_file_per_table 
#thread_concurrency = 8
myisam_sort_buffer_size = 2M
read_rnd_buffer_size = 4M
read_buffer_size = 1M
sort_buffer_size = 1M
table_open_cache = 256
key_buffer_size = 256M
query_cache_type = 0
tmp_table_size = 128M
max_heap_table_size = 128M
 
 
[mysqldump]
quick
quote-names
max_allowed_packet	= 16M
 
[mysql]
 
[isamchk]
key_buffer		= 16M
write_buffer = 2M
read_buffer = 2M
sort_buffer_size = 256M
key_buffer_size = 256M
 
!includedir /etc/mysql/conf.d/
  • linux/mysql.my.cnf.untuk.ram.1GB
  • Terakhir diubah: 5 bulan yang lalu
  • (Perubahan eksternal)