Timeline for Is InnoDB Engine up to speed against Memory Engine?
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot | replaced http://stackoverflow.com/ with https://stackoverflow.com/ | |
| Jan 22, 2012 at 12:49 | history | edited | Question Overflow | CC BY-SA 3.0 | added 843 characters in body |
| Jan 21, 2012 at 21:12 | history | edited | RolandoMySQLDBA | Nothing MyISAM-specific, this I removed the myisam tag. I added the memory tag | |
| Jan 21, 2012 at 17:42 | answer | added | RolandoMySQLDBA | timeline score: 7 | |
| Jan 21, 2012 at 11:29 | history | tweeted | twitter.com/#!/StackDBAs/status/160685320977920001 | ||
| Jan 21, 2012 at 10:44 | history | migrated | from stackoverflow.com (revisions) | ||
| Jan 21, 2012 at 10:21 | comment | added | Ben Huh | @ypercube: I did monitor the overall RAM usage which never exceeds 50%. | |
| Jan 21, 2012 at 10:18 | comment | added | ypercubeᵀᴹ | And how much RAM does MySQL actually use? It could be more than 2GB. | |
| Jan 21, 2012 at 10:15 | comment | added | Ben Huh | @ypercube: I set it to 1.3GB. I have 2GB of RAM. My table size is 1.2GB inclusive of index. | |
| Jan 21, 2012 at 10:13 | comment | added | ypercubeᵀᴹ | What did you set innodb_buffer_pool_size to and how much is the actual RAM you have? | |
| Jan 21, 2012 at 10:10 | comment | added | Ben Huh | @FrederickCheung: Can I say that I am missing out something which would allow InnoDB engine to perform like Memory Engine? | |
| Jan 21, 2012 at 9:59 | comment | added | Frederick Cheung | The buffer pool isn't a query cache - it's a cache of database pages that innodb can use instead of having to read them from disk (so it will contain the actual table and index data) | |
| Jan 21, 2012 at 9:56 | answer | added | Teez | timeline score: 4 | |
| Jan 21, 2012 at 9:25 | history | asked | Question Overflow | CC BY-SA 3.0 |