How to resolve this warning?

|
smlkw 2022-04-24 17:16:04
ysf_cms 2022-04-24 17:13:12
it takes 7-8 seconds to return the same query all the time and search the site everything is very good, but the search part is dec dec slow

I can commercially try to help you

If you’re interested, let’s talk in private messages about this

Rslnm87 2022-04-25 17:26:58
Can anybody help me with two questions about ASSERTION?
2022-04-25 17:30:28
Rslnm87 2022-04-25 17:26:58
Can anybody help me with two questions about ASSERTION?

Yes go ahead

Rslnm87 2022-04-25 17:32:58
2022-04-25 17:30:28
Yes go ahead

oh thanksss. Here In the 7.4.1 question, I need the answers for b and d section :

BayMykel 2022-04-26 05:33:58
Please why is MySQL server not working
BayMykel 2022-04-26 05:37:09
I’ve installed and uninstalled severally
engineerbu 2022-04-26 07:38:08
Try delete the Installation folder 📁 on Programs and files .. Restart and install again
2022-04-26 13:39:42
W3 school
Chandan Chowdary 2022-04-26 15:26:40
Anyone having MySQL master setup document
Chandan Chowdary 2022-04-26 15:28:36
Hi, Database is slow users are unable to connect and also taking more time to execute queries. So how to resolve the issue
smlkw 2022-04-26 16:19:32
Chandan Chowdary 2022-04-26 15:28:36
Hi, Database is slow users are unable to connect and also taking more time to execute queries. So how to resolve the issue

Tell more about characteristics of your MySQL server and which queries people send to the server

Chandan Chowdary 2022-04-26 16:20:23
Users are trying to fitch out the data
smlkw 2022-04-26 16:21:42
Chandan Chowdary 2022-04-26 16:20:23
Users are trying to fitch out the data

Did you track how much data they are fetching?
Maybe queries just too big and your server doesn’t have enough resources to proceed their requests

Chandan Chowdary 2022-04-26 16:22:48
Almost there are fetching 20+ tables
Chandan Chowdary 2022-04-26 16:23:14
And other users can’t work on the same database server
Chandan Chowdary 2022-04-26 16:23:42
So what steps should I have to take now from the performance side
smlkw 2022-04-26 16:25:53
Chandan Chowdary 2022-04-26 16:23:42
So what steps should I have to take now from the performance side

You need to check how much time each query takes for each user and approximate time to all your users in order the server could process them all without issues to user’s conveinience

Chandan Chowdary 2022-04-26 16:27:16
It should be taken more than 60 sec
Chandan Chowdary 2022-04-26 16:28:11
Some users query are running more then 120 min
getgoon 2022-04-26 16:29:32
Optimize the query or you need to load balance
smlkw 2022-04-26 16:31:38
Chandan Chowdary 2022-04-26 16:28:11
Some users query are running more then 120 min

you can use EXPLAIN to see how much data each query takes

this way you can optimize queries

Professor_Mi 2022-04-26 17:46:14
mysql_en-20139.jpg
Hi Guys can someone please share some docs to create mysql database schema for a chat system which contains the following :
Ruslan_Shade 2022-04-26 22:22:31
Hello, can someone help me, with replicas lag every hour for 5min
Me 2022-04-26 22:58:42
Anyone awake who knows sql..?
Me 2022-04-26 22:58:57
Would be great if u can just ping me.!
smlkw 2022-04-26 22:59:30
Me 2022-04-26 22:58:42
Anyone awake who knows sql..?

Please, ask your question without flood

Rafael 2022-04-27 02:37:55
hello, does anyone have a registration and login system with Google Authenicator?
Amrendra_Singh1 2022-04-27 08:35:53
mysql_en-20158.jpg
How to resolve this warning?
Amrendra_Singh1 2022-04-27 08:36:03
Amrendra_Singh1 2022-04-27 08:35:53
How to resolve this warning?

Kindly suggest me

P P 2022-04-27 15:22:35
q=Employee.objects.filter(‘sub’ = ‘comp’)
q = q.filter(‘marks’ >50)
q = q.sort
print(q)
In above how many times the database was invoked?
Can anyone tell me answer of this question
Arjun526 2022-04-27 15:23:55
mysql_en-20165.jpg

Arjun526 2022-04-27 15:24:11
Could anyone solve this
smlkw 2022-04-27 15:26:00
Rafael 2022-04-27 02:37:55
hello, does anyone have a registration and login system with Google Authenicator?

https://github.com/egorsmkv/otp-qr-demo

You check out my demo for using QR authentication

GitHub – egorsmkv/otp-qr-demo: A demonstration on how to create own OTP authenticationGitHub
A demonstration on how to create own OTP authentication – GitHub – egorsmkv/otp-qr-demo: A demonstration on how to create own OTP authentication
smlkw 2022-04-27 15:27:28
P P 2022-04-27 15:22:35
q=Employee.objects.filter(‘sub’ = ‘comp’)
q = q.filter(‘marks’ >50)
q = q.sort
print(q)
In above how many times the database was invoked?
Can anyone tell me answer of this question

It’s better to see queries in your MySQL server using enabled query_log

Or you can use debug modules for Django to see invoked queries

P P 2022-04-27 15:28:34
smlkw 2022-04-27 15:27:28
It’s better to see queries in your MySQL server using enabled query_log

Or you can use debug modules for Django to see invoked queries

Ok

|