New answers tagged 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
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
0
found the solution the problem was the "posts_per_page" it made my website crash on that specific section
and also in wp-config.php
added
define( 'WP_MEMORY_LIMIT', '256M' );
and it solved my problem
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 ...
0
On a WordPress multisite instance at AWS EC2 Hosting we got a similar problem,
of curl6 while updating the network after adding a new site, to the WP and the DNS records with an " A " Record resolving at the same networks static ip.
Actually this was very simple it was just the Database Transits that were causing these issues we used the free ...
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 ...
0
You can use active_plugins from the wordpress Options API if your site is not Multi-site wordpress site.
You can run it as:
add_action("plugins_loaded", function(){
$active_plugins = get_option("active_plugins", []);
echo "<pre>";
print_r( $active_plugins );
echo &...
1
I found it. It's in the active_sitewide_plugins value of the wordpress_sitemeta table.
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 ...
0
Thank you for the responses. I was able to get it handled by using a plugin.
https://wordpress.org/plugins/export-media-with-selected-content/
I'm going to look into the REST API solution for keeping it up to date while I continue the development side of the project.
0
I was able to export and import the Customizer settings using this Plugin :
Customizer Export/Import (Version 0.9.1 | By The Beaver Builder Team).
https://en-ca.wordpress.org/plugins/customizer-export-import/
It works like a charm and is safer than the database manipulation method.
0
Have you considered to use REST API to bridge the two environments?
Basically you need to hit the posts endpoint https://example.com/wp-json/wp/v2/posts using the after argument that permit to limit response to posts published after a given ISO8601 compliant date.
With the response you can insert new posts and sync the two installation.
More detail about the ...
0
This issue seems to be present no quite a small sites.
Has anyone else experienced it and is the database optimization the only solution?
Top 50 recent answers are included
