Timeline for Release MySQL Memory and Performance Tunning
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:22 | history | edited | CommunityBot |
added [performance-tuning] to 516 questions - Shog9 (Id=1924)
|
|
| Dec 23, 2015 at 16:48 | answer | added | Morgan Tocker | timeline score: 1 | |
| Dec 11, 2015 at 9:08 | history | tweeted | twitter.com/StackDBAs/status/675240799454515200 | ||
| Dec 10, 2015 at 18:48 | comment | added | Michael - sqlbot | You are tweaking far too many variables with this configuration. If you don't have a specific, objective reason for each of these entries, you should start with the defaults. | |
| Dec 10, 2015 at 15:31 | answer | added | Derek Downey | timeline score: 4 | |
| Dec 10, 2015 at 15:04 | comment | added | Derek Downey |
resizing the innodb_buffer_pool_size online is pretty invasive and will lock the db until it's complete. MySQL won't release global memory buffers, and only releases thread buffers after the thread is removed (ie; not held by thread_cache). If you get noticeable gain by allocating that extra 4GB, you should be budgeting your cloud spend with that in mind.
|
|
| Dec 10, 2015 at 14:41 | comment | added | ypercubeᵀᴹ |
innodb_buffer_pool_size has become a dynamic variable in 5.7.5. Perhaps you can use that.
|
|
| Dec 10, 2015 at 14:07 | history | edited | ypercubeᵀᴹ | CC BY-SA 3.0 |
added 520 characters in body
|
| Dec 10, 2015 at 12:50 | comment | added | András Váczi | To clarify, above I did not mean releasing the memory to the OS (or other application), but marking it as reusable by MySQL itself. | |
| Dec 10, 2015 at 11:09 | comment | added | András Váczi | In addition to @ypercube's comment, I'd expect MySQL to immediately release any memory it doesn't need anymore, to free it for its own purposes. I guess further that this is already implemented in the DB engine, possibly better than you could. | |
| Dec 10, 2015 at 11:03 | comment | added | ypercubeᵀᴹ | Why do you want to release the memory if the server is dedicated to MySQL? What would the RAM be used for? | |
| Dec 10, 2015 at 10:31 | history | edited | Julien Vavasseur | CC BY-SA 3.0 |
deleted 10 characters in body
|
| S Dec 10, 2015 at 10:29 | history | suggested | a_vlad | CC BY-SA 3.0 |
format code
|
| Dec 10, 2015 at 10:05 | review | Suggested edits | |||
| S Dec 10, 2015 at 10:29 | |||||
| Dec 10, 2015 at 10:01 | review | First posts | |||
| Dec 10, 2015 at 10:31 | |||||
| Dec 10, 2015 at 9:58 | history | asked | Mahipat | CC BY-SA 3.0 |