แนะนำเหมาะสำหรับ สอ.นะครับ
รอ ออกแบบ Falcon น่าจะลองมากกว่า สำหรับ รพ.
config ยังไม่มี Maria เลย
[mysqld]
basedir=C:\Program Files\HOSxP\MySQL
datadir=C:\Program Files\HOSxP\MySQL\data
default-character-set=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=256M
join_buffer_size=1M
concurrent_insert=2
max_heap_table_size=64M
innodb_data_file_path=ibdata1:100M:autoextend
innodb_flush_log_at_trx_commit=2
innodb_buffer_pool_size=128M
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
innodb_innodb_fast_recovery=1
innodb_ibuf_active_contract=1
innodb_adaptive_flushing=0
innodb_adaptive_checkpoint=estimate
query_cache_size=64M
max_connections=1000
innodb_file_per_table
skip-character-set-client-handshake
skip-locking
skip-name-resolve
big-tables
[mysql]
default-character-set=tis620
[mysqldump]
default-character-set=tis620
max_allowed_packet=16M
allow-keywords
[WinMySQLadmin]
user=sa
password=sa