gabba
11 contributions
4.5k contribution views
Recognition
Posts
-
Published Answer
Transfering wordpress databases to managed database
answering my own question, seems the zero date setting just took a while to appear -
Published Question
Transfering wordpress databases to managed database
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... -
Published Answer
intermittent high myqld load on wordpress/openlitespeed droplet
@eleu Mysql seems to have settled down, optimized a few DBs and that seemed to do something. regarding multiple lsphp instances … -
Published Answer
intermittent high myqld load on wordpress/openlitespeed droplet
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… -
Published Answer
intermittent high myqld load on wordpress/openlitespeed droplet
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… -
Published Answer
intermittent high myqld load on wordpress/openlitespeed droplet
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… -
Published Question
intermittent high myqld load on wordpress/openlitespeed droplet
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... -
Published Answer
Openlitespeed droplet keeps spiking at 400% cpu with a random command name, stops on reboot, timestamp settings?
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… -
Published Answer
Openlitespeed droplet keeps spiking at 400% cpu with a random command name, stops on reboot, timestamp settings?
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… -
Published Question
Openlitespeed droplet keeps spiking at 400% cpu with a random command name, stops on reboot, timestamp settings?
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 ... -
Published Question
mysqldump on an Ubuntu PhpMyAdmin droplet
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 ...