{"id":1360,"date":"2019-02-08T10:36:08","date_gmt":"2019-02-08T10:36:08","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2019\/02\/08\/1583743-are-mysql-heap-tables-supported-at-hostinger\/"},"modified":"2019-02-08T10:36:08","modified_gmt":"2019-02-08T10:36:08","slug":"1583743-are-mysql-heap-tables-supported-at-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/1583743-are-mysql-heap-tables-supported-at-hostinger\/","title":{"rendered":"Are MySQL Heap Tables Supported at Hostinger?"},"content":{"rendered":"<p class=\"no-margin\">In MySQL, a heap table, also known as a MEMORY table, is a type of table that is stored entirely in memory, as opposed to being stored on disk like regular tables, making them faster for reading\/writing actions.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">MySQL heap tables are <b>fully supported <\/b>on all our <b><a href=\"https:\/\/www.hostinger.com\/web-hosting\" target=\"_blank\" class=\"intercom-content-link\">Web<\/a> <\/b>and <b><a href=\"https:\/\/www.hostinger.com\/cloud-hosting\" target=\"_blank\" class=\"intercom-content-link\">Cloud<\/a> <\/b>hosting plans! A few considerations when using heap tables:<\/p><ul>\n<li>\n<p class=\"no-margin\"><b>Volatility<\/b> &ndash; data in heap tables is lost when the MySQL server restarts or when the table is dropped<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b>Indexing<\/b> options are limited compared to disk-based tables<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b>Locking<\/b> &ndash; heap tables use table-level locking, which can impact concurrent access when multiple clients are trying to access the table simultaneously<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b>Size Limitations<\/b> &ndash; Heap tables are limited by the available memory of your hosting plan. If your data exceeds the available memory, it might lead to performance issues or cause the server to run out of memory<\/p>\n<\/li>\n<\/ul><div class=\"intercom-interblocks-callout\" style=\"background-color: #e3e7fa80;border-color: #334bfa33\">\n<p class=\"no-margin\">If want to have full control over the <b>tmp_table_size<\/b> and <b>max_heap_table_size<\/b> variables in MySQL, you can consider a <b><a href=\"https:\/\/www.hostinger.com\/vps-hosting\" target=\"_blank\" class=\"intercom-content-link\">VPS Hosting<\/a><\/b> plan &#128161;<\/p>\n<\/div><p class=\"no-margin\">\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL heap tables on shared hosting packages<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[218],"tags":[],"class_list":["post-1360","post","type-post","status-publish","format-standard","hentry","category-supported-technologies-and-functions"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/1583743-are-mysql-heap-tables-supported-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/1583743-soportan-heap-tables-en-mysql-en-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/1583743-as-tabelas-de-heap-do-mysql-sao-suportadas-no-hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=1360"}],"version-history":[{"count":0,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1360\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}