Bradley Grainger
Bradley Grainger
The `CommandBehavior.SequentialAccess` flag is a hint to the ADO.NET library that rows should not be buffered in memory before being returned. This could reduce memory usage and improve performance for...
`MySqlDataSource` has methods to create connections and commands. It might be a performance enhancement (from creating less garbage) to pool and reuse these objects. Disposing a `MySqlConnection` or `MySqlCommand` would...
https://github.com/dotnet/EntityFramework.Docs/blob/main/entity-framework/core/what-is-new/ef-core-8.0/plan.md#aot-and-trimming-for-adonet > We will also work with the authors of other ADO.NET data providers to help make them AOT and trimming friendly. See https://learn.microsoft.com/en-us/dotnet/core/deploying/trimming/prepare-libraries-for-trimming for helpful information.
When MySqlConnector performs a connection reset, it also issues a `SET NAMES` statement (see https://github.com/mysql-net/MySqlConnector/issues/66) to work around https://bugs.mysql.com/bug.php?id=97633. MariaDB doesn't have this bug: https://jira.mariadb.org/browse/MDEV-18281. Although we currently have pipelining...
The MySqlSink code [uses `ExecuteNonQueryAsync`](https://github.com/saleem-mirza/serilog-sinks-mysql/blob/dev/src/Serilog.Sinks.MySQL/Sinks/MySQL/MySqlSink.cs#L140). It's a long-standing bug in MySql.Data ([bug 70111](https://bugs.mysql.com/bug.php?id=70111)) that async I/O is not implemented correctly; thus all these methods will actually run synchronously. (See also...
Fixes #7. Also makes a couple of minor improvements to the usage of the MySQL driver.
Based on [this code](https://pcg.di.unimi.it/predpcg64.c) linked from [this article](https://pcg.di.unimi.it/pcg.php), the internal state of `Pcg32Single` can be recovered (in just seconds) given three successive values from `Pcg32Single.GenerateNext`. (Note that this uses reflection...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html: > The unused `INFORMATION_SCHEMA.TABLESPACES` table, deprecated in MySQL 8.0.22, has now been removed. Remove support for this schema from MySqlConnector.
From @Kation: Same issues with 2.2.5 ``` at MySqlConnector.MySqlConnection.SetActiveReader(MySqlDataReader dataReader) in /_/src/MySqlConnector/MySqlConnection.cs:line 884 at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken)...
Since there can only be one active `MySqlDataReader` per `MySqlConnection`, we could create just one instance and recycle it when it's disposed. This could allow a user to start using...