Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:93118 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 34483 invoked from network); 8 May 2016 19:28:48 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 8 May 2016 19:28:48 -0000 Authentication-Results: pb1.pair.com smtp.mail=zeev@zend.com; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=zeev@zend.com; sender-id=pass Received-SPF: pass (pb1.pair.com: domain zend.com designates 157.56.110.145 as permitted sender) X-PHP-List-Original-Sender: zeev@zend.com X-Host-Fingerprint: 157.56.110.145 mail-bn1on0145.outbound.protection.outlook.com Received: from [157.56.110.145] ([157.56.110.145:44864] helo=na01-bn1-obe.outbound.protection.outlook.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 0F/A4-04420-E639F275 for ; Sun, 08 May 2016 15:28:47 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=RWSoftware.onmicrosoft.com; s=selector1-zend-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=CHHvpjHg9VhaB6OTn9m1bvlLzZ/FK1LmSHmIiX5n5O0=; b=Xab1VyR7opJXHFb154GN6F3GkZSGrmBJAdNJEqe9lMTgamPVlbnazsJxPKHFU+OMVy0zWnYiMIXMSXy5kAFyDF1PxNv+STDFsluOYKO8lz5OQnlL+RYJ34g1NWbk15amlMhyjBIxYuGzNAa6LL9YV2p2QlnSBSRNZXj/aY1KKKs= Received: from BY2PR02MB298.namprd02.prod.outlook.com (10.141.140.21) by BY2PR02MB298.namprd02.prod.outlook.com (10.141.140.21) with Microsoft SMTP Server (TLS) id 15.1.485.9; Sun, 8 May 2016 19:28:42 +0000 Received: from BY2PR02MB298.namprd02.prod.outlook.com ([10.141.140.21]) by BY2PR02MB298.namprd02.prod.outlook.com ([10.141.140.21]) with mapi id 15.01.0485.016; Sun, 8 May 2016 19:28:42 +0000 To: Raja Kulasekaran CC: "internals@lists.php.net" Thread-Topic: [PHP-DEV] How to get trace of all database queries executed by php Thread-Index: AQHRp+/suaWZXJifVESSF9C7cAWSIp+vb8ha Date: Sun, 8 May 2016 19:28:41 +0000 Message-ID: <66196212-9E54-45D5-BBA4-B7AF46A7C3F5@zend.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=zend.com; x-originating-ip: [77.127.110.61] x-ms-office365-filtering-correlation-id: b7575267-692c-4b68-a607-08d37776f6f7 x-microsoft-exchange-diagnostics: 1;BY2PR02MB298;5:4rJjkuA0X+22xr5thJ5rW45B3mqKfwt1qoPl9Qui8l6Oh/OnjElf/1d5G7Ej4tDgXrV1xKjZnJFtDbUILttsdj7FujcCx9cxETi8SdQAUJe7tMOO0zTNElFIFguxSbzJDXWmqe7aYvo8BFtaH/jtzQ==;24:9a6aiwS576HzyOg6D+0V+WMVh6z2Zts5I6Gbfq6hXDw9hZj3P7dJr6LfWEl8mdaiHeXArGe+KPJN1S3lAnpxUwMU2YLNprdem0P0CtAFyxM=;7:7HlNKN045iojRfZgDNLT6m4z4xQcsrFCuIbiUH/QV22Y4TJ1eXLCfFihWv1EVRTgcWE5FR4y5qv2yvBihCUn+RGe7OOlK71Yrz0L7CNgjDdavRrC2DL7lWvP0XqM5yoE5iPsxc+LJAAJc6AU1b3dw81eL3rKWyphKQA5KBw4Yp6CQ7EALDIuA7/E0IIIzodv x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BY2PR02MB298; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(601004)(2401047)(5005006)(8121501046)(3002001)(10201501046);SRVR:BY2PR02MB298;BCL:0;PCL:0;RULEID:;SRVR:BY2PR02MB298; x-forefront-prvs: 09368DB063 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(6009001)(24454002)(9170700001)(66066001)(33656002)(11100500001)(586003)(3280700002)(10400500002)(5008740100001)(5004730100002)(189998001)(5002640100001)(19580405001)(8936002)(19580395003)(4326007)(122556002)(1411001)(83716003)(2950100001)(110136002)(82746002)(87936001)(92566002)(2900100001)(86362001)(1220700001)(3660700001)(36756003)(6116002)(3846002)(102836003)(77096005)(76176999)(50986999)(81166005)(2906002)(54356999)(493534005)(104396002);DIR:OUT;SFP:1102;SCL:1;SRVR:BY2PR02MB298;H:BY2PR02MB298.namprd02.prod.outlook.com;FPR:;SPF:None;MLV:sfv;LANG:en; spamdiagnosticoutput: 1:23 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="iso-8859-8-i" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: zend.com X-MS-Exchange-CrossTenant-originalarrivaltime: 08 May 2016 19:28:42.0143 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 32210298-c08b-4829-8097-6b12c025a892 X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY2PR02MB298 Subject: Re: [PHP-DEV] How to get trace of all database queries executed by php From: zeev@zend.com (Zeev Suraski) > On 7 =E1=EE=E0=E9 2016, at 2:35, Raja Kulasekaran wro= te: >=20 > Hi, >=20 > Sorry If I am asking this question in irrelevent forum. > Please suggest me the point of direction if not. >=20 > I have encrypted php Application codebase which I may or may not have > access. >=20 > So, I would like to know how the application behaving / profiling Databas= e > queries through the .so or .dll level . >=20 > Is there any php extension available which help me out to give the > statistics of > all the queries execution details ? bit.ly/zraysa - you'd never want to look at database logs again! No PHP 7 = version yet but we should have that sometime soon. (and everyone right, it's not the right list :) Zeev