Cloud Insidr

Cybersecurity in the Age of the Machine

  • Subscribe!
  • Privacy Policy
  • Legal
  • Contact Us

Join us on Twitter: @CloudInsidr

  • news & alerts
    • events
    • industry analysis
    • industry gossip
    • people
  • cloud, edge & co.
    • AWS
    • administration & orchestration
      • web servers in the cloud
      • mail servers
      • databases
  • cybersec & warfare
    • encryption
  • blockchain
Home Uncategorized MariaDB Running Out of Memory? Here Is What You Can Do About It

Cloud Insidr 2015-07-02 Leave a Comment

MariaDB Running Out of Memory? Here Is What You Can Do About It

On small virtual servers with insufficient memory, MariaDB can give you a lot of trouble. It will crash, refuse to restart, and populate logs with errors. If trading your virtual server for another host is temporarily not an option, you can implement a quick fix.

Open the configuration file:

/etc/my.cnf.d/server.cnf

and find a line that reads:

[mysqld]

Right after it, enter:

performance_schema = off

to make sure MariaDB goes easy on RAM-expensive caching. The result will look something like this:

# this is only for the mysqld standalone daemon
[mysqld]
performance_schema = off

Now restart MariaDB:

service mysql restart

and you are done. That shoulf fix the crashes on underspec’d virtual servers.

You can read more about this here:
https://mariadb.com/blog/starting-mysql-low-memory-virtual-machines

Filed Under: Uncategorized

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Join Cloud Insidrs!

Symantec Code Signing (200x200)

Tag Cloud

automation AWS Azure Azure Active Directory Azure Arc Azure Lighthouse Azure Resource Manager certbot certificate clickjacking cron CSRF cyber security DD-WRT DNS over HTTPS DoH domain firmware Gemalto HPKP HSTS IAM letsencrypt log logs MFA MITM Netgear network router SELinux time stamp tip Whois WiFi x509 XSS
Secure Site with EV (160x600)

Pearson Education (InformIT)

Pearson Education (Peachpit)

Thawte Code Signing (200x200)

  • Content purchasing and syndication