I would like to test how many requests/sec mariadb can process to authenticate users. So I need to be able to test how many cycles I can do of connecting to mariadb, executing the password sql statement and closing the connection. Anyone know what tool I can use for this?
This isn't so easy, mostly because you will running out of ephemeral port: Each closed port has a delay time before being re-used for another new connection, so just creating and releasing a connection, the delay time is too short, as the result you'll run out of ephemeral port very quickly. So you will only be able to run very short benchmarks. On Fri, Apr 26, 2024 at 6:13 PM Marc via discuss <discuss@lists.mariadb.org> wrote:
I would like to test how many requests/sec mariadb can process to authenticate users. So I need to be able to test how many cycles I can do of connecting to mariadb, executing the password sql statement and closing the connection.
Anyone know what tool I can use for this? _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
-- Diego Dupin, Connector team
Just if you're wondering, this is only TCP/IP behavior, not something specific to mariadb On Fri, Apr 26, 2024 at 6:24 PM Diego Dupin <diego.dupin@mariadb.com> wrote:
This isn't so easy, mostly because you will running out of ephemeral port: Each closed port has a delay time before being re-used for another new connection, so just creating and releasing a connection, the delay time is too short, as the result you'll run out of ephemeral port very quickly. So you will only be able to run very short benchmarks.
On Fri, Apr 26, 2024 at 6:13 PM Marc via discuss < discuss@lists.mariadb.org> wrote:
I would like to test how many requests/sec mariadb can process to authenticate users. So I need to be able to test how many cycles I can do of connecting to mariadb, executing the password sql statement and closing the connection.
Anyone know what tool I can use for this? _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
-- Diego Dupin, Connector team
-- Diego Dupin, Connector team
Yes indeed, I think that is probably why I see so many similar results in the range of 100 - 200 req/sec.
Just if you're wondering, this is only TCP/IP behavior, not something specific to mariadb
On Fri, Apr 26, 2024 at 6:24 PM Diego Dupin <diego.dupin@mariadb.com <mailto:diego.dupin@mariadb.com> > wrote:
This isn't so easy, mostly because you will running out of ephemeral port: Each closed port has a delay time before being re-used for another new connection, so just creating and releasing a connection, the delay time is too short, as the result you'll run out of ephemeral port very quickly. So you will only be able to run very short benchmarks.
On Fri, Apr 26, 2024 at 6:13 PM Marc via discuss <discuss@lists.mariadb.org <mailto:discuss@lists.mariadb.org> > wrote:
I would like to test how many requests/sec mariadb can process to authenticate users. So I need to be able to test how many cycles I can do of connecting to mariadb, executing the password sql statement and closing the connection.
Anyone know what tool I can use for this? _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org <mailto:discuss@lists.mariadb.org> To unsubscribe send an email to discuss- leave@lists.mariadb.org <mailto:discuss-leave@lists.mariadb.org>
--
Diego Dupin, Connector team
--
Diego Dupin, Connector team
participants (2)
-
Diego Dupin -
Marc