-
Published Answer
answering my own question, seems the zero date setting just took a while to appear
•
By
gabba
-
Published Question
Having trouble transferring large databases to a managed database, as the mysql settings seem to be very strict and hard to work round, and when changing the mysql mode via the control panel it doesn't seem to be refl...
2
•
•
By
gabba
DigitalOcean Managed MySQL Database
-
Published Answer
@eleu Mysql seems to have settled down, optimized a few DBs and that seemed to do something.
regarding multiple lsphp instances …
•
By
gabba
-
Published Answer
yes i do the wordpress plugin is enabled and looks to be working fine, its just mysqld which goes between 70% - 300% cpu.
I’ll t…
•
By
gabba
-
Published Answer
yes i’m thinking the same must be a horrible wordpress query from some inherited plugin but still having no joy with slow query log…
•
By
gabba
-
Published Answer
Thanks Eric, i’m trying to get slow query log working, those instructions created the file, but when i try a select sleep(*) it doe…
•
By
gabba
-
Published Question
not sure how to debug this, its a large wordpress site with a big database and showprocesslist isn't giving me many clues, how do i set up a slowquery log on mariadb via ssh/phpmyadmin? and are the some basic mysql se...
9
•
•
By
gabba
MariaDB
MySQL
Ubuntu 18.04
WordPress
-
Published Answer
thanks Eric, i’ll keep an eye on it, but your right must be a file from the migration, just strange it ended up in the theme direct…
•
By
gabba
-
Published Answer
looks to be a virus:
lrwxrwxrwx 1 www-data www-data 0 Apr 18 02:49 /proc/23393/exe -> /var/www/html/wp-content/themes/twentynin…
•
By
gabba
-
Published Question
I've built a openlitespeed/wordpress droplet with a few virtual hosts, and its working very well, however after being up for a day or so CPU suddenly spikes with random command, this from top:
PID USER PR NI ...
3
•
•
By
gabba
Apache
Linux Basics
Ubuntu 18.04
-
Published Question
I'm trying to download a huge database from a droplet, its probably too big for PhpMyAdmin so i'm trying to run mysqldump from terminal and the sftp to grab the resulting file, however every option i try via terminal ...
1
•
•
By
gabba
MySQL