{"id":555,"date":"2019-11-19T16:52:05","date_gmt":"2019-11-19T11:22:05","guid":{"rendered":"https:\/\/askadmin.com\/?p=555"},"modified":"2019-11-19T16:52:05","modified_gmt":"2019-11-19T11:22:05","slug":"php-fatal-error-allowed-memory-size-exhausted","status":"publish","type":"post","link":"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/","title":{"rendered":"PHP Fatal error:\u00a0 Allowed memory size exhausted"},"content":{"rendered":"

Error:<\/strong><\/p>\n

PHP Fatal error:\u00a0 <\/span>Allowed memory size of 209715200 bytes exhausted (tried to allocate 4294967296 bytes) in \/var\/www\/html .<\/span><\/strong><\/p>\n

This can\u00a0 happen\u00a0 for various\u00a0 reasons\u00a0 like\u00a0 a loop in your query function\u00a0 or your column type in mysql table is\u00a0 longtext or any other kind of data which needs more memory to hold the data while\u00a0 running query .\u00a0 \u00a0To fix this ,<\/span><\/p>\n

    \n
  1. 1. First try to\u00a0 optimise your query and check for any loop creating functions .<\/li>\n
  2. 2. If you are sure that it is not any loop in function then try to increase\u00a0 memory allocation for PHP by adding\u00a0 line ini_set(\u201cmemory_limit\u201d,\u201d16M\u201c);\u00a0 <\/em><\/strong>\u00a0in your php script file .<\/em><\/li>\n
  3. instead you can also add memory limit\u00a0 in php.ini file\u00a0 by adding a line\u00a0 memory_limit=16M<\/strong><\/em> which will affect\u00a0 all php\u00a0 scripts .<\/li>\n
  4. 3. If your my sql column data type is largetext<\/strong> it require 4294967296 bytes (4GB)\u00a0 <\/span><\/strong>memory <\/span>so <\/span>instead of increasing memory\u00a0 can change data type to something like\n

    MEDIUMTEXT <\/span><\/strong>which requires only 16 MB. <\/span><\/p>\n<\/li>\n

  5. \n

    You can change existing mysql column data type\u00a0 with this query\u00a0<\/span><\/p>\n

    ALTER TABLE your_table MODIFY existing_column MEDIUMTEXT;<\/span><\/strong><\/p>\n<\/li>\n

  6. <\/li>\n<\/ol>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    Error: PHP Fatal error:\u00a0 Allowed memory size of 209715200 bytes exhausted (tried to allocate 4294967296 bytes) in \/var\/www\/html . This can\u00a0 happen\u00a0 for various\u00a0 reasons\u00a0 like\u00a0 a loop in your query function\u00a0 or your column type in mysql table is\u00a0 longtext or any other kind of data which needs more […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[142],"tags":[148,150,146,147,149],"yoast_head":"\nPHP Fatal error:\u00a0 Allowed memory size exhausted - Ask Admin - A Lifelong Learner<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHP Fatal error:\u00a0 Allowed memory size exhausted - Ask Admin - A Lifelong Learner\" \/>\n<meta property=\"og:description\" content=\"Error: PHP Fatal error:\u00a0 Allowed memory size of 209715200 bytes exhausted (tried to allocate 4294967296 bytes) in \/var\/www\/html . This can\u00a0 happen\u00a0 for various\u00a0 reasons\u00a0 like\u00a0 a loop in your query function\u00a0 or your column type in mysql table is\u00a0 longtext or any other kind of data which needs more […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/\" \/>\n<meta property=\"og:site_name\" content=\"Ask Admin - A Lifelong Learner\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-19T11:22:05+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"balu sreekanth\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/askadmin.com\/aa\/#website\",\"url\":\"https:\/\/askadmin.com\/aa\/\",\"name\":\"Ask Admin - A Lifelong Learner\",\"description\":\"Mobile App Development | IP Telephony | Linux\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/askadmin.com\/aa\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/#webpage\",\"url\":\"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/\",\"name\":\"PHP Fatal error:\u00a0 Allowed memory size exhausted - Ask Admin - A Lifelong Learner\",\"isPartOf\":{\"@id\":\"https:\/\/askadmin.com\/aa\/#website\"},\"datePublished\":\"2019-11-19T11:22:05+00:00\",\"dateModified\":\"2019-11-19T11:22:05+00:00\",\"author\":{\"@id\":\"https:\/\/askadmin.com\/aa\/#\/schema\/person\/e1ff95d4a91ea001e25af3273533a345\"},\"breadcrumb\":{\"@id\":\"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/askadmin.com\/aa\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP Fatal error:\u00a0 Allowed memory size exhausted\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/askadmin.com\/aa\/#\/schema\/person\/e1ff95d4a91ea001e25af3273533a345\",\"name\":\"balu sreekanth\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/askadmin.com\/aa\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6aebf95935573dc70f536f1003a2fb8c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6aebf95935573dc70f536f1003a2fb8c?s=96&d=mm&r=g\",\"caption\":\"balu sreekanth\"},\"sameAs\":[\"http:\/\/askadmin.com\"],\"url\":\"https:\/\/askadmin.com\/aa\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHP Fatal error:\u00a0 Allowed memory size exhausted - Ask Admin - A Lifelong Learner","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/","og_locale":"en_US","og_type":"article","og_title":"PHP Fatal error:\u00a0 Allowed memory size exhausted - Ask Admin - A Lifelong Learner","og_description":"Error: PHP Fatal error:\u00a0 Allowed memory size of 209715200 bytes exhausted (tried to allocate 4294967296 bytes) in \/var\/www\/html . This can\u00a0 happen\u00a0 for various\u00a0 reasons\u00a0 like\u00a0 a loop in your query function\u00a0 or your column type in mysql table is\u00a0 longtext or any other kind of data which needs more […]","og_url":"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/","og_site_name":"Ask Admin - A Lifelong Learner","article_published_time":"2019-11-19T11:22:05+00:00","twitter_misc":{"Written by":"balu sreekanth","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/askadmin.com\/aa\/#website","url":"https:\/\/askadmin.com\/aa\/","name":"Ask Admin - A Lifelong Learner","description":"Mobile App Development | IP Telephony | Linux","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/askadmin.com\/aa\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/#webpage","url":"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/","name":"PHP Fatal error:\u00a0 Allowed memory size exhausted - Ask Admin - A Lifelong Learner","isPartOf":{"@id":"https:\/\/askadmin.com\/aa\/#website"},"datePublished":"2019-11-19T11:22:05+00:00","dateModified":"2019-11-19T11:22:05+00:00","author":{"@id":"https:\/\/askadmin.com\/aa\/#\/schema\/person\/e1ff95d4a91ea001e25af3273533a345"},"breadcrumb":{"@id":"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/askadmin.com\/aa\/php-fatal-error-allowed-memory-size-exhausted\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/askadmin.com\/aa\/"},{"@type":"ListItem","position":2,"name":"PHP Fatal error:\u00a0 Allowed memory size exhausted"}]},{"@type":"Person","@id":"https:\/\/askadmin.com\/aa\/#\/schema\/person\/e1ff95d4a91ea001e25af3273533a345","name":"balu sreekanth","image":{"@type":"ImageObject","@id":"https:\/\/askadmin.com\/aa\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/6aebf95935573dc70f536f1003a2fb8c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6aebf95935573dc70f536f1003a2fb8c?s=96&d=mm&r=g","caption":"balu sreekanth"},"sameAs":["http:\/\/askadmin.com"],"url":"https:\/\/askadmin.com\/aa\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/askadmin.com\/aa\/wp-json\/wp\/v2\/posts\/555"}],"collection":[{"href":"https:\/\/askadmin.com\/aa\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/askadmin.com\/aa\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/askadmin.com\/aa\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/askadmin.com\/aa\/wp-json\/wp\/v2\/comments?post=555"}],"version-history":[{"count":1,"href":"https:\/\/askadmin.com\/aa\/wp-json\/wp\/v2\/posts\/555\/revisions"}],"predecessor-version":[{"id":556,"href":"https:\/\/askadmin.com\/aa\/wp-json\/wp\/v2\/posts\/555\/revisions\/556"}],"wp:attachment":[{"href":"https:\/\/askadmin.com\/aa\/wp-json\/wp\/v2\/media?parent=555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/askadmin.com\/aa\/wp-json\/wp\/v2\/categories?post=555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/askadmin.com\/aa\/wp-json\/wp\/v2\/tags?post=555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}