• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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