Timeline for Speeding up a simple select query on Mariadb
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 15, 2016 at 14:05 | comment | added | jkavalik | Otherwise you can just add the index and check if the IO usage gets significantly higher. I doubt that but you should verify anyway. How big is the table? How much RAM does your server have? | |
| May 15, 2016 at 14:03 | comment | added | jkavalik |
The mul in the key column of your describe says the points col to be already indexed. Add full create table statement please.
|
|
| May 15, 2016 at 11:11 | 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. | |
| Nov 14, 2015 at 7:41 | comment | added | ypercubeᵀᴹ |
You need an index on (points, user_id) for the specific query to be faster.
|
|
| S Jul 27, 2015 at 20:28 | history | suggested | G-Nugget | CC BY-SA 3.0 |
formatting
|
| Jul 27, 2015 at 19:36 | review | Suggested edits | |||
| S Jul 27, 2015 at 20:28 | |||||
| Nov 1, 2014 at 1:03 | answer | added | Imre L | timeline score: -2 | |
| Oct 31, 2014 at 23:57 | history | edited | altunyurt |
edited tags
|
|
| Oct 31, 2014 at 23:42 | history | asked | altunyurt | CC BY-SA 3.0 |