In most cases you should manage mysqld options through option files.
mysqld and mysqld.server reads options from the mysqld and server groups. mysqld_ safe read options from the mysqld, server, mysqld_safe and safe_mysqld groups.
An embedded MySQL server usually reads options from the server, embedded and xxxxx_ SERVER, where xxxxx is the name of the application.
mysqld accepts the following command-line options:
--ansi Use ANSI SQL syntax instead of MySQL syntax.
-b, --basedir=path
Path to installation directory. All paths are usually resolved relative to this.
--big-tables
Allow big result sets by saving all temporary sets on file. It solves most ’table full’ errors, but also slows down the queries where in-memory tables would su ce. MySQL is able to solve it automatically by using memory for small temporary tables and switching to disk tables where necessary.