View Scraps
Today in History
Celebrity Birthdays
Celebrity Deaths
Thoughts
Sign Up
Sign In
Welcome Guest
Submit Scraps
Most Viewed Scraps
Top Rated Scraps
Defrag your databases - Mysql Send mail vote down 0 vote down 0 Views : 307
Tagged in : Mysql
Defrag your databases

Whenever you change the structure of a MySQL database, or remove a lot of data from it, the files can become fragmented resulting in a loss of performance, particularly when running queries.

Just remember any time you change the database to run the optimiser:

mysqlcheck -o


You may also find it worth your while to defragment your database tables regularly if you are using VARCHAR fields: these variable-length columns are particularly prone to fragmentation.
By - Sanju, On - 2009-12-15



    Login to add Comments .


 
PHPApacheFirefox TweeksShortcutsOthersCSSJavascriptDNSWindowsWebsitesLinuxGame programmingMS OfficeMysqlCVSHTMLJSP/JavaVPS (Virtual Private Server)AJAXFTP ServerFlashAdobe PhotoshopApple MacASPTally tweeksInteresting FactsSEOMailLyricsTomcatCalculationJokesPhilosophyRelax and EnjoyCShell ScriptingCareer OpportunitiesMusic/SongsPoemgoogleArtPerlInternet ExplorerDOMEnglishMechanicalHealthC++Outlook ExpressScience
nice story...
30 waysgoogle improveshow tolil wayne30 ways
defrag yourfavor strreplacefind theweb log class
Website Uptime Contact Us || Privacy Policy || Terms and Conditions

Web hosting by Hiox India