How do I limit SQL resources

March 14th, 2010 by wktd
  • Hi all.

    Not sure where this belongs. Which file on my LINUX server do I need to change to limit the amount of resources my forum uses? My server has been crashing when my forum becomes over populated. Is there a way I can limit the RAM and CPU power vB (and MySQL) uses to prevent the server becoming overloaded and shutting down?

    Thanks.

    M




  • Can you please explain exactly what it is you mean and what you are trying to do?


  • When 200 or more folk are logged in and posting, the CPU and memory consumption goes through the roof. I have a dual P3 1Gb with 1Gb RAM on Red Hat Enterprise. The higher is gets, the slower is gets, and eventually it siezes the server. All the services shut down and I have to call my provider and ask them to reboot my server.

    Is there a way to limit the resources MySQL uses?


  • Please see this thread for help with optimizing your server:

    http://www.vbulletin.com/forum/showthread.php?threadid=70117

    Then post the requested info in a new thread in this forum.







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about How do I limit SQL resources , Please add it free.

    Posted in enart.gcgx.com  |  edit

    Bulgaria-Italy: How many miles will Berbatov walk today? Xbox 360 fans ?????????????