Professional Web Applications Themes

MySQL server compacting - MySQL

Hello! I have heard lately that when sb has very big mysql database and call delete sql query many times on this database it generates many gaps in database. That`s why database store a big space on hardware and can work lower. Is it true? Moreover, I have heard that in this case there is a need to compact database (from time to time) to fill/remove gaps and this will make such database more efficient. How to do that in phpmyadmin? Is it a thing which has to be done by admins? Should I do it by myself? If so, ...

  1. #1

    Default MySQL server compacting

    Hello!

    I have heard lately that when sb has very big mysql database and call delete
    sql query many times on this database it generates many gaps in database.
    That`s why database store a big space on hardware and can work lower. Is it
    true?

    Moreover, I have heard that in this case there is a need to compact database
    (from time to time) to fill/remove gaps and this will make such database
    more efficient. How to do that in phpmyadmin? Is it a thing which has to be
    done by admins? Should I do it by myself? If so, how can I do this in
    phpmyadmin? Should I take care for some things - which then?

    Thank you a lot
    Marcin


    MZ Guest

  2. #2

    Default Re: MySQL server compacting

    MZ wrote: 

    it's good practice to reorg your table periodically specifically to
    overcome the "gap" problem you're talking about.

    as far as phpmyadmin, i am not sure but i think i've seen a button
    somewhere to run table optimization commands. maybe ask phpmyadmin folks!
    lark Guest

  3. #3

    Default Re: MySQL server compacting

    MZ wrote: 

    It is the Optimize table option and can be found on the operations tab of
    phpmyadmin:
    http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html


    Paul Guest

Similar Threads

  1. Replies: 0
    Last Post: January 29th, 02:03 PM
  2. Replies: 6
    Last Post: August 13th, 08:24 PM
  3. Compacting access database using asp pages?
    By S N in forum ASP Database
    Replies: 2
    Last Post: April 24th, 10:02 AM
  4. access -compacting and ting?
    By Ray at in forum ASP
    Replies: 0
    Last Post: August 7th, 10:20 AM
  5. compacting the db
    By Armin in forum Microsoft Access
    Replies: 2
    Last Post: July 3rd, 08:13 AM

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