{"id":631,"date":"2021-03-08T11:08:55","date_gmt":"2021-03-08T03:08:55","guid":{"rendered":"https:\/\/play.datalude.com\/blog\/?p=631"},"modified":"2021-04-13T12:12:03","modified_gmt":"2021-04-13T04:12:03","slug":"formatting-mysqladmin-variables-output-sensibly","status":"publish","type":"post","link":"https:\/\/play.datalude.com\/blog\/2021\/03\/formatting-mysqladmin-variables-output-sensibly\/","title":{"rendered":"Formatting mysqladmin variables output sensibly"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">OK, so if you're here, you've probably been searching for a variable in mysqladmin and have watched twenty screens of spaces and pipes scroll past. Me too, so I'm just leaving this little snatch of formatting to remind myself how to tame it down to something readable. So if you're searching for 'buffer' related variables, you'll need something like this. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqladmin variables | tr -d \" \" | awk -F'|' '{print $2 \" = \" $3}' | grep buffer <\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Which gives you <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> aria_pagecache_buffer_size = 134217728\n aria_sort_buffer_size = 268434432\n bulk_insert_buffer_size = 16777216\n innodb_buffer_pool_chunk_size = 134217728\n innodb_buffer_pool_dump_at_shutdown = ON\n innodb_buffer_pool_dump_now = OFF\n innodb_buffer_pool_dump_pct = 25\n innodb_buffer_pool_filename = ib_buffer_pool\n innodb_buffer_pool_instances = 1\n innodb_buffer_pool_load_abort = OFF\n innodb_buffer_pool_load_at_startup = ON\n innodb_buffer_pool_load_now = OFF\n innodb_buffer_pool_size = 268435456\n innodb_change_buffer_max_size = 25\n innodb_change_buffering = all\n innodb_log_buffer_size = 8388608\n innodb_sort_buffer_size = 1048576\n join_buffer_size = 262144\n join_buffer_space_limit = 2097152\n key_buffer_size = 67108864\n mrr_buffer_size = 262144\n myisam_sort_buffer_size = 536870912\n net_buffer_length = 16384\n preload_buffer_size = 32768\n read_buffer_size = 2097152\n read_rnd_buffer_size = 1048576\n sort_buffer_size = 4194304\n sql_buffer_result = OFF<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Alternatively, you might have some luck with <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><br>mysql -e \"SHOW VARIABLES LIKE '%buffer%';\"<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>OK, so if you're here, you've probably been searching for a variable in mysqladmin and have watched twenty screens of spaces and pipes scroll past. Me too, so I'm just leaving this little snatch of formatting to remind myself how to tame it down to something readable. So if you're searching for 'buffer' related variables, &#8230; <a title=\"Formatting mysqladmin variables output sensibly\" class=\"read-more\" href=\"https:\/\/play.datalude.com\/blog\/2021\/03\/formatting-mysqladmin-variables-output-sensibly\/\" aria-label=\"Read more about Formatting mysqladmin variables output sensibly\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-631","post","type-post","status-publish","format-standard","hentry","category-it"],"_links":{"self":[{"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/posts\/631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/comments?post=631"}],"version-history":[{"count":0,"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/posts\/631\/revisions"}],"wp:attachment":[{"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/media?parent=631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/categories?post=631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/tags?post=631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}