Any tech guy who can finetune a sql server for me?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mrthumbs
    salad tossing sig guy
    • Apr 2002
    • 11702

    #1

    Any tech guy who can finetune a sql server for me?

    This thing keeps giving me issues.. im about to shoot myself.

    Freebsd.. sql5.. paypal payments!

    icq 160272407 or [email protected]
  • FuqALot
    Confirmed User
    • Dec 2001
    • 3817

    #2
    Needed this done the other day, I hit up the hosting guy (webair) and they optimized it for me. It is only one file (my.cnf), I believe, that needs to be edited.

    Comment

    • PussyTeenies
      Confirmed User
      • Feb 2005
      • 6496

      #3
      hit up that dutch guy!
      Need adult hosting?

      Contact us!
      WARM Hosting

      Need an IT solution? or someone to check your site and security? Nossie - IT Professional

      Comment

      • mrthumbs
        salad tossing sig guy
        • Apr 2002
        • 11702

        #4
        Originally posted by PussyTeenies
        hit up that dutch guy!
        I did.. and we had an appointment he would fix shit yesterday 14:00.......

        Comment

        • Mike Seth
          Registered User
          • Feb 2006
          • 88

          #5
          WTF is SQL5? MySQL5?
          Mike Seth - 274-570-412 <mikeseth at gmail.com>

          Comment

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

            #6
            Darksoul does good work.

            Comment

            • mrthumbs
              salad tossing sig guy
              • Apr 2002
              • 11702

              #7
              Originally posted by Mike Seth
              WTF is SQL5? MySQL5?
              Yes!!!!!!!!!

              Comment

              • Mike Seth
                Registered User
                • Feb 2006
                • 88

                #8
                Originally posted by Franck
                Darksoul does good work.
                Darksoul from emuadmin.com? That is true, and I can attest to that. The setup that I've seen is very tight.
                Mike Seth - 274-570-412 <mikeseth at gmail.com>

                Comment

                • Mike Seth
                  Registered User
                  • Feb 2006
                  • 88

                  #9
                  Originally posted by mrthumbs
                  Yes!!!!!!!!!
                  If you could possibly more specific about what is the trouble you're having then someone would've been able to help you.
                  Mike Seth - 274-570-412 <mikeseth at gmail.com>

                  Comment

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

                    #10
                    just increase max connections allowed, and the default is 8M memory size. should be at least 64m
                    Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.


                    My Newest Theme

                    Comment

                    • mrkris
                      Confirmed User
                      • May 2005
                      • 2737

                      #11
                      hit me up on icq - 342500546

                      PHP-MySQL-Rails | ICQ: 342500546

                      Comment

                      • PR_EZEKIEL
                        Confirmed User
                        • Feb 2005
                        • 134

                        #12
                        Originally posted by Mike Seth
                        If you could possibly more specific about what is the trouble you're having then someone would've been able to help you.
                        It sounds like he needs someone to help him with it...i'm sure if he knew more specifically what the problem was then he'd have said so.
                        PimpRoll.com

                        Comment

                        • Mike Seth
                          Registered User
                          • Feb 2006
                          • 88

                          #13
                          Originally posted by PR_EZEKIEL
                          It sounds like he needs someone to help him with it...i'm sure if he knew more specifically what the problem was then he'd have said so.
                          With MySQL, you do not normally touch the server settings unless you know precisely what is it that you're trying to achieve. "Finetuning" a server is a very uncommon operation. If there is a performance problem chances are it has something to do with the database structure and the way the client application makes queries and as such, thus the first thing to be done is consulting with a competent developer, not a system administrator.

                          He said "issues". What kind of issues?
                          Mike Seth - 274-570-412 <mikeseth at gmail.com>

                          Comment

                          • mrthumbs
                            salad tossing sig guy
                            • Apr 2002
                            • 11702

                            #14
                            Originally posted by Mike Seth
                            With MySQL, you do not normally touch the server settings unless you know precisely what is it that you're trying to achieve. "Finetuning" a server is a very uncommon operation. If there is a performance problem chances are it has something to do with the database structure and the way the client application makes queries and as such, thus the first thing to be done is consulting with a competent developer, not a system administrator.

                            He said "issues". What kind of issues?

                            The fact you refused to interpret my "sql5" as "mysql5" displays you are not constructive towards my 'issue'. Actually you're quite annoying although i appreciate your attempts for clarification.

                            Any my 'issue'? Penis size problems.. as usual :-(

                            MrKris: hitting you up.
                            Last edited by mrthumbs; 03-17-2006, 04:13 PM.

                            Comment

                            • Linguist
                              Confirmed User
                              • Apr 2004
                              • 1706

                              #15
                              Originally posted by mrthumbs
                              The fact you refused to interpret my "sql5" as "mysql5" displays you are not constructive towards my 'issue'. Actually you're quite annoying although i appreciate your attempts for clarification.

                              Any my 'issue'? Penis size problems.. as usual :-(

                              MrKris: hitting you up.
                              Saying sql5 shows your ignorance rather than his. There is no such thing as sql5. SQL is a general language, MySQL is a specific implementation of it.
                              Why would he readily interpret it as MySQL? There's a crapload of DB servers for freebsd.
                              315-310

                              Comment

                              • mrthumbs
                                salad tossing sig guy
                                • Apr 2002
                                • 11702

                                #16
                                Originally posted by Linguist
                                Saying sql5 shows your ignorance rather than his. There is no such thing as sql5. SQL is a general language, MySQL is a specific implementation of it.
                                Why would he readily interpret it as MySQL? There's a crapload of DB servers for freebsd.

                                Well let me say this: if i knew all that and was as tech-literate as you i wouldnt be asking stupid questions on this forum!!

                                Comment

                                • Linguist
                                  Confirmed User
                                  • Apr 2004
                                  • 1706

                                  #17
                                  Originally posted by mrthumbs
                                  Well let me say this: if i knew all that and was as tech-literate as you i wouldnt be asking stupid questions on this forum!!
                                  nah, i'm just saying that you shouldn't slam him for interpreting it incorrectly. He had a good guess that it was mysql5 but you went out all hostile on him AFTER he gave you quite a sound advice. I'd actually consider his advice before/after tuning your server.. it may be an application issue
                                  315-310

                                  Comment

                                  • mrthumbs
                                    salad tossing sig guy
                                    • Apr 2002
                                    • 11702

                                    #18
                                    Originally posted by Linguist
                                    nah, i'm just saying that you shouldn't slam him for interpreting it incorrectly. He had a good guess that it was mysql5 but you went out all hostile on him AFTER he gave you quite a sound advice. I'd actually consider his advice before/after tuning your server.. it may be an application issue
                                    You people take me way too serious haha.

                                    But you're right.. i could have been an application issue.. it could have been a hardware issue.. but from my first post it should have been quite obvious im a clueless moron and i need someone to check THAT out..

                                    Comment

                                    • woj
                                      <&(©¿©)&>
                                      • Jul 2002
                                      • 47880

                                      #19
                                      Originally posted by mrthumbs
                                      The fact you refused to interpret my "sql5" as "mysql5" displays you are not constructive towards my 'issue'. Actually you're quite annoying although i appreciate your attempts for clarification.

                                      Any my 'issue'? Penis size problems.. as usual :-(

                                      MrKris: hitting you up.
                                      He is actually right, most of the time problems are due to poorly designed db tables or inefficient coding.
                                      Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000
                                      Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager
                                      Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

                                      Comment

                                      • woj
                                        <&(©¿©)&>
                                        • Jul 2002
                                        • 47880

                                        #20
                                        This is kinda like looking into the engine or transmission because the car is "slow " when really the problem is the driver. If you put an old lady in a race car, it won't go very fast no matter how much you tune the car.
                                        Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000
                                        Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager
                                        Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

                                        Comment

                                        • Mike Seth
                                          Registered User
                                          • Feb 2006
                                          • 88

                                          #21
                                          I don't mean to offend anyone, but "issues" is simply not a valid description of a problem. It is an equivalent of "my website doesnt work". How do you know you have a problem? How does it express itself? What did you change prior when the problem appeared? I can't help you unless you give me something to work with. Seriously, you can't just expect to post about "issues" and have a flock of mind-readers fix your DB problems with the power of a thought.
                                          Mike Seth - 274-570-412 <mikeseth at gmail.com>

                                          Comment

                                          • prime
                                            Confirmed User
                                            • Feb 2005
                                            • 400

                                            #22
                                            this one is goood!
                                            i want some more drama...

                                            | offshore solutions | manual labor | staff leasing | and more!
                                            Dedicated -Motivated-Managed Employees
                                            icq.: 309570461 live chat

                                            Comment

                                            • Mike Seth
                                              Registered User
                                              • Feb 2006
                                              • 88

                                              #23
                                              Originally posted by prime
                                              this one is goood!
                                              i want some more drama...
                                              http://www.ljdrama.org
                                              Mike Seth - 274-570-412 <mikeseth at gmail.com>

                                              Comment

                                              Working...