"I rarely find myself in need to use my.ini for clients". Not me either
except for max_allowed_packet (what is implemented in both server and
client) that user want to set to INSERT table rows with photographs (.jpg's
typically) to a table.
And the 'mysql' command line client has a default max_allowed_packet of 1MB
(in the server it was raised to 4MB in MySQL 5.6 - and if I remember right
it is 8MB in recent MariaDB - but I belive the client setting is still 1MB
even in MySQL 5.6 - I have not checked though).
In contrast the C-API (both Oracle's and MariaDB's) has a defaut of 1GB
(not sure about other connectors - such as JAVA and .NET). But I am not
aware of any GUI client compiling/linking the connector with client
max_allowed_packet lowered from 1GB (the highest possible value the
protocol allows for currently).
-- Peter
On Fri, Sep 27, 2013 at 8:19 PM, Vladislav Vaintroub
Current directory does not play any role in choosing defaults file. You indeed need either to specify –defauilts-file, or set MYSQL_HOME, or the bdefault logic of finding my.ini will apply ****
On the other hand, I rarely find myself in need to use my.ini for clients. In doubt, I provide –port , and that’s all I need for the command line clients****
** **
*From:* Peter Laursen [mailto:peter_laursen@webyog.com] *Sent:* Freitag, 27. September 2013 19:15 *To:* Vladislav Vaintroub *Cc:* Maria Developers; Maria Discuss *Subject:* Re: [Maria-developers] MySQL bug affects mariaDB****
** **
Thanks wlad for explanation, but this applies to 'shortcuts' (in start menu) only I think, as I understand your reply. ****
** **
If I navigate ('cd ..') to the /datadir where my.ini resides and launch 'mysql' from commnd line I will need to specify --defaults-file on the command line, right? If not the client will start with defaults (or it will use whatever other my.ini it finds in C:\, C:\Windows or /basedir).****
** **
?****
** **
** **
-- Peter****
** **
On Fri, Sep 27, 2013 at 7:06 PM, Vladislav Vaintroub < wlad@montyprogram.com> wrote:****
The command line clients are not services, and they are not started with --defaults-file, this is correct.****
****
But****
****
1.We install shortcut to mysql client and shortcut does have --defaults-file , and the default-file points to the right place, i.e whenever you installed the mysql server instance****
On my machine (I used the default x64 installation), MySQL client shortcut is this****
****
C:\Windows\System32\cmd.exe /k " "C:\Program Files\MariaDB 5.5\bin\mysql.exe" "--defaults-file=C:\Program Files\MariaDB 5.5\data\my.ini" -uroot -p"”****
****
2. Out installation also provides another shortcut – called Command Prompt( MariaDB …)****
It could be used to call arbitrary client utilities, mysqladmin or somesuch .It uses yet another, less known, trick to force client utilities to look for correct my.ini - it sets environment variable MYSQL_HOME to point to the the datadir ( Besides, it also sets PATH to include “bin” directory, so that calling mysqladmin or mysql would not result in “path not found”)****
****
The inspiration for this shortcut was a very similar feature of Visual Studio , the “Visual Studio 20xx Command Line”.****
****
The summary of my.ini client-side support is that :****
If you install with MSI, installer will create shortcuts that help client utilities to find correct my.ini . You can have multiple versions of the MariaDB installed, and the shortcuts will still work correctly – every version specific shortcut would point to version-specific my.ini****
****
Thus, I’d argue that this bug does not affect MariaDB.****
****
****
****
*From:* Maria-developers [mailto:maria-developers-bounces+wlad= montyprogram.com@lists.launchpad.net] *On Behalf Of *Peter Laursen *Sent:* Freitag, 27. September 2013 10:06 *To:* Maria Developers; Maria Discuss *Subject:* [Maria-developers] MySQL bug affects mariaDB****
****
****
I think the 'mysql' client with MariaDB has a similar problem as it has with MySQL - refer?****
http://bugs.mysql.com/bug.php?id=70443****
****
MariaDB installer installs my.ini to /datadir - what with MariaDB is a subfolder to /basedir. ****
****
The server will look for it correctly as the registry key defining the service has a --default-file specification. But the command line clients don't read the registry key.****
****
****
@Wlad?****
****
****
-- Peter****
-- Webyog****
****
****
** **