Announcement

Collapse
No announcement yet.

Memory problems?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • George L
    replied
    Re: working before

    Originally posted by della
    ...fine, I agree that it is a puny system... But, why has it been working fine for the past year? Can it be that whatever new users/posts over the weekend just burst its seems???

    Jason
    hard to say could be increased mysql usage nowadays or just the configuration of mysql settings changed or are no longer adequate and need retuning or a server upgrade

    Leave a comment:


  • George L
    replied
    Re: Re: Re: not too beefy...

    Originally posted by Steve Machol
    I didn't know that! Would broccoli work better?
    pc lingo.. celery = celeron hehe

    Leave a comment:


  • della
    replied
    working before

    ...fine, I agree that it is a puny system... But, why has it been working fine for the past year? Can it be that whatever new users/posts over the weekend just burst its seems???

    Jason

    Leave a comment:


  • Steve Machol
    replied
    Re: Re: not too beefy...

    Originally posted by eva2000
    ... and celery is not really meant for servers
    I didn't know that! Would broccoli work better?

    Leave a comment:


  • George L
    replied
    Re: not too beefy...

    Originally posted by della
    ...ok, found the page with configs. The MySQL db is sitting on db12 (Celeron 667 MHz, 256MB RAM, 20GB disk) and the PHP scripts/etc are sitting on ynilo (Athlon 1400 MHz, 512MB DDR RAM, 25GB disk).

    Not that tells us much. Up until yesterday, it seemed to be enough.

    Jason
    there's you problem the database server is severely lacking in hardware... not enough memory, slow disk drives and celery is not really meant for servers

    Leave a comment:


  • della
    replied
    db alive

    ...well, the db seems to be alive because I can access via phpMyAdmin, and I did these two small queries:

    http://www.igda.org/php-bin/test_db12x.php
    (select my record from the user table)

    http://www.igda.org/php-bin/test_db12.php
    (running the same query on the forumpermission table mentioned in my first post above)

    http://www.igda.org/php-bin/test_db12xx.php
    (select all usernames from user table)

    These are very simple, of course, but nice to see the system/MySQL is alive...

    Jason

    Leave a comment:


  • della
    replied
    not too beefy...

    ...ok, found the page with configs. The MySQL db is sitting on db12 (Celeron 667 MHz, 256MB RAM, 20GB disk) and the PHP scripts/etc are sitting on ynilo (Athlon 1400 MHz, 512MB DDR RAM, 25GB disk).

    Not that tells us much. Up until yesterday, it seemed to be enough.

    Jason

    Leave a comment:


  • George L
    replied
    download and install phpsysinfo at http://phpsysinfo.sourceforge.net/ and post the url to the phpsysinfo page it will show what hardware you have

    Leave a comment:


  • della
    replied
    totally bust

    ...ya, I noticed the flush table thing, but that seems rather tweaky. At this point, the entire forum is bust and inaccessible...

    Sadly, I have no clue what the server is. But, I did find this policy regarding resource usage:

    http://www.pair.com/pair/policies/dbresource.html

    (as an aside, I think I am way over the 20mb disk space limit...)


    Jason

    Leave a comment:


  • George L
    replied
    looks like they rather than optimise mysql have decided to set it to automatically flush tables every XX amount of time... not good especially during peak mysql usage times

    how memory and cpu speed is on your server ?

    Leave a comment:


  • della
    replied
    thanks

    ...ok, cool. I'll point that out and see how it goes.

    Thanks,

    Jason

    Leave a comment:


  • Steve Machol
    replied
    As I pointed out, mysqlinfo shows no processes running. This should be a clue to them that something is wrong. Ask them to restart MySQL and if you still have problems ask them to reboot the server.

    I wish I could be more constructive but I do not have root access to this server and I have no magic words that will make your host behave responsibly.

    Leave a comment:


  • della
    replied
    can't move

    ...ya, I was none too happy with their response... But, it is not really an option to move at this stage...

    I must admit that I am pretty clueless when it comes to this stuff... I am great at general db and php coding, but not the server side stuff...

    Can you provide any more constructive feedback beyond moving host? That is, any info in general or from the above info links that I can go to them and say "look, you need to...".

    Also, might a simple "reboot" help in this situation.

    I can't imagine that gaining a few more users or posts over the weekend would have tipped us past the resource limits...

    Thanks!

    Jason

    Leave a comment:


  • Steve Machol
    replied
    You won't like it but my advice is to find a new host. This one clearly does not know how to manage a server and would rather blame the software than learn how to optimize and manage mySQL.

    Note that mysqlinfo shows '0' mysql processes running. Ask them to explain how this is a problem with vB.

    Leave a comment:


  • della
    started a topic Memory problems?

    Memory problems?

    Hi all,

    ...need some help.

    vB starting acting funny over the weekend and is now not responding:
    http://www.igda.org/Forums

    I kept getting error emails with text to the effect of:

    **********
    Database error in vBulletin: Invalid SQL: SELECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='1'
    mysql error: MySQL client run out of memory
    mysql error number: 2008
    Date: Monday 16th of September 2002 07:06:16 AM
    Script: /Forums/forumdisplay.php?forumid=126
    Referer:
    **********

    I contact my host to ask if there was a server problem (they recently updated their FreeBSD install to 4.6), or if they needed to reboot, etc. But, they told me that forum code is ineffecient and I should debug/optimize... Ya, that's a lot of help.

    So, in part, that motivated me to update my vB install from v2.0.3 to v2.2.7. The update went fine (ie, I can access my MySQL server), but did not help with anything. I can't even access my admin page.

    Here are the links to the various info pages:
    http://www.igda.org/Forums/admin/mysqlinfo.php
    http://www.igda.org/Forums/admin/phpinfo.php
    http://www.igda.org/Forums/admin/phptest.php


    Any advice or help would be greatly appreciated.

    Jason
Loading...
Working...
X