Results 1 to 2 of 2

Thread: DataBase profiler

  1. #1
    Join Date
    Jul 2008

    DataBase profiler

    Hi all

    I am getting to the end of a mammoth creation and learning curve or creating a PHP, JavaScript and MYSQL dynamic site and I am looking for any recommendations on profiling my database to find any bottlenecks or issues with my MYSQL.

    I have implemented caching across the entire site using pear but I still want to make sure when the DB is being used it is as efficient as possible.

    Has anyone got any personal recommendations for performing such profiling? As always money is tight here so an open source application would be ideal to test on my home Dev server before I release her into the wild.

    Thanks in advance for any help.

  2. #2
    Join Date
    Aug 2004
    One thing you can do is use MySQL's EXPLAIN to help optimize queries. In fact, you might spend a little time poking around the enitre Optimization chapter while you're there (in particular section 7.2).
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center