Results 1 to 10 of 10

Threaded View

  1. #7
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Mysql server constantly crashing

    The things that I'd pick out of that data are that your mysql server has only been running for 45 minutes - did you restart it? Or is this further evidence of it crashing frequently.

    The other is the number of slow queries. 287 in 45 minutes is a lot. I prefer that number to be 0. Though we don't know what the threshold is set to.

    As a comparable, the (sorry, site offline) site mysql server has been running for 13 days, during which it has handled a 377 million (yes million) queries of which 41 were flagged as slow.

    I'm afraid you need to get inside your slow query log. It is possible that it is you tying up the mysql server and crashing it.

    Please note DrByte's request. Your version of Zen Cart and the mods that you have installed are likely to be vital information going forward if this does prove to be an issue with your Zen Cart.
    Last edited by kuroi; 3 Jul 2010 at 04:31 PM.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

 

 

Similar Threads

  1. MySQL user crashing servers MySQL
    By focus360 in forum General Questions
    Replies: 8
    Last Post: 22 Jan 2009, 09:25 PM
  2. server crashing with my 1.3.7.1 site? how to fix?
    By cshart in forum General Questions
    Replies: 2
    Last Post: 19 Jan 2008, 05:00 PM
  3. Cart Began Hanging and Crashing Server
    By DevMast45 in forum Installing on a Linux/Unix Server
    Replies: 14
    Last Post: 18 Apr 2007, 08:17 PM
  4. Server Crashing
    By itollij in forum General Questions
    Replies: 7
    Last Post: 17 Nov 2006, 02:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg