255 lines
10 KiB
PHP
255 lines
10 KiB
PHP
<?php
|
|
|
|
/**
|
|
* Index WP MySQL For Speed
|
|
*
|
|
* @author: Oliver Jones, Rick James
|
|
* @copyright: 2022 Oliver Jones
|
|
* @license GPL-2.0-or-later
|
|
*
|
|
* @wordpress-plugin0
|
|
* Plugin Name: Index WP MySQL For Speed
|
|
* Plugin URI: https://plumislandmedia.org/index-wp-mysql-for-speed/
|
|
* Description: Speed up your WordPress site by adding high-performance keys (database indexes) to your MySQL database tables.
|
|
* Version: 1.5.2
|
|
* Requires at least: 4.2
|
|
* Tested up to: 6.6.2
|
|
* Requires PHP: 5.6
|
|
* Author: OllieJones, rjasdfiii
|
|
* Author URI: https://github.com/OllieJones
|
|
* License: GPL v2 or later
|
|
* License URI: https://www.gnu.org/licenses/gpl-2.0.html
|
|
* GitHub Plugin URI: https://github.com/OllieJones/index-wp-mysql-for-speed
|
|
* Primary Branch: main
|
|
* Text Domain: index-wp-mysql-for-speed
|
|
* Domain Path: /languages
|
|
* Network: true
|
|
* Tags: database, index, key, mysql, wp-cli
|
|
*/
|
|
|
|
/** current version number */
|
|
define( 'index_wp_mysql_for_speed_VERSION_NUM', '1.5.2' );
|
|
define( 'index_mysql_for_speed_major_version', 1.5 );
|
|
define( 'index_mysql_for_speed_inception_major_version', 1.3 );
|
|
define( 'index_mysql_for_speed_inception_wp_version', '5.8.3' );
|
|
define( 'index_mysql_for_speed_inception_wp_db_version', 49752 );
|
|
define( 'index_mysql_for_speed_log', null );
|
|
|
|
/* set up some handy globals */
|
|
define( 'index_wp_mysql_for_speed_PLUGIN_NAME', trim( dirname( plugin_basename( __FILE__ ) ), '/' ) );
|
|
define( 'index_wp_mysql_for_speed_stats_endpoint', 'https://upload.plumislandmedia.net/wp-json/plumislandmedia/v1/upload' );
|
|
define( 'index_wp_mysql_for_speed_monitor', 'imfsQueryMonitor' );
|
|
define( 'index_wp_mysql_for_speed_querytag', '*imfs-query-tag*' );
|
|
/* version 32814 was the advent of utfmb4 */
|
|
define( 'index_wp_mysql_for_speed_first_compatible_db_version', 31536 );
|
|
define( 'index_wp_mysql_for_speed_last_compatible_db_version', 0 ); /*tested up to 58975 */
|
|
|
|
define( 'index_wp_mysql_for_speed_help_site', 'https://plumislandmedia.net/index-wp-mysql-for-speed/' );
|
|
|
|
register_activation_hook( __FILE__, 'index_wp_mysql_for_speed_activate' );
|
|
register_deactivation_hook( __FILE__, 'index_wp_mysql_for_speed_deactivate' );
|
|
|
|
add_action( 'init', 'index_wp_mysql_for_speed_do_everything' );
|
|
|
|
function index_wp_mysql_for_speed_do_everything( ) {
|
|
|
|
// define( 'INDEX_WP_MYSQL_FOR_SPEED_TEST', true ); /*tested up to 53932 */
|
|
if ( defined ('INDEX_WP_MYSQL_FOR_SPEED_TEST') && INDEX_WP_MYSQL_FOR_SPEED_TEST) {
|
|
require_once( plugin_dir_path( __FILE__ ) . 'tests/test-update-filter.php' );
|
|
}
|
|
/* admin page activation */
|
|
$admin = is_admin();
|
|
if ( $admin ) {
|
|
$userCanLoad = is_multisite() ? is_super_admin() : current_user_can( 'activate_plugins' );
|
|
if ( $userCanLoad ) {
|
|
/* recent install or upgrade ? */
|
|
if ( index_wp_mysql_for_speed_plugin_updated() ) {
|
|
index_wp_mysql_for_speed_activate_mu_plugin();
|
|
}
|
|
$nag = index_wp_mysql_for_speed_nag();
|
|
index_wp_mysql_for_speed_require( $nag );
|
|
add_filter( 'plugin_action_links_' . plugin_basename( __FILE__ ), 'index_wp_mysql_for_speed_action_link' );
|
|
}
|
|
}
|
|
/* wp-cli interface activation */
|
|
if ( defined( 'WP_CLI' ) && WP_CLI ) {
|
|
require_once( plugin_dir_path( __FILE__ ) . 'code/cli.php' );
|
|
index_wp_mysql_for_speed_require();
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Figure out whether user hasn't yet added or updated indexes.
|
|
* Doing anything on the highperf index page clears this.
|
|
* We check for plugin major version updates and wp database version updates.
|
|
* @return string|false
|
|
*/
|
|
function index_wp_mysql_for_speed_nag() {
|
|
global $wp_version, $wp_db_version;
|
|
$result = false;
|
|
if ( ! function_exists( 'wp_doing_ajax' ) || ! wp_doing_ajax() ) {
|
|
$imfsPage = get_option( 'ImfsPage' );
|
|
$majorVersion = ( $imfsPage !== false && isset( $imfsPage['majorVersion'] ) && is_numeric( $imfsPage['majorVersion'] ) )
|
|
? floatval( $imfsPage['majorVersion'] ) : index_mysql_for_speed_inception_major_version;
|
|
$savedWpVersion = ( $imfsPage !== false && isset( $imfsPage['wp_version'] ) ) ? $imfsPage['wp_version'] : index_mysql_for_speed_inception_wp_version;
|
|
$savedDbVersion = ( $imfsPage !== false && isset( $imfsPage['wp_db_version'] ) ) ? $imfsPage['wp_db_version'] : index_mysql_for_speed_inception_wp_db_version;
|
|
if ( ! $imfsPage ) {
|
|
$result = 'add';
|
|
} else if ( $wp_db_version != $savedDbVersion ) {
|
|
$result = 'version_update';
|
|
} else if ( $majorVersion !== index_mysql_for_speed_major_version ) {
|
|
$result = 'update';
|
|
}
|
|
}
|
|
|
|
return $result;
|
|
}
|
|
|
|
/**
|
|
* Is the plugin or the installation recently updated?
|
|
* @return bool
|
|
*/
|
|
function index_wp_mysql_for_speed_plugin_updated() {
|
|
global $wp_version, $wp_db_version;
|
|
if ( ! function_exists( 'wp_doing_ajax' ) || ! wp_doing_ajax() ) {
|
|
$imfsPage = get_option( 'ImfsPage' );
|
|
|
|
$savedPluginVersion = ( $imfsPage !== false && isset( $imfsPage['plugin_version'] ) ) ? $imfsPage['plugin_version'] : '';
|
|
$savedWpVersion = ( $imfsPage !== false && isset( $imfsPage['wp_version'] ) ) ? $imfsPage['wp_version'] : '';
|
|
$savedDbVersion = ( $imfsPage !== false && isset( $imfsPage['wp_db_version'] ) ) ? $imfsPage['wp_db_version'] : '';
|
|
|
|
return ( index_wp_mysql_for_speed_VERSION_NUM !== $savedPluginVersion )
|
|
|| ( $wp_version !== $savedWpVersion )
|
|
|| ( $wp_db_version !== $savedDbVersion );
|
|
}
|
|
return false;
|
|
}
|
|
|
|
add_action( 'init', 'index_wp_mysql_for_speed_monitor', 0 );
|
|
|
|
function index_wp_mysql_for_speed_monitor() {
|
|
/* monitoring code ... as light as possible when not monitoring. */
|
|
$monval = get_option( index_wp_mysql_for_speed_monitor );
|
|
if ( $monval ) {
|
|
if ( $monval->stoptime > time() ) {
|
|
$admin = is_admin();
|
|
if ( ( ( $monval->targets & 1 ) !== 0 && $admin ) || ( ( $monval->targets & 2 ) !== 0 && ! $admin ) ) {
|
|
if ( $monval->samplerate === 1.0 || rand() <= $monval->samplerate * getrandmax() ) {
|
|
require_once( plugin_dir_path( __FILE__ ) . 'code/querymon.php' );
|
|
new ImfsMonitor( $monval, 'capture' );
|
|
}
|
|
}
|
|
} else {
|
|
require_once( plugin_dir_path( __FILE__ ) . 'code/querymon.php' );
|
|
$m = new ImfsMonitor( $monval, 'nocapture' );
|
|
$m->completeMonitoring();
|
|
update_option( index_wp_mysql_for_speed_monitor, null, true );
|
|
}
|
|
}
|
|
//}
|
|
/* wp-cli interface activation */
|
|
if ( defined( 'WP_CLI' ) && WP_CLI ) {
|
|
require_once( plugin_dir_path( __FILE__ ) . 'code/cli.php' );
|
|
index_wp_mysql_for_speed_require();
|
|
}
|
|
}
|
|
|
|
function index_wp_mysql_for_speed_require( $nag = false ) {
|
|
if ( ! function_exists('index_wp_mysql_for_speed_timestamp' ) ) {
|
|
/** Show timestamp in localtime.
|
|
* Polyfill, for old wp lacking wp_date
|
|
*
|
|
* @return string
|
|
*/
|
|
function index_wp_mysql_for_speed_timestamp( $format, $timestamp = null ) {
|
|
|
|
$saved = date_default_timezone_get();
|
|
date_default_timezone_set( get_option( 'timezone_string', 'UTC' ) );
|
|
$result = date( $format, $timestamp ?: time() );
|
|
date_default_timezone_set( $saved );
|
|
|
|
return $result;
|
|
}
|
|
}
|
|
|
|
require_once( plugin_dir_path( __FILE__ ) . 'code/imsfdb.php' );
|
|
require_once( plugin_dir_path( __FILE__ ) . 'afp/admin-page-framework.php' );
|
|
require_once( plugin_dir_path( __FILE__ ) . 'code/admin.php' );
|
|
require_once( plugin_dir_path( __FILE__ ) . 'code/upload.php' );
|
|
require_once( plugin_dir_path( __FILE__ ) . 'code/querymoncontrol.php' );
|
|
require_once( plugin_dir_path( __FILE__ ) . 'code/notice.php' );
|
|
new ImfsNotice ( $nag );
|
|
}
|
|
|
|
function index_wp_mysql_for_speed_activate() {
|
|
if ( version_compare( get_bloginfo( 'version' ), '4.2', '<' ) ) {
|
|
deactivate_plugins( basename( __FILE__ ) ); /* fail activation */
|
|
return;
|
|
}
|
|
update_option( index_wp_mysql_for_speed_monitor, null, true );
|
|
index_wp_mysql_for_speed_activate_mu_plugin();
|
|
}
|
|
|
|
/** Install the mu plugin to filter DDL.
|
|
* @return void
|
|
*/
|
|
function index_wp_mysql_for_speed_activate_mu_plugin() {
|
|
try {
|
|
/* install mu-plugin for handling version upgrades to tables */
|
|
$filterName = 'index-wp-mysql-for-speed-update-filter.php';
|
|
|
|
$src = trailingslashit( plugin_dir_path( __FILE__ ) ) . 'code/assets/mu/' . $filterName;
|
|
$dest = trailingslashit( WPMU_PLUGIN_DIR ) . $filterName;
|
|
|
|
if ( ! file_exists( $dest ) ) {
|
|
/* Make sure the `mu-plugins` directory exists. It might not in a standard install */
|
|
if ( ! is_dir( WPMU_PLUGIN_DIR ) ) {
|
|
wp_mkdir_p( WPMU_PLUGIN_DIR );
|
|
}
|
|
|
|
/* Copy the little must-use plugin to the mu-plugins directory. */
|
|
$result = copy( $src, $dest );
|
|
if ( ! $result ) {
|
|
/* translators: this goes into error_log() */
|
|
error_log( __( 'index-wp-mysql-for-speed: Unable to set up the mu-plugin to filter data definition language when preparing for a WordPress upgrade.', 'index-wp-mysql-for-speed' ) );
|
|
}
|
|
}
|
|
} catch ( Exception $exception ) {
|
|
/* translators: this goes into error_log() */
|
|
error_log( $exception->getMessage() . ': ' . __( 'index-wp-mysql-for-speed: Exception setting up the mu-plugin to filter data definition language when preparing for a WordPress upgrade.', 'index-wp-mysql-for-speed' ) );
|
|
}
|
|
}
|
|
|
|
function index_wp_mysql_for_speed_deactivate() {
|
|
/* clean up emphemeral options */
|
|
delete_option( 'imfsQueryMonitor' );
|
|
delete_option( 'imfsQueryMonitornextMonitorUpdate' );
|
|
delete_option( 'imfsQueryMonitorGather' );
|
|
delete_option( index_wp_mysql_for_speed_monitor );
|
|
/* Delete the mu-plugin for handling upgrades. */
|
|
$filterName = 'index-wp-mysql-for-speed-update-filter.php';
|
|
$dest = trailingslashit( WPMU_PLUGIN_DIR ) . $filterName;
|
|
if ( file_exists( $dest ) ) {
|
|
if ( ! @unlink( $dest ) ) {
|
|
/* translators: this goes into error_log() */
|
|
error_log( __( 'index-wp-mysql-for-speed: Unable to remove the mu-plugin to filter data definition language.', 'index-wp-mysql-for-speed' ) );
|
|
}
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Add Settings link to this plugin's listing on the Plugins page.
|
|
*
|
|
* @param $actions
|
|
*
|
|
* @return array
|
|
*/
|
|
function index_wp_mysql_for_speed_action_link( $actions ) {
|
|
/* translators: for settings link on plugin page */
|
|
$name = __( "Settings", 'index-wp-mysql-for-speed' );
|
|
$mylinks = [
|
|
'<a href="' . admin_url( 'tools.php?page=imfs_settings' ) . '">' . $name . '</a>',
|
|
];
|
|
|
|
return array_merge( $mylinks, $actions );
|
|
}
|
