Out Of memory Error

aaP_hprj

Hi
i am getting this error from past few month .
i always need to restart the server from vps console after this error .May i know how to solve this issue?
Thank you

aaPanel_Kern

aaP_hprj
Hello,
Is the problem solved?
What is the hardware configuration of your server?
Check whether the memory configured by mysql exceeds the physical memory? Does all software use more memory than physical memory?
Check the slow sql statement of mysql query and whether the table has an index

aaP_hprj

Any Help Guys...

aaP_hprj

Hello,

I hope you are doing well.

I’m currently using a VPS with the following configuration:

Server Details:
• 2 CPU Cores
• 4 GB RAM
• Hosted on Hetzner

I’m trying to troubleshoot MySQL performance, but I’m not sure where to find a couple of things in the AA panel:

Where can I check how much memory is allocated/configured for MySQL?

Where can I view or monitor slow SQL queries?

Could you please guide me on where to find these settings or logs in the panel?

I would really appreciate your help. Thank you in advance!

aaP_smithdayton

You can find the MySQL slow logs under Logs > Soft Logs > MySql Slow Logs,

But I'm sure you've found them by now. To determine your MySql memory allocation you could run the following query in your phpmyadmin console.

SELECT (
@@innodb_buffer_pool_size +
@@innodb_log_buffer_size +
@@key_buffer_size +
@@max_connections * (
@@read_buffer_size +
@@read_rnd_buffer_size +
@@sort_buffer_size +
@@join_buffer_size +
@@thread_stack +
@@binlog_cache_size
)
) / (1024 * 1024 * 1024) AS MAX_MEMORY_GB;

My system has 128GB of memory, the sql query returns MAX_MEMORY_GB = 21.5236, I've made not adjustments to MySql beyond the standard panel install process.
If I were to select the 16-32GB optimization settings in the MySQL settings in the appstore, this value would change to around 11.3GB, on your system you should consider optimizing for the minimum, to help avoid exhausting your resouces on a small VPS