Questions tagged [wordpress]

For questions about databases behind WordPress, a content management system based on PHP. General questions about WordPress are off-topic but might be welcomed at WordPress Stack Exchange.

Filter by
Sorted by
Tagged with
0 votes
0 answers
24 views

bitnami /opt/bitnami/mysql/data increases in size over time

I'm having a similar issue as to what is described in this post which never received an answer. Essentially, I'm running bitnami and my server space is filling up over time on what is a very simple ...
user284564's user avatar
0 votes
1 answer
425 views

how can I view deleted records in an ibd file?

I'm in a situation with a wordpress site where a table wp_options keeps increasing in filesystem size really fast even though it only has 10000 records and we have to constantly optimize it to reduce ...
gabtzi's user avatar
  • 159
0 votes
0 answers
25 views

Two Database Instances, need to share table data

Background Two sites, both WordPress; one is public-facing, and the second is private with restrictive access. The public-facing site has a form on it, but I need to be able to access the information ...
N. Kendrick's user avatar
0 votes
1 answer
52 views

Advice on WooCommerce DB and really slow WC core admin queries

Thanks for reading! So I'm kind of banging my head against a wall but I firstly want to say that I think this is a DB setup problem rather than the code as even when stripped back to bare bones WC the ...
Devon Developer's user avatar
0 votes
3 answers
769 views

How can I purge MySQL binlogs if MySQL is turned off

I am using Digital Ocean droplets for my WordPress Site. There are more than 60 binlog files in /var/lib/mysql. Most of the solutions say that I should purge them from MySQL. The storage is so full ...
Sky Lurk's user avatar
  • 101
0 votes
0 answers
57 views

What is the best way to get posts with comments from MariaDB?

I have a MariaDB DB with three tables: posts ID | title | content | author_id | likes_count -------------------------------------------------- 1 | Abcd | content_01 | 1 |...
Elgameel's user avatar
0 votes
0 answers
196 views

Mysql stopped working on my wordpress website

I'm not that experienced with linux or mysql so bear that in mind. I generated my website using the wordpress droplet on digital ocean and its been working fine, but today the website started saying ...
John's user avatar
  • 101
1 vote
0 answers
134 views

Critically high website CPU usage very sudden, persistent upon reboots [closed]

Quick summary. Wordpress community website, large userbase. Has caching for guests (WP Super Cache). Always operates around load of 1-2, or 5-6 at peak hours CPU. As of 4pm EST on Feb 15, the CPU load ...
yesbutmaybeno's user avatar
0 votes
1 answer
40 views

What is ideal configuration for Mysqld.cnf?

I run a news & media blog with over a few million readers every month. I'm currently using Google Cloud with a 32gb ram server with WordPress. My server is hitting 84% memory usage due to the ...
Jaya's user avatar
  • 11
0 votes
1 answer
104 views

mySQL INNER JOIN and Conditions

I wrote a mySQL query that is just works as I need. SELECT COUNT(wp_posts.ID) as count, wp_terms.term_id FROM wp_terms INNER JOIN wp_term_taxonomy ON wp_term_taxonomy.term_id = wp_terms.term_id AND ...
techn9ne's user avatar
0 votes
1 answer
547 views

WordPress and WooCommerce very slow query

After a migration to a new WooCommerce install, but we are experiencing very sow queries. Sometimes more than 1 minte. Currently this query is fired. This is fired in 0.7253s EXPLAIN SELECT t.*, tt.*, ...
Wouter's user avatar
  • 1
0 votes
1 answer
355 views

Unable to create WordPress databse user

Wordpress and MariaDB are on different hosts. I'm connected to MariaDB via it's CLI command interface. I am following the DigtalOcean guide. Here are the DB and OS info: 10.3.32-MariaDB-0ubuntu0.20....
Gilberto Martins's user avatar
0 votes
1 answer
54 views

Large Primary key affecting performance?

I have a Wordpress site, and as a result of a plugin, my posts and postmeta table IDs got set to autoincrement at 9004111220000000 and up. I didn't notice until I had 10s of thousands of IDs like that....
Uncle Jam's user avatar
1 vote
3 answers
800 views

WordPress MYSQL DB BINARY LOG - Droplet/SERVER Volume Increasing rapidly

My WordPress website uses Nginx. Recently I have noticed that server volume has increased from 8GB to 40GB. I have found that the WordPress MYSQL Binary Log is taking more space. Each second, database ...
 Ibrahim EL-Sanosi's user avatar
0 votes
0 answers
134 views

Sql query + wpml in one language only

I'm not a developer, just a normal user, so please don't expect me to be like you :) I'm managing my website in WordPress, Running 4 languages using WPML, (en,de,cz,pl) My concern is, I want to search ...
Mahmoud Al Nagar's user avatar
0 votes
1 answer
735 views

MySQL keeps crashing - Error establishing a database connection

I had installed wordpress on ubuntu 20.04 on 2GB/2CPU and I have a problem with my MySQL server that keeps crashing. Everyday we are getting below error : error establishing a database connection and ...
Vishal Gupta's user avatar
1 vote
1 answer
742 views

Wordpress crash on slow queries related to wp_term and wp_term_taxonomy

I have a WordPress blog with around 90K articles. The problem is I get frequent crashes on the server and browsing is slow due to some slow queries on the website. I am suspecting the problem is with ...
user avatar
-1 votes
2 answers
302 views

Creating Tables with the same table names from other databases doesn't have any bad effects?

I have a WordPress website and I cloned it to another website(domain) using a plugin called Duplicator. So in the backend, phpMyAdmin, I've two different databases but all the tables in both databases ...
Umer Mansoor's user avatar
0 votes
1 answer
957 views

High CPU usage in AWS RDS

When I visit the woocommerce orders page in WordPress, MySQL RDS CPU usage goes to 100% but the website is working perfectly fine. In 'active sessions' section, "wait/io/tables/sql/handler" ...
Anish Sapkota's user avatar
2 votes
1 answer
285 views

Unexpected very slow user count in WordPress

I have a Wordpress page that returns timeout error every so often. When reviewing the MySQL "slow queries" log, I could notice that there is an extremely slow query coming from Wordpress, ...
Joseph's user avatar
  • 121
0 votes
1 answer
64 views

Restoring a MySQL database

My Ubuntu 16.04 server was recently hacked and my host allowed me to recover the file system via FTP, closing all other ports thus disabling me from logging in and stopping any services. I have the ...
hatcat's user avatar
  • 101
0 votes
2 answers
96 views

PolyLang WP Update to replace one string to another

I have to replace one string to another one in post_content column in table wp_post ( Wordpress ). My query works only then when I use SELECT but when I want to use UPDATE command with REPLACE then I ...
Macsurf's user avatar
0 votes
1 answer
60 views

Should a meta_key or other key-value table columns use a HASH or BTREE index?

I've noticed that my WordPress database has BTREE indexes everywhere. By my understanding, BTREE indexes allow more efficient < > and BETWEEN queries, but are otherwise less efficient than a ...
Dan W's user avatar
  • 101
0 votes
2 answers
61 views

Advice for database implementation [closed]

We need to configure a database for our NGO. We have to save information about the children and several pictures and documents for each of them. A friend is currently saving the data of over 70 kids ...
starryn1ght's user avatar
-1 votes
1 answer
581 views

Problem with mysql/data folder is too big and took the whole place

for the first time I am faced with such a problem that has puzzled everyone. I have all hosting busy (AWS lightsail) 78GB and after a few analyzes I realized that 90% of the memory is occupied in the ...
Edgar Poe's user avatar
1 vote
2 answers
1k views

After changing engine from myisam to innodb tables are larger in size, is this an expected behaviour?

I updated a WordPress database from myisam to innodb on a server using apache and mysql, and I noticed that some tables, such as wp-posts grew in size after running the ALTER TABLE wp_posts ENGINE=...
mhweb's user avatar
  • 63
2 votes
1 answer
7k views

Warning: mysqli_real_connect(): (HY000/2002): Connection refused in /var/www/html/wordpress/wp-includes/wp-db.php on line 1626

I'm just starting to code and I try to host a Wordpress website on a server of my school. However, as soon as I upload the website on the Wordpress interface with the plugin "all-in-one migration", ...
Clemm's user avatar
  • 21
1 vote
1 answer
968 views

MySQL server keeps crashing every few minutes

I am having the hardest time tracking down this problem. Every few minutes or so my database server crashes so all 3 WordPress sites on my WHM cPanels all crash at the same time. When it does, I get ...
Okomikeruko's user avatar
3 votes
2 answers
8k views

How to fix MySQL high CPU usage running on VPS

I manage a WordPress site on virtual private server with 2 vCore, 80GB SSD, 4GB of memory, Ubuntu 18.04, Apache 2.4.29, and mysql community version 8.0.20. When started the site on the server, ...
mhweb's user avatar
  • 63
0 votes
1 answer
2k views

MySQL server stops running due to "Out of memory" errors [duplicate]

Recently moved a Wordpress site to an Ubuntu 18.04 server running Apache, hosted by Armor (they're useless). This has happened twice now about a week apart. Happened early morning while not working on ...
Patrick St.Onge's user avatar
0 votes
1 answer
81 views

Migrating a Mariadb/wordpress site with only .frm files

My server crashed. My /home /www and lib/mysql were on a different hard disk so I have all the data. The original server was Debian 9 with Mariadb and an apache webserver. I planned to move to mysql ...
Saif Ahmed's user avatar
0 votes
1 answer
196 views

Permissions issues with MYSQL on a Bitnami/Nginx/PHP/WordPress server

i just did restarted services on my Bitnami/Nginx/SSL/WordPress server (was updating my certs). I suddenly got a disk space full, i found that my issue was Binlogs clogging up, which i promptly ...
Nickey K's user avatar
0 votes
1 answer
133 views

Need help with indexes on 2 slow wordpress query

Here are my my 2 slow query i want to improve. SELECT object_id, term_taxonomy_id FROM wp_term_relationships INNER JOIN wp_posts ON object_id = ID WHERE term_taxonomy_id IN (525627,516360,525519,...
Wed's user avatar
  • 13
0 votes
1 answer
204 views

How can I improve this slow query in my wordpress site?

SELECT object_id, term_taxonomy_id FROM wp_term_relationships INNER JOIN wp_posts ON object_id = ID WHERE term_taxonomy_id IN (525627,516360,525519,535782,517555,525186,517572,549564,1,517754,541497,...
Wed's user avatar
  • 13
-1 votes
1 answer
31 views

MySQL Table is Huge Where Only Text Values Are Stored

I am using LAMP Stack...And one of my db table wp_options (Rows: 10,600) is now about 194+ GB in size... Not sure why the size growing so much huge... As far as i am concern most of the records are ...
Sajjad Hossain Sagor's user avatar
0 votes
2 answers
1k views

mysql > why replace command is not working on strings coming from json encoded?

Say in my wordpress db I've got a post_content column containing strings like this: href=\"http:\/\/dev.example.com\/example\/wp-content\/uploads\/2019\/07\/my.pdf\" The above is a portion of string ...
Luca Reghellin's user avatar
0 votes
0 answers
215 views

Slow queries constantly getting stuck on Wordpress database of ~100,000 posts

I am constantly getting stuck SELECT queries on my wordpress databases like the following: Many of the SELECT queries that get stuck are fairly ordinary, such as pulling the last 10 posts of an ...
John's user avatar
  • 1
0 votes
0 answers
465 views

phpMyAdmin -- how do I figure out which DB these connections and processes belong to?

I've got about 8 databases on one server, mostly corresponding to WordPress sites. I'm using shared hosting that does not give us superuser permissions. When I log into phpMyAdmin (version 3.5.2) and ...
James Dewey's user avatar
1 vote
1 answer
174 views

Looking for some advice to complete custom mysql query against 3 different tables

I would like to create a query to populate a table dynamically by querying the 3 databases that contain relevant information about their entry. wp_gf_entry, wp_gf_entry_meta, and (ideally) with ...
Zoe's user avatar
  • 13
1 vote
1 answer
659 views

How to avoid DROP TABLE for a specific MySQL table

I have used a Wordpress plugin that for some unknown reason is always deleting a database table (cerber_files). The plugin's author is not giving support for this issue. I think in order to solve ...
Rogério Dec's user avatar
0 votes
2 answers
315 views

Value of prepared statement is listed as error in query string

I have made a Wordpress plugin that writes some data to a proprietary table. The query as shown in the log is: INSERT INTO berichten_devices (device_UUID, article_id) VALUES (%s, %s) If I take ...
Tjeerd's user avatar
  • 25
0 votes
1 answer
75 views

MySQL: Can not add foreign key into create table statement

The queries below (assigned to php variables) seem to have an issue on the 2nd query, where I set the foreign key to the "couponId" column on the first table. My IDE lints "couponId" (inside the ...
Sean D's user avatar
  • 129
0 votes
0 answers
223 views

Restoring backup with a MySQL Database downgrade

I want to migrate a MySQL 5.7 database to a MySQL 5.1 version because the MySQL version of the server I’m migrating my WordPress webpage is 5.1. I tried to do it in the usual way but it was not ...
andrestoga's user avatar
0 votes
1 answer
104 views

Mariadb times out on startup after system reboot

This is continued from: https://stackoverflow.com/q/55071021/8644833 Mariadb shuts down after running for a minute or two. If I remove Mariadb and reinstall (keeping my databases), everything works ...
Phillip Brantley's user avatar
0 votes
1 answer
487 views

How to use Unicode chars on PHPMyAdmin?

On a WordPress site I want to replace " !" and " ?" by " !" and " ?". The challenge is that the replacement string not uses a common space char but a thin space char (U+2009). PHPMyAdmin is used for ...
Toby's user avatar
  • 1
-1 votes
3 answers
283 views

Less traffic, But Mysql Still Hit upto 200%

I Run WordPress On my with with Less traffic, 5 or 6 online, but mysql till hits upto 200%, though sometimes it come down to 100 or less, but it still goes up to 200% again, the funniest thing is that ...
Godwin Alex Ogbonda's user avatar
0 votes
1 answer
2k views

Trigger after insert, insert new row into another table [closed]

I'm developing a Wordpress site. I'm trying to insert a new row into a table when new row with specific value in usermeta table is added. This is what I got for now: DELIMITER | CREATE TRIGGER ...
Ante Medic's user avatar
0 votes
1 answer
2k views

How to merge two databases (each with different updates) on the same server

I have an almost regular WordPress setup including a mySQL database (Server A). On March 1st 2018 this installation and mySQL database was copied to a new server (Server B). On the new server (B) a ...
Jens's user avatar
  • 9
0 votes
2 answers
139 views

Error establishing a database connection

we have wordpress site & everyday we are getting below error : error establishing a database connection almost once i a day than we have to restart mysql to fix this.... var/log/mysql - error....
Baby in Database's user avatar
1 vote
1 answer
7k views

Wordpress causes high CPU usage (mysqld)

I have a wordpress site with 500k posts in MYSQL database running on debian dedicated server: Server OS: Debian 8 "Jesssie)" - Linux version 4.9.58-xxxx-std-ipv6-64 ([email protected]) (gcc ...
Martin Smith's user avatar