Timeline for What performance should I expect from MySQL (Using Amazon RDS)
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 6, 2013 at 10:31 | vote | accept | Chen Harel | ||
| Nov 5, 2013 at 22:12 | answer | added | ypercubeᵀᴹ | timeline score: 2 | |
| Nov 5, 2013 at 21:55 | comment | added | Chen Harel | @ypercube - edited question. | |
| Nov 5, 2013 at 21:53 | history | edited | Chen Harel | CC BY-SA 3.0 |
added 130 characters in body
|
| Nov 5, 2013 at 21:49 | comment | added | ypercubeᵀᴹ |
How many distinct pk2 values are there in total (in the whole table)? And please add the exact query you are running.
|
|
| Nov 5, 2013 at 21:27 | comment | added | Chen Harel | done. it's 5.6.13 | |
| Nov 5, 2013 at 21:27 | history | edited | Chen Harel | CC BY-SA 3.0 |
more stuff from comments
|
| Nov 5, 2013 at 21:15 | comment | added | Raymond Nijland | Can you post an SHOW PROFILE ALL FOR QUERY query_id (id is with in SHOW PROFILES) (because i want to know the CPU timings) and also the MySQL version? | |
| Nov 5, 2013 at 20:56 | comment | added | Chen Harel | added both create table and profiling to question | |
| Nov 5, 2013 at 20:55 | history | edited | Chen Harel | CC BY-SA 3.0 |
added create and profiling
|
| Nov 5, 2013 at 20:29 | comment | added | Raymond Nijland | based on the explain output... InnoDB engine gives an estimate off 493481 rows and need to use an WHERE condition to filter out more records (so your query should consume some CPU cycles) .. type range tells me InnoDB chooses to do an Disk scan based on PRIMARY KEY range and needs to use an temporary table.. | |
| Nov 5, 2013 at 20:25 | comment | added | Raymond Nijland | So we still and "show create table " statement output.. and please also run an profile on that query... SET profiling = 1; YOUR_QUERY; SHOW PROFILES; SHOW PROFILE ALL FOR QUERY query_id (id is with in SHOW PROFILES) and also post that output here | |
| Nov 5, 2013 at 17:50 | history | asked | Chen Harel | CC BY-SA 3.0 |