I have 4 core 8 gb server with 10 WordPress sites installed on it for testing purpose before I migrating from a stable Hostinger server to AAPanel running on Contabo CentOS Server but I am wondering seeing it is using 95% or more RAM where as the same 15+ WordPRess sites on my existing hostinger server with 2 core 3 gb RAM is working like a champ without any restart issues or downtime over a months. I am now wondering whether migrating from hostinger to aapanle could be a right decision or I'll end with troubles managing server and panel everyday. If I am mistaking anything with aapanel about the performance issue then please guide.

Hello, you can use the top or htop command to see what is taking up memory At the same time, it is recommended to check whether the configuration of php and mysql is set too large aaP_info168

Adjust according to your program, it should be caused by too large configuration

I have applied suggested PHP changes and restarted PHP and Server but still it is consuming about 50% of the RAM

Is all the php used by the website adjusted? Does mysql also need to be adjusted?

Yes....same suggested PHP settings have been applied to all php versions i.e. 7.4, 8.0 and 8.1 Check below the current config of mysql [client] #password = your_password port = 3306 socket = /tmp/mysql.sock [mysqld] binlog_cache_size = 128K thread_stack = 256K join_buffer_size = 2048K query_cache_type = 1 max_heap_table_size = 512M port = 3306 socket = /tmp/mysql.sock datadir = /www/server/data default_storage_engine = InnoDB performance_schema_max_table_instances = 400 table_definition_cache = 400 skip-external-locking key_buffer_size = 384M max_allowed_packet = 100G table_open_cache = 384 sort_buffer_size = 1024K net_buffer_length = 4K read_buffer_size = 1024K read_rnd_buffer_size = 768K myisam_sort_buffer_size = 32M thread_cache_size = 128 query_cache_size = 192M tmp_table_size = 512M sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES explicit_defaults_for_timestamp = true #skip-name-resolve max_connections = 300 max_connect_errors = 100 open_files_limit = 65535 log-bin=mysql-bin binlog_format=mixed server-id = 1 expire_logs_days = 10 slow_query_log=1 slow-query-log-file=/www/server/data/mysql-slow.log long_query_time=3 #log_queries_not_using_indexes=on early-plugin-load = "" innodb_data_home_dir = /www/server/data innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /www/server/data innodb_buffer_pool_size = 512M innodb_log_file_size = 256M innodb_log_buffer_size = 16M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 innodb_max_dirty_pages_pct = 90 innodb_read_io_threads = 4 innodb_write_io_threads = 4 [mysqldump] quick max_allowed_packet = 500M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 128M sort_buffer_size = 2M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout

RAM Usage Issue

aaPanel_Kern

Hello, set the adjustment according to your actual requirements.

aaP_info168

Did that too but still it crosses 50% RAM so far....whenever it reaches the 50% it terminates the server automatically.

aaP_info168

I think I have restarted contabo server more then 15 times.......I am worried about it's stability now.

aaP_info168

Do you need my panel login details to understand the issue at your level?

aaPanel_Kern

Does terminating server mean that the specified server is not functioning properly? It is recommended that you check what is taking up the memory, you can go to the app store to install the task manager to check
If it is only 50% occupied and it cannot run normally, it is recommended that you check whether the server system is normal?

aaP_info168

If you refer my initial screenshots above you will be understand which task or processes overloading the RAM .

aaPanel_Kern

Can’t see what is occupied, it may be that the system has cached

aaP_info168

Your answer is now loosing the track.......I have very clearly shared all the information's as per your requirements since the beginning of this post.

I am still not convinced with your suggestions and experiments so far what exactly causing the RAM over usage and server auto stopping.

Moreover for your information, yesterday I have pointed back all my sites A records back to the hostinger server and then after aaPanel RAM overusing is not happening......so now the question is aaPanel is really compatible to handle multiple sites and wordpress instances within single panel or not.

aaPanel_Kern

Hello, I suggest you review the information you gave by yourself.
We can assist you to check what the problem is. Didn’t you configure the configuration that exceeds the physical memory to make you adjust it?
The server is down and you are giving no information at all. You need to check what causes the server to stop. It is recommended that you check the system log
/var/log/messages
/var/log/dmesg

aaP_info168

I think I manage to resolve the RAM overload issue by choosing PHP Optimization running mode as "On Demand" and I am hoping this setting won't effect any other area of operations.

Will post feedback again after a week of usage.

aaP_elmantar.zakaria

Hello
i have the same issue in two server that only hosted one website in each other , the suggested modification of running to On-demande it's work for me , thank's for all .