Practical Query Analysis - The Diigo Meta page

• 29 Jun 11
  

  Vivus Ignis

  postgresql

• 14 Dec 09
  

  k-fish

  rdbms tool development

• 13 Nov 09
  

  marekblaha

  postgresql

• 22 Aug 09
  

  cucak666

  mysql optimalization script tools

• 28 Sep 08
  

  François VANTOMME

  postgresql optimization tools

• 19 Aug 08
  

  Jessica Winblad

  Web Design - SQL

  • And to collect data from MySQL:   Turn on logging in /etc/my.cnf by adding a line to the mysqld section: log=/var/log/mysql-queries.log   Do a touch /var/log/mysql-queries.log && chown mysql:mysql /var/log/mysql-queries.log   Restart the MySQL server: /etc/rc.d/init.d/mysql restart
• 04 Jul 08
  

  Miguel Angel Rasero

  postgresql performance tuning database

• 08 Oct 07
  

  If you have a busy PostgreSQL or MySQL database application, you might want to analyze the queries to see if they can be improved. Here's a little utility to help with that.

  postgresql performance database tuning ruby SQL

• 

  Calamity Factors

  If you have a busy PostgreSQL or MySQL database application, you might want to analyze the queries to see if they can be improved. Here's a little utility to help with that.

  postgresql performance database tuning ruby SQL

• 19 Sep 07
  

  Joaquin Navarro

  database performance postgresql profiling programming tools tuning tips

• 12 Jul 07
  

  Charleno Pires

  query_performance

• 24 May 07
  

  evangineer

  database imported delicious postgresql query tuning

• 13 May 07
  

  bazso666 bazso

  bazso bookmarks

• 27 Mar 07
  

  Danny

  database delicious performance postgresql tips tools

• 16 Mar 07
  

  Ken Newquist

  mysql performance

• 05 Feb 07
  

  miles woodroffe

  postgres

• 03 Nov 06
  

  Pistos Christou

  analysis database log mysql postgresql query

• 05 Oct 06
  

  TooManySecrets

  Programa como el "statspack" del oracle para postgresql y mysql.

  analisis postgresql mysql dba estadisticas tuning performance sql database

• 04 Sep 06
  

  Joel Liu

  analysis mysql performance ruby

• 05 Jun 06
  

  Pablo Caro Revuelta

  Da cosas prácticas como sqls mas frecuentes, las de mayor duracion

• 20 Mar 06
  

  Sérgio Carvalho

  development optimization postgresql

• 30 Nov 05
  

  Charles Nadeau

  database MySQL postgresql tuning tools Ruby

• 10 Nov 05
  

  F H

  postgresql performance postgres tips tools opensource db sql

• 14 May 05
  

  Sérgio Carvalho

  development postgresql optimization

• 17 Feb 05
  

  M G

  Utility to analyze queries to Postgres or MySQL

Page Comments

• 
  Pistos Christou on 2006-11-03
  PostgreSQL Query Analyzer produces HTML reports on the most frequent queries, slowest queries, queries by type select/insert/update/delete), and more.

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.