Timeline for Best configuration for MySQL? InnoDB and MyISAM
Current License: CC BY-SA 3.0
23 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 28, 2017 at 15:24 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 26, 2017 at 20:27 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 19, 2017 at 6:13 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 14, 2017 at 3:14 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 10, 2017 at 13:40 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 11, 2017 at 1:55 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 9, 2016 at 23:29 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 27, 2016 at 21:20 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 23, 2016 at 22:34 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 22, 2016 at 22:35 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 23, 2016 at 3:30 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 2, 2016 at 14:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 9, 2015 at 0:09 | comment | added | Michael - sqlbot |
You should remove all of those settings except innodb_buffer_pool_size. Don't depart from the defaults unless you have a specific reason to, and verify the impact of each change, separately. Tweaking parameters like this can have unintended consequences and most "tuning" advice you will find is not helpful.
|
|
| May 8, 2015 at 21:20 | answer | added | Rick James | timeline score: 1 | |
| May 8, 2015 at 8:27 | answer | added | Masoud | timeline score: 1 | |
| May 8, 2015 at 5:46 | comment | added | jkavalik | Well, it does not seem wrong to me, but I don't have enough experience to weight its optimality. | |
| May 8, 2015 at 5:37 | comment | added | Roberto Chaves | @user1786423 Alright, thanks, will try that later. But do you know if my current configuration is optimal? | |
| May 8, 2015 at 5:27 | comment | added | jkavalik | Ah, I hit enter too fast and then edited previous comment instead of making another one - check the "exteded version" please :) | |
| May 8, 2015 at 5:27 | history | edited | Roberto Chaves | CC BY-SA 3.0 |
edited body
|
| May 8, 2015 at 5:25 | comment | added | Roberto Chaves | Yes.. sorry @user1786423 | |
| May 8, 2015 at 5:23 | comment | added | jkavalik | I suppose you meant MyISAM with those "2.2 Seconds". Otherwise - MyISAM does not support ACID (transactions) so it does a lot less work than InnoDB - but it has to lock the entire table for some operations where InnoDB can only locks specific rows - so the difference should be other way around on parallel concurent operations. | |
| May 8, 2015 at 4:31 | review | First posts | |||
| May 8, 2015 at 5:13 | |||||
| May 8, 2015 at 4:26 | history | asked | Roberto Chaves | CC BY-SA 3.0 |