Out of memory (Cant alocate 200MB)!

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
postcd
Registered User
Posts: 83
Joined: Sun Oct 14, 2007 3:42 pm
Contact:

Out of memory (Cant alocate 200MB)!

Post by postcd » Fri Mar 04, 2011 1:27 pm

General Error
SQL ERROR [ mysql4 ]
Out of memory (Needed 216664338 bytes) [5]
HELP ME please please, i cant figure it out. I have above error. It cant alocate around 200MB.
I have Machine i7 920 - 4x 2x 2.66+ GHz - 8 GB RAM, 1GB /tmp
Full root access to server. Quite big board and this config:
[mysqld]

log_slow_queries=/var/log/mysqld.slow.log
long_query_time=6

socket = /var/lib/mysql/mysql.sock
safe-show-database
old-password=1
set-variable = max_connections=200
interactive_timeout=100
wait_timeout=1000
connect_timeout=30
key_buffer=2048M
join_buffer=1048M
max_allowed_packet=256M
table_cache=4096
sort_buffer=512M
record_buffer=128M
thread_cache_size=128
max_user_connections=100

thread_concurrency=6
myisam_sort_buffer_size=256M
max_heap_table_size=1024M
tmp_table_size=1024M
innodb_buffer_pool_size=1024M
query_cache_limit=728M
query_cache_size=1024M
query_cache_type=1

[mysqldump]
quick
max_allowed_packet=64M

# ..... isamchk default is 64 64 16 16
[isamchk]
key_buffer=256M
sort_buffer=256M
read_buffer=16M
write_bufer=16M

# myisamchk default is 64 64 16 16
[myisamchk]
key_buffer=256M
sort_buffer=256M
read_buffer=16M
write_buffer=16M
Im qite hopeless. Maybe File compression enabled on server takes alot of ram, i have it defaultly enabled. Takes around one CPU core also.

Please what to increase safely?

I have much more sites on server and average load is 3-17 (8-16) which is peak load sometimes. Interesting is that only 15% of RAM is used. :(
I have Health Forum and also webmaster Hosting Forum. Interested in making money? Try money maker forum.

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51867
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Out of memory (Cant alocate 200MB)!

Post by Brf » Fri Mar 04, 2011 2:29 pm

We cannot help you with SQL server problems.
This board is support for the phpBB software, not the database server.

Oleg
Former Team Member
Posts: 1221
Joined: Sat Jan 30, 2010 4:42 pm
Location: NYC
Contact:

Re: Out of memory (Cant alocate 200MB)!

Post by Oleg » Fri Mar 04, 2011 10:22 pm

In addition to what Brf said, your configuration is all over the place. Memory settings need to make sense together. Start by taking all memory settings from here: http://fts.ifac.cnr.it/cgi-bin/dwww/usr ... uge.cnf.gz If that does not help, ask for help on forums dealing with server configuration.
Participate in phpBB development: Get involved | Issue tracker | Report a bug | Development board | [url=irc://chat.freenode.net/phpbb-dev]Development IRC chat[/url]
My stuff: mindlinkgame.com

Locked

Return to “[3.0.x] Support Forum”