Ahmad -
It's not always a cut-and-dried thing; performance tuning involves a
lot of factors, and with living databases should be an ongoing thing.
Check out the section on optimization at
http://dev.mysql.com/doc/refman/5.0/en/optimize-overview.html
and/or Jeremy Zawodny's excellent book, "High Performance MySQL"
what may be of specific interest to you right away is the EXPLAIN
function, showing you how MySQL will execute your queries:
http://dev.mysql.com/doc/refman/5.0/en/explain.html
Dan
On 10/16/06, Ahmad Al-Twaijiry <ahmadt@stripped> wrote:
> Hi
>
> is there anyway or command to run it against a production table to see
> if there is any column that I should think about indexing it
>
> remember this is a production database, so I can't run it in debug
> mode and I don't have a root access to the database (I'm just a
> developer).
>
>
>
> Thanks
>
> --
>
> Ahmad Fahad AlTwaijiry
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
