Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:110156 Return-Path: Delivered-To: mailing list internals@lists.php.net Received: (qmail 61994 invoked from network); 14 May 2020 13:49:39 -0000 Received: from unknown (HELO php-smtp4.php.net) (45.112.84.5) by pb1.pair.com with SMTP; 14 May 2020 13:49:39 -0000 Received: from php-smtp4.php.net (localhost [127.0.0.1]) by php-smtp4.php.net (Postfix) with ESMTP id 1E2521804C9 for ; Thu, 14 May 2020 05:26:48 -0700 (PDT) X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on php-smtp4.php.net X-Spam-Level: X-Spam-Status: No, score=-2.1 required=5.0 tests=BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,FREEMAIL_FROM,HTML_MESSAGE, RCVD_IN_DNSWL_NONE,RCVD_IN_MSPIKE_H2,SPF_HELO_NONE,SPF_PASS autolearn=no autolearn_force=no version=3.4.2 X-Spam-ASN: AS15169 209.85.128.0/17 X-Spam-Virus: No X-Envelope-From: Received: from mail-ed1-f42.google.com (mail-ed1-f42.google.com [209.85.208.42]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by php-smtp4.php.net (Postfix) with ESMTPS for ; Thu, 14 May 2020 05:26:47 -0700 (PDT) Received: by mail-ed1-f42.google.com with SMTP id l3so2168456edq.13 for ; Thu, 14 May 2020 05:26:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=d7W5Sv3T7j1b9SnXxpMYMLuvCiOPbU+cM46WmeuW1F8=; b=c+/YxDc8DHDvpxFmx67t3P64FAn3VrRm0to8Wm+eAhGDpl6k6qBJ7ege6FV5V5Yq3r Y5vfVOG8h+YsIl8z4B+rP3zUVp6TppzTOy9FW61MEzzpYcs1oGDjQ8hPxwnk8pHoxVYg 2BLZ092jt+Se0KmO5S+z9VM0pdpufr4V7+Q6yid2wPugaWQh8ZKUYIf0BOg+FxpP3vxj YBHe14uOcVdhrwjtmcwSuMjMujxA8gUct5TWy7ZDuD+9lrp8mLsfoGjQP1dLRTQdsUWU reTUjBwjGUORNZngB1sPRfASKxZi+Pw/r6nLpFlFiYD3w7StShBjP0ndz1ZlljzRD410 BPtA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=d7W5Sv3T7j1b9SnXxpMYMLuvCiOPbU+cM46WmeuW1F8=; b=Ufa4dL5TOH0xCaV7l8/ftkkjhShxXs6JKrB1cEnsmj/Epu+ksjZGZqyJouOreBYm22 95xQR2xLBoDSWvAMKJroYiPsXYG6HIurH5evbJcDqylz0MFQ9WDZLkYU2mq4Jum6kT1i NM2s5chi7O4L7wbr3suNIZ5K2gyVA7N4IGYZm8bocMtrfqRxs0KmZRYilLdXmUeH93DA FftU5RJDNmO3EcFDUrKNUbhzr1oHFRurQJFXpn5hUdHNqhnuDmLNSUyFdgD+BIy9CviN 1yZHLbasnSdjNHBlvvYBm0E4W7x57jX4nHKijb681de3tw9sJ3GboeqUKMORSUHkLLYw WkVA== X-Gm-Message-State: AOAM5308brTZPXEcaCIEuOA5IC4gdpCZxaFENBCadA9FDdFjYmR1M4pq jyz89w1kKV6fdcgwxMlfXQjgTvhON8u6IYoiKnD/Nesc X-Google-Smtp-Source: ABdhPJyyEkrEnq26A68P5vOnRG/WUzLO9ZtPkuZR/OzjQQ/XkhV6s/yhWpCdgNSDH5KN387iGVT2TsrVGt7NMEaceBM= X-Received: by 2002:a05:6402:b4e:: with SMTP id bx14mr3787115edb.1.1589459203762; Thu, 14 May 2020 05:26:43 -0700 (PDT) MIME-Version: 1.0 Date: Thu, 14 May 2020 07:26:31 -0500 Message-ID: To: internals@lists.php.net Content-Type: multipart/alternative; boundary="00000000000039ae9b05a59acf68" Subject: Measuring database performance in MySQL From: tiffany.k.taylor@gmail.com (Tiffany Taylor) --00000000000039ae9b05a59acf68 Content-Type: text/plain; charset="UTF-8" Hi internals! I am currently working on an RFC draft to disable prepared statement emulation for MySQL by default. I understand this has been discussed previously[1][2], and one major concern is performance with reused statements if prepared statement emulation is disabled because of the extra round-trip. With MySQL 8.0, prepared statement reuse can be faster. My question: does anyone know of any code for testing database performance in PHP, that could be used to measure changes between older version of MySQL and newer versions? Thanks in advance, Tiffany Taylor [1] https://externals.io/message/60841 [2] https://externals.io/message/88018 --00000000000039ae9b05a59acf68--