Databases
StackOverflow2013
Postsdbo
POPHP/mysql memory error Drupal
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP/mysql memory error Drupal
    primarykey
    data
    text
    <p>So I am working in a local drupal CMS environment and am easily able to navigate through and open any pages to view or edit. But the moment I try to save changes or delete pages I get one of the two following errors. </p> <p>Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 76 bytes) in /Users/krice/projects/drupal/includes/database.mysql.inc on line 145</p> <p>Fatal error: Maximum execution time of 60 seconds exceeded in /Users/krice/projects/drupal/includes/database.mysql.inc on line 109</p> <p>Here is my my.cnf file and my php.ini file I have (the parts that matter if i need to show more i can)</p> <p>my.cnf</p> <pre><code># The MySQL server [mysqld] port = 8889 socket = /Applications/MAMP/tmp/mysql/mysql.sock skip-external-locking key_buffer_size = 384M max_allowed_packet = 16M table_open_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 tmp_table_size=2G max_heap_table_size=2G </code></pre> <p>php.ini</p> <pre><code>;;;;;;;;;;;;;;;;;;; ; Resource Limits ; ;;;;;;;;;;;;;;;;;;; max_execution_time = 60 ; Maximum execution time of each script, in seconds max_input_time = 60 ; Maximum amount of time each script may spend parsing request data memory_limit = 2048M ; Maximum amount of memory a script may consume (8MB) </code></pre> <p>As you can see I have tried uping my max execution time and memory_limit and still does the same thing but now it waits 60 seconds then gives me the errors.</p> <p>Any help would be greatly appreciated and if you need more info I can provide it thanks.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRyan
    1. USYourGoodFriend
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPHP/mysql memory error Drupal
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COShow Your phpinfo values of memory_limit. You should boost Your php ressources. Time to 5 minutes. Memory to 256M.
      singulars
      1. POPHP/mysql memory error Drupal
      1. USFedir RYKHTIK
    2. COdid you actually reboot apache after changing the php.ini? :)
      singulars
      1. POPHP/mysql memory error Drupal
      1. USJulien
    3. CO@Fedir The memory_limit is already at 512MB (says so in the error message) and a maximum execution time of 60sec (says so in the error message) should be enough.
      singulars
      1. POPHP/mysql memory error Drupal
      1. USOswald
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload