← 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, 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