← Back to team overview

maria-discuss team mailing list archive

Re: I expected the same values for mariadb_config, mysql_config and my_print_defaults --mysqld

 

Hi, Guillermo!

On Jul 03, Guillermo Cespedes wrote:
> Hi,
> The values are not correct, they are even different, I expected the same values.
> See socket and version.

Version is identical in my 10.2.7 branch. I must've fixed it recently,
there were few related changes. In particular, mysql_config shows all
--libs now in 10.2.7.

mariadb_config and mysql_config show compile-time defaults, while
my_print_defaults only prints the contents of your my.cnf files.
As you can see, socket option is present in of your files, even in
two of them.

> # /usr/local/mysql/bin/mariadb_config
> 
> Copyright 2011-2015 MariaDB Corporation AB
> Get compiler flags for using the MariaDB Connector/C.
> Usage: mariadb_config [OPTIONS]
>   --cflags        [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/mysql]
>   --include       [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/mysql]
>   --libs          [-L/usr/local/mysql/lib/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto]
>   --libs_r        [-L/usr/local/mysql/lib/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto]
>   --libs_sys      [-lpthread -ldl -lm -lssl -lcrypto]
>   --version       [10.2.5]
>   --socket        [/tmp/mysql.sock]
>   --port          [3306]
>   --plugindir     [/usr/local/mysql/lib/plugin]
>   --tlsinfo       [OpenSSL 1.1.0f]
> 
> # /usr/local/mysql/bin/mysql_config 
> 
> Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
> Options:
>         --cflags         [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/.. ]
>         --include        [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/..]
>         --libs           [-L/usr/local/mysql/lib  -lmariadb]
>         --libs_r         [-L/usr/local/mysql/lib  -lmariadb]
>         --plugindir      [/usr/local/mysql/lib/plugin]
>         --socket         [/tmp/mysql.sock]
>         --port           [0]
>         --version        [10.2.6]
>         --libmysqld-libs [-L/usr/local/mysql/lib  -lmysqld -lpthread -lz -lm -ldl -lssl -lcrypto -lpcre -lcrypt -llz4 -laio]
>         --variable=VAR   VAR is one of:
>                 pkgincludedir [/usr/local/mysql/include/mysql]
>                 pkglibdir     [/usr/local/mysql/lib]
>                 plugindir     [/usr/local/mysql/lib/plugin]
> 
> 
> # my_print_defaults --mysqld
> 
> --port=3306
> --socket=/var/run/mysqld/mysqld.sock
> --skip-external-locking
> --key_buffer_size=16M
> --max_allowed_packet=1M
> --table_open_cache=64
> --sort_buffer_size=512K
> --net_buffer_length=8K
> --read_buffer_size=256K
> --read_rnd_buffer_size=512K
> --myisam_sort_buffer_size=8M
> --log-bin=mysql-bin
> --binlog_format=mixed
> --server-id=1
> --user=mysql
> --pid-file=/var/run/mysqld/mysqld.pid
> --socket=/var/run/mysqld/mysqld.sock
> --port=3306
> --basedir=/usr/local/mysql
> --datadir=/usr/local/mysql/data
> --tmpdir=/tmp
> --lc-messages-dir=/usr/local/mysql/share
> --skip-external-locking
> --bind-address=127.0.0.1
> --key_buffer=16M
> --max_allowed_packet=16M
> --thread_stack=192K
> --thread_cache_size=8
> --myisam-recover=BACKUP
> --query_cache_limit=1M
> --query_cache_size=16M
> --log_error=/var/log/mysql/error.log
> --expire_logs_days=10
> --max_binlog_size=100M
> 
> 
> 
> 
> Guillermo Céspedes
> Full Stack Developer
> 
> 
> 

> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

Regards,
Sergei
Chief Architect MariaDB
and security@xxxxxxxxxxx


Follow ups

References