Professional Web Applications Themes

MySQL crashed - MySQL

We had an odd problem with Mysql the other day (v. 4.0 - RHEL3 up2date). Our web site stopped responding. We logged in, and checked our log files. 1.nothing related in /var/log/messages. 2.too late to check dmesg. 3.no problems in the mysql log. There were active queries and looked as if it were in use and running properly. I was not around when the problem occured, but i was told that you could hop into the mysql console, but it froze when you did "use database_name;" I thought this was odd, as the log files show that the website didn't ...

  1. #1

    Default MySQL crashed


    We had an odd problem with Mysql the other day (v. 4.0 - RHEL3 up2date).

    Our web site stopped responding.
    We logged in, and checked our log files.
    1.nothing related in /var/log/messages.
    2.too late to check dmesg.
    3.no problems in the mysql log. There were active queries and looked as
    if it were in use and running properly.

    I was not around when the problem occured, but i was told that you could
    hop into the mysql console, but it froze when you did "use database_name;"

    I thought this was odd, as the log files show that the website didn't have
    any trouble doing this.

    at this point mysql was restarted, and operations resumed as normal.

    What type of things should I be looking for to prevent this?
    Arty Guest

  2. #2

    Default Re: MySQL crashed

    I found why our mysql server crashed the other day.
    Mysql gave several errors saying
    "060311 10:06:01 Error in accept: Too many open files"

    right now mysql has close to 3000 files open, which can vary by a few
    hundred to a thousand every second. The entire system has on average about
    4000 files open.

    I thought this might be a problem, but /proc/sys/fs/file-max says we can
    have 209708 files open...

    ulimit -a shows this.
    open files (-n) 1024

    How do i fix this??
    Obviously /proc/sys/fs/file-max is not the problem
    /proc/sys/fs/file-ng shows "1665 1046 209708"
    And that number in ulimit was the problem, would I be having trouble right
    now??

    Plz, help!
    Arty Guest

Similar Threads

  1. Contribute Crashed
    By kgui in forum Macromedia Contribute General Discussion
    Replies: 1
    Last Post: April 25th, 05:40 PM
  2. Replies: 0
    Last Post: January 29th, 02:03 PM
  3. FCServer crashed
    By kekkek in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: March 18th, 09:44 AM
  4. Server Crashed
    By Vineet Mehrotra in forum Informix
    Replies: 2
    Last Post: June 26th, 09:31 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139