No, I just get an error using the MariaDB Connecter/ODBC driver. It keeps crashing out with the "max_allowed_packet_size" not found. Note that it DOES have the "_size" part in the error, but there is no system variable by that name only the "max_allowed_packet" variable which I've left as the default.
When I look in the log file, I see it's trying to set the "max_allowed_packet_size=4096" and then "Quit".
Fred
On Tue, Mar 15, 2016 at 4:58 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2016-03-15 15:48, Fred Taylor wrote:
I do have several .INI file in the main folder where MariaDB is installed, but I'm not specifying any of them. Their names are: my-huge.ini my-innodb-heavy-4G.ini my-large.ini my-medium.ini my-small.ini wsrep.ini
I would guess there is a default file that is used, but those are the only .ini files I see.
In the data folder there is a my.ini file: [mysqld] datadir=C:/Program Files/MariaDB 10.1/data port=3306 sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" default_storage_engine=innodb innodb_buffer_pool_size=405M innodb_log_file_size=50M [client] port=3306
Should I add the max_allowed_packet entry to the [mysqld] section that matches the setting (419304) I see in Heidi-SQL?
I should really read all these replies before I reply. Ugh.
Are you trying to use something beyond 1024?
[excessive quoting removed by server]