hmseb

Possible I don’t remember, there’s so many plugin updates all the time…

From what I’ve seen, the memory in myPhpAdmin is getting full, then the cpu usage goes crazy, the mysql gets shutdown. When the mysql server comes back up, everything is working fine for a few hours.

I haven’t tried switching themes, I have this theme since September, never had an issue before.

I doubt it, I only have 25 products and when I run P3 it doesn’t crash automatically.

I’ve also raise the memory limit to 256MB and the memory of a script to 64MB.

I just don’t get what can cause this many cache in the memory https://i.imgur.com/3zB9DsW.png

Here are the lines from my debug file from the last crash.

[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:49 UTC] PHP Warning: mysql_connect(): Too many connections in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:51 UTC] PHP Warning: mysqli_real_connect(): MySQL server has gone away in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:51 UTC] PHP Warning: mysqli_real_connect(): Error while reading greeting packet. PID=6953 in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:51 UTC] PHP Warning: mysqli_real_connect(): (HY000/2006): MySQL server has gone away in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:51 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:51 UTC] PHP Warning: mysql_connect(): Connection refused in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:12:56 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): Connection refused in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:12:57 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): Connection refused in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysqli_real_connect(): MySQL server has gone away in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysqli_real_connect(): MySQL server has gone away in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysqli_real_connect(): MySQL server has gone away in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2006): MySQL server has gone away in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysqli_real_connect(): Error while reading greeting packet. PID=7162 in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysqli_real_connect(): Error while reading greeting packet. PID=7159 in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2006): MySQL server has gone away in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysqli_real_connect(): (HY000/2006): MySQL server has gone away in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:09 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:09 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:09 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysql_connect(): Connection refused in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysql_connect(): Connection refused in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:09 UTC] PHP Warning: mysql_connect(): Connection refused in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:11 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:11 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:11 UTC] PHP Warning: mysql_connect(): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:18 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:18 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:18 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:18 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:18 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:20 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:20 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:20 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:20 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:20 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:21 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:23 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:23 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:23 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:23 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:23 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:24 UTC] PHP Warning: Cannot modify header information – headers already sent by (output started at /home/pinuts/public_html/wp-includes/functions.php:3464) in /home/pinuts/public_html/wp-includes/functions.php on line 3503
[24-Jan-2016 13:13:24 UTC] PHP Warning: Cannot modify header information – headers already sent by (output started at /home/pinuts/public_html/wp-includes/functions.php:3464) in /home/pinuts/public_html/wp-includes/functions.php on line 3503
[24-Jan-2016 13:13:24 UTC] PHP Warning: Cannot modify header information – headers already sent by (output started at /home/pinuts/public_html/wp-includes/functions.php:3464) in /home/pinuts/public_html/wp-includes/functions.php on line 3503
[24-Jan-2016 13:13:24 UTC] PHP Warning: Cannot modify header information – headers already sent by (output started at /home/pinuts/public_html/wp-includes/functions.php:3464) in /home/pinuts/public_html/wp-includes/functions.php on line 3503
[24-Jan-2016 13:13:24 UTC] PHP Warning: Cannot modify header information – headers already sent by (output started at /home/pinuts/public_html/wp-includes/functions.php:3506) in /home/pinuts/public_html/wp-includes/functions.php on line 3503
[24-Jan-2016 13:13:25 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:26 UTC] PHP Warning: Cannot modify header information – headers already sent by (output started at /home/pinuts/public_html/wp-includes/functions.php:3506) in /home/pinuts/public_html/wp-includes/functions.php on line 3503
[24-Jan-2016 13:13:27 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:28 UTC] PHP Warning: Cannot modify header information – headers already sent by (output started at /home/pinuts/public_html/wp-includes/functions.php:3464) in /home/pinuts/public_html/wp-includes/functions.php on line 3503
[24-Jan-2016 13:13:33 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:33 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:33 UTC] PHP Warning: mysql_connect(): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:33 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1488
[24-Jan-2016 13:13:33 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518
[24-Jan-2016 13:13:33 UTC] PHP Warning: mysql_connect(): No such file or directory in /home/pinuts/public_html/wp-includes/wp-db.php on line 1518

I see this error in a “deprecated log” plugin, but I don’t have any other details…

The line 1209 in wp-db.php that’s its referring to is:
public function escape_by_ref( &$string ) {
if ( ! is_float( $string ) )
$string = $this->_real_escape( $string );
}

All wp installations and plugins are up to date.

I also have a lot of these:

Incorrect Use of QM_DB()
Used in wp-includes/wp-db.php on line 1209.

Oh well, back to square one…

The build up happened again, but it seems to be slower.

FYI

I’ve been deactivating plugins on the website I thought was the problem and running P3 after every deactivation.

Seems like “Query Monitor” or “itheme sync” plugin was the one causing the memory build up, ever since I’ve deactivated those 2, the ram seems to be stable. Maybe there’s a conflict with something else…

I’ll be monitoring everything for the next few hours/days.

Thanks for that suggestion!

I get your point, but I’m pretty sure it’s one of the 4 sites that is the cause.

Let I would have narrowed it down to the website responsible, what would be the next step?

Yeah it’s a short interruption, but for one site with ecommerce it isn’t good…

It varies, but yes I can see the memory build up.

Ok, but once I identified what site is causing it, how do I find the source into that website?

1-
/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);

So this should be alright.

2- Regarding the memory, I see this in my slow query plugin: 256M Overridden at runtime from 512M

I’ll try to figure this out, I don’t know what overrides it…

3-Downtime is usually a few minutes, CPU spikes, MySQL server goes down and everything comes back up.

So all sites are malware free.

Do you see anything in the logs that could point to something?

Yeah well support of the hosting company are not really helping out, from time to time they say “install a cache plugin” “it might be sql related” “you don’t have enough ram, upgrade your package”… There’s never a clear answer to what is the cause of this.

I’ll scan the site to make sure there’s no malware

These are the logs for the last 24h, if that can help.

https://dl.dropboxusercontent.com/u/5725048/Pinuts%20Logs.txt

I don’t, all I have for now is the debug.log from WP.