how often does your MySql go down?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pharrell
    Registered User
    • Nov 2002
    • 63

    #1

    how often does your MySql go down?

    its been down for an hour ever day for the last week.

    is this shit common with all virtual hosting plans?
  • buddyjuf

    #2
    once every 17 years

    Comment

    • Dirty F
      Too lazy to set a custom title
      • Jul 2001
      • 59204

      #3
      ASk for more connections.

      Comment

      • juicylinks
        So Fucking Banned
        • Apr 2001
        • 122992

        #4
        Never gone down for me I think your host setup is messed up if its going down all the time

        Comment

        • Backov
          Confirmed User
          • Mar 2001
          • 1600

          #5
          It also has a tendency to crash if you have heavy volume of INSERT/DELETE transactions and are running MySQL 4.7.xxx (anything before 5.0).

          The solution - Linux.

          It fragments the hell out of its process memory space on FBSD and Linux has better thread support so doesn't have this issue.

          If you're running FreeBSD this may be your issue.
          <embed src="http://banners.spotbrokers.com/button.swf" FlashVars="clickURL=http://banners.spotbrokers.com" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="120" height="60"></embed>

          Comment

          • muchmoreporn
            Confirmed User
            • Mar 2002
            • 784

            #6
            depends who your programmer is.. no more comments
            SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

            Comment

            • nxventures
              Confirmed User
              • Mar 2003
              • 574

              #7
              Originally posted by muchmoreporn
              depends who your programmer is.. no more comments
              Incorrect.
              SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

              Comment

              • TheJimmy
                ICQ- five seven 0 2 5 5 0
                • Jan 2001
                • 10747

                #8
                Originally posted by Backov
                It also has a tendency to crash if you have heavy volume of INSERT/DELETE transactions and are running MySQL 4.7.xxx (anything before 5.0).

                The solution - Linux.

                It fragments the hell out of its process memory space on FBSD and Linux has better thread support so doesn't have this issue.

                If you're running FreeBSD this may be your issue.

                which flavor of linux do you prefer/recommend?
                Investor with 5m - 15m USD to invest. Do you have a site or network of sites earning 50k - 200k a month income? Email your contact and preliminary data to: domain.cashventures (at) gmail.com....Please...no tire kickers...serious offers and inquiries only.

                Comment

                • muchmoreporn
                  Confirmed User
                  • Mar 2002
                  • 784

                  #9
                  I never have a problem with mine but once I had a programmer that i paid to do some work for me and everything was fucking up every few mins, way too many resources was being used, he claimed it was not his fault, paid him for this job, i got pissed deleted the fucking site and nevered talked to him since, moved my sites from my host, was a huge mess over a project i was trying to make big, and just said fuck it
                  SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

                  Comment

                  • Pharrell
                    Registered User
                    • Nov 2002
                    • 63

                    #10
                    Originally posted by muchmoreporn
                    I never have a problem with mine but once I had a programmer that i paid to do some work for me and everything was fucking up every few mins, way too many resources was being used, he claimed it was not his fault, paid him for this job, i got pissed deleted the fucking site and nevered talked to him since, moved my sites from my host, was a huge mess over a project i was trying to make big, and just said fuck it



                    I am in that position right now!

                    Comment

                    • foe
                      Confirmed User
                      • May 2002
                      • 5246

                      #11
                      hardly ever

                      Comment

                      • foe
                        Confirmed User
                        • May 2002
                        • 5246

                        #12
                        Originally posted by muchmoreporn
                        I never have a problem with mine but once I had a programmer that i paid to do some work for me and everything was fucking up every few mins, way too many resources was being used, he claimed it was not his fault, paid him for this job, i got pissed deleted the fucking site and nevered talked to him since, moved my sites from my host, was a huge mess over a project i was trying to make big, and just said fuck it
                        that sucks, choose your hosts carefully

                        Comment

                        • Spunky
                          I need a beer
                          • Jun 2002
                          • 133978

                          #13
                          Yup time to move

                          Comment

                          • icedemon
                            Confirmed User
                            • Jun 2003
                            • 1022

                            #14
                            It depends on several things. The way that MySQL is setup. The way the databases are setup. The way the programs access MySQL. The operating system and the computer that it's on. If MySQL is accessed too much at once and not setup right, it'll be down alot.
                            Clips4Sale.com

                            Comment

                            • Arty
                              Confirmed User
                              • Nov 2002
                              • 880

                              #15
                              Originally posted by Pharrell
                              its been down for an hour ever day for the last week.

                              is this shit common with all virtual hosting plans?
                              What do you mean by down? Causes for that might be different depending on the error... One of the causes might be open connections if that has a small limit especially if the persistent connection used by clients and left open.

                              Comment

                              • pudcat
                                Confirmed User
                                • Mar 2003
                                • 1169

                                #16
                                what type of errors are you getting? when I've had errors on virtual hosting plans it's always been that it's got too many open connections, ask the server admin to bump it up a bit and it should be sweet...

                                of course if you're getting some other type of errors then I can't help without the error message
                                SUBMIT YOUR BABE GALLERIES

                                PROMOTE YOUR BLOG HERE

                                always looking for hardlinks icq #207011694

                                Thunder-Ball.net, good for hardlink exchanges

                                Comment

                                • jennycards
                                  Confirmed User
                                  • Feb 2002
                                  • 1124

                                  #17
                                  On Linux it is important to have enough RAM. When the OS starts swapping to the harddrive mysql tends to die.

                                  Make you RAM as big as your prick
                                  Make Money with true niche programs like Adult ECards - Pantyhose Fetish - Men in Pantyhose

                                  Comment

                                  • PbG
                                    Confirmed User
                                    • May 2003
                                    • 1025

                                    #18
                                    hmmn did'nt know it could go down . . .

                                    Originally posted by Pharrell
                                    its been down for an hour ever day for the last week.

                                    is this shit common with all virtual hosting plans?

                                    Uncensored-Hosting | Photography by Gus

                                    Comment

                                    • SYNIKAL
                                      Confirmed User
                                      • Feb 2003
                                      • 1795

                                      #19
                                      Should never be down if you got a quality host....
                                      ...........

                                      Comment

                                      • PrettyCarla
                                        Confirmed User
                                        • Dec 2002
                                        • 144

                                        #20
                                        I have bad experiences running MySQL on large web servers with high transfer. There has to be some bug causing that sometimes one (random) table gets corrupted. It can be usually corrected with REPAIR TABLE but is difficult to find it if you are not familiar with your application.

                                        Comment

                                        • ServerGenius
                                          Confirmed User
                                          • Feb 2002
                                          • 9377

                                          #21
                                          lower the idle time-out settings.....they're default redigolous high.
                                          Set it to 60 seconds....this will dramatically lower the amount of
                                          idle threads so with the same amount of threads you'll be able
                                          to process a shitload more queries because threads don't keep
                                          lingering around doing nothing.

                                          DynaMite
                                          | http://www.sinnerscash.com/ | ICQ: 370820 | Skype: SinnersCash | AdultWhosWho |

                                          Comment

                                          • ServerGenius
                                            Confirmed User
                                            • Feb 2002
                                            • 9377

                                            #22
                                            You can check on your mysql server by connecting through the
                                            shell with the mysql client.

                                            show processlist;

                                            shows you processes you're mysql server is handling......here
                                            you can see how many idle requests are lingering around and
                                            for how long.....you'll see they stick around VERY long meaning
                                            at that point they're not able to take new queries. This is the
                                            most common reason while mysql runs out of processes and
                                            crashes.......increasing the amount of concurent threads helps
                                            but actually you're not solving the problem.....you just give the
                                            problem more space before it becomes critical and you're wasting
                                            valuable system resources..

                                            status;

                                            shows you the status of the mysql server and gives you some
                                            stats info on what's going on...

                                            DynaMite
                                            | http://www.sinnerscash.com/ | ICQ: 370820 | Skype: SinnersCash | AdultWhosWho |

                                            Comment

                                            • fris
                                              I have to go potty
                                              • Aug 2002
                                              • 55906

                                              #23
                                              the only time shit breaks on your server is if you are a clueless admin, end of story.
                                              Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.


                                              My Newest Theme

                                              Comment

                                              • xzoom
                                                Confirmed User
                                                • Mar 2003
                                                • 129

                                                #24
                                                Originally posted by Pharrell
                                                its been down for an hour ever day for the last week.

                                                is this shit common with all virtual hosting plans?
                                                MySql has never gone down! Maybe it's because I'm on a dedicated server....

                                                Just my

                                                Comment

                                                • blazin
                                                  Confirmed User
                                                  • Aug 2002
                                                  • 2781

                                                  #25
                                                  Never had problems on dedicated with any of my mainstream applications - except for my client that insists on using Win NT

                                                  However I have recently experienced problems on a virtual account I have ( failing to connect )

                                                  Gonna move to a dedicated server this week...
                                                  I don't endorse a god damn thing......

                                                  Comment

                                                  • tiger74
                                                    Confirmed User
                                                    • May 2003
                                                    • 308

                                                    #26
                                                    non ever!

                                                    think of changing u'r host?

                                                    Comment

                                                    • tiger74
                                                      Confirmed User
                                                      • May 2003
                                                      • 308

                                                      #27
                                                      Originally posted by Arty


                                                      What do you mean by down? Causes for that might be different depending on the error... One of the causes might be open connections if that has a small limit especially if the persistent connection used by clients and left open.
                                                      agreed.

                                                      Comment

                                                      • Mr.Fiction
                                                        Confirmed User
                                                        • Feb 2002
                                                        • 9484

                                                        #28
                                                        Originally posted by fris
                                                        the only time shit breaks on your server is if you are a clueless admin, end of story.
                                                        Don't be lazy, protect free speech: ACLU | Free Speech Coalition | EFF | IMPA

                                                        Comment

                                                        Working...