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
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
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 ...
- 111
2
votes
2
answers
364
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.
...
- 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.
...
0
votes
1
answer
435
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/...
-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....
- 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 ...
- 153
3
votes
2
answers
1k
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 ...
- 31
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 ...
- 33
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 ...
- 151
3
votes
2
answers
3k
views
MySQL hundreds of sleep processes giving "Error establishing a database connection" error
I'm running a LAMP with ubuntu server 12, mysql innodb_version 5.5.49 on a Wordpress platform (3 websites virtualized). Has been running without issue for about 2 years, but I just started getting an ...
- 131
2
votes
2
answers
280
views
Select the maximum aggregate value for a limited set of chunked/grouped rows in a large database?
I work on WordPress plugin which implements sitemap functionality.
One of the steps is to build an index of sitemap pages for post entries. The logic required is roughly: determine last modified time ...
- 123
2
votes
2
answers
846
views
Migrate SQL Server backup to MySQL for a Wordpress site
I have a client with an old .Net site that used SQL Server. For lots of reasons they decided to switch to Wordpress. They had a bunch of news articles on that old site that they want turned into posts ...
- 23
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 ...
- 103
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
1
vote
1
answer
522
views
Dedicated tables VS Multipurpose Tables
I am developing a forum like app using a MySQL database. I have posts, comments and replies just any other forum.
At the moment I have a table for posts, a table for comments/replies and a table for ...
- 363
2
votes
1
answer
2k
views
In a WordPress/WooCommerce table the prices are hosed. How to realign them? (a key=value structure)
We had in our WordPress/Woocommerce table (hence mySQL) ab_postmeta the sale (discount) prices for some products.
We thought that reseting the sale prices via SQL query (and not via WordPress ...
- 153
2
votes
1
answer
268
views
Is it normal that our Wordpress' database crashed multiple times in this month alone?
I just started a new job at a small magazine as an IT guy. It all worked fine, but I'm worried about some issues with our VPS installation.
Since I started working here (26 days ago), our Wordpress' ...
- 23
0
votes
1
answer
86
views
Is this an appropriate forum for help with beginners dba questions? [closed]
I've installed MAMP and Wordpress on a local machine to learn about databases.
Can anyone recommend a 'hello world' type tutorial, where I can create my own database within this environment?
I ...
1
vote
1
answer
135
views
Counting Number of Database Connections on a Page
I have a LAMP stack(mysql and php) wordpress site and I want to know the number of database connections opened when a page loads. I can find other numbers but I can't figure out the number for a ...
- 125
0
votes
2
answers
2k
views
Spanish characters saved incorrect in Mysql
I have googled this already, but I couldn't find what's wrong in my situation.
I have a wordpress site that has a lot of non-english users which type in words such as "español" it is printed ...
- 125
1
vote
3
answers
726
views
Mysql 5.5.45 crashing after refreshing web page rapidly(Too Many Connection warning)
I am using ec2 aws instance for my wordpress webiste.after every 5 to 10 minute and randomly my website going down i tried lots of things like increasing buffer memory ,memory limit but that not ...
2
votes
1
answer
1k
views
WordPress with massive MySQL database slow. Would MySQL replication help?
Database Administration is usually not my strength, but one friend asked me if I can help him with his project. He is running a WordPress (MySQL) website with WooCommerce. The postmeta table stores ...
- 23
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
2
votes
1
answer
138
views
Join two SELECT results with the same post_id value
I need to do a query to the MySQL database of my site built in WordPress / WooCommerce.
The 'wp_posts' table keeps products, articles and more. Every row in 'wp_posts' has a 'post_id' to connect '...
- 21
1
vote
1
answer
2k
views
Optimise MySQL on VPS (2 CPUs & 3 GB RAM) with WP MU
I have a vps server with os centos 6.7 64x, 2 cpu's and 3gb ram, and I use it exclusively for a WP MU (Memory limit: 512 MByte/Memory usage: 53.97 MByte).
I use mostly myisam and have about 30 ...
- 43
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
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
3
votes
1
answer
896
views
MySQL very long-running queries
I have a quite large db (800+Mb dump file) that I imported to my local server. It's a Wordpress db from witch I need to extract certain posts. There are around 160,000 posts inside.
Currently I'm ...
- 31
1
vote
2
answers
2k
views
join same table twice and get the results of rows
i have table like wp_term_relationships
object_id term_taxonomy_id term_order
194 2 0
194 7 0
194 8 0
194 ...
2
votes
1
answer
2k
views
Error 134 in a MySql table
I have a file (mysql error file) full of this message
[ERROR] Got error 134 when reading table './xxxx/wp_options'
I don't really know how to fix this problem
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
vote
1
answer
2k
views
Speed up MariaDB?
I have a Wordpress Woocommerce store using WP All Import Pro to run automatic imports on a 15 minute cronjob schedule. It's usually trying to update 400 to 500 items from our supplier every 15 minutes....
- 13
2
votes
2
answers
3k
views
Waiting for table level lock on wordpress site
We are experiencing issues with mySQL loading 100% of the server's CPU. While checking the running processes we found many of the following:
Waiting for table level lock | SELECT option_name, ...
- 21
0
votes
3
answers
203
views
Major performance difference from a small change in query
I have a query written out to search a WordPress database for any post ids that match the keyword search to post content, title, author, or associated company. The company portion of the query is
...
- 101
13
votes
3
answers
40k
views
Cache MySQL database in memory
I am having problems with a website with 600MB of MySQL database. The website is way too slow. I noticed the bigger the MySQL database gets, the slower it goes. When it was 5MB, the website was very ...
- 379