And how can i do that, , i am in my BIN folder and found MYSQLD application but what are the steps?

|
MasterZiv 2022-02-01 15:49:52
litmusv 2022-02-01 15:41:22
So I’d of table users will be the foreign key not user_type?

Yes.

M S 2022-02-01 15:53:32
for this user no of rows is 0 but the explain plan scans 11k + rows
MasterZiv 2022-02-01 16:01:12
I answered above …
M S 2022-02-01 16:03:14
MasterZiv 2022-02-01 16:01:12
I answered above …

Is there any way to reduce those rows scanning

cris_highlight_bot 2022-02-01 16:10:56
MasterZiv 2022-02-01 16:10:56
THis index is not sutable for the query

KEY IDX_QueuePosition (UserID,SkillID,CampaignID,ISActive,LastRequestTime) )

select * from tablename
where
UserID = 7127
AND SkillID = 41666
AND Priority = IFNULL(0,0)
AND ISActive = TRUE
AND CampaignID <> 0
AND LastRequestTime >= SUBDATE(NOW(),INTERVAL 1 MINUTE);
the sutable index would be
KEY IDX_QueuePosition (UserID,SkillID,ISActive,LastRequestTime) )

so the plan just shows “I’ll be scanning the fist index at hand”

mysql_en-16911.jpg

MasterZiv 2022-02-01 16:10:56
M S 2022-02-01 16:03:14
Is there any way to reduce those rows scanning

THis index is not sutable for the query

KEY IDX_QueuePosition (UserID,SkillID,CampaignID,ISActive,LastRequestTime) )

select * from tablename
where
UserID = 7127
AND SkillID = 41666
AND Priority = IFNULL(0,0)
AND ISActive = TRUE
AND CampaignID <> 0
AND LastRequestTime >= SUBDATE(NOW(),INTERVAL 1 MINUTE);
the sutable index would be
KEY IDX_QueuePosition (UserID,SkillID,ISActive,LastRequestTime) )

so the plan just shows “I’ll be scanning the fist index at hand”

M S 2022-02-01 16:17:44
MasterZiv 2022-02-01 16:10:56
THis index is not sutable for the query

KEY IDX_QueuePosition (UserID,SkillID,CampaignID,ISActive,LastRequestTime) )

select * from tablename
where
UserID = 7127
AND SkillID = 41666
AND Priority = IFNULL(0,0)
AND ISActive = TRUE
AND CampaignID <> 0
AND LastRequestTime >= SUBDATE(NOW(),INTERVAL 1 MINUTE);
the sutable index would be
KEY IDX_QueuePosition (UserID,SkillID,ISActive,LastRequestTime) )

so the plan just shows “I’ll be scanning the fist index at hand”

Thanq for the response 👍

litmusv 2022-02-01 16:19:09
MasterZiv 2022-02-01 15:49:52
Yes.

Thnakyou

Liran 2022-02-01 16:55:36
hi i have some problem I cant seem to understand:
i try to run this with my personal user:

GRANT insert,update ON *.* TO ‘my_ofer’@’%’;

but I get Error Code: 1045. Access denied for user ‘lirany’@’%’ (using password: YES)

with the root user I did:

grant all privileges on *.* to lirany@’%’ with grant option;

but still it doesnt let me run the grant with my own useer

Anjali 2022-02-02 07:36:29
Can anyone help me in this
Krishnak42 2022-02-02 08:49:09
Hello
Can anyone help me on stored procedures, i have some doubt on in out inout parameter….please share videos
Krishnak42 2022-02-02 09:07:53
Hello
How to create stored procedure in mysql
In
Out
Inout
please share syntax
Krishnak42 2022-02-02 09:18:07
Thank’s a lot
Liran 2022-02-02 12:19:36
does DROP COLUMN can cause a lock? the column was created but isn’t in use in any way
Khushi Hura 2022-02-02 12:19:51
Liran 2022-02-02 12:19:36
does DROP COLUMN can cause a lock? the column was created but isn’t in use in any way

No

Khushi Hura 2022-02-02 12:19:56
It can’t
MasterZiv 2022-02-02 12:23:31
Liran 2022-02-02 12:19:36
does DROP COLUMN can cause a lock? the column was created but isn’t in use in any way

ALTER TABLE will lock the table for fore time, exclusively.

Shraddha 2022-02-02 13:08:04
Cant connect to my localhost ,i have tried to start by going in into services yet it says ‘ the MySQL57 services on local computer started and then stopped.some services stop automatically if they are not in use by other services or programs.’ what am i suppose to do?
amuelle1 2022-02-02 13:18:22
Shraddha 2022-02-02 13:08:04
Cant connect to my localhost ,i have tried to start by going in into services yet it says ‘ the MySQL57 services on local computer started and then stopped.some services stop automatically if they are not in use by other services or programs.’ what am i suppose to do?

Take a look into mysql error log, should give you a hint what’s going wrong.

MasterZiv 2022-02-02 13:19:42
Shraddha 2022-02-02 13:08:04
Cant connect to my localhost ,i have tried to start by going in into services yet it says ‘ the MySQL57 services on local computer started and then stopped.some services stop automatically if they are not in use by other services or programs.’ what am i suppose to do?

Is it Windows ?

Shraddha 2022-02-02 13:19:56
Yes
Shraddha 2022-02-02 13:20:38
I activated my windows 10 license yesterday and right after that ,everytime i enter my password its crashing
amuelle1 2022-02-02 13:24:19
Sounds like a fundamental problem with the system. First solve this, than have a look at mysql.
amuelle1 2022-02-02 13:25:06
Hello, I’m a software developer from Germany with many years of experience with MySQL. But now I have a problem that I can’t get any further. After a new installation (VM) of the slave: MySQL master slave replication, version 5.7.33, Linux, slave fails to connect to master (error 1159), master reports “Got timeout reading communication packets”. From the console of the slave, connect to master is possible without any problems. Only the server process seems to have this problem, so no firewall, no connectivity problems are involved. Any ideas?
MasterZiv 2022-02-02 13:28:49
Shraddha 2022-02-02 13:20:38
I activated my windows 10 license yesterday and right after that ,everytime i enter my password its crashing

Then you can set MySQLD service to “always ON” mode, so that MySQL would start always and always work

MasterZiv 2022-02-02 13:30:12
amuelle1 2022-02-02 13:25:06
Hello, I’m a software developer from Germany with many years of experience with MySQL. But now I have a problem that I can’t get any further. After a new installation (VM) of the slave: MySQL master slave replication, version 5.7.33, Linux, slave fails to connect to master (error 1159), master reports “Got timeout reading communication packets”. From the console of the slave, connect to master is possible without any problems. Only the server process seems to have this problem, so no firewall, no connectivity problems are involved. Any ideas?

re-check your network then. most probably it is network.

MasterZiv 2022-02-02 13:31:36
amuelle1 2022-02-02 13:25:06
Hello, I’m a software developer from Germany with many years of experience with MySQL. But now I have a problem that I can’t get any further. After a new installation (VM) of the slave: MySQL master slave replication, version 5.7.33, Linux, slave fails to connect to master (error 1159), master reports “Got timeout reading communication packets”. From the console of the slave, connect to master is possible without any problems. Only the server process seems to have this problem, so no firewall, no connectivity problems are involved. Any ideas?

it can be different ports used for normal protocol connection and binlog fetching.
Re-check documentation what are ports.

MasterZiv 2022-02-02 13:32:15
Shraddha 2022-02-02 13:20:38
I activated my windows 10 license yesterday and right after that ,everytime i enter my password its crashing

this is not related to MySQL

amuelle1 2022-02-02 13:32:41
MasterZiv 2022-02-02 13:30:12
re-check your network then. most probably it is network.

I know this, thats why I rechecked it again and again. also testet app usage from slave machine to master without any problems. everything is working but the server process not.

Shraddha 2022-02-02 13:33:24
MasterZiv 2022-02-02 13:28:49
Then you can set MySQLD service to “always ON” mode, so that MySQL would start always and always work

And how can i do that ,,i am in my BIN folder and found MYSQLD application but what are the steps?

MasterZiv 2022-02-02 13:33:50
amuelle1 2022-02-02 13:32:41
I know this, thats why I rechecked it again and again. also testet app usage from slave machine to master without any problems. everything is working but the server process not.

re-check, probably you didn’t check it correctly.

MasterZiv 2022-02-02 13:34:38
Shraddha 2022-02-02 13:33:24
And how can i do that ,,i am in my BIN folder and found MYSQLD application but what are the steps?

By usual manipulation with a windows service. It is standard Windows thing

amuelle1 2022-02-02 13:36:23
MasterZiv 2022-02-02 13:31:36
it can be different ports used for normal protocol connection and binlog fetching.
Re-check documentation what are ports.

how to setup different port for bin log fetching? docu?

MasterZiv 2022-02-02 13:38:22
amuelle1 2022-02-02 13:36:23
how to setup different port for bin log fetching? docu?

IDK

MasterZiv 2022-02-02 13:40:06
amuelle1 2022-02-02 13:36:23
how to setup different port for bin log fetching? docu?

I don’t say you need to change the port number from default value to some other.
Just check in the docs, if binlog fetching requires an additional port, and if it does, enable another port in the firewall

|