memory usage how to lower down or clean cache
can anyone show me how to lower down memory usage? or clean the cache? newbie here…
2 Answers
1gb for memory…for the last 3weeks i was running my website from .tt and after finalizing it i migrated to .com (just d other day), this morning when i woke up and check my site, i got an error (the website onky display an error) cant log.in both my backend and front end (i am using joomla) i lost all my 3 weeks work…its very frustrating…my cpu and memory usage skyrocketed....it was normal while im using the .tk....is digitalocean that vulnerable to attacks? My website is running well last night....it was dead this morning…
Have another answer? Share your knowledge.
Related
-
question
WordPress write to disk issues (LAMP, Ubuntu 14.04)
Hi, Everything was working fine until suddenly WordPress can't write anything to disk, such as update plugins, upload media, etc. Also as a result of this, w3 total cache doesn't work, because it can't write to disk. I have checked to make sure that permissions are set to 755 and owner is www-data (apache user). Temporarily swithching permissions to 775 or 777 and running an update still didn't work. I have even tried to recreate the uploads and upgrade directories. Nothing works. Any suggestions on a fix for this? Thanks!
-
question
Job for mysqld.service failed See “systemctl status mysqld.service , journalctl -xe & tail -30 /var/log/mysql/error.log "
I don't know what i have to do now seeing this error(mysql.service won't start) bcz i'm that much linux guy..... Pls give some solution asap <^>systemctl status mysqld.service<^> ``` ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: activating (start-post) (Result: exit-code) since Wed 2017-08-23 19:17:34 UTC; 24s ago Process: 26606 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE) Process: 26597 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 26606 (code=exited, status=1/FAILURE); : 26607 (mysql-systemd-s) Tasks: 2 Memory: 324.0K CPU: 520ms CGroup: /system.slice/mysql.service └─control ├─26607 /bin/bash /usr/share/mysql/mysql-systemd-start post └─26676 sleep 1 Aug 23 19:17:34 ubuntu-1gb-nyc3-01 systemd[1]: Starting MySQL Community Server... Aug 23 19:17:35 ubuntu-1gb-nyc3-01 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE ``` <^>journalctl -xe<^> ``` -- Unit mysql.service has begun starting up. Aug 23 19:19:05 ubuntu-1gb-nyc3-01 audit[26888]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/26888/status" pid=2688 Aug 23 19:19:05 ubuntu-1gb-nyc3-01 audit[26888]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" p Aug 23 19:19:05 ubuntu-1gb-nyc3-01 audit[26888]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/26888/status" pid=2688 Aug 23 19:19:05 ubuntu-1gb-nyc3-01 kernel: audit: type=1400 audit(1503515945.954:748): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" Aug 23 19:19:05 ubuntu-1gb-nyc3-01 kernel: audit: type=1400 audit(1503515945.954:749): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" Aug 23 19:19:05 ubuntu-1gb-nyc3-01 kernel: audit: type=1400 audit(1503515945.954:750): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" Aug 23 19:19:06 ubuntu-1gb-nyc3-01 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE Aug 23 19:19:23 ubuntu-1gb-nyc3-01 sshd[26930]: Connection closed by 116.31.116.40 port 40327 [preauth] Aug 23 19:19:36 ubuntu-1gb-nyc3-01 systemd[1]: Failed to start MySQL Community Server. -- Subject: Unit mysql.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has failed. -- -- The result is failed. Aug 23 19:19:36 ubuntu-1gb-nyc3-01 systemd[1]: mysql.service: Unit entered failed state. Aug 23 19:19:36 ubuntu-1gb-nyc3-01 systemd[1]: mysql.service: Failed with result 'exit-code'. Aug 23 19:19:36 ubuntu-1gb-nyc3-01 systemd[1]: mysql.service: Service hold-off time over, scheduling restart. Aug 23 19:19:36 ubuntu-1gb-nyc3-01 systemd[1]: Stopped MySQL Community Server. -- Subject: Unit mysql.service has finished shutting down -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has finished shutting down. Aug 23 19:19:36 ubuntu-1gb-nyc3-01 systemd[1]: Starting MySQL Community Server... -- Subject: Unit mysql.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has begun starting up. Aug 23 19:19:36 ubuntu-1gb-nyc3-01 audit[26981]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/26981/status" pid=2698 Aug 23 19:19:36 ubuntu-1gb-nyc3-01 audit[26981]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" p Aug 23 19:19:36 ubuntu-1gb-nyc3-01 audit[26981]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/26981/status" pid=2698 Aug 23 19:19:36 ubuntu-1gb-nyc3-01 kernel: audit: type=1400 audit(1503515976.446:751): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" Aug 23 19:19:36 ubuntu-1gb-nyc3-01 kernel: audit: type=1400 audit(1503515976.446:752): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" Aug 23 19:19:36 ubuntu-1gb-nyc3-01 kernel: audit: type=1400 audit(1503515976.446:753): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" Aug 23 19:19:37 ubuntu-1gb-nyc3-01 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE Aug 23 19:19:48 ubuntu-1gb-nyc3-01 sudo[27025]: root : TTY=pts/0 ; PWD=/root ; USER=root ; COMMAND=/bin/journalctl -xe Aug 23 19:19:48 ubuntu-1gb-nyc3-01 sudo[27025]: pam_unix(sudo:session): session opened for user root by root(uid=0) ``` <^>tail -30 /var/log/mysql/error.log<^> ``` 2017-08-23T19:22:08.951104Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2017-08-23T19:22:08.951207Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2017-08-23T19:22:09.177161Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-08-23T19:22:09.181318Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-0ubuntu0.16.04.1) starting as process 27514 ... 2017-08-23T19:22:09.190896Z 0 [Note] InnoDB: PUNCH HOLE support available 2017-08-23T19:22:09.190945Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-23T19:22:09.190960Z 0 [Note] InnoDB: Uses event mutexes 2017-08-23T19:22:09.190971Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-08-23T19:22:09.190980Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-08-23T19:22:09.190990Z 0 [Note] InnoDB: Using Linux native AIO 2017-08-23T19:22:09.191768Z 0 [Note] InnoDB: Number of pools: 1 2017-08-23T19:22:09.192044Z 0 [Note] InnoDB: Using CPU crc32 instructions 2017-08-23T19:22:09.195523Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2017-08-23T19:22:09.213977Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-08-23T19:22:09.219177Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-08-23T19:22:09.233451Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-23T19:22:09.252993Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-08-23T19:22:09.253125Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-08-23T19:22:09.264465Z 0 [Warning] InnoDB: 1048576 bytes should have been written. Only 851968 bytes written. Retrying for the remaining bytes. 2017-08-23T19:22:09.264519Z 0 [Warning] InnoDB: Retry attempts for writing partial data failed. 2017-08-23T19:22:09.264539Z 0 [ERROR] InnoDB: Write to file ./ibtmp1failed at offset 5242880, 1048576 bytes should have been written, only 851968 were written. Operating system error number 28. Check that your OS and file s2017-08-23T19:22:09.866980Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-08-23T19:22:09.867026Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2017-08-23T19:22:09.867033Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-08-23T19:22:09.867040Z 0 [ERROR] Failed to initialize plugins. 2017-08-23T19:22:09.867043Z 0 [ERROR] Aborting 2017-08-23T19:22:09.867049Z 0 [Note] Binlog end 2017-08-23T19:22:09.867098Z 0 [Note] Shutting down plugin 'MyISAM' 2017-08-23T19:22:09.867485Z 0 [Note] /usr/sbin/mysqld: Shutdown complete ``` and i'm using ubuntu 16.04(1gb) Droplet Thanks in advance
-
question
100% CPU usage - Magento website - Demo server - 1 GB/1 CPU plan
Hi, We have demo server set-up couple of months ago. Recently we upgraded to DO updated Graphs. We see that CPU usage is 90-100%! As this is demo, we do not expected any users!!! After getting advise from DO, we upgraded to Apache2-Prefork and PHP-FPM. I confirmed through command prompt and phpinfo() that both are successfully done. I also installed HTOP. Please see below snapshot of HTOP: https://ibb.co/bQWB6Q Waiting for expert opinion and insight.
-
question
phpMyAdmin to manage remote database
Hello guys, I am using two droplets for my application: one is running mySQL only, the other one runs Nginx (PHP, mysql-client etc.). I have followed this tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql to set things up. Everything is running fine but I would love to manage the MySQL database from the second droplet where I already have a running webserver. I can install it but how can I tell phpMyAdmin to use the remote datebase? It looks like it tries to create a new database on the very droplet to manage its settings but the installation routine leaves no place to change that behaviour. Any help? Thanks, Dominik
Hi there. To be able to give any advice, can you please share what’s your Droplet size and what services are you running on it?