logo


1 vote
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.

Commenti Chi ha votato Links collegati