Posts Tagged ‘mysql’

Roadmap to optmize php code ““Micro” Optimizations That Matter”

This a nice & short article: “Micro Optimizations That Matter” by Brandon Savage.

It’s like roadmap to optimize your web applications rather than the php code by itself, “micro” tricks that can definitely impact performance positively.

Improve Mysql Performance

The best answers come from measurable data, don’t let the “I think that “, “I believe”, “IF…” drive your decisions when it comes to performance.

Where to look? Well, don’t try to reinvent the wheel, there are plenty of tools that can provide enough data so you can make informed decisions regarding mysql performance.

SQL Performance Tips: There is lack on benchmarks about most of the suggestions here, still, many of them are obvious and can help you about what to test.

How to profile a query in mysql: this is self explanatory :)

Using the New MySQL Query Profiler: SQL diagnostic tool that assists in the debugging and analysis of running SQL.

Mysql Tools

I’ve been using some tools for mysql administration (either web or desktop applications), the more used are:

  1. phpmyAdmin: default web administrator in many bundle installations, useful, basic; not ajax-y which sometimes makes me feel like that’s a boring place to be.. kinda ugly too, Still backup function are easy to find and use.
  2. turbodbadmin: nice web application with ajax all around, looks like a desktop applications and it is very efficient.
  3. SQL Yog: desktop application, very easy to use when you try to copy a whole database from a server to another remotely.

Here you will find some other tools and overviews about them.

Return top

Information

Lacoste Shoes Saletory burch flatsNike Dunk Highchristian louboutin pumpstory burch bagsCheap Air max shoesnike air max 2010air force 1christian louboutin uktory burch shoeslebron shoesLacoste Shoes 2010