Questions tagged [drupal]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
30 views

Optimize MariaDB for Drupal 10 to handle more users

I have problems with my Drupal 10/MariaDB 10.5/PHP 8.1 website when they are 20 users simultaniously. The website goes down and the response time is really big (up to 30seconds sometimes) because php-...
mt.i.1's user avatar
  • 11
1 vote
1 answer
117 views

Join with certain tables causes execution time to skyrocket

Database Application: Ver 8.0.30 for Linux on x86_64 (MySQL Community Server - GPL) Server: Ubuntu 18.04.6 RAM: 32GB CPUs: 8 core The underlying application framework is Drupal and it uses a query ...
Amit Sedai's user avatar
1 vote
0 answers
57 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 ...
That Brazilian Guy's user avatar
-1 votes
1 answer
160 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 ...
Windy Wanderer's user avatar
1 vote
1 answer
8k 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 ...
donut's user avatar
  • 141
0 votes
1 answer
69 views

Slow SELECT in Drupal CMS

I have a slow query from a table with 7000 rows. After a long time trying to optimize the MySQL conf nothing has changed. The query: | 38 | root | localhost | nrj | Query | 28 | Sending data | ...
alireza m's user avatar
0 votes
2 answers
1k 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 ...
chefnelone's user avatar
1 vote
1 answer
2k 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 ...
Abdulaziz Hamdan's user avatar
0 votes
1 answer
264 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....
mgoubert's user avatar
  • 103
1 vote
0 answers
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 ...
user153878's user avatar
0 votes
1 answer
3k 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: Table ...
user3166736's user avatar
0 votes
1 answer
1k 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....
Aram Boyajyan's user avatar
1 vote
0 answers
324 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 ...
flumingo's user avatar
  • 111
1 vote
2 answers
217 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 ...
Patrick's user avatar
  • 4,229
1 vote
1 answer
244 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, ...
Dave's user avatar
  • 11
2 votes
1 answer
7k 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 ...
user avatar