Title: hungpham's Replies | WordPress.org --- # hungpham [ ](https://wordpress.org/support/users/hungpham/) * [Profile](https://wordpress.org/support/users/hungpham/) * [Topics Started](https://wordpress.org/support/users/hungpham/topics/) * [Replies Created](https://wordpress.org/support/users/hungpham/replies/) * [Reviews Written](https://wordpress.org/support/users/hungpham/reviews/) * [Topics Replied To](https://wordpress.org/support/users/hungpham/replied-to/) * [Engagements](https://wordpress.org/support/users/hungpham/engagements/) * [Favorites](https://wordpress.org/support/users/hungpham/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 114 total) 1 [2](https://wordpress.org/support/users/hungpham/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/hungpham/replies/page/3/?output_format=md)… [6](https://wordpress.org/support/users/hungpham/replies/page/6/?output_format=md) [7](https://wordpress.org/support/users/hungpham/replies/page/7/?output_format=md) [8](https://wordpress.org/support/users/hungpham/replies/page/8/?output_format=md) [→](https://wordpress.org/support/users/hungpham/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Index WP MySQL For Speed] I have variation swatches and when i use the plugin they taxonomy disappears](https://wordpress.org/support/topic/i-have-variation-swatches-and-when-i-use-the-plugin-they-taxonomy-disappears/) * [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [7 months ago](https://wordpress.org/support/topic/i-have-variation-swatches-and-when-i-use-the-plugin-they-taxonomy-disappears/#post-18669076) * [This plugin](https://vi.wordpress.org/plugins/woo-variation-swatches/), is that correct? I have been using that for a site for quite a long time, it’s working fine with Index WP MySQL For Speed. Are you able to check the server error log? Is there anything there? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Wordfence Security - Firewall, Malware Scan, and Login Security] autoload column in wp_wfls_settings table](https://wordpress.org/support/topic/autoload-column-in-wp_wfls_settings-table/) * Thread Starter [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [7 months, 2 weeks ago](https://wordpress.org/support/topic/autoload-column-in-wp_wfls_settings-table/#post-18652329) * Thank you. I am using mysqldumpslow, and yes, when checking the slow log manually, I see the correct request is SELECT `name`, `value` FROM `wp_wfls_settings ` WHERE `autoload` = ‘yes’; Sorry for not checking that before. * However, even the query is fast, it calls many times. Like today: * Count: 61783  Time=0.00s (16s)  Lock=0.00s (6s)  Rows_sent=29.9 (1846350), Rows_examined =29.9 (1846350), Rows_affected=0.0 (0), 2users@localhost SELECT `name`, `value` FROM `wp_wfls_settings` WHERE `autoload` = ‘S’ * When will that query be called? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Wordfence Security - Firewall, Malware Scan, and Login Security] autoload column in wp_wfls_settings table](https://wordpress.org/support/topic/autoload-column-in-wp_wfls_settings-table/) * Thread Starter [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [7 months, 3 weeks ago](https://wordpress.org/support/topic/autoload-column-in-wp_wfls_settings-table/#post-18642744) * No, the plugin was installed directly inside wp-admin, so it’s not a modified version. I am not running any other plugin for backing up, it’s done at server level. The query is called many times during a day, not only a specific time. And it’s not only the wp_wfls_settings table, there is query to the wp_wfconfig table too. * Count: 22228  Time=0.00s (4s)  Lock=0.00s (2s)  Rows_sent=29.9 (664902), Rows_examined =29.9 (664902), Rows_affected=0.0 (0), 2users@localhost SELECT `name`, `value` FROM `wp_wfls_settings` WHERE `autoload` = ‘S’ * Count: 19105  Time=0.00s (16s)  Lock=0.00s (2s)  Rows_sent=267.7 (5113785), Rows_examined =289.5 (5531371), Rows_affected=0.0 (0), 2users@localhost SELECT name, val FROM wp_wfconfig WHERE autoload = ‘S’ * Have cleared cache, restarted the server, but still seeing those queries coming up in slow log. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Index WP MySQL For Speed] Will this help with the following](https://wordpress.org/support/topic/will-this-help-with-the-following/) * [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [8 months, 2 weeks ago](https://wordpress.org/support/topic/will-this-help-with-the-following/#post-18607324) * You should ask your host again more information of which tables they are checking. This plugin is working with certain tables, not all tables in your WordPress installation. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Index WP MySQL For Speed] Almost everything gives 404 error](https://wordpress.org/support/topic/almost-everything-gives-404-error/) * [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [11 months, 3 weeks ago](https://wordpress.org/support/topic/almost-everything-gives-404-error/#post-18467001) * You might want to re-save the permalink first. I see many times that the .htaccess is either missing or not working right away on a new server. Re-saving would resolve that. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Index WP MySQL For Speed] Cannot create indexes for Advanced Coupons for WooCommerce Free plugin](https://wordpress.org/support/topic/cannot-create-indexes-for-advanced-coupons-for-woocommerce-free-plugin/) * [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [1 year, 2 months ago](https://wordpress.org/support/topic/cannot-create-indexes-for-advanced-coupons-for-woocommerce-free-plugin/#post-18288110) * Because they are custom tables, I think. * This plugin adds and updates keys in these WordPress and WooCommerce tables. - wp_comments - wp_commentmeta - wp_posts - wp_postmeta - wp_termmeta - wp_users - wp_usermeta - wp_options - wp_wc_orders_meta - wp_woocommerce_order_itemmeta - wp_automatewoo_log_meta * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Index WP MySQL For Speed] Access denied for user ‘wp_sgs’@’localhost’](https://wordpress.org/support/topic/access-denied-for-user-wp_sgslocalhost/) * [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [1 year, 3 months ago](https://wordpress.org/support/topic/access-denied-for-user-wp_sgslocalhost/#post-18265633) * I am not sure where is the “Upgrade Storage Now” button. Do you have any screenshot? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] sbjs cookies](https://wordpress.org/support/topic/sbjs-cookies/) * Thread Starter [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [1 year, 5 months ago](https://wordpress.org/support/topic/sbjs-cookies/#post-18123851) * Thanks for the answer. Actually, it’s from WooCommerce in my cookie report * Initiator: Script tag, page source line number 1363 Source: [https://mydomain.com/wp-content/plugins/woocommerce/assets/js/sourcebuster/sourcebuster.min.js?ver=9.3.3](https://mydomain.com/wp-content/plugins/woocommerce/assets/js/sourcebuster/sourcebuster.min.js?ver=9.3.3) * Now I found [this page](https://woocommerce.com/document/order-attribution-tracking/), confirming it’s WooCommerce cookies. You might want to update the cookies page. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Index WP MySQL For Speed] backend takes 10+ seconds](https://wordpress.org/support/topic/backend-takes-10-seconds/) * Thread Starter [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [1 year, 8 months ago](https://wordpress.org/support/topic/backend-takes-10-seconds/#post-17994765) * Thanks for suggestion. The object cache is running. But there is a failed setting with Store Transients when wp-admin cache is off. Correcting it, the wp-admin is faster now. * About Yoast, not sure if the reason is Store Transients also, but tried to monitor again, I didn’t see that request. Will monitor a few more times. * Thanks again. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Meta for WooCommerce] doesn’t exist but underwent a visibility transform](https://wordpress.org/support/topic/doesnt-exist-but-underwent-a-visibility-transform/) * Thread Starter [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [1 year, 8 months ago](https://wordpress.org/support/topic/doesnt-exist-but-underwent-a-visibility-transform/#post-17978330) * Thanks for answering. The troubleshooting steps… no problem with any of that. * Anyway, there is no more error in the last few days. I am not sure if it’s a temporary issue on Facebook’s side, or something else. Will keep checking in the next few more days. Hopefully there is no more error like that. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Index WP MySQL For Speed] Unable to read published form data (Lost connection to MySQL server during query](https://wordpress.org/support/topic/unable-to-read-published-form-data-lost-connection-to-mysql-server-during-query/) * [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [1 year, 9 months ago](https://wordpress.org/support/topic/unable-to-read-published-form-data-lost-connection-to-mysql-server-during-query/#post-17937404) * In case of shared hosting, you will need to contact your hosting provider. cPanel doesn’t provide log for MySQL or MariaDB. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Index WP MySQL For Speed] wp_postmeta is corrupt](https://wordpress.org/support/topic/wp_postmeta-is-corrupt/) * [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [1 year, 10 months ago](https://wordpress.org/support/topic/wp_postmeta-is-corrupt/#post-17838729) * It’s happening before the plugin tries to add new keys. You might want to repair the table first, for example, with phpMyAdmin * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Index WP MySQL For Speed] Simple Download Monitor](https://wordpress.org/support/topic/simple-download-monitor-2/) * Thread Starter [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [1 year, 11 months ago](https://wordpress.org/support/topic/simple-download-monitor-2/#post-17780933) * Thanks a lot for the info. I forgot to check the MariaDB optimization. Have increased innodb_buffer_pool_size and turned on Redis. Let’s see if the performance is better 🙂 * Thanks again. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Index WP MySQL For Speed] Simple Download Monitor](https://wordpress.org/support/topic/simple-download-monitor-2/) * Thread Starter [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [1 year, 11 months ago](https://wordpress.org/support/topic/simple-download-monitor-2/#post-17778249) * Sorry, missed this. The post 4443 doesn’t have many downloads. But I just added an index to post_id and it seems help. No more long time query from sdm_downloads table. Thanks a lot. * The reason of select all is because the site owner wants to show the total downloads. * Now, there are several long time queries related to postmeta table. Can you take a look at the new upload, please? * Thank you. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[LiteSpeed Cache] consent mode](https://wordpress.org/support/topic/consent-mode-6/) * Thread Starter [hungpham](https://wordpress.org/support/users/hungpham/) * (@hungpham) * [2 years, 1 month ago](https://wordpress.org/support/topic/consent-mode-6/#post-17502777) * Sth likes this * `domain.com/?gl=12kx3m8sdm_upMQ.._gaJ8SHI1MTk3M08Ni4xNzESSDk2ODE3_ga_HSHWJYUSG* MTcxMDQ59SKJH4xSHJ72MTcxMDQ5NjgxNi4wshj28jMA..` - This reply was modified 2 years, 1 month ago by [hungpham](https://wordpress.org/support/users/hungpham/). - This reply was modified 2 years, 1 month ago by [hungpham](https://wordpress.org/support/users/hungpham/). Viewing 15 replies - 1 through 15 (of 114 total) 1 [2](https://wordpress.org/support/users/hungpham/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/hungpham/replies/page/3/?output_format=md)… [6](https://wordpress.org/support/users/hungpham/replies/page/6/?output_format=md) [7](https://wordpress.org/support/users/hungpham/replies/page/7/?output_format=md) [8](https://wordpress.org/support/users/hungpham/replies/page/8/?output_format=md) [→](https://wordpress.org/support/users/hungpham/replies/page/2/?output_format=md)