The WordPress plugin StatPress (no longer available in the Plugin Directory) is still widely used and still is very slow. Here are some MySQL statements you can use to optimize its performance, as a WordPress optimization tip…
All kudos go to Felipe Ferreira for this one. Read his post Statpress is slow to understand why I posted these MySQL statements here, and what they do.
Where necessary, replace
wp_ with your own MySQL database table prefix.
ALTER TABLE wp_statpress MODIFY DATE INT(8) UNSIGNED NOT NULL; ALTER TABLE wp_statpress ADD KEY (date); ALTER TABLE wp_statpress MODIFY ip CHAR(15) NOT NULL; ALTER TABLE wp_statpress ADD KEY (ip); ALTER TABLE wp_statpress MODIFY spider VARCHAR(16); ALTER TABLE wp_statpress MODIFY feed VARCHAR(16);
ALTER TABLE wp_statpress ADD KEY (spider); ALTER TABLE wp_statpress ADD KEY (feed);
My name is Jan. I am not a hacker, coder, developer, programmer or guru. I am merely a system administrator, doing my daily thing at Vevida in the Netherlands. With over 15 years of experience, my specialties include Windows Server, IIS, Linux (CentOS, Debian), security, PHP, WordPress, websites & optimization. Want to support me and donate? Use this link: https://paypal.me/jreilink.
Automatically flush Redis cache after publishing a WordPress post
WordPress .htaccess security best practices in Apache 2.4.6+
Set WP_MEMORY_LIMIT value correctly in wp-config.php
How to: Protect WordPress from brute-force XML-RPC attacks
Remove Jetpack email sharing service
How to make Twenty Seventeen theme full width in WordPress
Check WordPress Core files integrity
Clear PHP opcode caches before WordPress Updates: ease the updating process