as shown here http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html >=mysql-5.0.37 supports this query profiling which can help in query performance tunning, but it's not a available. Reproducible: Always Steps to Reproduce: 1. mysql -uroot -p 2. mysql> set profiling=1; Actual Results: ERROR 1193 (HY000): Unknown system variable 'profiling' Expected Results: Query OK, 0 rows affected (0.00 sec) Portage 2.1.3_rc9 (default-linux/x86/2006.1, gcc-4.2.0, glibc-2.6-r0, 2.6.20.1 i686) ================================================================= System uname: 2.6.20.1 i686 AMD Sempron(tm) Processor 3100+ Gentoo Base System release 1.12.10 Timestamp of tree: Fri, 03 Aug 2007 08:50:01 +0000 distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) [disabled] dev-lang/python: 2.4.4-r4 dev-python/pycrypto: 2.0.1-r6 sys-apps/sandbox: 1.2.18.1 sys-devel/autoconf: 2.13, 2.61-r1 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10 sys-devel/binutils: 2.17-r1 sys-devel/gcc-config: 1.3.16 sys-devel/libtool: 1.5.24 virtual/os-headers: 2.6.22-r2 ACCEPT_KEYWORDS="x86 ~x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -march=athlon-xp -pipe -ftracer -ftree-vectorize" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-O2 -march=athlon-xp -pipe -ftracer -ftree-vectorize -fvisibility-inlines-hidden" DISTDIR="/usr/portage/distfiles" FEATURES="candy distlocks metadata-transfer parallel-fetch sandbox sfperms strict unmerge-orphans userpriv usersandbox" GENTOO_MIRRORS="http://mirror.datapipe.net/gentoo/distfiles http://distfiles.gentoo.org" LDFLAGS="-Wl,-O1 -Wl,--sort-common -Wl,--warn-once" LINGUAS="en" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/portage/local/layman/puboverlay /usr/portage/local/layman/webapps-experimental /usr/portage/local/layman/php-experimental /usr/local/portage" SYNC="rsync://rsync.namerica.gentoo.org/gentoo-portage"
This needs the '--enable-community-features' compile flag
They are in community only, not the main dev-db/mysql.
InCVS.