maria-discuss team mailing list archive

[Michal Schorm <mschorm@xxxxxxxxxx>]

Hi Daniel and thanks for a reply!

I'll parse the mail you send a little:


*1) Move "mysqldump, mysqlbinlog, mysqlcheck, mysql_upgrade" and their
manpages to dependent package.* * I'm really not going to make another
subpackage only with them, but I can easily move them back to subpackages
where they were.
 * But Why ?? (I don't see the point. The idea is, that when you really
need them, you can install them on the server, use them and remove again,
since they would be used verry little. ) Please explan, what did you meant.

*2) https://jira.mariadb.org/browse/MDEV-10646
<https://jira.mariadb.org/browse/MDEV-10646>*
* I'm deffinitelly gonna wait for the upstream. I don't see really the
urgence of this issue and it is elementarly solved by config file change.

*3) /usr/libexec/mysql-scripts-common includes mysqld_safe as a section,
however this isn't read by the systemd invocation of mysqld*
* I'll  check it, test it, eventualy file the bugs to start appropriate
processes.

*4) /usr/share/mariadb/my-* - recommend dropping these.*

recommendations:
>
> /usr/share/mariadb/my-* - recommend dropping these. "huge" isn't really
> a myisam configuration or an innodb with a 384M buffer pool. Other files
> are equally as comicly harmful. Getting users to actually read rather
> than these wild ass guesses as config files will save them much pain.
>





On Mon, Jan 30, 2017 at 3:04 AM, Daniel Black <daniel.black@xxxxxxxxxxx>
wrote:

>
>
> On 27/01/17 22:58, Michal Schorm wrote:
> > Hello everybody,
> >
> > I made a (form my POV) bigger change to how MariaDB is packed, and I
> > would be grateful for any feedback.
>
> Thanks for continuing with this.
>
> > I separated all the non-essential utilities to a standalone sub-package
> > "server-utils".
> > It should be installed automaticly with the "server" package as a weak
> > dendency, so regular user should not spot any change.
>
> Good. If every it becomes a non-dependency the following should be moved
> to a dependent package:
>
> /usr/bin/mysqldump  /usr/bin/mysqlbinlog /usr/bin/mysqlcheck
> mysql_upgrade and associated man pages.
>
> > Rawhide:
> > https://koji.fedoraproject.org/koji/taskinfo?taskID=17426872
> > F25:
> > https://bodhi.fedoraproject.org/updates/FEDORA-2017-0f44f2b8c8
> > F24:
> > https://bodhi.fedoraproject.org/updates/FEDORA-2017-801e01d1ed
> >
>
>
> questions/comments:
>
> on the systemd settings:
>
> ExecStopPost=/usr/libexec/mysql-wait-stop seems to just wait for pid, in
> the case of Type=notify I thought this wasn't needed.
>
> MDEV-10646, https://github.com/MariaDB/server/pull/297 should be an easy
> fix.
>
> https://github.com/MariaDB/server/blob/10.1/support-
> files/mariadb.service.in
> has been updated a bit more to support added constraints and better
> support for galera configurations.
>
> errors:
>
> /usr/libexec/mysql-scripts-common includes mysqld_safe as a section
> however this isn't read by the systemd invocation of mysqld.
>
> Running mysql (the client program) with these packages fails to find the
> server socket.
>
> strace of mysql sees and attempt to connect to a null string socket
> socket(AF_UNIX, SOCK_STREAM, 0)         = 3
> connect(3, {sa_family=AF_UNIX,
> sun_path=@"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
> 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
> 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
> 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"},
> 110) = -1 ECONNREFUSED (Connection refused)
>
> There seems to be a lack of compile time to support the default of
> /var/lib/mysql/mysql.sock
>
> To be prudent, and to support other mysql client programs, including
> socket=/var/lib/mysql/mysql.sock in a [client] section of a config file
> is recommended.
>
>
> recommendations:
>
> /usr/share/mariadb/my-* - recommend dropping these. "huge" isn't really
> a myisam configuration or an innodb with a 384M buffer pool. Other files
> are equally as comicly harmful. Getting users to actually read rather
> than these wild ass guesses as config files will save them much pain.
>
>
> https://jira.mariadb.org/browse/MDEV-11869 might contains some insights
> to systemd settings/packaging too.
>
>  dnf list installed | grep -i mariadb
> mariadb.x86_64                        3:10.1.21-1.fc24
> @updates-testing
> mariadb-common.x86_64                 3:10.1.21-1.fc24
> @updates-testing
> mariadb-config.x86_64                 3:10.1.21-1.fc24
> @updates-testing
> mariadb-errmsg.x86_64                 3:10.1.21-1.fc24
> @updates-testing
> mariadb-libs.x86_64                   3:10.1.21-1.fc24
> @updates-testing
> mariadb-server.x86_64                 3:10.1.21-1.fc24
> @updates-testing
> mariadb-server-utils.x86_64           3:10.1.21-1.fc24
> @updates-testing
>
>


-- 

Michal Schorm
Core Services - Databases Team
mail: mschorm@xxxxxxxxxx
Brno-IRC: mschorm