← Back to team overview

maria-discuss team mailing list archive

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




Follow ups