ขอแบบ ram 8G หน่อยครับ
ผม config เอง Restore Database ประมาณสองชั่วโมง
[mysqld]
basedir=C:\Program Files (x86)\HOSxP\MySQL
datadir=C:\Program Files (x86)\HOSxP\MySQL\data
character-set-server=tis620
key_buffer=128M
table_cache=512
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=1M
myisam_sort_buffer_size=128M
max_allowed_packet=1G
join_buffer_size=4M
concurrent_insert=2
max_heap_table_size=1G
innodb_data_file_path=ibdata1:100M:autoextend
innodb_flush_log_at_trx_commit=2
innodb_buffer_pool_size=4G
innodb_additional_mem_pool_size=20M
innodb_log_file_size=128M
innodb_log_buffer_size=8M
innodb_lock_wait_timeout=50
innodb_support_xa=0
innodb_locks_unsafe_for_binlog=1
innodb_thread_concurrency=0
innodb_doublewrite=0
query_cache_size=1G
myisam-recover=FORCE,BACKUP
default_storage_engine=MyISAM
max_connections=1000
innodb_file_per_table
skip-character-set-client-handshake
skip-name-resolve
big-tables
[mysql]
default-character-set=tis620
[mysqldump]
default-character-set=tis620
max_allowed_packet=1G
allow-keywords
[WinMySQLadmin]
user=sa
password=sa
แนะนำด้วยครับ มั่วๆเอามากๆ