Home > Bookmarks, Hosting, Linux, MySQL > Optimize MySQL Tables

Optimize MySQL Tables

November 17th, 2007 Leave a comment Go to comments

How to Optimize MySQL Tables ?

1. Login on server
2. Type next linux command in your mysql folder with MYI files :

myisamchk –quick –check-only-changed –sort-index –analyze *.MYI

folder ex: /var/lib/mysql/yourdatabase/

Categories: Bookmarks, Hosting, Linux, MySQL Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.
GoCache - ByREV-Cache v1.0 - live served in : 0.183034 sec (gzip)