Home / server / Questions / 394091
Accepted
chrisjlee
Asked: 2012-05-31 10:50:01 +0800 CST

figure out mysql ini settings via command line

  • 772

For php there is php -i. For apache i can debug settings with apachectl -S.

Is there a way for me to output via command line what the current "sourced" settings for mysql are?

I'm trying to figure out if i correctly set my innodb poolsize.

mysql

2 Answers

  1. Best Answer

    You can query it from the command line with an account that has enough privileges.

    mysql -u root -p -e "show variables;"
mysql -u root -p -e "show variables like '%innodb%';"
mysql -u root -p -e "show variables like 'innodb_buffer_pool_size';"
    • 2

  2. I think you will be pleased with either of these commands:

    mysqld --verbose --help
    or mysqladmin variables

    • 0