"As we advance in life it becomes more and more difficult, but in fighting the difficulties the inmost strength of the heart is developed."
A description about the blog can be placed here.

MySQl continually crashes. I am desparate for help

Posted in: zjnq.com Date: March 9th, 2010

  • I don't know what to do. A week since I'm running vB and the mysql daemon crashes at least twice a day, and what's more - I can't back up the database (see different thread).

    I have admins who are at a loss on what is causing this, and I really really need some help, ideas, input.

    Some data:

    I am running a dedicated server (though I do not have root access to it - it's called Managed Dedicated Server whereby the host admins are the root, thus taking 100% responsibility for the server's fine running).

    Versions:
    OS: BSDI BSD/OS 4.0.1
    Apache: 1.3.9
    PHP: 3.0.12 (phpinfo can be found at http://www.atlasf1.com/php.php)
    MySQl: 3.22.32

    Hardware:
    CPU: dual Pentium 450
    RAM: 512mb

    Free memory is always above 200mb, normally around 300.

    The server has only this website and it serves a traffic of about 80gb a month. No special applications running and no other application works with MySQL other than vB.

    Please let me know what other information can be helpful.

    Thanks,

    Bira

    [Edited by bira on 06-11-2000 at 03:45 PM]


  • well right now they *are* trying to find the problem and its solution. I just know that leaving it down to them would be timely. I had hoped that maybe someone here would have an idea or has knowledge of MySQL.

    But thanks!


  • Shri, thanks for the advice. Before I do that, I want to eliminate any possibility of a simple server config change that could be done. I can't shake off the feeling that somewhere something is simply not configured right.

    By the way, the MySQL variables on my server can be found at http://www.atlasf1.com/mysqlvar.txt -- if someone knows something about MySQL, I'd appreciate it if heshe could have a look and say if something should be changed.

    Thanks


  • Shri, I feel complimented that you could even consider me to be able to install MySQL :) :)

    No, MySQL was installed or compiled - I've no idea - by Concentric's senior admin who is supposed to be an expert in this. To his defence I would say that's he's very good at what he does but apparently hit a wall in this one.

    I don't have root access to the server, although it's my server. The service is titled "managed dedicated server" which means Concentric take full responsibility on the fine running of the server (and therefore do not allow anyone root access except for their own admins). Therefore, if I need something compiled or changed - I call them or drop them a line via e-mail and they do it for us.


  • Bira,

    If you're getting a core dump (crash) then I suspect its an incompatibility with some other software / libraries.

    How did you install mysql? I installed mine using RPMs which were available and it worked out of the box... Did you compile yours? (That could be a problem).

    Shri


  • bira,

    Woohoo, Glad to hear it :)


  • Bira :)

    Don't you think its best that Concentric deals with mySQL directly? Do they have a support contract with them as a provider of mySQL?

    Debugging crashes is a little bit beyond me if it has core dumped... (hey .. i'm just a sales guy :) )

    Shri


  • What is that -q --quick thing that you mentioned in your post?

    John


  • well since they did that -q --quick thingy, peace has been restored to the server. Touch wood, no crashes for some 48 hours now, and everything works flawlessly :)

    Thanks all


  • John,

    Well Concentric's senior admin just told me they fixed the problem, so I wrote him back asking what did they do that fixed it and he replied:


    We used the -q option:

    -q, --quick Don't buffer query, dump directly to stdout.


    I have no idea what it means, but if you want me to ask him for more details I can.

    Cheers,

    Bira


  • that looks like an "out of the box" installation.

    try raising the key_buffer to about 128Mb, the max connections to 200 (or 300) and the sort buffer to 4Mb. our servers are basically identical in hardware specs, and that's how mine is running.

    Also, raise the PHP memory to 32 Mb.


  • Bira,

    Might be worth your while to go to http://www.mysql.com and buy yourself a support contract. With 80GB of data flowing through your servers, its definately worth buying support to make sure you have a rock solid stable implementation.

    Shri


  • ok, Martin, I'll do that and let you know.

    Thanks







    • #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 MySQl continually crashes. I am desparate for help , Please add it free.

    edit

    Hard Rain on Software Sector
    uBid Latest Firm to Embrace MS' .Net