PHP programmer of bangladesh
A PHP Programmer of Bangladesh

MySQL Database Optimization

June 20th 2008 in Database, Programming, mysql

MySQL database optimization is one of the major part of web development. Basically those developers who deals with heavy traffic based web development, will need such optimization. There are very few web tutorial regarding this. I was searching for such tutorial for some purpose with my work. i share those sites contents with you through their full reference.

10 great articles for optimizing MySQL queries

This site includes some wonderful tutorial regarding optimization.  The following key features are discuss in the tutorial

  1. Identifying slow MySQL queries
  2. MySQL & PHP Performance Optimization Tips
  3. MySQL Presentations: Optimizing MySQL
  4. MySQL 5 Optimization and Tuning Guide
  5. Survive heavy traffic with your Web server
  6. Tools to use for MySQL Performance - Peter Zaitsev
  7. MySQL Queries Optimization (video) - Peter Zaitsev
  8. Table Design and MySQL Index Details
  9. MySQL Reference Manual: Optimization Overview
  10. MySQL Reference Manual: The MySQL Query Cache

Reference site: http://phpimpact.wordpress.com/

Optimizing MySQL Queries

This is another site which focus on query optimization with several techniques. The discussion includes following topics

reference: http://hackmysql.com/documents

hope that this links will help you most like me.  thanks to all.


Viewing 5 Comments

Trackbacks

close Reblog this comment
Powered by Disqus · Learn more
blog comments powered by Disqus

Moonrise: A microblogging Site

I joinned Right Brain Solution in Nov, 2007. after joining RBS, i was assigned to a project called Moonrise. Moonriseis a micro blogging site like twitter. Those who are very closed to web world can easily identify what twitter means. Twitter gives you the way to express your feelings with a simple word or sentence. [...]

Moonrise: A microblogging SitePrevious Entry

First FaceBook Application: Blog Review

Today i finished up 90% work of my first facebook application. This is just for my personal interest. The name of the Application is “fanphp”. This application will fatch the latest post from my blog and make it visible to the facebook profile page. then any user adding this application can comment on my post [...]

First FaceBook Application: Blog ReviewNext Entry

Where i am ???



Currently I am working in Right Brain Solution(RBS) as a Software Engineer(Team Leader). I start my journey in RBS from 6th Nov, 2007.
Where i Was???
I am a php professional from Bangladesh. I start my journey as a professional from 1st july, 2006 in EVOKNOW Incorporation. I was there for one and half year. My Position was there "Software Engineer(Lead Developer)". I left EVOKNOW at 5th Nov, 2007.
Self Formed
I do some freelancing work with some of my friends under this name. Our dream is to make it world famous in the field of web development & solution. If you would like to work with us, send us your proposal to technopeoplebd@gmail.com
Social Networks
View Md. Mahabubul Hasan Masud's profile on LinkedIn
Moonrise: What i feeling???
Feelings from moonrise
More items See these feelings on moonrise