MySQL query is very slow (15 minutes)

I was previously using SQLite for a personal project and due to a constraint of having it available online, I decided to make the switch to MySQL. I converted my database to the MySQL equivalent but I just noticed that performance is VERY poor. This is a 70 mb database with around 600k records total. The query I am running is an INNER JOIN that executes in less than 500 ms using SQLite but the same query using MySQL takes 15 minutes.

SELECT has.tag_id, has.image_id FROM has INNER JOIN image ON image.image_id = has.image_id INNER JOIN person ON person.person_id = image.person_id WHERE"Random Person" 
  • has table has 80k records
  • image table has 290k records
  • person table has 500 records

Here is the structure of the three tables:

create table media.person (     person_id int auto_increment         primary key,     name         text not null )     collate = utf8_unicode_ci;  create table media.image (     id           int auto_increment,     image_id     int  not null,     person_id int  not null,     link         text not null,     checksum     text null,     constraint id         unique (id) )     collate = utf8_unicode_ci;  alter table media.image     add primary key (id);  create table media.has (     id       int auto_increment         primary key,     tag_id   int not null,     image_id int not null )     collate = utf8_unicode_ci; 

Note that I added a primary key to the has table because I suspected it might have been the source of the problem, but it isn’t and SQLite was doing fine without that primary key.

The database uses the InnoDB engine. Here is the output of the mysql --version command:

mysql Ver 14.14 Distrib 5.7.30 

Where could the problem come from? I can understand a small loss of performance because MySQL is heavier than SQLite but certainly not to the point of going from 500 ms to 15 minutes for such a simple query.

Can a scholar repeat healing hands every 10 minutes?

In adventures in Middle-Earth RPG, the scholar class has “Hands of a Healer” ability: “If you can touch a creature, you may expend one Healing Die per action, instantly granting them hit points equal to 1d8 plus your wisdom modifier…If instead you tend the creature for at least 10 minutes…, then you may multiply the 1d8 by your proficiency modifier… “

My question is: Can a scholar repeat healing hands every 10 minutes, spending more healing dices?

What are the repercussions of being able to finish a short rest in only 10 minutes instead of taking 1 hour?

Currently we are playing a horror adventure in D&D 5e. Due to circumstances (beings locked in a haunted house, rooms changing just when we close the doors, etc.), a 1-hour rest is hardly possible.

Our DM ruled that short rests can be as short as 10 minutes. The obvious result is that we can take it. What are other changes that we, both players and DM, should be aware of?

If it matters, party consists of Lore Bard, Vengeance Paladin, Chaos Sorcerer and Divination Wizard, all level 3.

Get Domain, Hosting and Email for 1 Year Configured in Minutes for $50

We Provide Google Domain and Google Cloud HostingGoDaddy Domain and GoDaddy HostingHostgator Domain and Hostgator HostingBigrock Domain and Bigrock HostingWordpress HostingWe are a Domain & Website hosting company offering a plethora of specialized web services, including domain hosting, website hosting and email address. We provide Super fast web hosting with a guarantee for security and reliability. We Provide domain name registration with DNS Service, Domain Forwarding. Web Hosting plans with Free website builder and Reseller Hosting.

by: necessitypro
Created: —
Category: Webhosting
Viewed: 246

The page you requested is temporarily unavailable. We apologize for the inconvenience, please check back in a few minutes

I am adding and updating 56 columns(include people picker column) and 4999 rows in sharepoint list through excel using rest api but after some time i get throttle temporary issue and it does not update or add all data. “The page you requested is temporarily unavailable. We apologize for the inconvenience, please check back in a few minutes”

I will transcribe audio or video of 5 Minutes for $7

Is transcription a boring task for you? Don’t Worry… Let us do this job for you I will transcribe any files like InterviewsCallsYoutube videosDictation Meeting etc. Features of the work: 100% readable transcriptsSpelling/grammar checkRevisions 100% satisfaction guaranteed 100% confidentiality Sounds relatable? then make your order with me. Looking forward to work with you.

by: irbaz
Created: —
Category: Transcription
Viewed: 258