Timeline for How to reduce the response time of a query that yields ~4.9 million rows in ~12-13 seconds
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 27, 2019 at 10:49 | answer | added | Mohamed ElKalioby | timeline score: -1 | |
| Jul 26, 2019 at 1:36 | comment | added | Rick James | What do you do with the 4.8M rows? I ask because maybe you could do more with it before getting to the client. | |
| Jul 26, 2019 at 1:34 | comment | added | Rick James |
What are the possible value of status? How many of each? SELECT status, count(*) FROM Outbound_call_files GROUP BY status;
|
|
| Jul 25, 2019 at 18:36 | comment | added | Jacob H | If your bottleneck is network then the solution is to reduce the data size being sent or increase the pipe size. There's no magic trick to circumvent this. | |
| Jul 25, 2019 at 18:32 | comment | added | Iori_Yagami | totally i agree with you but if the mess was done before I was and now you were requested to correct the mess | |
| Jul 25, 2019 at 18:23 | comment | added | mustaccio | "as dba my dutty is optimize and improve the mess" -- I think a DBA's duty is to avoid the mess, not improve it. You'll need to keep developers in line when warranted, including this case. In my view there is no realistic use case requiring the client to pull ~5 million rows from the database. Also, now that the query profile is properly formatted, it is obvious that the network is your bottleneck, and there's nothing you can do about it on the database side. | |
| Jul 25, 2019 at 18:10 | history | edited | MDCCL | CC BY-SA 4.0 |
Re-incorporated the generic tag of the database management system in use. Reworded some excerpts.
|
| Jul 25, 2019 at 18:08 | history | edited | Iori_Yagami | CC BY-SA 4.0 |
added 78 characters in body; edited tags
|
| Jul 25, 2019 at 17:51 | comment | added | Iori_Yagami | This query runs in Mysql 5.5.62, This table contains a total of ~ 5 millions of rows, RAM is 150G and the buffer pool is configured 100G | |
| Jul 25, 2019 at 17:42 | comment | added | Iori_Yagami | Im optimizing all slow queries into slow query log file and this query is one of them. I dont undestand logic behind from this query but as dba my dutty is optimize and improve the mess that the developers does | |
| Jul 25, 2019 at 17:36 | history | edited | MDCCL | CC BY-SA 4.0 |
Added formatting; fixed typos; reworded title; etc.
|
| Jul 25, 2019 at 17:30 | comment | added | mustaccio | What use case requires retrieving 4 million rows to the client? Please also consider formatting your question properly. | |
| Jul 25, 2019 at 17:20 | history | edited | Iori_Yagami | CC BY-SA 4.0 |
added 909 characters in body
|
| Jul 25, 2019 at 17:03 | history | edited | Iori_Yagami | CC BY-SA 4.0 |
deleted 218 characters in body
|
| Jul 25, 2019 at 16:35 | history | asked | Iori_Yagami | CC BY-SA 4.0 |