What are the basic monitoring commands for MySQL in Linux OS using putty?

|
DBA 2022-09-26 19:48:08
Vikram Kesari 2022-09-26 15:58:31
Guys, help me with interview questions? on Mysql, n errors ..

Yes me too needed

unmonks 2022-09-26 20:29:54
Ganesh K 2022-09-26 15:21:20
Is system configuration like ram and cpu same on both…also did you tried to restart the machine and tried …
Did you see any spike while running update on slow server …
Or in both machine enough drive available…
Just curious, if all the parameters like table size and cpu and ram all same …why one take more and one is less time…

Possible of locks on table in production server …but this is not here …

Issue resolved, Dropped unwanted and duplicate indices.

Arvind Verma 2022-09-27 05:58:11
mysql_en-25295.jpg

Tom 2022-09-27 08:43:49
Which Infra ia good for middleware hosting App in respect of cost?

Bare Metal
Cloud Vms
Virtual OS
Containers

Tom 2022-09-27 08:44:03
Tom 2022-09-27 08:43:49
Which Infra ia good for middleware hosting App in respect of cost?

Bare Metal
Cloud Vms
Virtual OS
Containers

Anyone know the correct answer

dev 2022-09-27 08:53:44
mysql_en-25318.jpg
In my code, I want to assign a manager to the employee by selecting the manager and in front of it is the employee then click done to put them together. The system user can see the manager and employee name or email, but I want to send the id of each one of them to my if statement to take action. Each time I run the code it gave me this message: Trying to access array offset on the value of type null. I have done something like this with another script I have but this script doesn’t have select tags and I only receive one value.

What I have tried is:
In the code that is in the photo, I can see all the options perfectly but when choosing the value to send them to the condition it keeps giving me errors.
also when I put the end while under the form it works but the options will only repeat or only have one option.

BURUJULA GAYATHRI 2022-09-27 12:32:56
How can I find out which query is running slow inside a stored procedure.Can anyone help me
Grv 2022-09-27 12:35:37
BURUJULA GAYATHRI 2022-09-27 12:32:56
How can I find out which query is running slow inside a stored procedure.Can anyone help me

turn on slow logs to track

BURUJULA GAYATHRI 2022-09-27 12:38:33
How can I find this option
Ganesh K 2022-09-27 14:52:56
BURUJULA GAYATHRI 2022-09-27 12:38:33
How can I find this option

There is slow query log parameter ..default 10 seconds ..

2022-09-27 16:54:30
Grv 2022-09-27 12:35:37
turn on slow logs to track

exactly

Gopal 2022-09-28 08:01:33
Hello all will any one share the beginners course of sql
Varadamadhusudhan 2022-09-28 10:14:01
Gopal 2022-09-28 08:01:33
Hello all will any one share the beginners course of sql

Search in youtube

youraj 2022-09-28 11:17:45
Only sql is enough to get job(job purpose only)
Or
Some other language also needed.
🦹🏻‍♂️ 2022-09-28 11:22:12
youraj 2022-09-28 11:17:45
Only sql is enough to get job(job purpose only)
Or
Some other language also needed.

which job?

youraj 2022-09-28 11:23:17
Any job in IT sector
N K 2022-09-28 12:47:25
What are the basic monitoring commands for MySQL in Linux OS using putty ?
BURUJULA GAYATHRI 2022-09-28 17:03:10
How can I get the past 5 hours records based on trigger time
2022-09-28 17:04:45
BURUJULA GAYATHRI 2022-09-28 17:03:10
How can I get the past 5 hours records based on trigger time

easy

BURUJULA GAYATHRI 2022-09-28 17:31:39
2022-09-28 17:04:45
easy

Yes ofcourse but I have to check whenever a row inserted I have to check that record ia already entered in a table within 5 hours

BURUJULA GAYATHRI 2022-09-28 17:32:04
BURUJULA GAYATHRI 2022-09-28 17:31:39
Yes ofcourse but I have to check whenever a row inserted I have to check that record ia already entered in a table within 5 hours

If you know this let me know it is very helpful to me please

BURUJULA GAYATHRI 2022-09-28 17:34:00
Current _timestamp()- interval 5 Hour. Is it fine to put condition like this
Swapnil 2022-09-28 19:21:20
BURUJULA GAYATHRI 2022-09-28 17:34:00
Current _timestamp()- interval 5 Hour. Is it fine to put condition like this

yes

Shhss 2022-09-29 13:06:18
I should say, that I’m lucky enough to find the real platform among the fakes once, is really hard out there, many Investors has comes across so many fake managers in online trade, but for me my experience in bitcoin investment is awesome,but thanks to @Garys_williams is behind this joy I’m feeling right now, I invested 1000$ dollars and I make profit of 10k dollars in less than 3days this awesome.

You can also reach out to him via the link below

https://t.me/joinchat/W4lCMBm0HUlhZDM0
https://t.me/joinchat/W4lCMBm0HUlhZDM0

2022-09-29 15:53:51
Swapnil 2022-09-28 19:21:20
yes

wow

Tom 2022-09-29 17:19:21
How can we CaptureTraces Information?

DBCC Trace
SQL Profiler
Both A and B
Encryption
None of the above

Tom 2022-09-29 17:19:45
Tom 2022-09-29 17:19:21
How can we CaptureTraces Information?

DBCC Trace
SQL Profiler
Both A and B
Encryption
None of the above

Anyone please tell me what is the correct answer?

svart 2022-09-29 17:23:17
Tom 2022-09-29 17:19:21
How can we CaptureTraces Information?

DBCC Trace
SQL Profiler
Both A and B
Encryption
None of the above

Not related to mysql

Tom 2022-09-29 17:24:42
This is from mysql server
svart 2022-09-29 17:25:41
Tom 2022-09-29 17:24:42
This is from mysql server

There is a difference between mysql and SQL server

Swapnil 2022-09-29 17:26:18
Tom 2022-09-29 17:19:21
How can we CaptureTraces Information?

DBCC Trace
SQL Profiler
Both A and B
Encryption
None of the above

C

unmonks 2022-09-29 20:16:06
Tom 2022-09-29 17:19:21
How can we CaptureTraces Information?

DBCC Trace
SQL Profiler
Both A and B
Encryption
None of the above

Both A and B

Tom 2022-09-29 20:16:27
Thanks❤️
Kennedy 2022-09-29 21:58:18
Hallo friends… is this possible … I have two tables whereby I want to insert to table 2 by selecting from table 1 and then delete all the data in table 1
Tom 2022-09-29 22:04:37
How to monitor blocking?

Sp_who2
Select * from Sys.sysprocesses
Sp_who
All of the mentioned
None of the above

|