Topic: Articles by Priya T
|
Mysql Server Optimization for DBA
Monday, July 02, 2007
|
| |
MySQL is the most widely used multi-user, multi-threading SQL database
management system. To optimize MySQL performance, a DBA should have
reasonable knowledge of MySQL system variables. This
article covers the basics of MySQL server optimization. We will first
discuss MySQL optimization during installation. Then
we will discuss the seven most important and common system variables.
Plus, a brief note on how to optimize the server using those seven
variables.
We will also discuss MySQL status variables. This article would be very
useful for a newbie MySQL DBA when setting up a MySQL server.
|
|
 |
|
|
Online
There are 19 guests and 0 members online.
|
|