Timeline for Configuring MySQL (my.cnf) for MyISAM and InnoDB
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 15, 2019 at 14:26 | comment | added | Malus Jan |
@RolandoMySQLDBA Config file: [mysql] [mysqld] tmp_table_size=2G max_heap_table_size=2G innodb_data_file_path = ibdata1:10M:autoextend:max:512M key_buffer_size = 256M max_allowed_packet = 1M table_open_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 16M [myisamchk] key_buffer_size = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout
|
|
| Apr 15, 2019 at 14:25 | comment | added | Malus Jan | @RolandoMySQLDBA I start working on a web application which is hosted in linux (ubuntu) with 2G RAM and 2 CPU. but the mysqld process get about 70% of the memory and do not release it. There is a backup process (mysqldump) run each midnight which takes lots of memory. I want o know if there is any way to release the memory taken by mysqldump or optimising the mysql.cnf (MySQL 5.7)? I'll put the config file in next comment. Thanks | |
| Apr 15, 2019 at 14:21 | comment | added | RolandoMySQLDBA | @MalusJan default values are sufficient when memory is at a premium. The OS needs memory more than the DB when the amount of RAM is low. Personally, I would start with 512M for innodb_buffer_pool_size and tune conservatively from there. | |
| Apr 15, 2019 at 14:04 | comment | added | Malus Jan | @RolandoMySQLDBA If the server has just 2G memory what's your recommendation? | |
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Feb 8, 2017 at 11:17 | comment | added | Rocco The Taco | Does this work with MariaDb as well? | |
| Feb 8, 2017 at 11:14 | comment | added | Rocco The Taco | When I try this I get an error? I've already done the conversion prior to adjusting the my.cnf. | |
| May 21, 2013 at 22:37 | vote | accept | tschelik | ||
| May 10, 2013 at 14:44 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
added 1027 characters in body
|
| May 10, 2013 at 1:18 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
added 1 characters in body
|
| May 9, 2013 at 21:07 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |