mysql_embedded
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.4.6
From MariaDB 10.4.6, mariadb-embedded
is a symlink to mysql_embedded
, the tool for examining the slow query log.
MariaDB starting with 10.5.2
From MariaDB 10.5.2, mariadb-embedded
is the name of the tool, with mysql_embedded
a symlink.
mysql_embedded
is a mysql client statically linked to libmysqld, the embedded server. Upon execution, an embedded MariaDB server is instantiated and you can execute statements just as you would using the normal mysql client, using the same options.
Do not run mysql_embedded while MariaDB is running, as effectively it starts a new instance of the server.
Examples
sudo mysql_embedded -e 'select user, host, password from mysql.user where user="root"' +------+-----------+-------------------------------------------+ | user | host | password | +------+-----------+-------------------------------------------+ | root | localhost | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | db1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | 127.0.0.1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | ::1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | +------+-----------+-------------------------------------------+
Sending options with --server-arg
:
sudo mysql_embedded --server-arg='--skip-innodb' --server-arg='--default-storage-engine=myisam' --server-arg='--log-error=/tmp/mysql.err' -e 'select user, host, password from mysql.user where user="root"' +------+-----------+-------------------------------------------+ | user | host | password | +------+-----------+-------------------------------------------+ | root | localhost | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | db1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | 127.0.0.1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | ::1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | +------+-----------+-------------------------------------------+
See Also
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.