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
27 views

MyISAM table cannot be repaired

A wordpress table is corrupted and automatic repair methods are failing. All myisamchk options have the same result: - recovering (with keycache) MyISAM-table 'rvwj_options' Data records: 208 Found ...
user avatar
0 votes
1 answer
66 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.*, ...
user avatar
  • 1
0 votes
1 answer
30 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....
user avatar
0 votes
1 answer
33 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....
user avatar
1 vote
3 answers
101 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 ...
user avatar
0 votes
0 answers
38 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 ...
user avatar
0 votes
1 answer
185 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 ...
user avatar
0 votes
1 answer
202 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
38 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 ...
user avatar
0 votes
1 answer
397 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" ...
user avatar
2 votes
1 answer
76 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, ...
user avatar
0 votes
1 answer
31 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 ...
user avatar
  • 101
0 votes
2 answers
24 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 ...
user avatar
0 votes
1 answer
28 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 ...
user avatar
  • 101
0 votes
2 answers
52 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 ...
user avatar
-1 votes
1 answer
153 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 ...
user avatar
0 votes
0 answers
32 views

How to properly perform database maintenance on a live website

I'm using WordPress to host a website, and for years, I've been using plugins to perform maintenance (delete revisions, expired transits, optimizing table, etc.) on the msyqls database, but I've been ...
user avatar
  • 63
1 vote
2 answers
368 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=...
user avatar
  • 63
2 votes
1 answer
3k 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", ...
user avatar
  • 21
1 vote
1 answer
372 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 ...
user avatar
3 votes
2 answers
4k 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, ...
user avatar
  • 63
0 votes
1 answer
1k 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 ...
user avatar
0 votes
1 answer
42 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 ...
user avatar
0 votes
1 answer
63 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 ...
user avatar
0 votes
1 answer
71 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,...
user avatar
  • 13
0 votes
1 answer
91 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,...
user avatar
  • 13
-1 votes
1 answer
30 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 ...
user avatar
0 votes
2 answers
728 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 ...
user avatar
0 votes
0 answers
128 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 ...
user avatar
  • 1
0 votes
0 answers
164 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 ...
user avatar
1 vote
1 answer
141 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 ...
user avatar
  • 13
1 vote
1 answer
217 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 ...
user avatar
0 votes
2 answers
42 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 ...
user avatar
  • 25
0 votes
1 answer
53 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 ...
user avatar
  • 129
0 votes
0 answers
115 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 ...
user avatar
0 votes
1 answer
72 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 ...
user avatar
0 votes
1 answer
360 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 ...
user avatar
  • 1
-1 votes
3 answers
162 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 ...
user avatar
0 votes
1 answer
1k 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 ...
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 ...
user avatar
  • 9
0 votes
2 answers
101 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....
user avatar
1 vote
1 answer
5k 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 (kernel@kernel.ovh.net) (gcc ...
user avatar
0 votes
1 answer
89 views

Wordpress site has a lot of connections

Recently my wordpress site is having troubles and is stopping from working due to heavy load in the mysql processes. I need to know what is causing all this traffic and how to narrow the issue so I ...
user avatar
  • 1
1 vote
2 answers
3k views

Temporary tables created on disk: is huge

I have an issue with a huge number of Temp tables writing on disk. I have tried many things to avoid this but no luck and I really am giving up. I though I might need some expertise to help solve this ...
user avatar
  • 111
2 votes
2 answers
240 views

How to increase performance with joins to create VIEW from Wordpress wp_usermeta [duplicate]

After a lot of searching, I finally was able to create a SQL Query to retrive Wordpress User Meta Data. Now the problem is, the performance is so bad it doesn't even show me a result after 30 min. ...
user avatar
  • 23
0 votes
1 answer
1k views

Help me understand and resolve MySQL deadlock - "lock mode AUTO-INC waiting"

I am experiencing an issue with MySQL deadlocks and here is what I see in the MySQL error log: 2017-07-24 09:09:29 7fd5235db700InnoDB: transactions deadlock detected, dumping detailed information. ...
user avatar
0 votes
1 answer
403 views

WordPress database error Table './databasename/wep_options' is marked as crashed and should be repaired for query

Please help me my mysql is keep crashing again and again and generating following error i am out of any clue what will be the reason for this issue WordPress database error Table './databasename/...
user avatar
-1 votes
2 answers
1k views

optimize wordpress mysql queries for millions of rows

I run a wordpress woocommcerce site with millions of rows in tables. After I made partition, there still some slow queries as below: Question: how can optimize the 3 queries? Query 1 # Query 1: 0....
user avatar
  • 19
3 votes
1 answer
1k views

MySQL 5.5 vs 5.6,5.7 above same database same query but different output, limit have duplicated ID

I am using Running same source code and same database for WordPress, only the mysql version is different. It make my pagination post have duplication. Here is what I found out. Any idea how to solve ...
user avatar
  • 151
3 votes
2 answers
975 views

Error Referencing wp_users as Foreign Key

I'm fairly new to SQL. I'm trying to create a FK for one of my tables (time_sheet) to one of the Wordpress tables (wp_users). But I'm hitting an error and I'm not entirely sure why that is. This is ...
user avatar
  • 31