By Abdo
I am running ubuntu 16.04. with lamp 1 click install. I made before a month a good. It was working perfectly. But now if even I test my website page speed by any page speed tools I get the error. error establishing a database connection, really it is a problem. I did not find a solution to it. The problem it was working fine. I found error by utf firewall , I cannot remember the name but I disable it. I have many errors that cannot disappear.
[Warning] Changed limits: max_open_files: 1024 (requested 5000)
[Warning] Changed limits: table_open_cache: 431 (requested 2000)
[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
[ERROR] InnoDB: Cannot allocate memory for the buffer pool
[ERROR] InnoDB: Plugin initialization aborted with error Generic error
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Failed to initialize plugins.
[ERROR] Aborting
Please help. If you face this problem please help:
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
@hansen
I love digitalocean I want my website in here, I hate other hosting. I started here. my dream is to host here.
Ok when I change ram.
Does [Warning] Changed limits: max_open_files: 1024 (requested 5000)
[Warning] Changed limits: table_open_cache: 431 (requested 2000) disappear. My problem is just these two errors. And I am still making my website I did not finish it. After I finish I can upgrade because I must upgrade and I know 0.5 ram is nothing. But I just want to change the Changed limits: max_open_files: 1024 because I really hate just 4 errors and they are repeated million time in mysql error folder.
InnoDB: Cannot allocate memory for the buffer pool
The above is normally a sign that you’re using all the available RAM on your Droplet, which means that you’d need to optimize (tweak/tune) your MySQL installation for your particular needs or upgrade the Droplet so that you have more RAM available.
If this is a 512MB Droplet, for example, you really don’t have much to work with and said RAM can become exhausted rather quickly unless you’re familiar with ways that you can better optimize your stack (Apache/NGINX, MySQL/MariaDB, PHP, etc).
It’s not impossible to run a single installation on a 512MB Droplet, though it’s not super-easy without making some modifications.
@hansen These are the difault configration just install new droplet and see by yourself. This problem. If 5 users open my website. I get error establishing database.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.