Skip site navigation (1) Skip section navigation (2)

Re: Selects query stats?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Jim C(dot) Nasby <jnasby(at)pervasive(dot)com>
Cc: Robin Ericsson <lobbin(at)gmail(dot)com>, Dan Gorman <dgorman(at)hi5(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Selects query stats?
Date: 2006-05-30 03:52:35
Message-ID: cone.1148961155.527933.34675.1000@zoraida.natserv.net (view raw or flat)
Thread:
Lists: pgsql-performance
I am not sure if this is what the original poster was refering to, but I 
have used an application called mtop that shows how many queries per second 
mysql is doing.

In my case this is helpfull because we have a number of machines running 
postfix and each incoming mail generates about 7 queries. Queries are all 
very simmilar to each other in that scenario.

Having access to that query/second stat allowed me to improve the 
settings in MysQL. Ultimately once we migrated to a new server I could see 
how moving to the new machine increased the speed at which we could accept 
emails.

I am, little by little, getting PostgreSQL to be used, but for now the 
postfix queries are tied to MySQL. By the time we hopefully do move to 
PostgreSQL for the Postfix backend it will be very helpfull to have some 
sort of way to measure queries/time period. 


In response to

Responses

pgsql-performance by date

Next:From: Jonathan BlitzDate: 2006-05-30 09:35:55
Subject: Re: Adding and filling new column on big table
Previous:From: Francisco ReyesDate: 2006-05-30 03:22:36
Subject: Re: Adding and filling new column on big table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group