Tips on MySQL Database Optimization
* Use MySQL Commands like EXPLAIN, EXPLAIN EXTENDED and ANALYZE often to understand queries you are running
* Create indexes on fields you feel are most likely to be used in your queries.
* Design your tables with emphasis on proper data type. Do not use Data type like TEXT for fields like title of posts.
* Use proper table field names. A column named "t" will not make much sense to other programmers working with you, use fields like "post_title" so that one gets idea of what the column is for.
* Use mysql_pconnect and mysql_connect with intelligence. Do not blindly use mysql_pconnect just because it keeps a connection open for multiple uses. It can kill your server.
MySQL EXPLAIN Syntax : http://dev.mysql.com/doc/refman/5.0/en/explain.html
MySQL ANALYZE Syntax : http://dev.mysql.com/doc/refman/5.0/en/analyze-table.html
That is it for now.
Regards
BollywoodSARGAM Database Development Team
* Use MySQL Commands like EXPLAIN, EXPLAIN EXTENDED and ANALYZE often to understand queries you are running
* Create indexes on fields you feel are most likely to be used in your queries.
* Design your tables with emphasis on proper data type. Do not use Data type like TEXT for fields like title of posts.
* Use proper table field names. A column named "t" will not make much sense to other programmers working with you, use fields like "post_title" so that one gets idea of what the column is for.
* Use mysql_pconnect and mysql_connect with intelligence. Do not blindly use mysql_pconnect just because it keeps a connection open for multiple uses. It can kill your server.
MySQL EXPLAIN Syntax : http://dev.mysql.com/doc/refman/5.0/en/explain.html
MySQL ANALYZE Syntax : http://dev.mysql.com/doc/refman/5.0/en/analyze-table.html
That is it for now.
Regards
BollywoodSARGAM Database Development Team


0 Comments:
Post a Comment
<< Home