• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

MySQL spending lots of memory

J

jcals

Guest
Hi there, have a plesk server with 2GBs of RAM memory and MySQL server spends about 700MBs MBs, there's no MySQL activity there, so we don't really need that.

This is my.ini config file:

[PleskSQLServer]
port=8306
basedir=C:\\Archivos de programa\\SWsoft\\Plesk\\MySQL
datadir=C:\\Archivos de programa\\SWsoft\\Plesk\\MySQL\\Data
default-character-set=latin1
default-storage-engine=INNODB
query_cache_size=8M
table_cache=32
tmp_table_size=7M
thread_cache=32
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=300
key_buffer=4M
max_allowed_packet=1M
sort_buffer=256K
net_buffer_length=4K
old_passwords=1
tmpdir=C:\\Archivos de programa\\SWsoft\\Plesk\\admin\\db
[client]
port=8306


Any ideas?

Thanks!
 
Okay ... found it, it was another my.ini:

innodb_buffer_pool_size=640M

Thanks anyway ! ;-)
 
Back
Top