13 replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
source | link
12 deleted 5 characters in body; Post Made Community Wiki
source | link

What most people are unaware of is that the InnoDB Transaction Log Files are the same size for all models : 128M. Given default settings (innodb_log_files_in_group = 2), that's 256M of Transaction Log Space. If you wish to resize themset some other InnoDB option, you must do the followingthis:

  • Create a Custom DB Parameter Group (call it MySettings)
  • Download RDS CLI and setup a config file with your AWS Credentials
  • Execute the following : ./rds-modify-db-parameter-group MySettings --parameters "name=innodb_log_file_size"name=<InnoDB Option>,value=1Gvalue=???,method=immediate"
  • Modify using DB Parameter Option List MySettings
  • Restart the MySQL RDS Instance

What most people are unaware of is that the InnoDB Transaction Log Files are the same size for all models : 128M. Given default settings (innodb_log_files_in_group = 2), that's 256M of Transaction Log Space. If you wish to resize them, you must do the following:

  • Create a Custom DB Parameter Group (call it MySettings)
  • Download RDS CLI and setup a config file with your AWS Credentials
  • Execute the following : ./rds-modify-db-parameter-group MySettings --parameters "name=innodb_log_file_size,value=1G,method=immediate"
  • Modify using DB Parameter Option List MySettings
  • Restart the MySQL RDS Instance

What most people are unaware of is that the InnoDB Transaction Log Files are the same size for all models : 128M. Given default settings (innodb_log_files_in_group = 2), that's 256M of Transaction Log Space. If you wish to set some other InnoDB option, do this:

  • Create a Custom DB Parameter Group (call it MySettings)
  • Download RDS CLI and setup a config file with your AWS Credentials
  • Execute the following : ./rds-modify-db-parameter-group MySettings --parameters "name=<InnoDB Option>,value=???,method=immediate"
  • Modify using DB Parameter Option List MySettings
  • Restart the MySQL RDS Instance
11 added 2 characters in body
source | link

I hope you are not using LODA DATA INFILELOAD DATA INFILE for importing. Why ? Because, only MyISAM tables benefit from it in conjunction with the bulk insert buffer (which by default is 8M). InnoDB does not benefit from it.

I hope you are not using LODA DATA INFILE for importing. Why ? Because, only MyISAM tables benefit from it in conjunction with the bulk insert buffer (which by default is 8M). InnoDB does not benefit from it.

I hope you are not using LOAD DATA INFILE for importing. Why ? Because, only MyISAM tables benefit from it in conjunction with the bulk insert buffer (which by default is 8M). InnoDB does not benefit from it.

10 added 126 characters in body
source | link
9 deleted 98 characters in body; added 1 characters in body
source | link
8 added 54 characters in body
source | link
7 added 44 characters in body; added 110 characters in body
source | link
6 added 76 characters in body
source | link
5 added 2181 characters in body; added 60 characters in body; added 351 characters in body
source | link
4 added 117 characters in body; added 208 characters in body
source | link
3 added 1467 characters in body; added 398 characters in body
source | link
2 added 512 characters in body
source | link
1
source | link