maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #04677
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