maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #04678
Re: I expected the same values for mariadb_config, mysql_config and my_print_defaults --mysqld
Hi, thanks for the info.
Regards.
Guillermo Céspedes
Full Stack Developer
> El 4 jul. 2017, a las 14:44, Sergei Golubchik <serg@xxxxxxxxxxx> escribió:
>
> 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
References