@scottalanmiller said in MySQL/Wordpress issue:

@wls-itguy said in MySQL/Wordpress issue:

@scottalanmiller said in MySQL/Wordpress issue:

@wls-itguy said in MySQL/Wordpress issue:

@jmoore It is when I restart the service. and then about 30-90 seconds later it stops again.

@DustinB3403 What do you mean by using top?

The top command. But it isn't a good tool for that. For immediately memory use this instead free -m

Total 3948 used 343

The full output would be best, but that gives us a starting point.

root@www:~# free -m
             total       used       free     shared    buffers     cached
Mem:          3948        347       3601          0          5         37
-/+ buffers/cache:        304       3644
Swap:          511         19        492

@scottalanmiller said in MySQL/Wordpress issue:

Can I get the output of **df -h ** as well?

Filesystem Size Used Avail Use% Mounted on
/dev/root 16G 14G 2.6G 84% /
devtmpfs 2.0G 0 2.0G 0% /dev
tmpfs 395M 196K 395M 1% /run
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 893M 0 893M 0% /run/shm

@scottalanmiller said in MySQL/Wordpress issue:

@wls-itguy said in MySQL/Wordpress issue:

@jmoore It is when I restart the service. and then about 30-90 seconds later it stops again.

@DustinB3403 What do you mean by using top?

The top command. But it isn't a good tool for that. For immediately memory use this instead free -m

Total 3948 used 343

@jmoore It is when I restart the service. and then about 30-90 seconds later it stops again.

@DustinB3403 What do you mean by using top?

@jmoore
When I restart MySQL I get this:

Checking for tables which need an upgrade, are corrupt or were
not closed cleanly..

@aaronstuder said in MySQL/Wordpress issue:

@wls-itguy How much RAM?

@wls-itguy said in MySQL/Wordpress issue:

4GB plan through Linode.

Now that I think about it. We resized (downsized) about 2 months ago and I'd like to think that it was around that time (maybe a little later) that this issue showed up.

4GB plan through Linode.

running Debian 7

In another search I found said to run 'find / -type s | grep mysqld.sock'

And I got the following results.

find: /proc/8311/task/8311/fd/5': No such file or directory find: /proc/8311/task/8311/fdinfo/5': No such file or directory
find: /proc/8311/fd/5': No such file or directory find: /proc/8311/fdinfo/5': No such file or directory

Not sure what that means

Yes. Linode host. I have checked space on the server and there is no issue there.

Good Morning All,

I have been having this issue with MySQL on our main website where out of the blue MySQL services stop. I get this error on the page:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /var/www/wls.wels.net/public_html/wp-includes/wp-db.php on line 1568

And usually if I restart the services all is good for about a week. Now it doesn't even take 2-3 minutes before the services stop again.

I have run through some things that I found on searches but nothing has fixed the issue so far. I am not a linux/MySQL guru by any means and any kick in a better direction would be greatly appreciated.

Jeff

@brandon220 Do you need the FXO and the card? I have a bunch of those laying around after we switched a few phones from Analog to full digital.

@marcinozga said in MySQL/PHP issue.:

@WLS-ITGuy line Loaded Configuration File: will give you config location.

Yup. Got it. Changed the memory_limit there and was able to run the script without using -d.

@marcinozga Gives me a list of files pulled from /etc/php5/cli/

@marcinozga
Gotcha! Thanks for the help!

@marcinozga said in MySQL/PHP issue.:

Just to clarify, -d option allows you to override any php settings.

OK. So why would php.ini show that it is allowing 2G but not actually allow 2G?

@marcinozga said in MySQL/PHP issue.:

php -d memory_limit=2048M admin/cli/mysql_compressed_rows.php --list

That all worked! And now I am on to the next part of the upgrade!

@marcinozga

Yes. If I CD to /var/www/moodle/ and run 'php admin/cli/mysql_compressed_rows.php --list' I get PHP Fatal error: Allowed memory size of 262144 bytes exhausted (tried to allocate 49152 bytes) in var/www/moodle/admin/cli/mysql_compressed_rows.php on line 152

@marcinozga said in MySQL/PHP issue.:

Actually, you might have more than one php.ini file. Create info.php file with this content:

<?php phpinfo(); ?>

and visit it in web browser. See what memory limits it shows and where could additional configs be located.

@marcinozga said in MySQL/PHP issue.:

Increase it temporarily to 2048M, or higher, and drop down once the conversion is done. Restart apache/nginx/other web server, or restart php-fpm if it's used instead after each config change.

Has been set at 2048M, restarted apache and rebooted server and still get the same error.