seanconklin

SELECT CONCAT( 'ALTER TABLE ', TABLE_NAME, ' ENGINE=InnoDB;' ) 
FROM INFORMATION_SCHEMA.TABLES
WHERE ENGINE = 'MyISAM'
AND table_schema = 'database-name-here';

seanconklin

SELECT post_type, count( post_type )
FROM wp_posts
GROUP BY post_type
ORDER BY count( post_type ) DESC
LIMIT 50;

seanconklin

SELECT meta_key, count( meta_key )
FROM wp_postmeta
GROUP BY `meta_key`
ORDER BY count( meta_key ) DESC
LIMIT 50;

seanconklin

SELECT
	'Autoload KB' as name, ROUND( SUM( LENGTH( option_value ) ) / 1024 ) as size, null as autoload
	FROM wp_options
	WHERE autoload = 'yes'
UNION
	SELECT 'Autoload count', count( * ), null as autoload
	FROM wp_options
	WHERE autoload = 'yes'
UNION (
	SELECT option_name, length( option_value ), autoload

seanconklin

# DEFAULT OFF
#LoadModule mpm_event_module lib/httpd/modules/mod_mpm_event.so

# REQUIRED
LoadModule mpm_prefork_module lib/httpd/modules/mod_mpm_prefork.so

# DEFAULT OFF
#LoadModule mpm_worker_module lib/httpd/modules/mod_mpm_worker.so

# DISABLED

seanconklin

seanconklin

SELECT meta_key, count( meta_key )
FROM wp_usermeta
GROUP BY meta_key
ORDER BY count( meta_key ) DESC
LIMIT 50;

seanconklin

SELECT * FROM wp_posts
WHERE post_type = 'shop_order'
AND post_status IN( 'wc-cancelled', 'wc-completed', 'wc-failed', 'wc-pending' )
AND post_date < CURDATE() - INTERVAL 100 DAY
ORDER BY ID DESC;