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.
30
questions with no upvoted or accepted answers
1
vote
0
answers
343
views
High load on server because of one query
I have one query running from last stable version of wordpress on causing high load on my centos 6.7 server
I enabled slow query log thought /etc/my.cnf file to record which sql cause this problem ...
- 163
1
vote
1
answer
56
views
How to filter out the records with the latest date?
I have a table with id, task_id, created_taskaction (= rec.cr.date).
I would like to get the latest record for e.g. task_id 0001.
In the wordpress framework I tried this:
> $last_task_action2=$...
- 189
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
318
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
175
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
327
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
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
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....
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 ...
0
votes
1
answer
912
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
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
56
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
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
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
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 ...
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
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
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
1
answer
342
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 ...
- 1
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 ...
- 1
0
votes
1
answer
140
views
MYSQL INSERT takes too long and each next portion takes more than previous
First 1000 takes 8 sec, next 1000 takes 12 sec and each next more and more. I have two databases with 1,5 million rows each. My goal is to fill empty table jf first db with relationship links.
Items, ...
- 1
-1
votes
1
answer
504
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
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 ...
-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 ...