Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


RAM issue with VPS
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

RAM issue with VPS

MridulMridul Member
edited September 2015 in Help

Dear Admins,

Im frequently facing issues of Database unable to connect on my VPS. The error is appearing when i try to login to admin area of the forum.

Hardware : Im using a dacentec VPS. 1 GB RAM + 25 GB HDD , VestaCP Installed.

Installs :

  1. I installed 2 x IPB forum ( Both are New Fresh Installs , 5 members only as im still testing )

  2. I have limited the plugins to around 5 in both , and dont have CPU intesive plugins like shoutbox.

Error : Without any error ( the forum loads fine ) but the admin area become in accessible as i get this :

Unfortunately, NodeQuery gives no warning, ( tells me that i have used 350 MB RAM ) while when i check graphs in client area of Dacentec , I come to know that im constantly using nearly all of my RAM ranging from 800 - 950 MB for over hours.

Plz Advise.

I feel this Link solves my question, but dont know which one...

http://webflake.sx/topic/4759-driver-error-database-error/

Comments

  • AshleyUkAshleyUk Member
    edited September 2015

    What does your /etc/my.cnf look like?

    You may have it set to use more RAM than you have available.

    Thanked by 1Mridul
  • MridulMridul Member
    edited September 2015

    @AshleyUk said:
    What does your /etc/my.cnf look like?
    You may have it set to use more RAM than you have available.

    Thanx fr the advise, let me check this and get back to you.

    Update :

    It looks like this :

    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    symbolic-links=0
    max_connections=200
    max_user_connections=30
    wait_timeout=30
    interactive_timeout=50
    long_query_time=5
    #log-queries-not-using-indexes
    #log-slow-queries=/var/log/mysql/log-slow-queries.log
    
    #innodb_use_native_aio = 0
    innodb_file_per_table
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    
  • Hi
    I am posting a link that will help you increase the amount of ram used by mysql

    http://www.ewhathow.com/2013/09/how-to-increase-mysql-memory-limit/

  • im having problem like this before i was using vestacp, try to change your template description of nginx from default to hosting. i know i change something in there before then ram suddenly drops.

    http://vestacp.com/docs/#template-description

  • @Mridul said:

    Have a read of http://digitaloceanvps.blogspot.co.uk/2014/04/best-configuration-for-512mb-1gb-ram.html as well

    There is plenty of blog posts about configuring my.cnf for low ram usage, currently you have no limits on MySQL so in a low RAM environment your probably find your exhausting all your RAM.

  • perennateperennate Member, Host Rep
    edited September 2015

    Make sure your Apache MaxClients is reasonably low (e.g. 8 or 16). Do

    grep -r 'MaxRequestWorkers\|MaxClients'

    in your Apache directory.

    Thanked by 1XiNiX
  • Thank you guys, i am working on ur suggestions

Sign In or Register to comment.