Questions tagged [drupal]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
49 views

What caused queries to execute repeatedly with different pids?

Recently I have noticed some of the queries are repeatedly being executed with new pids, this results in 100% CPU utilization. So I queried my postgres to see what's going on, with: SELECT pid, ...
1
vote
0answers
33 views

How do I deduplicate Drupal taxonomies on a PostgreSQL database?

Background I've been tasked with deduplicating a Drupal 7 install. There are about 15 thousand articles published, which have been imported directly into the database using some custom in-house ...
0
votes
1answer
122 views

Extremely slow requests on small innodb tables

The situation is the following. Two InnoDB tables, one has 2 records, another one - 281 - small ones, insert and update requests may last up to two (!) minutes. Dropped db, created again. The ...
1
vote
1answer
5k views

MySQL starts using > 90% of CPU, “Copying to tmp table on disk” and “converting HEAP to MyISAM”

I have a server where MySQL is periodically taking up 11 of the 12 CPU cores. Once this starts it doesn't end until I restart MySQL. At least, I haven't let it run like this for more than a half hour ...
0
votes
1answer
60 views

Too Slow Select in Drupal cms

i have a slow query form a table with 7000 rows. in order after along time to optimizing MySQL conf nothing changed. this query is : | 38 | root | localhost | nrj | Query | 28 | Sending data | ...
0
votes
2answers
924 views

Optimization of variables in my.cnf (mysql) for Drupal

I just get a Dedicated Server running UBUNTU and I need to optimize the variables in my.cnf for Drupal 7. I understand that this is tailed job. Then Is there any tool to help me to do this? I am a ...
1
vote
1answer
1k views

MYSQL crashes on XAMPP while working with drupal

Good day, just today morning i was using drupal to add some content, it crashed and mysql shutdown unexpectedly at xampp!! last thing i was doing was inserting a data into a field with "auto complete ...
0
votes
1answer
210 views

Count(*) as rolecount, filter by rolecount = 1

How can i filter out the rows who only got rolecount = 1? WHERE rolecount = 1 gives an error. Can't really figure out how to do it. SELECT u.uid AS uid, u.name AS name, u.picture AS picture, n....
1
vote
0answers
1k views

What to do with unused RAM on a MySQL database server?

For years I have been running dedicated servers with more or less limited ressources, resulting in unsatisfying performance of the web application (Drupal). Tools like Matthew Montgomery's MySQL ...
0
votes
1answer
2k views

My database keeps crashing on startup how can i repair it without it running?

I've got some problems with my database. I hope somebody can help me out. Problem: The database keeps crashing on startup. In my log i see a couple off these errors: [ERROR] /usr/libexec/mysqld: ...
0
votes
1answer
726 views

Combine results from two queries?

I need to combine the results from two queries into one result set and order them altogether. This is the working, raw SQL code I have: SELECT * FROM ( SELECT t1.id AS entity_id, t2....
1
vote
0answers
293 views

Drupal database doesn't work after MySQL restart

I've installed Drupal 7x on my local XAMPP 1.8.3 Server. Everything went fine but after adding some modules, changing the drupal theme and restarting the MySQL Server, the MySQL Server is dropping ...
0
votes
0answers
88 views

Query take a long time! Is that server issue?

When Query runs on Server (shared-server) it takes (2.5332 sec) But when I run the same Query on another Server (dedicated-server), it takes only (0.0205 sec). I don't know where is the issue! Is ...
1
vote
2answers
198 views

What is proper database design for a drupal table with an order field?

I am adding a custom widget to an instance of Drupal 6.x & MySQL 5.5 and came across a problem with updating rows. I have a table of recipe ingredients where multiple ingredients are tied to a ...
1
vote
1answer
170 views

Why does copied MySQL database have different data than source?

I am trying to migrate database A to database B. I have tried various methods for this, including... Using Navicat, do Tools > Data Transfer, copying structure and data from A to B Using Navicat, ...
2
votes
1answer
6k views

mysqldump: Got error: 1017: Can't find file: 'drupal_install_test' (errno: 2) when using LOCK TABLES

I'm trying to backup a drupal site database but I'm having some issues. When I ran the following command: mysqldump -uroot -p drupaSite > drupaSite.sql I get the following error: mysqldump: Got ...