"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 <[email protected]>wrote: > 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:[email protected]] > *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 < > [email protected]> 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= > [email protected]] *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**** > > **** > > **** > > ** ** >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
