Jump to content

Photo
* * * * * 4 votes

Social Engine 4 Server Resource Problem


  • Please log in to reply
109 replies to this topic

#1 Salman

Salman

    Red Team Sierra 1

  • Administrators
  • Level
  • 3,344 points
  • 6,256 posts
    • Gender:Male


Users Awards

Posted 26 October 2010 - 12:31 PM

*
POPULAR

Well all Social Engine 4 users , do you know why social engine 4 takes soo much server resource, its takes all server ram, WHY? Does Social Engine Official Team has this answer? No...... But Social Engine Forum aka SEF team has this answer with proper solution, would it be shared for free or premium :P :P :P

Its not social engine 4 script problem, its because Social Engine 4 using InnoDB database, Problem lies inside your database and your server MYSQL configuration, you need to configure something in your MY SQL, and for this you need good VPS having 1-2gb ram or Dedicated Server with 4-8gb ram and keep in mind Social Engine 4 cannot be hosted on shared servers because you cannot set that value to your server while on shared hosting. It still consumes your server ram, thats why cannot be hosted on Shared Servers but your site will get a boost performance.

Its not Social Engine is slow, Social Engine InnoDB database takes all over your server ram and when ram consumed by Server, your server looses its performance and your site will also looses its performance.

Ok here is solution to control Ram Buffer and some other things for innodb
For my UBUNTU LINUX SERVER EDITION 10.4 LTS its file location
/etc/mysql/my.cnf
its configuration file of MYSQL
add these line in the end of file, and make sure entry should not be double, kindly search for same line in file before
innodb_buffer_pool_size=2M
 innodb_additional_mem_pool_size=1M
 innodb_log_file_size=2M
 innodb_log_buffer_size=2M
 innodb_flush_log_at_trx_commit=2
 innodb_lock_wait_timeout=50
 innodb_thread_concurrency=8

After adding this code, restart your MYSQL
click this if you want to +1rep my post Posted Image if you found its quality work

#2 JimiC

JimiC

    Level 5

  • Members
  • Level
  • 95 points
  • 465 posts

Posted 26 October 2010 - 01:29 PM

Can i ask for more? If it works it would be a great tip! Guru Salman.

#3 Salman

Salman

    Red Team Sierra 1

  • Administrators
  • Level
  • 3,344 points
  • 6,256 posts
    • Gender:Male


Users Awards

Posted 26 October 2010 - 07:35 PM

Can i ask for more? If it works it would be a great tip! Guru Salman.


Yes, Ask, What you want to ASK? also solution is posted
click this if you want to +1rep my post Posted Image if you found its quality work

#4 IAmNotMe

IAmNotMe

    Basic Developer

  • Premium
  • Level
  • 150 points
  • 190 posts
    • Gender:Not Telling

Posted 26 October 2010 - 11:36 PM

i dont see /etc/mysql/my.cnf in my directadmin should i create it? or put the code somewhere else?

#5 Misterp

Misterp

    Level 4

  • Premium
  • Level
  • 48 points
  • 189 posts
    • Gender:Not Telling
    • Location:I Taught Your Girl That Thing She Likes! ;)


Users Awards

Posted 27 October 2010 - 12:09 AM

i dont see /etc/mysql/my.cnf in my directadmin should i create it? or put the code somewhere else?


me also

#6 thalhah

thalhah

    Level 3

  • Members
  • Level
  • 9 points
  • 85 posts

Posted 27 October 2010 - 12:15 AM

wah... but for me its not the problem. haha. everyday just one user aktive. myself. and server just localhost. :D :D .. i want to publish but youone template still not have solution. heee

#7 Salman

Salman

    Red Team Sierra 1

  • Administrators
  • Level
  • 3,344 points
  • 6,256 posts
    • Gender:Male


Users Awards

Posted 27 October 2010 - 12:29 AM

as i mentioned above in my post for UBUNTU SERVER
For my UBUNTU LINUX SERVER EDITION 10.4 LTS its file location
/etc/mysql/my.cnf
its configuration file of MYSQL

also you need Managed VPS or DEDICATED Server to do such configurations, which has root access
if you are using Cpanel, i dont know its WHM has file manager or not
I access that file from WEBMIN file manager, install webmin on your managed vps / dedicated server http://www.webmin.com/

You can do it via puty too
if you are using CENTOS Operating System , its file location maybe changed, i dont know where is this file in CentOS but after using google i found this
http://help.directad.../item.php?id=44
maybe its /etc/my.cnf

from webmin , you can find this file easily in its file manager , using search tool, and find my.cnf ,users having WHM should look around it, i am not using CPanel/WHM
as Ubuntu Compilers are faster than centos, and SE4 works faster in Ubuntu Server 10.4 and control panel EHCP

Kindly dont add this code in any other file than my.cnf file for Linux and my.ini file for windows, else your server can get crashed

After adding this code, restart your MYSQL
Thank You :)
click this if you want to +1rep my post Posted Image if you found its quality work

#8 kofmzc

kofmzc

    Level 3

  • Members
  • Level
  • 25 points
  • 87 posts
    • Gender:Male
    • Location:Pakistan

Posted 27 October 2010 - 09:47 AM

No credits to me? SEF Team! :broken:

#9 Salman

Salman

    Red Team Sierra 1

  • Administrators
  • Level
  • 3,344 points
  • 6,256 posts
    • Gender:Male


Users Awards

Posted 27 October 2010 - 11:52 AM

No credits to me? SEF Team! :broken:


Thanks KOFMZC for point me right, you got +1 rep from me :) :) :)
but i did alot hardwork to get this problem solved :D :D
but keep in mind i worked around whole night to get it working :D :lol:
click this if you want to +1rep my post Posted Image if you found its quality work

#10 Bangash

Bangash

    Blue Team Bravo 1

  • Moderators
  • Level
  • 1,488 points
  • 1,741 posts
    • Gender:Male
    • Location:Peshawar, Pakistan
    • Software:SE 4.1.x


Users Awards

Posted 27 October 2010 - 11:56 AM

& I was the one on whom Salman made his experiment :D

Im like an open book. You must meet me if u wanna read me :)





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users


All the resources listed here are just for testing purpose and they shouldn't be used at any commercial environment without a valid license.
Those are for users who wants to try them before buy. Help the developer to build it better by purchasing them from original authors.