Timeline for Same SQL stall on server but work on local ( on slower machine )
Current License: CC BY-SA 3.0
23 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 10, 2015 at 8:14 | history | edited | WonderLand | CC BY-SA 3.0 |
edited body
|
| Sep 4, 2015 at 8:46 | comment | added | jkavalik | @WonderLand which client sent the query has no effect in deciding what plan to use for its execution. | |
| Sep 4, 2015 at 8:39 | vote | accept | WonderLand | ||
| Sep 4, 2015 at 5:19 | comment | added | WonderLand | thx, I did and the problem is the same, I'm trying to downgrade my local mysql to to same live version ... | |
| Sep 4, 2015 at 5:14 | comment | added | jkavalik | @WonderLand You can use commandline mysql. | |
| Sep 4, 2015 at 4:50 | answer | added | greenlitmysql | timeline score: 1 | |
| Sep 4, 2015 at 4:19 | history | edited | WonderLand | CC BY-SA 3.0 |
deleted 142 characters in body
|
| Sep 4, 2015 at 3:46 | comment | added | WonderLand |
Done. I'm running the SQL using php that also for sure make a difference ... how can I test it without php ?
|
|
| Sep 4, 2015 at 3:45 | history | edited | WonderLand | CC BY-SA 3.0 |
added 3750 characters in body; edited tags
|
| Sep 3, 2015 at 23:31 | comment | added | Rick James |
Please provide SHOW CREATE TABLE for each of the three tables.
|
|
| Sep 3, 2015 at 17:28 | comment | added | WonderLand | I have added the index info for the two main tables | |
| Sep 3, 2015 at 17:27 | history | edited | WonderLand | CC BY-SA 3.0 |
added 5754 characters in body
|
| Sep 3, 2015 at 8:52 | comment | added | jkavalik | They probably are (at least partially). Can you add table/index information too, so we can see what each index contains? | |
| Sep 3, 2015 at 8:44 | comment | added | WonderLand | I found out some difference in the explain ... I'm not sure if they are relevant | |
| Sep 3, 2015 at 8:43 | history | edited | WonderLand | CC BY-SA 3.0 |
added 155 characters in body
|
| Sep 3, 2015 at 8:35 | history | edited | WonderLand | CC BY-SA 3.0 |
added 1124 characters in body
|
| Sep 3, 2015 at 8:30 | comment | added | WonderLand | but the query is not so heavy and the difference in time is huge, I doubt the optimization on mysql 5.6 are so big ... | |
| Sep 3, 2015 at 7:32 | comment | added | jkavalik | The EXPLAIN will show, but if table structure is the same, my guess is 5.6 has just better plan (and maybe some optimization). | |
| Sep 3, 2015 at 6:53 | comment | added | WonderLand | local ha 8gb ram, live 32 gb... I'm trying the explain command | |
| Sep 3, 2015 at 6:52 | history | edited | WonderLand | CC BY-SA 3.0 |
added 442 characters in body
|
| Sep 3, 2015 at 6:47 | comment | added | Marco |
Did you try the explain command to see how the SQL is behaving? Do both the live server and your local machine have the same memory used by the database? Databases benefit more from memory than CPU.
|
|
| Sep 3, 2015 at 5:56 | review | First posts | |||
| Sep 3, 2015 at 7:07 | |||||
| Sep 3, 2015 at 5:56 | history | asked | WonderLand | CC BY-SA 3.0 |