Timeline for mysql session logging tables
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 13, 2012 at 15:06 | comment | added | Jarede | you're right thats not using an index on that query. we're using that on a paginated page, so generally there will be only 40 accountids at a time (untill we allow users to decide how many accounts they want per page). | |
| Nov 13, 2012 at 15:03 | comment | added | Derek Downey | You can add EXPLAIN before the select: EXPLAIN SELECT count(id).. to get an idea of what MySQL is doing to process your query. Unless there is a very good reason for it, I wouldn't search for accountid IN (unlimited id list). See my answer footnote for why. | |
| Nov 13, 2012 at 15:01 | answer | added | Derek Downey | timeline score: 2 | |
| Nov 13, 2012 at 14:45 | history | edited | Derek Downey | CC BY-SA 3.0 | a bit of formatting |
| Nov 13, 2012 at 14:35 | comment | added | Jarede | added, let me know if you'd like anymore info. | |
| Nov 13, 2012 at 14:34 | history | edited | Jarede | CC BY-SA 3.0 | Showing table creation details and a sample query |
| Nov 13, 2012 at 14:15 | comment | added | Derek Downey | Hi, can you add the DDL (SHOW CREATE TABLE) for one of the session tables. Also, give a few of the queries you're running that you notice slowdown with. | |
| Nov 13, 2012 at 10:55 | history | asked | Jarede | CC BY-SA 3.0 |