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.
86
questions
0
votes
1
answer
395
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 ...
- 149
0
votes
0
answers
23
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 ...
0
votes
1
answer
35
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 ...
0
votes
3
answers
313
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 ...
- 101
0
votes
0
answers
54
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 |...
- 11
0
votes
0
answers
174
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
...
- 101
0
votes
0
answers
323
views
MySQLTuner vs cPanel SQL recommendations are different / contradictory
I've used WHM's (cPanel) to optimize the mysql configuration on my server and it suggested making the following changes which I made
innodb_buffer_pool_size=3328M
key_buffer_size=55M
...
- 51
1
vote
0
answers
113
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 ...
- 111
0
votes
1
answer
39
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 ...
- 11
0
votes
1
answer
91
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 ...
- 3
0
votes
1
answer
506
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.*, ...
- 1
0
votes
1
answer
299
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....
0
votes
1
answer
51
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....
1
vote
3
answers
705
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 ...
0
votes
0
answers
130
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 ...
0
votes
1
answer
685
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 ...
1
vote
1
answer
682
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 ...
Mahmoud Moussa
-1
votes
2
answers
212
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 ...
0
votes
1
answer
910
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" ...
- 101
2
votes
1
answer
279
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, ...
- 121
0
votes
1
answer
59
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 ...
- 101
0
votes
2
answers
90
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 ...
- 1
0
votes
1
answer
55
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 ...
- 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 ...
-1
votes
1
answer
502
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 ...
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=...
- 63
2
votes
1
answer
6k
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", ...
- 21
1
vote
1
answer
929
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 ...
- 111
3
votes
2
answers
7k
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, ...
- 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 ...
0
votes
1
answer
77
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 ...
- 11
0
votes
1
answer
176
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 ...
- 1
0
votes
1
answer
125
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,...
- 13
0
votes
1
answer
184
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,...
- 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 ...
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 ...
- 175
0
votes
0
answers
212
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 ...
- 1
0
votes
0
answers
405
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 ...
1
vote
1
answer
170
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 ...
- 13
1
vote
1
answer
573
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 ...
- 113
0
votes
2
answers
291
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 ...
- 25
0
votes
1
answer
67
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 ...
- 129
0
votes
0
answers
210
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 ...
0
votes
1
answer
96
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 ...
0
votes
1
answer
477
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 ...
- 1
-1
votes
3
answers
264
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 ...
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 ...
- 11
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 ...
- 9
0
votes
2
answers
137
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....
- 211
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 ...
- 13