)]}'
{"lib/databases/mysql":[{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"7b3bb15cadd3f09b76dd7f34f65fe41c2a23c144","unresolved":false,"context_lines":[{"line_number":96,"context_line":"    iniset -sudo $my_conf mysqld bind-address \"$SERVICE_LISTEN_ADDRESS\""},{"line_number":97,"context_line":"    iniset -sudo $my_conf mysqld sql_mode TRADITIONAL"},{"line_number":98,"context_line":"    iniset -sudo $my_conf mysqld default-storage-engine InnoDB"},{"line_number":99,"context_line":"    iniset -sudo $my_conf mysqld max_connections 256"},{"line_number":100,"context_line":"    iniset -sudo $my_conf mysqld query_cache_type OFF"},{"line_number":101,"context_line":"    iniset -sudo $my_conf mysqld query_cache_size 0"},{"line_number":102,"context_line":""}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_18abf175","line":99,"updated":"2017-03-01 07:16:02.000000000","message":"Cool, let\u0027s dig into that a little. binlog_cache_size is only allocated when binary logging is enabled. We should definitely disable that in a devstack context (yay, 4K). We have read_rnd_buffer_size set to 8200 bytes, but we could drop it lower (manual says min of 1 byte.. I\u0027d say we could go to 256 bytes so that at least the few ordered joins we do are not 100% disk serviced. \nWith those adjustments:\n\nsort_buffer_size \u003d 32768\nread_buffer_size \u003d 8200\nread_rnd_buffer_size \u003d 256\njoin_buffer_size \u003d 128\nthread_stack \u003d 196608\nbinlog_cache_size \u003d (0|4096)\n\nNot sure how you got to 10.3MB earlier, maybe we forgot a variable? With the changes I suggest, it gets even lower. All I did was drop binlog_cache_size\u0027s 4K, and read_rnd_buffer_size\u0027s 8200 bytes. But if you make the adjustments I suggest, per-conn overhead using your formula is 237960, or about 232kB. So the difference is 256*232 \u003d\u003d 58MB (total at 256 connections) vs. 1024*232 \u003d\u003d 237MB.. so.. a far cry from 8GB? Anyway, 256 is fine, but I think 512 would give more padding to not break anybody.","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"e40a3f17c859675cd5dbccc6bd257742f67ad60c","unresolved":false,"context_lines":[{"line_number":96,"context_line":"    iniset -sudo $my_conf mysqld bind-address \"$SERVICE_LISTEN_ADDRESS\""},{"line_number":97,"context_line":"    iniset -sudo $my_conf mysqld sql_mode TRADITIONAL"},{"line_number":98,"context_line":"    iniset -sudo $my_conf mysqld default-storage-engine InnoDB"},{"line_number":99,"context_line":"    iniset -sudo $my_conf mysqld max_connections 256"},{"line_number":100,"context_line":"    iniset -sudo $my_conf mysqld query_cache_type OFF"},{"line_number":101,"context_line":"    iniset -sudo $my_conf mysqld query_cache_size 0"},{"line_number":102,"context_line":""}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_29b5dbcc","line":99,"updated":"2017-02-28 21:35:25.000000000","message":"This is probably a bit aggressive to be honest. Per-connection buffers are pretty small anyway.","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":9664,"name":"amrith","email":"amrith.kumar@gmail.com","username":"amrith"},"change_message_id":"f1060a5df938535cce726157cc83d28fbabe4d1a","unresolved":false,"context_lines":[{"line_number":96,"context_line":"    iniset -sudo $my_conf mysqld bind-address \"$SERVICE_LISTEN_ADDRESS\""},{"line_number":97,"context_line":"    iniset -sudo $my_conf mysqld sql_mode TRADITIONAL"},{"line_number":98,"context_line":"    iniset -sudo $my_conf mysqld default-storage-engine InnoDB"},{"line_number":99,"context_line":"    iniset -sudo $my_conf mysqld max_connections 256"},{"line_number":100,"context_line":"    iniset -sudo $my_conf mysqld query_cache_type OFF"},{"line_number":101,"context_line":"    iniset -sudo $my_conf mysqld query_cache_size 0"},{"line_number":102,"context_line":""}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_171d8973","line":99,"in_reply_to":"ba2be162_29b5dbcc","updated":"2017-03-01 00:59:08.000000000","message":"So this could cause failures; yes. But they are very obvious (the error message is) and I\u0027m not sure about the per connection overhead being small. I\u0027ve generally reduced this as the first step in any memory diet.\n\nThe total memory used per connection is (sort_buffer_size + read_buffer_size + read_rnd_buffer_size + join_buffer_size + thread_stack + binlog_cache_size). So with the numbers we have a per connection overhead of 10.3MB.\n\nThe difference between 256 and 1024 is therefore about 8gb IF YOU ACTUALLY GET UP TO 1024 CONNECTIONS.\n\nA simple tool that I\u0027ve found to be helpful in the past is http://www.mysqlcalculator.com/","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"e40a3f17c859675cd5dbccc6bd257742f67ad60c","unresolved":false,"context_lines":[{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"},{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"},{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"},{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"},{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_49ca0f51","line":109,"updated":"2017-02-28 21:35:25.000000000","message":"I\u0027d set this to 0. We don\u0027t use fulltext searches in OpenStack (and if we do, we should stop immediately!)","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"7b3bb15cadd3f09b76dd7f34f65fe41c2a23c144","unresolved":false,"context_lines":[{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"},{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"},{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"},{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"},{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_38b6f5dc","line":109,"updated":"2017-03-01 07:16:02.000000000","message":"TIL those are just limits, and 0 is allocated until you make an innodb fulltext query. Thanks for reminding me to RTFM. :-D","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":9664,"name":"amrith","email":"amrith.kumar@gmail.com","username":"amrith"},"change_message_id":"f1060a5df938535cce726157cc83d28fbabe4d1a","unresolved":false,"context_lines":[{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"},{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"},{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"},{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"},{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_d774d1fe","line":109,"in_reply_to":"ba2be162_49ca0f51","updated":"2017-03-01 00:59:08.000000000","message":"I agree but the min is 1600000 (see: https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_ft_cache_size)","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"e40a3f17c859675cd5dbccc6bd257742f67ad60c","unresolved":false,"context_lines":[{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"},{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"},{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"},{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"},{"line_number":113,"context_line":"    iniset -sudo $my_conf mysqld join_buffer_size 128"}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_69c7d345","line":110,"updated":"2017-02-28 21:35:25.000000000","message":"Same for this.","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":9664,"name":"amrith","email":"amrith.kumar@gmail.com","username":"amrith"},"change_message_id":"f1060a5df938535cce726157cc83d28fbabe4d1a","unresolved":false,"context_lines":[{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"},{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"},{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"},{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"},{"line_number":113,"context_line":"    iniset -sudo $my_conf mysqld join_buffer_size 128"}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_575f0172","line":110,"in_reply_to":"ba2be162_69c7d345","updated":"2017-03-01 00:59:08.000000000","message":"Ditto, this is the minimum (https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_ft_total_cache_size)","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"7b3bb15cadd3f09b76dd7f34f65fe41c2a23c144","unresolved":false,"context_lines":[{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"},{"line_number":119,"context_line":"    iniset -sudo $my_conf mysqld sort_buffer_size 32K"},{"line_number":120,"context_line":"    iniset -sudo $my_conf mysqld thread_cache_size 0"},{"line_number":121,"context_line":"    iniset -sudo $my_conf mysqld thread_stack 131072"},{"line_number":122,"context_line":"    iniset -sudo $my_conf mysqld tmp_table_size 1K"},{"line_number":123,"context_line":""},{"line_number":124,"context_line":"    if [[ \"$DATABASE_QUERY_LOGGING\" \u003d\u003d \"True\" ]]; then"}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_58bba9c4","line":121,"updated":"2017-03-01 07:16:02.000000000","message":"Should be enough. I have another side of me that wants it at the minimum, because I don\u0027t want OpenStack to depend on heavy, complicated queries that would overflow this.","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"e40a3f17c859675cd5dbccc6bd257742f67ad60c","unresolved":false,"context_lines":[{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"},{"line_number":119,"context_line":"    iniset -sudo $my_conf mysqld sort_buffer_size 32K"},{"line_number":120,"context_line":"    iniset -sudo $my_conf mysqld thread_cache_size 0"},{"line_number":121,"context_line":"    iniset -sudo $my_conf mysqld thread_stack 131072"},{"line_number":122,"context_line":"    iniset -sudo $my_conf mysqld tmp_table_size 1K"},{"line_number":123,"context_line":""},{"line_number":124,"context_line":"    if [[ \"$DATABASE_QUERY_LOGGING\" \u003d\u003d \"True\" ]]; then"}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_89c40741","line":121,"updated":"2017-02-28 21:35:25.000000000","message":"This is a small win, but could cause things to crash where they wouldn\u0027t normally crash. IMO, leave this one at the default.","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":9664,"name":"amrith","email":"amrith.kumar@gmail.com","username":"amrith"},"change_message_id":"f1060a5df938535cce726157cc83d28fbabe4d1a","unresolved":false,"context_lines":[{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"},{"line_number":119,"context_line":"    iniset -sudo $my_conf mysqld sort_buffer_size 32K"},{"line_number":120,"context_line":"    iniset -sudo $my_conf mysqld thread_cache_size 0"},{"line_number":121,"context_line":"    iniset -sudo $my_conf mysqld thread_stack 131072"},{"line_number":122,"context_line":"    iniset -sudo $my_conf mysqld tmp_table_size 1K"},{"line_number":123,"context_line":""},{"line_number":124,"context_line":"    if [[ \"$DATABASE_QUERY_LOGGING\" \u003d\u003d \"True\" ]]; then"}],"source_content_type":"application/x-shellscript","patch_set":3,"id":"ba2be162_f778f5fa","line":121,"in_reply_to":"ba2be162_89c40741","updated":"2017-03-01 00:59:08.000000000","message":"OK, I\u0027ll split the difference and make it 192k (the 32 bit default)","commit_id":"52772a37dcfbd98a7d2886f3d7e22c5cb9324644"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":100,"context_line":"    iniset -sudo $my_conf mysqld query_cache_type OFF"},{"line_number":101,"context_line":"    iniset -sudo $my_conf mysqld query_cache_size 0"},{"line_number":102,"context_line":""},{"line_number":103,"context_line":"    # Additional settings to put MySQL on a memory diet"},{"line_number":104,"context_line":"    iniset -sudo $my_conf mysqld binlog_cache_size 4K"},{"line_number":105,"context_line":"    iniset -sudo $my_conf mysqld binlog_stmt_cache_size 4K"},{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_800af5d0","line":103,"updated":"2017-03-01 14:58:51.000000000","message":"I\u0027m sure Amrith has some thought stoo, but I\u0027ll take a stab at these","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":2750,"name":"Sean Dague","email":"sean@dague.net","username":"sdague"},"change_message_id":"154bccf53c9b44fcbd729f2356df8a18b6c86813","unresolved":false,"context_lines":[{"line_number":100,"context_line":"    iniset -sudo $my_conf mysqld query_cache_type OFF"},{"line_number":101,"context_line":"    iniset -sudo $my_conf mysqld query_cache_size 0"},{"line_number":102,"context_line":""},{"line_number":103,"context_line":"    # Additional settings to put MySQL on a memory diet"},{"line_number":104,"context_line":"    iniset -sudo $my_conf mysqld binlog_cache_size 4K"},{"line_number":105,"context_line":"    iniset -sudo $my_conf mysqld binlog_stmt_cache_size 4K"},{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_30d8c153","line":103,"updated":"2017-03-01 11:30:45.000000000","message":"so, before approving it, I think we need a comment on each of these on what it impacts, and what errant behavior in gate runs we might see because of it, so that when someone else is debugging this all in 6 months, they have a guide.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":2750,"name":"Sean Dague","email":"sean@dague.net","username":"sdague"},"change_message_id":"66d3b7b11823d6ed33eee9fa032e4334b6649d6d","unresolved":false,"context_lines":[{"line_number":100,"context_line":"    iniset -sudo $my_conf mysqld query_cache_type OFF"},{"line_number":101,"context_line":"    iniset -sudo $my_conf mysqld query_cache_size 0"},{"line_number":102,"context_line":""},{"line_number":103,"context_line":"    # Additional settings to put MySQL on a memory diet"},{"line_number":104,"context_line":"    iniset -sudo $my_conf mysqld binlog_cache_size 4K"},{"line_number":105,"context_line":"    iniset -sudo $my_conf mysqld binlog_stmt_cache_size 4K"},{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_9e393f44","line":103,"in_reply_to":"ba2be162_16356bd9","updated":"2017-03-02 12:44:17.000000000","message":"well, I\u0027d like it in the patch if we can, because if people see odd behavior, what is much more likely to happen is a full revert of all of this work, instead of understanding why.\n\nAlso, devstack is meant to be educational, I think we have an opportunity here to have some useful information in here sot hat people learn as they go forward.\n\nAnyway, if you and clint can update the patch with comment lines before each of these, that would be great.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":9664,"name":"amrith","email":"amrith.kumar@gmail.com","username":"amrith"},"change_message_id":"a520a287f2a0c1756be0f3ed673f241993e41d40","unresolved":false,"context_lines":[{"line_number":100,"context_line":"    iniset -sudo $my_conf mysqld query_cache_type OFF"},{"line_number":101,"context_line":"    iniset -sudo $my_conf mysqld query_cache_size 0"},{"line_number":102,"context_line":""},{"line_number":103,"context_line":"    # Additional settings to put MySQL on a memory diet"},{"line_number":104,"context_line":"    iniset -sudo $my_conf mysqld binlog_cache_size 4K"},{"line_number":105,"context_line":"    iniset -sudo $my_conf mysqld binlog_stmt_cache_size 4K"},{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_16356bd9","line":103,"in_reply_to":"ba2be162_30d8c153","updated":"2017-03-01 15:27:19.000000000","message":"Sean, I see that Clint has taken a stab at these. I am not sure that this is such a good idea because, for the most part, what we have is a comment that points you to the MySQL documentation. One cannot, in a series of comments, encapsulate \u0027troubleshooting MySQL\u0027. If in 6 months something bad happens with MySQL, someone will look at error messages or errant behaviors and try to figure out where MySQL is getting configured and rapidly arrive here.\n\nI\u0027m not sure that documenting links to each setting is such a good idea. But, if that is what i\u0027ll take to get this merged, I\u0027m happy to do it.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":101,"context_line":"    iniset -sudo $my_conf mysqld query_cache_size 0"},{"line_number":102,"context_line":""},{"line_number":103,"context_line":"    # Additional settings to put MySQL on a memory diet"},{"line_number":104,"context_line":"    iniset -sudo $my_conf mysqld binlog_cache_size 4K"},{"line_number":105,"context_line":"    iniset -sudo $my_conf mysqld binlog_stmt_cache_size 4K"},{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"},{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_a00ff9df","line":104,"updated":"2017-03-01 14:58:51.000000000","message":"binlog_cache_size is used only when binary logging is turned on, which would be rare and is not the default. This is a buffer that precedes flushing the binary log to disk, so if binary logging is turned on, this will mean more frequent flushes and syncs to disk. https://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html#sysvar_binlog_cache_size","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":102,"context_line":""},{"line_number":103,"context_line":"    # Additional settings to put MySQL on a memory diet"},{"line_number":104,"context_line":"    iniset -sudo $my_conf mysqld binlog_cache_size 4K"},{"line_number":105,"context_line":"    iniset -sudo $my_conf mysqld binlog_stmt_cache_size 4K"},{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"},{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"},{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_c014edf6","line":105,"updated":"2017-03-01 14:58:51.000000000","message":"While binlog_cache_size is for the total size of transactions, this holds non-transactional statements. Same basic possible effect. https://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html#sysvar_binlog_stmt_cache_size","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":103,"context_line":"    # Additional settings to put MySQL on a memory diet"},{"line_number":104,"context_line":"    iniset -sudo $my_conf mysqld binlog_cache_size 4K"},{"line_number":105,"context_line":"    iniset -sudo $my_conf mysqld binlog_stmt_cache_size 4K"},{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"},{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"},{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"},{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_e0f9f1c9","line":106,"updated":"2017-03-01 14:58:51.000000000","message":"This only effects an optimization path on writes to MyISAM tables, which we should have none of. So MyISAM INSERT..SELECT\u0027s will be slower. https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_bulk_insert_buffer_size","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":104,"context_line":"    iniset -sudo $my_conf mysqld binlog_cache_size 4K"},{"line_number":105,"context_line":"    iniset -sudo $my_conf mysqld binlog_stmt_cache_size 4K"},{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"},{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"},{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"},{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_00f7e5d3","line":107,"updated":"2017-03-01 14:58:51.000000000","message":"This is disabling the host cache which is used to cache reverse lookups. The cache is specifically not used for 127.0.0.0/8, ::1, or localhost sockets. It could make multinode testing slower since every new MySQL connection will cause a reverse lookup. https://dev.mysql.com/doc/refman/5.6/en/host-cache.html","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":105,"context_line":"    iniset -sudo $my_conf mysqld binlog_stmt_cache_size 4K"},{"line_number":106,"context_line":"    iniset -sudo $my_conf mysqld bulk_insert_buffer_size 0"},{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"},{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"},{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_2004e9be","line":108,"updated":"2017-03-01 14:58:51.000000000","message":"This buffer pool is the internal cache that InnoDB tables use for reads and writes. When this is overwhelmed, things will get much more disk bound.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":107,"context_line":"    iniset -sudo $my_conf mysqld host_cache_size 0"},{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"},{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"},{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"},{"line_number":113,"context_line":"    iniset -sudo $my_conf mysqld join_buffer_size 128"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_4001ddad","line":110,"updated":"2017-03-01 14:58:51.000000000","message":"The two above are memory limits on InnoDB FULLTEXT, which is a new feature in 5.7 and we should not be using.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":108,"context_line":"    iniset -sudo $my_conf mysqld innodb_buffer_pool_size 5M"},{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"},{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"},{"line_number":113,"context_line":"    iniset -sudo $my_conf mysqld join_buffer_size 128"},{"line_number":114,"context_line":"    iniset -sudo $my_conf mysqld key_buffer_size 8"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_602c214b","line":111,"updated":"2017-03-01 14:58:51.000000000","message":"This buffer is used to buffer transactions in-memory before writing them to the innodb internal transaction log. Large transactions, or high amounts of concurrency, will cause the system to fill this faster and thus make the system more disk-bound.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":109,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"},{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"},{"line_number":113,"context_line":"    iniset -sudo $my_conf mysqld join_buffer_size 128"},{"line_number":114,"context_line":"    iniset -sudo $my_conf mysqld key_buffer_size 8"},{"line_number":115,"context_line":"    iniset -sudo $my_conf mysqld max_heap_table_size 16K"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_803115a5","line":112,"updated":"2017-03-01 14:58:51.000000000","message":"This buffer is used for sorting when InnoDB is creating indexes. Could cause that to be slower, but only if tables are large.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":110,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"},{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"},{"line_number":113,"context_line":"    iniset -sudo $my_conf mysqld join_buffer_size 128"},{"line_number":114,"context_line":"    iniset -sudo $my_conf mysqld key_buffer_size 8"},{"line_number":115,"context_line":"    iniset -sudo $my_conf mysqld max_heap_table_size 16K"},{"line_number":116,"context_line":"    iniset -sudo $my_conf mysqld net_buffer_length 1K"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_a0261966","line":113,"updated":"2017-03-01 14:58:51.000000000","message":"This buffer makes table and index scans faster. So this setting could make some queries more disk bound.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld innodb_log_buffer_size 256K"},{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"},{"line_number":113,"context_line":"    iniset -sudo $my_conf mysqld join_buffer_size 128"},{"line_number":114,"context_line":"    iniset -sudo $my_conf mysqld key_buffer_size 8"},{"line_number":115,"context_line":"    iniset -sudo $my_conf mysqld max_heap_table_size 16K"},{"line_number":116,"context_line":"    iniset -sudo $my_conf mysqld net_buffer_length 1K"},{"line_number":117,"context_line":"    iniset -sudo $my_conf mysqld read_buffer_size 8200"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_c02b0d2f","line":114,"updated":"2017-03-01 14:58:51.000000000","message":"This is for MyISAM tables. Should not have any of those.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":112,"context_line":"    iniset -sudo $my_conf mysqld innodb_sort_buffer_size 64K"},{"line_number":113,"context_line":"    iniset -sudo $my_conf mysqld join_buffer_size 128"},{"line_number":114,"context_line":"    iniset -sudo $my_conf mysqld key_buffer_size 8"},{"line_number":115,"context_line":"    iniset -sudo $my_conf mysqld max_heap_table_size 16K"},{"line_number":116,"context_line":"    iniset -sudo $my_conf mysqld net_buffer_length 1K"},{"line_number":117,"context_line":"    iniset -sudo $my_conf mysqld read_buffer_size 8200"},{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_e020114c","line":115,"updated":"2017-03-01 14:58:51.000000000","message":"This is a governor on in-memory temp tables. If a temp table gets bigger than this it gets turned into an on-disk temp table. So could make some queries of larger tables slower.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":113,"context_line":"    iniset -sudo $my_conf mysqld join_buffer_size 128"},{"line_number":114,"context_line":"    iniset -sudo $my_conf mysqld key_buffer_size 8"},{"line_number":115,"context_line":"    iniset -sudo $my_conf mysqld max_heap_table_size 16K"},{"line_number":116,"context_line":"    iniset -sudo $my_conf mysqld net_buffer_length 1K"},{"line_number":117,"context_line":"    iniset -sudo $my_conf mysqld read_buffer_size 8200"},{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"},{"line_number":119,"context_line":"    iniset -sudo $my_conf mysqld sort_buffer_size 32K"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_001e050c","line":116,"updated":"2017-03-01 14:58:51.000000000","message":"This is an initial size that is governed by max_packet_length. A tiny CPU cost to have to resize the buffer if large statements are sent. https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_net_buffer_length","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":114,"context_line":"    iniset -sudo $my_conf mysqld key_buffer_size 8"},{"line_number":115,"context_line":"    iniset -sudo $my_conf mysqld max_heap_table_size 16K"},{"line_number":116,"context_line":"    iniset -sudo $my_conf mysqld net_buffer_length 1K"},{"line_number":117,"context_line":"    iniset -sudo $my_conf mysqld read_buffer_size 8200"},{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"},{"line_number":119,"context_line":"    iniset -sudo $my_conf mysqld sort_buffer_size 32K"},{"line_number":120,"context_line":"    iniset -sudo $my_conf mysqld thread_cache_size 0"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_201b091d","line":117,"updated":"2017-03-01 14:58:51.000000000","message":"This is for MyISAM tables only.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":115,"context_line":"    iniset -sudo $my_conf mysqld max_heap_table_size 16K"},{"line_number":116,"context_line":"    iniset -sudo $my_conf mysqld net_buffer_length 1K"},{"line_number":117,"context_line":"    iniset -sudo $my_conf mysqld read_buffer_size 8200"},{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"},{"line_number":119,"context_line":"    iniset -sudo $my_conf mysqld sort_buffer_size 32K"},{"line_number":120,"context_line":"    iniset -sudo $my_conf mysqld thread_cache_size 0"},{"line_number":121,"context_line":"    iniset -sudo $my_conf mysqld thread_stack 196608"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_4018fd1d","line":118,"updated":"2017-03-01 14:58:51.000000000","message":"This buffer is used to speed up Multi-Range read optimization, which some complicated queries do. https://dev.mysql.com/doc/refman/5.6/en/mrr-optimization.html","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":116,"context_line":"    iniset -sudo $my_conf mysqld net_buffer_length 1K"},{"line_number":117,"context_line":"    iniset -sudo $my_conf mysqld read_buffer_size 8200"},{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"},{"line_number":119,"context_line":"    iniset -sudo $my_conf mysqld sort_buffer_size 32K"},{"line_number":120,"context_line":"    iniset -sudo $my_conf mysqld thread_cache_size 0"},{"line_number":121,"context_line":"    iniset -sudo $my_conf mysqld thread_stack 196608"},{"line_number":122,"context_line":"    iniset -sudo $my_conf mysqld tmp_table_size 1K"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_60d34139","line":119,"updated":"2017-03-01 14:58:51.000000000","message":"Any sort that can fit in sort_buffer_size will be an order of magnitude faster. So complicated queries on larger result sets and tables will suffer disk-bound penalties.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":117,"context_line":"    iniset -sudo $my_conf mysqld read_buffer_size 8200"},{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"},{"line_number":119,"context_line":"    iniset -sudo $my_conf mysqld sort_buffer_size 32K"},{"line_number":120,"context_line":"    iniset -sudo $my_conf mysqld thread_cache_size 0"},{"line_number":121,"context_line":"    iniset -sudo $my_conf mysqld thread_stack 196608"},{"line_number":122,"context_line":"    iniset -sudo $my_conf mysqld tmp_table_size 1K"},{"line_number":123,"context_line":""}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_80d83555","line":120,"updated":"2017-03-01 14:58:51.000000000","message":"This is a minor optimization that does not effect Linux much (it was mostly for Solaris and other Unices with slow pthread_create() calls.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"89eb377628470618469e99364f20c5a12b86313d","unresolved":false,"context_lines":[{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"},{"line_number":119,"context_line":"    iniset -sudo $my_conf mysqld sort_buffer_size 32K"},{"line_number":120,"context_line":"    iniset -sudo $my_conf mysqld thread_cache_size 0"},{"line_number":121,"context_line":"    iniset -sudo $my_conf mysqld thread_stack 196608"},{"line_number":122,"context_line":"    iniset -sudo $my_conf mysqld tmp_table_size 1K"},{"line_number":123,"context_line":""},{"line_number":124,"context_line":"    if [[ \"$DATABASE_QUERY_LOGGING\" \u003d\u003d \"True\" ]]; then"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_a0dd3944","line":121,"updated":"2017-03-01 14:58:51.000000000","message":"I used the word crash, but I meant a crash of the query. https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_thread_stack Basically, if you run out of stack for new SQL operations like functions, joins, etc, the query just errors. The default size is very conservative. I\u0027d actually love to find queries that fail with this new size, as they need to be rewritten as they\u0027re putting too much load on the DB. My guess is we don\u0027t do any of that.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":2750,"name":"Sean Dague","email":"sean@dague.net","username":"sdague"},"change_message_id":"154bccf53c9b44fcbd729f2356df8a18b6c86813","unresolved":false,"context_lines":[{"line_number":118,"context_line":"    iniset -sudo $my_conf mysqld read_rnd_buffer_size 8200"},{"line_number":119,"context_line":"    iniset -sudo $my_conf mysqld sort_buffer_size 32K"},{"line_number":120,"context_line":"    iniset -sudo $my_conf mysqld thread_cache_size 0"},{"line_number":121,"context_line":"    iniset -sudo $my_conf mysqld thread_stack 196608"},{"line_number":122,"context_line":"    iniset -sudo $my_conf mysqld tmp_table_size 1K"},{"line_number":123,"context_line":""},{"line_number":124,"context_line":"    if [[ \"$DATABASE_QUERY_LOGGING\" \u003d\u003d \"True\" ]]; then"}],"source_content_type":"application/x-shellscript","patch_set":4,"id":"ba2be162_30bfe1d1","line":121,"updated":"2017-03-01 11:30:45.000000000","message":"rereading the comments, this can cause a crash? Anything which we know can cause a fail shouldn\u0027t be in here.","commit_id":"18092253c26dcebe310e93426716c36a4c863bd2"},{"author":{"_account_id":7,"name":"Jay Pipes","email":"jaypipes@gmail.com","username":"jaypipes"},"change_message_id":"26db202050024f9fca7f11d44781408f07be868b","unresolved":false,"context_lines":[{"line_number":179,"context_line":"    # and"},{"line_number":180,"context_line":"    # https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_ft_total_cache_size"},{"line_number":181,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":182,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":183,"context_line":""},{"line_number":184,"context_line":"    # innodb_log_buffer_size This buffer is used to buffer"},{"line_number":185,"context_line":"    # transactions in-memory before writing them to the innodb"}],"source_content_type":"application/x-shellscript","patch_set":5,"id":"3a1ff146_ccbc276f","line":182,"updated":"2017-03-15 18:20:39.000000000","message":"unless I\u0027m mistaken, we don\u0027t actually utilize fulltext search in any of the OpenStack projects, so unless the above are the lowest possible values, I think you could set them both to smaller values, especially the first one since it\u0027s multiplied by 256 (it\u0027s a per-thread size)","commit_id":"1e66388c5f2b81b4fc5d544dbf5fde2935218bd0"},{"author":{"_account_id":9664,"name":"amrith","email":"amrith.kumar@gmail.com","username":"amrith"},"change_message_id":"71117a440bce2bab2a7faf6536147ab04d0dca76","unresolved":false,"context_lines":[{"line_number":179,"context_line":"    # and"},{"line_number":180,"context_line":"    # https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_ft_total_cache_size"},{"line_number":181,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_cache_size 1600000"},{"line_number":182,"context_line":"    iniset -sudo $my_conf mysqld innodb_ft_total_cache_size 32000000"},{"line_number":183,"context_line":""},{"line_number":184,"context_line":"    # innodb_log_buffer_size This buffer is used to buffer"},{"line_number":185,"context_line":"    # transactions in-memory before writing them to the innodb"}],"source_content_type":"application/x-shellscript","patch_set":5,"id":"3a1ff146_8c594f5d","line":182,"in_reply_to":"3a1ff146_ccbc276f","updated":"2017-03-15 18:22:57.000000000","message":"per the handy-dandy link https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_ft_cache_size this is the minimum size :(\n\nyes, they are per thread and this is wasted space but can\u0027t do less.","commit_id":"1e66388c5f2b81b4fc5d544dbf5fde2935218bd0"},{"author":{"_account_id":7,"name":"Jay Pipes","email":"jaypipes@gmail.com","username":"jaypipes"},"change_message_id":"26db202050024f9fca7f11d44781408f07be868b","unresolved":false,"context_lines":[{"line_number":206,"context_line":"    # and shared between threads. This is a server wide setting. For"},{"line_number":207,"context_line":"    # more details see"},{"line_number":208,"context_line":"    # https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_key_buffer_size"},{"line_number":209,"context_line":"    iniset -sudo $my_conf mysqld key_buffer_size 8"},{"line_number":210,"context_line":""},{"line_number":211,"context_line":"    # max_heap_table_size sets the maximum amount of memory for MEMORY"},{"line_number":212,"context_line":"    # tables (which we don\u0027t use). The value is set to 16k, the"}],"source_content_type":"application/x-shellscript","patch_set":5,"id":"3a1ff146_4c6e7730","line":209,"updated":"2017-03-15 18:20:39.000000000","message":"yeah, this is fine since the only MyISAM tables in use are internal system tables.","commit_id":"1e66388c5f2b81b4fc5d544dbf5fde2935218bd0"}]}