Today, I was trying to log in to my website’s Admin page, but I was stopped by following a warning from WordPress’s
Unable to allocate memory for pool
The full warning summary was something like this:
Warning: require_once() [function.require-once]: Unable to allocate memory for pool. in /nnn/000/000/mnt/111111/domains/domainname.com/html/wp-includes/pluggable.php on line 1547
Warning: Cannot modify header information - headers already sent by (output started at /nnn/000/000/mnt/111111/domains/domainname.com/html/wp-includes/pluggable.php:1547) in /nnn/000/000/mnt/111111/domains/domainname.com/html/wp-includes/pluggable.php on line 678
Warning: Cannot modify header information - headers already sent by (output started at /nnn/000/000/mnt/111111/domains/domainname.com/html/wp-includes/pluggable.php:1547) in /nnn/000/000/mnt/111111/domains/domainname.com/html/wp-includes/pluggable.php on line 679
Warning: Cannot modify header information - headers already sent by (output started at /nnn/000/000/mnt/111111/domains/domainname.com/html/wp-includes/pluggable.php:1547) in /nnn/000/000/mnt/111111/domains/domainname.com/html/wp-includes/pluggable.php on line 680
Warning: Cannot modify header information - headers already sent by (output started at /nnn/000/000/mnt/111111/domains/domainname.com/html/wp-includes/pluggable.php:1547) in /nnn/000/000/mnt/111111/domains/domainname.com/html/wp-includes/pluggable.php on line 896
So, after a few online searches, I found out that the culprit is the spam-related logs stored by Akismet in the MySQL database for every SPAM comment it detects and deletes.
So the Solution to this problem was something like this:
I log in to the ‘phpMyAdmin’ page on my server,
Then, I selected the ‘wp_commentsmeta’ table, and at the bottom of the page, or beside its name, I selected ‘Empty’ for this particular table, then clicked ‘OK or YES’ on the next prompt.
Tip: Empty all ‘commentsmeta’ table in your MySQL Database for all domains & sub domains.
I discovered that the ‘wp_commentsmeta’ table had grown to more than 3MB (3 Mega Bytes) in size, causing a load on the MySQL server.
And Voila, I could log in to my WordPress Website’s Admin page again.
I hope it helps!
Thanks & Regards
Mandar Apte