The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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
0answers
15 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
1answer
23 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 ...
0
votes
0answers
8 views

Allow only import table in phpmyadmin

We build a wordpress site as a database interface in localhost (only). We are using a plugin WpDataTables to display tables, statistics etc. Is it possible to expose somehow only the import option of ...
0
votes
1answer
20 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 ...
0
votes
2answers
21 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 ...
0
votes
1answer
27 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 ...
0
votes
0answers
27 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
1answer
26 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
1answer
32 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
votes
3answers
106 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
1answer
194 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 ...
2
votes
1answer
171 views

Wordpress database connection error & Database was not shutdown normally

I need some solution for my wordpress site database error. I have face this DB error last one month. I don't know what is the reason for this Database connection error. Please review my error.log ...
1
vote
1answer
418 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 ...
0
votes
2answers
81 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....
1
vote
1answer
2k 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 ...
0
votes
1answer
29 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 ...
0
votes
2answers
129 views

MySQL crashed because of the large number of requests

I often began to fall down mysql. I recorded a large number of requests: 11019 user localhost user 20892 Query Waiting INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`)...
1
vote
2answers
2k 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 ...
2
votes
2answers
111 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. ...
0
votes
1answer
524 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
1answer
282 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
2answers
443 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....
3
votes
1answer
874 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 ...
3
votes
2answers
514 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 ...
3
votes
1answer
801 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 ...
-1
votes
1answer
1k 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 ...
3
votes
2answers
2k 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 ...
2
votes
2answers
244 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 ...
2
votes
2answers
550 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 ...
0
votes
1answer
297 views

Performance penalty for using thousands of tables in MySQL

Background I'm using wordpress multisite in which each user will have separate blog. For each blog, additional 15 tables are created. The website will be used by thousands of users. That means that ...
0
votes
1answer
97 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
vote
1answer
293 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 ...
2
votes
1answer
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 ...
2
votes
1answer
237 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' ...
0
votes
1answer
47 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
1answer
68 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 ...
0
votes
2answers
740 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 ...
1
vote
0answers
541 views

Ways to recover a corrupted Wordpress database?

As a result of increasing PHP_Memory Limit our wordpress data base has apparently crashed and been corrupted. Our host, Rackspace, attempted crash recovery but all attempts failed. What commands or ...
1
vote
3answers
546 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
1answer
809 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 ...
1
vote
0answers
329 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 ...
2
votes
1answer
81 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 '...
1
vote
1answer
596 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 ...
1
vote
2answers
640 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'...
1
vote
1answer
28 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=$...
3
votes
1answer
732 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 ...
1
vote
2answers
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
1answer
848 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
1answer
121 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
vote
1answer
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....