2

Check out this thread wp_options is GB in size My wp_options table dropped from 670GB to 13.5MB after running the optimization commands they outlined


2

The post_type field is an internal feld, you shouldn't be giving it values that require longer column lengths, and there's no need for it to be user facing. WP allows you to override everything about it, from the query variable name, rewrite rules, to the wording displayed. But more importantly, you shouldn't modify WP core. That goes for the database ...


1

My question is, is it a good idea to use docker for a big woocommerce website (more than 100k products)? Or will this incur a noticable performance cost compared to running wordpress straight on the VPS (without containerization)? It won't make much difference, nothing you will notice. It's not even in the top 50 things you should be concerned with for ...


1

As in this question and answer, and because of your huge .htaccess file it's like you have a .htaccess directive that's causing your apache to not process that file or understand its type. As mentioned by @Rup, using the default Wordpress .htaccess, and checking other directories for rogue .htaccess files will likely resolve this issue. If it doesn't, you ...


1

This is more of a MySQL question, but I think your design is fine and is unlikely to create any database problems, even for a lot of rows (up to 1,000,000). The reason for this is: Why this is fine Nearly everything you do with this table should be writes, and there will only be a 'small' number of writes per day (up to a thousand?). This is not a good idea ...


1

I found it. It's in the active_sitewide_plugins value of the wordpress_sitemeta table.


1

Here you go Javier, this should work. I included comments within the code to try and show you where things needed to change and added a few things you were missing. I'll explain more below. <?php /* Should really come up with something more unique and related to your plugin */ function yourplugin_dbcreation() { global $wpdb; $charset_collate ...


1

As suggested in comments, the best way to update stock, or any other product information would be through the WooCommerce API. The product endpoint with all the parameters is documented here (link is directly to how to update): https://woocommerce.github.io/woocommerce-rest-api-docs/#update-a-product. I'm not very familiar with woocommerce, but based on ...


Only top voted, non community-wiki answers of a minimum length are eligible