[Maria-discuss] I expected the same values for mariadb_config, mysql_config and my_print_defaults --mysqld
Hi, The values are not correct, they are even different, I expected the same values. See socket and version. # /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
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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Regards, Sergei Chief Architect MariaDB and security@mariadb.org
Hi, thanks for the info. Regards. Guillermo Céspedes Full Stack Developer
El 4 jul. 2017, a las 14:44, Sergei Golubchik <serg@mariadb.org> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Regards, Sergei Chief Architect MariaDB and security@mariadb.org
participants (2)
-
Guillermo Cespedes -
Sergei Golubchik