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
683
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
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 ...
- 76.9k
0
votes
1
answer
290
views
Issues regarding phpMyAdmin - character set
I'm trying to migrate a Wordpress site from one server to another. Everything is going fine apart from the database migration.
I have my database 'A', and using phpMyAdmin I am attempting to export ...
CommunityBot
- 1
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 ...
- 35.1k
0
votes
1
answer
340
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 ...
CommunityBot
- 1
0
votes
2
answers
290
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 ...
CommunityBot
- 1
0
votes
1
answer
908
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" ...
CommunityBot
- 1
0
votes
3
answers
286
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 ...
- 55
0
votes
1
answer
32
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 ...
- 55
0
votes
0
answers
52
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 |...
- 7,649
0
votes
0
answers
172
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
1
answer
505
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.*, ...
CommunityBot
- 1
0
votes
0
answers
312
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
112
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 ...
- 1,480
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 ...
- 76.9k
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 ...
CommunityBot
- 1
1
vote
3
answers
697
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 ...
- 91
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", ...
CommunityBot
- 1
0
votes
1
answer
298
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....
- 6,261
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....
- 7,649
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 ...
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 ...
1
vote
1
answer
681
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 ...
- 7,917
0
votes
1
answer
487
views
Performance penalty for using thousands of tables in MySQL
Background
I'm using WordPress multisite in which each user will have a separate blog. For each blog, additional 15 tables are created. The website will be used by thousands of users. That means that ...
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
58
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 ...
- 82.9k
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
1
vote
2
answers
1k
views
wordpress site kills mysql
I move client wordpress sites from one VPS to another, it all went smooth until I moved a site that kills mysql (and, consequently, all other wp sites). It used to work fine on the previous VPS.
Here'...
- 111
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 ...
- 76.9k
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 ...
- 82.9k
-1
votes
1
answer
500
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 ...
- 76.9k
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=...
- 76.9k
1
vote
1
answer
926
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 ...
- 76.9k
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, ...
- 1,687
0
votes
1
answer
2k
views
PostgreSQL to MySQL migration to use database for WordPress site - how to's?
I have a complex issue to solve, related to database migration. I have a website full of news to migrate that is currently based on a PostgreSQL database and written in PHP, without a CMS. I have a ...
CommunityBot
- 1
3
votes
1
answer
2k
views
Wordpress using varchar(255) for index with InnoDB and utf8mb4_unicode_ci?
I'm trying to learn a bit more about the details of proper database construction and ran across something that confuses me. In a current Wordpress installation, I'm finding varchar fields used for ...
- 76.9k
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 ...
- 1,687
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,...
- 846
0
votes
1
answer
183
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,...
- 76.9k
-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 ...
- 76.9k
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
211
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 ...
- 80
0
votes
0
answers
398
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 ...
- 19.4k
1
vote
1
answer
566
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 ...
- 19.4k