Jump to content

Photo
* * * * * 4 votes

Social Engine 4 Server Resource Problem


  • Please log in to reply
109 replies to this topic

#11 eliteness

eliteness

    Level 4

  • Members
  • Level
  • 59 points
  • 142 posts
    • Gender:Male
    • Location:canada

Posted 27 October 2010 - 01:52 PM

i confirm that in centos VPS , its under /etc/my.cnf
However when i add the config mentionned above
i stop the mysql service and i cannot restart it... weird.

#12 ChukuchukuBeef

ChukuchukuBeef

    Blue Team Charlie 1

  • Moderators
  • Level
  • 279 points
  • 449 posts
    • Gender:Not Telling


Users Awards

Posted 17 November 2010 - 06:32 AM

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


Works in my test environment !!!
Thanks a lot !
You are freaking AWESOME :******
ChukuChukuBeef => Porcupine :)
I'm usually nice , but I might spike you if you pose significant threat to the Quality & Decency of SEF !
click this Posted Image (green + icon) if you want to +1rep my post

#13 Salman

Salman

    Red Team Sierra 1

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


Users Awards

Posted 17 November 2010 - 08:59 AM

2nd Social Engine 4 resource usage is their Online Users Activity is MEMORY BASED SESSION, instead of filebased or DATABASE SESSIONS, which is using huge amount of server resource too...
click this if you want to +1rep my post Posted Image if you found its quality work

#14 david77

david77

    Level 2

  • Members
  • Level
  • 3 points
  • 31 posts

Posted 19 November 2010 - 01:03 PM

is there the same problem with SE V3?

#15 Webguy

Webguy

    Level 2

  • Members
  • Level
  • 6 points
  • 28 posts

Posted 27 November 2010 - 06:58 PM

thanks, seems like it added a little speed. i have a dedicated but only have 2 gigs of ram. the home page and member profiles are still sluggish. prolly because of the feeds....

#16 Salman

Salman

    Red Team Sierra 1

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


Users Awards

Posted 30 November 2010 - 07:32 PM

3rd resource problem is bandwidth also... you need some world wide 100mbps line with your server to handle too many request simultaneously ........
click this if you want to +1rep my post Posted Image if you found its quality work

#17 andrewfashion

andrewfashion

    Level 2

  • Members
  • Level
  • 8 points
  • 27 posts

Posted 01 December 2010 - 11:24 AM

thank you for this :D

#18 rizwanshariq

rizwanshariq

    Level 1

  • Members
  • Level
  • 2 points
  • 9 posts

Posted 04 December 2010 - 05:11 PM

thnx alot bro

#19 TiredWithSE

TiredWithSE

    Level 2

  • Members
  • Level
  • 9 points
  • 41 posts

Posted 10 December 2010 - 07:33 PM

increasing the size of buffers may also increase mysql performance for SE
e.g.
key_buffer_size = 000M
table_cache = 0000
sort_buffer_size = 0M
read_buffer_size = 0M
join_buffer_size = 0M
read_rnd_buffer_size = 00M

the values of above buffer sizes depends on the size of your server's ram

#20 Salman

Salman

    Red Team Sierra 1

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


Users Awards

Posted 10 December 2010 - 08:39 PM

increasing the size of buffers may also increase mysql performance for SE
e.g.
key_buffer_size = 000M
table_cache = 0000
sort_buffer_size = 0M
read_buffer_size = 0M
join_buffer_size = 0M
read_rnd_buffer_size = 00M

the values of above buffer sizes depends on the size of your server's ram


well its good for dedicated server where you host 1 SE4, because such things consume more of ur system resource
click this if you want to +1rep my post Posted Image if you found its quality work




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.