From: Date: August 13 2007 1:42pm
Subject: Re: profiling question
List-Archive: http://lists.mysql.com/internals/34949
Message-Id: <01348487-48A7-4F73-AEDB-E7B45CB4A22E@mysql.com>
MIME-Version: 1.0 (Apple Message framework v752.3)
Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg=pgp-sha1; boundary="Apple-Mail-1-392255301"
Content-Transfer-Encoding: 7bit

--Apple-Mail-1-392255301
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed


On 12 Aug 2007, at 12:26, Vangelis Katsikaros wrote:
> In http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
> "profiling" and "profiling_history_size" variables are noted as  
> session variables, which is also mentioned in
> http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html
>
> However profiling_history_size can be set from the my.cnf file  
> where as
> profiling can't. Also from mysql command line it is possible to do ie
> SET GLOBAL profiling_history_size=10;
>
> So is profiling_history_size session but handled like global or simply
> hasn't been updated in the docs?

The session's history-size is set from the global size when the  
session is created.  You may think of it as a default value.

> Also I would like to ask if there is a reason for not having  
> profiling as global variable.

Yes, it's intentional.

Profiling is expensive, and it should never be left on.  This is a  
safeguard against our users who don't read the manual.

Furthermore, profiling data is session-specific.  Outside of a  
session, there's no way to access the profiling data.  Thus, it  
doesn't make sense to enable profiling from outside, when one can't  
access it from outside.

Now, it would be nice to create a way to write "remote" profiling  
data to a table.  Say, I'm in connection 23 and I want profiling data  
on connection 42 (or some expression that describes the session), it  
would be nice to turn on profiling and write its results to a  
particular table that I name.  I invite that feature to be implemented.

- chad

--
Chad Miller, Software Developer                         chad@stripped
MySQL Inc., www.mysql.com
Orlando, Florida, USA                                13-20z,  UTC-0400
Office: +1 408 213 6740                         sip:6740@stripped



--Apple-Mail-1-392255301
content-type: application/pgp-signature; x-mac-type=70674453;
	name=PGP.sig
content-description: This is a digitally signed message part
content-disposition: inline; filename=PGP.sig
content-transfer-encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (Darwin)

iD8DBQFGwEO5/peCpMTxrLsRAqHcAJ4le4mZlNn9WjgS/U94fXNOQdksSwCeM0zS
KVrGg7miFIEdReq81eyrAkU=
=amdo
-----END PGP SIGNATURE-----

--Apple-Mail-1-392255301--