Not sure how you are using serverpilot on Linode, but the memory looks OK- it shows the majority taken up by caching-

http://www.linuxatemyram.com/

@bryantrv:

Not sure how you are using serverpilot on Linode, but the memory looks OK- it shows the majority taken up by caching-

http://www.linuxatemyram.com/

That happened after i optimized the DB of all 4 blogs… check below

> root@webentrapments:~# free -m

total used free shared buffers cached

Mem: 1999 1830 169 0 7 42

-/+ buffers/cache: 1779 219

Swap: 255 234 21

root@webentrapments:~#

Here readings for the past 30M

https://www.dropbox.com/s/5lv2y43jkwt5m … 9.png?dl=0">https://www.dropbox.com/s/5lv2y43jkwt5m28/Screenshot_2015-08-28-18-44-29.png?dl=0

I don't see a problem here. Looks fine to me.

-Chris

@caker:

I don't see a problem here. Looks fine to me.

-Chris

Hello;

Here is a reading from newrelic

~~https://www.dropbox.com/s/5lv2y43jkwt5m … -44-29.png">https://www.dropbox.com/s/5lv2y43jkwt5m28/Screenshot_2015-08-28-18-44-29.png" />

https://www.dropbox.com/s/5lv2y43jkwt5m … -44-29.png">https://www.dropbox.com/s/5lv2y43jkwt5m28/Screenshot_2015-08-28-18-44-29.png

> Mem 93.6 %

my database server is offline,~~

Here is a screenshot https://drive.google.com/file/d/0BxlVq3 … p=drivesdk">https://drive.google.com/file/d/0BxlVq3SdH3IKZ0EtLS1RZzRsLWs/view?usp=drivesdk

here is error log from /var/log/mysql

> 150828 19:45:56 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.

150828 19:45:56 [Note] Plugin 'FEDERATED' is disabled.

150828 19:45:56 InnoDB: The InnoDB memory heap is disabled

150828 19:45:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins

150828 19:45:56 InnoDB: Compressed tables use zlib 1.2.8

150828 19:45:56 InnoDB: Using Linux native AIO

150828 19:45:56 InnoDB: Initializing buffer pool, size = 128.0M

InnoDB: mmap(137363456 bytes) failed; errno 12

150828 19:45:56 InnoDB: Completed initialization of buffer pool

150828 19:45:56 InnoDB: Fatal error: cannot allocate memory for the buffer pool

150828 19:45:56 [ERROR] Plugin 'InnoDB' init function returned error.

150828 19:45:56 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

150828 19:45:56 [ERROR] Unknown/unsupported storage engine: InnoDB

150828 19:45:56 [ERROR] Aborting

150828 19:45:56 [Note] /usr/sbin/mysqld: Shutdown complete

Here is the default settings for mysql

> #

The MySQL database server configuration file.

#

You can copy this to one of:

- "/etc/mysql/my.cnf" to set global options,

- "~/.my.cnf" to set user-specific options.

#

One can use all long options that the program supports.

Run program with –help to get a list of available options and with

--print-defaults to see which it would actually understand and use.

#

For explanations see

http://dev.mysql.com/doc/mysql/en/serve … ables.html">http://dev.mysql.com/doc/mysql/en/server-system-variables.html

This will be passed to all mysql clients

It has been reported that passwords should be enclosed with ticks/quotes

escpecially if they contain "#" chars…

Remember to edit /etc/mysql/debian.cnf when changing the socket location.

[client]

port = 3306

socket = /var/run/mysqld/mysqld.sock

Here is entries for some specific programs

The following values assume you have at least 32M ram

This was formally known as [safe_mysqld]. Both versions are currently parsed.

[mysqld_safe]

socket = /var/run/mysqld/mysqld.sock

nice = 0

[mysqld]

#

* Basic Settings

#

user = mysql

pid-file = /var/run/mysqld/mysqld.pid

socket = /var/run/mysqld/mysqld.sock

port = 3306

basedir = /usr

datadir = /var/lib/mysql

tmpdir = /tmp

lc-messages-dir = /usr/share/mysql

skip-external-locking

#

Instead of skip-networking the default is now to listen only on

localhost which is more compatible and is not less secure.

bind-address = 127.0.0.1

#

* Fine Tuning

#

key_buffer = 16M

maxallowedpacket = 16M

thread_stack = 192K

threadcachesize = 8

This replaces the startup script and checks MyISAM tables if needed

the first time they are touched

myisam-recover = BACKUP

max_connections = 100

table_cache = 64

thread_concurrency = 10

#

* Query Cache Configuration

#

querycachelimit = 1M

querycachesize = 16M

tmptablesize = 16M

maxheaptable_size = 16M

local-infile =0

#

* Logging and Replication

#

Both location gets rotated by the cronjob.

Be aware that this log type is a performance killer.

As of 5.1 you can enable the log at runtime!

generallogfile = /var/log/mysql/mysql.log

general_log = 1

#

Error log - should be very few entries.

#

log_error = /var/log/mysql/error.log

#

Here you can see queries with especially long duration

logslowqueries = /var/log/mysql/mysql-slow.log

longquerytime = 2

log-queries-not-using-indexes

#

The following can be used as easy to replay backup logs or for replication.

note: if you are setting up a replication slave, see README.Debian about

other settings you may need to change.

server-id = 1

log_bin = /var/log/mysql/mysql-bin.log

expirelogsdays = 10

maxbinlogsize = 100M

binlogdodb = includedatabasename

binlogignoredb = includedatabasename

#

* InnoDB

#

InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.

Read the manual for more InnoDB related options. There are many!

#

* Security Features

#

Read the manual, too, if you want chroot!

chroot = /var/lib/mysql/

#

For generating SSL certificates I recommend the OpenSSL GUI "tinyca".

#

ssl-ca=/etc/mysql/cacert.pem

ssl-cert=/etc/mysql/server-cert.pem

ssl-key=/etc/mysql/server-key.pem

[mysqldump]

quick

quote-names

maxallowedpacket = 16M

[mysql]

no-auto-rehash # faster start of mysql but no tab completition

[isamchk]

key_buffer = 16M

#

* IMPORTANT: Additional settings that can override those from this file!

The files must end with '.cnf', otherwise they'll be ignored.

#

!includedir /etc/mysql/conf.d/

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)