Timeline for High CPU usage from sorting result queries
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:23 | history | edited | CommunityBot |
added [query-performance] to 2412 questions - Shog9 (Id=1924)
|
|
| Jul 7, 2017 at 23:18 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 6, 2017 at 20:27 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 1, 2017 at 10:50 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 24, 2017 at 9:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 15, 2017 at 20:42 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 24, 2016 at 20:20 | answer | added | Rick James | timeline score: 0 | |
| Jun 12, 2016 at 20:15 | answer | added | jkavalik | timeline score: 1 | |
| Jun 12, 2016 at 19:23 | comment | added | iLinux85 | @jkavalik i update my question with your needs | |
| Jun 12, 2016 at 19:22 | history | edited | iLinux85 | CC BY-SA 3.0 |
update my question with requested needs
|
| Jun 12, 2016 at 19:09 | history | edited | iLinux85 | CC BY-SA 3.0 |
added 4 characters in body
|
| Jun 10, 2016 at 20:42 | comment | added | jkavalik |
Your processlist shows most sorts on ooo_video_serie, please run show create table ooo_video_serie; and add the results to your question. Then run EXPLAIN SELECT * FROM ooo_video_serie WHERE id_episode='96652' AND active=1 ORDER BY langue,lorde ASC; and add the output too.
|
|
| Jun 10, 2016 at 11:34 | comment | added | Rathish Kumar B | Enable slow query log and identify the the specific query which utilizing high CPU power. | |
| Jun 9, 2016 at 21:39 | history | asked | iLinux85 | CC BY-SA 3.0 |