How can I check if a query is causing a lock?

|
PS 2022-01-29 13:00:58
MasterZiv 2022-01-29 12:59:16
If so, and you can’t find MSI for Win 64 – install MSI 32 bit, I think, as you are a beginner, this will be more then enough for you.

I am beginner for databases. Not for programming. But it seems like, it really does not work. I found 64bit, it was a zip file, but could not install it and then I tried the 32bit, it did not work…

MasterZiv 2022-01-29 13:01:29
PS 2022-01-29 13:00:58
I am beginner for databases. Not for programming. But it seems like, it really does not work. I found 64bit, it was a zip file, but could not install it and then I tried the 32bit, it did not work…

Yes this is for manual installation.

PS 2022-01-29 13:04:13
MasterZiv 2022-01-29 12:54:07
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

MySQL Installer Method

The simplest and recommended method is to download MySQL Installer (for Windows) and let it install and configure a specific version of MySQL Server as follows:

Download MySQL Installer from https://dev.mysql.com/downloads/installer/ and execute it.

Yes, thank you! I did everything written there… I downloaded the 64bit zip folder, I executed and then? After that nothing works… In Google it says I should find the ini-file default and change it… There is no such file…. In oracle it says I need visual 2019… So I installed that and then? Nothing worked… I wonder if everyone uses a different operating system than windows for mysql…

PS 2022-01-29 13:04:46
MasterZiv 2022-01-29 13:01:29
Yes this is for manual installation.

There is no automatic installation. I did not want manually… But no chance…

PS 2022-01-29 13:05:53
You are so nice! Thanks all ☺️ for your time and assistance.
PS 2022-01-29 13:06:21
I am rotating in circle as after downloading it is not working as written in the manual…
PS 2022-01-29 13:12:09
mysql_en-16787.jpg

PS 2022-01-29 13:12:19
I did all of the step.
Step 1 check (Microsoft Visual C++ 2019)
Step two check
And the last step 3 it says install…
PS 2022-01-29 13:12:44
I clicked the link and it says I should find a ini… But there is no such file. No where…
PS 2022-01-29 13:13:23
mysql_en-16790.jpg

PS 2022-01-29 14:25:55
MasterZiv 2022-01-29 13:00:55
I;ll probably will find the MSI later, I’ll try finding

Thank you, I will wait ☺️

Deb_575 2022-01-29 18:51:57
PriyaJeevan18 2022-01-27 08:56:29
Hi all,

I want to upgrade MySQL 5.7.31 to 5.7.36 on windows

Can anyone please help me with the steps?

Just go with inplace upgrade, it’s a minor version upgrade

Qureshi Sohel 2022-01-30 10:04:14
mysql_en-16805.jpg

Qureshi Sohel 2022-01-30 10:04:15
mysql_en-16806.jpg

Qureshi Sohel 2022-01-30 10:04:23
Anyone please help me how app download sql coding
i00chi 2022-01-30 11:26:48
mysql_en-16812.jpg

i00chi 2022-01-30 11:27:16
i00chi 2022-01-30 11:26:48

so, I tried to create a contraint key for the this

i00chi 2022-01-30 11:27:38
Before that, greeting. hello everyone. I need a little help here.
i00chi 2022-01-30 11:28:27
i00chi 2022-01-30 11:27:16
so, I tried to create a contraint key for the this

i deleted the old foreign key in the customer and get booking table even so, it’s still giving me the yellow error up there.

Liran 2022-01-30 17:36:52
how can I check if a query is causing a lock? and how can I kill other process/query to let me query run without locks?
MasterZiv 2022-01-30 17:37:59
Liran 2022-01-30 17:36:52
how can I check if a query is causing a lock? and how can I kill other process/query to let me query run without locks?

Did you mean deadlocks?

Liran 2022-01-30 17:38:28
MasterZiv 2022-01-30 17:37:59
Did you mean deadlocks?

yes, it caused my production to shutdown last night

MasterZiv 2022-01-30 17:44:20
Liran 2022-01-30 17:38:28
yes, it caused my production to shutdown last night

This cannot be, deadlocks are usual thing, can’t cause server shut down

Liran 2022-01-30 17:44:52
i will explain – we try to alter a table to add some column on a production server (there might be queries running on this table), i want to run this alter and in case there’s a lock be aware of it and kill the other query. for some reason last time there was a shutdown for some reason. not sure a dead lock 😮
MasterZiv 2022-01-30 17:44:54
Liran 2022-01-30 17:38:28
yes, it caused my production to shutdown last night

Look into the server log, deadlocks should be there

Liran 2022-01-30 17:49:31
MasterZiv 2022-01-30 17:44:54
Look into the server log, deadlocks should be there

maybe i am wrong regard the type of lock. we did alter to an existing table to add a column.

MasterZiv 2022-01-30 17:50:45
Liran 2022-01-30 17:49:31
maybe i am wrong regard the type of lock. we did alter to an existing table to add a column.

Hardly it was a dead lock

Liran 2022-01-30 17:51:51
MasterZiv 2022-01-30 17:50:45
Hardly it was a dead lock

what kind of lock alter is causing?

MasterZiv 2022-01-30 17:54:30
Liran 2022-01-30 17:44:52
i will explain – we try to alter a table to add some column on a production server (there might be queries running on this table), i want to run this alter and in case there’s a lock be aware of it and kill the other query. for some reason last time there was a shutdown for some reason. not sure a dead lock 😮

This is usually done like that :
1 Turn IP tables to disallow new connections
2 Disconnect all the existing connections (kill) You may optionally way till the connections are not busy.
3 do alter
4 turn ip tables off

MasterZiv 2022-01-30 17:54:43
Liran 2022-01-30 17:51:51
what kind of lock alter is causing?

Just locks

MasterZiv 2022-01-30 17:55:45
Liran 2022-01-30 17:44:52
i will explain – we try to alter a table to add some column on a production server (there might be queries running on this table), i want to run this alter and in case there’s a lock be aware of it and kill the other query. for some reason last time there was a shutdown for some reason. not sure a dead lock 😮

This cannot be done like this, afaik

Liran 2022-01-30 17:56:36
MasterZiv 2022-01-30 17:54:30
This is usually done like that :
1 Turn IP tables to disallow new connections
2 Disconnect all the existing connections (kill) You may optionally way till the connections are not busy.
3 do alter
4 turn ip tables off

but this means like doing a downtime

madno 2022-01-30 17:56:51
Can we estimate a query execution time?
Liran 2022-01-30 17:57:13
i want to run this alter and in case it gets locked kill the locking query, isn’t it possible?
nikhil02220 2022-01-30 18:39:17
Liran 2022-01-30 17:57:13
i want to run this alter and in case it gets locked kill the locking query, isn’t it possible?

You can use pt-online-schema-change tool. Explore the tool.

|