Check compiled in options to mysql binary

[csross]

How do I find out what options were compiled into the binary versions of mysql? Also, is there a way to see what options were compiled when a binary was manually created with configure/make/make install. Is there a query you can do on the daemon?

Thanks

 

[TonyGroves]

The server options can be listed with: SHOW GLOBAL VARIABLES

This will show the current values of the options; they will be the same as the defaults except for those that have been overridden at server startup or altered at runtime.

I hope that's some help.

 

[csross]

I ran it and of course it overflows so I cannot see all the options. But I would like what was used in the ./configure statement before the make. Is that what this showss?

How can I get it to show more than one page of items?

Thanks

 

[TonyGroves]

If you use a GUI client like MySQL Control Centre, you can inspect the output at your leisure.

Alternatively, you could direct the output to a file, and inspect it with a text editor or spreadsheet program. For example (on Windows):
[tt]c:\mysql\bin> [/tt][tt]mysql >c:\temp\mysql.csv[/tt]
You won't see any welcome message, but you can then enter your queries, and the output will be sent to the file.

I'm afraid I don't know much about the compilation process; I use only pre-compiled binaries. Maybe somebody else can help here.