I have two tables like this wp_posts ID post_date post_title post_type post_status 1 2020-12-10 ABC institute publish 2 2020-12-16 DEG institute publish 3 2020-12-11 XXY institute publish 4 2020-12-12 ABX institute publish 5 2020-12-24 ZYU institute publish 6 2020-12-28 ANM…
I have 2 big tables in my database (wp_frm_items with about 3 million rows and wp_frm_item_metas with about 35 million rows). I'm using the Query Monitor WordPress plugin and noticed that queries using joins and making counts are slow. Some…
I have the following query. It works great, except when the row for _billing_company does not exists. Can I get some kind of a default or an empty value if _billing_company does not exist? In the example below, the post…
I have a Digital Ocean-managed MySQL database. In order to prevent data replication issues across nodes, DO automatically sets your instance with sql_require_primary_key. This is fine in theory except that there are various WordPress plugins, including notably WP Cerber, which…
It is the first time that I tried to install Wordpress in a container, I have used the following from the official docker documentation, but I received the following errors: version: "3.9" services: db: image: mysql:5.7 volumes: - db_data:/var/lib/mysql restart:…
I have the following function that I tweaked because I needed to use a table with less rows and fields. The tables in wordpress that the function was using are wp_posts and wp_postmeta (see below) but it has too many…
I'm having performance issues with my Wordpress site, due to the number of registered users, the wp_usermeta table has almost 70 million rows. Users do not have access to modify their profile so I have thought about deleting the unnecessary…
I have a static website in html and php. In the footer I have a segment that retrieves the 4 most recent blog posts from a wordpress blog that I host in connection to the static site. The code I…
I need to set some user meta in my wordpress through local python script. Hence I can't use the WP update_user_meta for it - it has to be done manually. import mysql.connector as mysql cnx = mysql.connect(host=HOST, database=DATABASE, user=USER, password=PASSWORD)…
In my WordPress v5.7 I have the below code in my taxonomy.php template to get a custom post_type posts count in that taxonomy term. // CURRENT TERM $term = get_queried_object(); $bookArgs = array( 'post_type' => 'book', 'post_status' => 'publish', //…