MySQL Creating Indexes

Aug 27, 2010 Author: Developer
Usually, you create all the indexes you need when you are creating tables. Any column declared as PRIMARY KEY, KEY, UNIQUE, or INDEX will be indexed. Sometimes you will find that you are running many…

Compressing MyISAM Tables

Aug 26, 2010 Author: Developer
Although tables become static or dynamic without your specific request (but in response to your design decisions), tables are not automatically compressed. To compress a table, you need to use the command-line…

MyISAM Tables

Aug 26, 2010 Author: SQLmaster
Many people use MySQL for years without discovering that it offers different table types. These people are using MyISAM tables because this has been the default in all recent versions. MyISAM tables offer…