BIz Thread: MySQL what exactly does optimizing tables do?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Juicy D. Links
    So Fucking Banned
    • Apr 2001
    • 122992
    #1

    BIz Thread: MySQL what exactly does optimizing tables do?

    Help keep things tidy kinda like dfragging a pc?
    Tags: None
    • tical
      Confirmed User
      • Feb 2002
      • 6504
      #2
      yeah, pretty much just like that... if you delete a lot of entries and you optimize its like defragging and its able to reclaim that empty space
      112.020.756

        Comment

        • tical
          Confirmed User
          • Feb 2002
          • 6504
          #3
          yeah, pretty much just like that... if you delete a lot of entries and you optimize its like defragging and its able to reclaim that empty space
          112.020.756

            Comment

            • StuartD
              Sofa King Band
              • Jul 2002
              • 29903
              #4
              It repairs, analyzes and sorts your mysql indexes. Makes things run at their best all the time.
              This is me on facebook
              This is me on twitter

                Comment

                • woj
                  <&(©¿©)&>
                  • Jul 2002
                  • 47880
                  #5
                  What's with all the biz threads lately? You made a deal with gfy to post more biz threads in exchange for getting unbanned?
                  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

                    • StuartD
                      Sofa King Band
                      • Jul 2002
                      • 29903
                      #6
                      Originally posted by woj
                      What's with all the biz threads lately? You made a deal with gfy to post more biz threads in exchange for getting unbanned?
                      This is me on facebook
                      This is me on twitter

                        Comment

                        • tical
                          Confirmed User
                          • Feb 2002
                          • 6504
                          #7
                          so chads not even real?
                          112.020.756

                            Comment

                            • Juicy D. Links
                              So Fucking Banned
                              • Apr 2001
                              • 122992
                              #8
                              Originally posted by woj
                              What's with all the biz threads lately? You made a deal with gfy to post more biz threads in exchange for getting unbanned?
                              i am turning back to Juic D of 2001-2003

                                Comment

                                • CaptainHowdy
                                  Too lazy to set a custom title
                                  • Dec 2004
                                  • 94137
                                  #9
                                  Originally posted by woj
                                  What's with all the biz threads lately? You made a deal with gfy to post more biz threads in exchange for getting unbanned?
                                  And this is not a "biz thread" exactly...

                                    Comment

                                    • Nom_is
                                      Confirmed User
                                      • Jan 2006
                                      • 197
                                      #10
                                      Originally posted by Juicy D. Links
                                      Help keep things tidy kinda like dfragging a pc?
                                      It just brings your MySQL indexes up to date. They are stored in your server's memory rather than on the hard disk. If you have a database in which many entries are being altered it is important to repair and optimize on a regular basis. If you don't and you are using INNODB tables they can lock up and be unreadable until you repair and optimize the indexes on that table. This can also cause MySQL to crash.
                                      ICQ# 314-721-978

                                        Comment

                                        • uno
                                          RIP Dodger. BEST.CAT.EVER
                                          • Dec 2002
                                          • 18450
                                          #11
                                          Can you do that via phpMyAdmin?
                                          -uno
                                          icq: 111-914
                                          CrazyBabe.com - porn art
                                          MojoHost - For all your hosting needs, present and future. Tell them I sent ya!

                                            Comment

                                            • munki
                                              Do Fun Shit.
                                              • Dec 2004
                                              • 13393
                                              #12
                                              Thanks for reminding me... I've got a couple that are about due for a cleanup...

                                              “I have the simplest tastes. I am always satisfied with the best.” -Oscar Wilde

                                                Comment

                                                • budz
                                                  Disruptive Innovator
                                                  • Sep 2003
                                                  • 4230
                                                  #13
                                                  yeah,.. just how do you do this

                                                  and can it be a risk..
                                                  i.e.. not degragging for years then tring it once can corrupt your hd ?
                                                  C:\Code\
                                                  C:\Code\Run\

                                                    Comment

                                                    • Juicy D. Links
                                                      So Fucking Banned
                                                      • Apr 2001
                                                      • 122992
                                                      #14
                                                      phpmyadmin you can do it

                                                        Comment

                                                        • uno
                                                          RIP Dodger. BEST.CAT.EVER
                                                          • Dec 2002
                                                          • 18450
                                                          #15
                                                          I don't see it anywhere. ;(
                                                          -uno
                                                          icq: 111-914
                                                          CrazyBabe.com - porn art
                                                          MojoHost - For all your hosting needs, present and future. Tell them I sent ya!

                                                            Comment

                                                            • uno
                                                              RIP Dodger. BEST.CAT.EVER
                                                              • Dec 2002
                                                              • 18450
                                                              #16
                                                              Nevermind, found it. Is there a way to set up a cronjob for this to run once a week or so on all dbs?
                                                              -uno
                                                              icq: 111-914
                                                              CrazyBabe.com - porn art
                                                              MojoHost - For all your hosting needs, present and future. Tell them I sent ya!

                                                                Comment

                                                                Previous template Next
                                                                Working...