Timeline for Is the Memory engine adequate for a read intensive/lookup table?
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 15, 2020 at 9:05 | history | edited | CommunityBot | Commonmark migration | |
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot | replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/ | |
| Jan 29, 2013 at 18:36 | comment | added | Pedro Werneck | A side question... do you recommend querying if the key exists in any particular way? Is it possible that I'm skipping the cache if I do any fancy stuff, like select exists (select * from blacklist where num=x) ? | |
| Jan 28, 2013 at 23:12 | comment | added | RolandoMySQLDBA | Fixed it in the question, thank you for catching that. And you're welcome. | |
| Jan 28, 2013 at 23:12 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | deleted 9 characters in body |
| Jan 28, 2013 at 23:09 | vote | accept | Pedro Werneck | ||
| Jan 28, 2013 at 23:09 | comment | added | Pedro Werneck | I think the last line was wrong too. It gave me the no "blacklist_keycache" error, but when I replaced it with the table name, it worked beautifully. Time spent on that query decreased by over 50%, and disk I/O decreased noticeably too. Thanks a lot! | |
| Jan 28, 2013 at 18:55 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | added 658 characters in body |
| Jan 28, 2013 at 5:09 | comment | added | RolandoMySQLDBA | Sorry the INTO should be IN. I updated the answer... | |
| Jan 28, 2013 at 5:07 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | deleted 2 characters in body |
| Jan 28, 2013 at 1:53 | comment | added | Pedro Werneck | I get a syntax error with the INTO on the second statement. Is that right? | |
| Jan 28, 2013 at 0:48 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |