MySQL compiling and Linking for Speed

Sep 04, 2010 Author: MYSQL Expert
You may be able to get a performance improvement from your server by downloading the source version and compiling it yourself. Specifically, if you have a Pentium-based machine and run Linux, you will…

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…