Centos Oneliners - Revision history

Brian: /* Wordpress Mysql Hacks */

2019-05-30T22:26:15Z

‎Wordpress Mysql Hacks

2017-09-12T16:47:15Z

‎Wordpress Mysql Hacks

2017-02-04T13:18:26Z

‎Apache Oneliners

2016-03-25T16:01:37Z

‎Wordpress Mysql Hacks

2014-07-29T13:12:03Z

‎Apache Oneliners

2014-02-18T19:23:07Z

‎Centos Oneliners

2014-02-10T14:33:32Z

‎Centos Oneliners

2014-02-06T21:20:11Z

‎Centos Oneliners

2014-02-06T20:47:03Z

‎Mysql Oneliners

2014-02-06T20:06:43Z

‎Mysql Oneliners

← Older revision		Revision as of 22:26, 30 May 2019
Line 181:		Line 181:
	Verify Disabled		Verify Disabled
	SELECT * FROM wp_options WHERE option_name LIKE '%notify%';		SELECT * FROM wp_options WHERE option_name LIKE '%notify%';
		+
		+	How to remove spam user that do not input a username
		+
		+	DELETE u FROM wp_users u
		+	LEFT JOIN wp_usermeta um1 ON u.id = um1.user_id AND um1.meta_key = 'first_name'
		+	LEFT JOIN wp_usermeta um2 ON u.id = um2.user_id AND um2.meta_key = 'last_name'
		+	WHERE (um1.meta_value IS NULL OR CHAR_LENGTH(um1.meta_value) = 0)
		+	AND (um2.meta_value IS NULL OR CHAR_LENGTH(um2.meta_value) = 0);
		+
		+	DELETE um FROM wp_usermeta um
		+	LEFT JOIN wp_users u ON u.id = um.user_id
		+	WHERE u.id IS NULL;

← Older revision		Revision as of 16:47, 12 September 2017
Line 175:		Line 175:
	Check what Crons are setup in Wordpress		Check what Crons are setup in Wordpress
	SELECT * FROM `wp_options` WHERE `option_name` LIKE '%cron%';		SELECT * FROM `wp_options` WHERE `option_name` LIKE '%cron%';
		+
		+	Disable Comment Notifications Spam
		+	UPDATE wp_options SET option_value="" WHERE option_name LIKE "%notify";
		+
		+	Verify Disabled
		+	SELECT * FROM wp_options WHERE option_name LIKE '%notify%';

@@ Line 66: / Line 66: @@
 IPs using the most bandwidth (in MB) from the last 5000 hits
   tail -5000 ./transfer.log | awk '{tx[$1]+=$10} END {for (x in tx) {print x, "\t", tx[x]/1048576, "M"}}' | sort -k 2n | tail -n 20 | tac
 hits per hour

← Older revision		Revision as of 16:01, 25 March 2016
Line 165:		Line 165:
	UPDATE wp_posts SET guid = replace(guid, 'http://www.oldsite.com','http://www.newsite.com');		UPDATE wp_posts SET guid = replace(guid, 'http://www.oldsite.com','http://www.newsite.com');
	UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldsite.com', 'http://www.newsite.com');		UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldsite.com', 'http://www.newsite.com');
		+
		+	Check what Crons are setup in Wordpress
		+	SELECT * FROM `wp_options` WHERE `option_name` LIKE '%cron%';

@@ Line 18: / Line 18: @@
 ===Apache Oneliners===
 Max_Clients - Check which account is getting the most traffic
   for z in $(find /home/*/var/*/logs/transfer.log); do echo $z; echo '----------'; for x in $(seq -w 0 24); do echo -n "$x  "; grep -c "$(date +%d/%b/%Y:)$x" $z; done;done;
 Check the Number of IP's Connecting over Port 80
   netstat -tn |grep EST| grep :80 | awk '{print $5}'| cut -d: -f1 | sort | uniq -c | sort -rn | head

@@ Line 12: / Line 12: @@
 What process is using up the most memory
   ps aux | awk '{if ($5 != 0 ) print $2,$5,$6,$11}' | sort -k2n
 ===Apache Oneliners===

@@ Line 8: / Line 8: @@
 Strace all php-fpm process by a single user for debugging
   echo; read -p "User Name: " _user_ ;strace -ffTttvs20000 -o ~/strace.$_user_.log $(ps aux | grep php-fpm | grep $_user_ | awk '{print $2}'| sed 's/\([0-9]*\)/\-p \1/g')
 What process is using up the most memory
   ps aux | awk '{if ($5 != 0 ) print $2,$5,$6,$11}' | sort -k2n

@@ Line 80: / Line 80: @@
 Check database size for all databases
   SELECT table_schema "DB Name", Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" FROM information_schema.tables GROUP  BY table_schema;
-Check Free space in the Database
+Check Free space in the Database -  Free space in the tablespace not allocated to any segment
   SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 /1024 "Data Base Size in MB",sum( data_free )/ 1024 / 1024 "Free Space in MB"FROM information_schema.TABLES GROUP BY table_schema ;
 Check when the databases where last updated