hungpham
Forum Replies Created
-
This plugin, 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?
Thank you. I am using mysqldumpslow, and yes, when checking the slow log manually, I see the correct request is SELECT
name,valueFROM<strong>wp_wfls_settings</strong>WHEREautoload= ‘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
SELECTname,valueFROMwp_wfls_settingsWHEREautoload= ‘S’When will that query be called?
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
SELECTname,valueFROMwp_wfls_settingsWHEREautoload= ‘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
In reply to: [Index WP MySQL For Speed] Will this help with the followingYou 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
In reply to: [Index WP MySQL For Speed] Almost everything gives 404 errorYou 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.
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
In reply to: [Index WP MySQL For Speed] Access denied for user ‘wp_sgs’@’localhost’I am not sure where is the “Upgrade Storage Now” button. Do you have any screenshot?
Forum: Plugins
In reply to: [WooCommerce] sbjs cookiesThanks 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.3Now I found this page, confirming it’s WooCommerce cookies. You might want to update the cookies page.
Forum: Plugins
In reply to: [Index WP MySQL For Speed] backend takes 10+ secondsThanks 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
In reply to: [Meta for WooCommerce] doesn’t exist but underwent a visibility transformThanks 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.
In case of shared hosting, you will need to contact your hosting provider. cPanel doesn’t provide log for MySQL or MariaDB.
Forum: Plugins
In reply to: [Index WP MySQL For Speed] wp_postmeta is corruptIt’s happening before the plugin tries to add new keys. You might want to repair the table first, for example, with phpMyAdmin
Forum: Plugins
In reply to: [Index WP MySQL For Speed] Simple Download MonitorThanks 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
In reply to: [Index WP MySQL For Speed] Simple Download MonitorSorry, 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
In reply to: [LiteSpeed Cache] consent mode