Hey i have a small problem , my mysql jumps often to 49% memory usage , i have 4gb memory.
This is my config
#
# * Fine Tuning
#
key_buffer = 100M
max_allowed_packet = 128M
thread_stack = 50M
thread_cache_size = 8
sort_buffer_size = 4M
join_buffer_size = 4M
innodb_additional_mem_pool_size = 50M # Values beetween 20M and 50M are enough for character tables and for every innodb database.
innodb_thread_concurrency = 1 # 1 To Processors of 1 or 2 cores. 2 for Quad CoRe. 4 for i7 / Xeon and 8 for Bi-XEON (2 processors).
innodb_flush_log_at_trx_commit = 0 # 0 to reduce the I / O of HD, but in case of a fall is to lose data from the last transaction. 1 recommended for losing nothing. (More I/O) 2 Mix beetween one and two.
innodb_buffer_pool_size = 7G # The size of the table of characters plus a margin. ¡¡¡¡ATTENTION THIS IS SPACE FOR MYSQL RAM!!!! which is reserved!
innodb_file_per_table = 1 # Recomended for reduce file access.
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
default-storage-engine = INNODB
skip-external-locking
max_connections = 20
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 50M
query_cache_size = 512M
Have i done something wrong , i have duel core(3.0ghz) and 4GB memory, i also host mangos on it