mysql_51
(1)
Name
mysql_51 - MySQL RDBMS version 5.1 for Solaris
Synopsis
Please see following description for synopsis
Description
SunOS 5.11 1
User Commands mysql_51(1)
NAME
MySQL 5.1 - MySQL RDBMS version 5.1 for Solaris
DESCRIPTION
MySQL version 5.1 for Solaris is delivered in the following
3 packages:
+--------------------------+---------------------------------------+
| Package | Contents |
+--------------------------+---------------------------------------+
| database/mysql-51 | MySQL 5.1 Server package |
+--------------------------+---------------------------------------+
|database/mysql-51/library | MySQL 5.1 lib package (lib component) |
+--------------------------+---------------------------------------+
| database/mysql-51/tests | MySQL 5.1 test package |
+--------------------------+---------------------------------------+
The MySQL 5.1 software for Solaris is installed into a num-
ber of sub-directories of /usr/mysql/5.1.
The database/mysql-51 package installs the following direc-
tories:
+------------------------+----------------------------------+
| Directory | Contents |
+------------------------+----------------------------------+
| /usr/mysql/5.1/bin | Binaries and Scripts |
+------------------------+----------------------------------+
|/usr/mysql/5.1/include | Development header files |
+------------------------+----------------------------------+
|/usr/mysql/5.1/man/man1 | Manual pages for client programs |
+------------------------+----------------------------------+
|/usr/mysql/5.1/man/man8 | Manual pages for server programs |
+------------------------+----------------------------------+
| /usr/mysql/5.1/share | Shared data:locale,timezone |
+------------------------+----------------------------------+
| /usr/mysql/5.1/docs | HTML documentation |
| | |
+------------------------+----------------------------------+
The database/mysql-51 package also installs the following
64-bit directories
o /usr/mysql/5.1/bin/64 - 64-bit Binaries and scripts
o
The following directories are additionally created by data-
base/mysql-51 package
SunOS 5.11 Last change: 1
User Commands mysql_51(1)
+--------------------+---------------------------------+
| Directory | Contents |
+--------------------+---------------------------------+
|/var/mysql/5.1/data | Default database data directory |
+--------------------+---------------------------------+
| /etc/mysql/5.1 | Configuration file location |
| | |
+--------------------+---------------------------------+
The database/mysql-51 package also installs the following
SMF files to facilitate automatic service management (refer
to smf(5) and the SMF section below):
/lib/svc/manifest/application/database/mysql_51.xml
/lib/svc/method/mysql_51
The database/mysql-51/tests package creates the following
directories:
+--------------------------+---------------------+
| Directory | Contents |
+--------------------------+---------------------+
|/usr/mysql/5.1/mysql-test | MySQL test programs |
+--------------------------+---------------------+
|/usr/mysql/5.1/sql-bench | SQL Benchmark test |
| | |
+--------------------------+---------------------+
The database/mysql-51/library package contains the
libraries for client API:
+----------------------+----------------------------------+
| Directory | Contents |
+----------------------+----------------------------------+
| /usr/mysql/5.1/lib | Libraries for client API |
+----------------------+----------------------------------+
|/usr/mysql/5.1/lib/64 | 64-bit Libraries for client API |
| | |
+----------------------+----------------------------------+
DTrace SUPPORT for MySQL SERVER
MySQL 5.1 provides for the DTrace support at the time of the
mysql server startup. MySQL server registers the probes for
the provider mysql.
Probes that are used at the time of creating and closing of
client connection are
probe connection-start();
probe connection-done();
Probes that fire at the start/end of any client command pro-
cessing (including SQL queries)
SunOS 5.11 Last change: 2
User Commands mysql_51(1)
probe command-start();
probe command-done();
Probes that fire at the start/end of any SQL query process-
ing.
probe query-start();
probe query-done();
Probes that fire at the start/end of SQL query parsing
probe query-parse-start();
probe query-parse-done();
Probes that track whether the query hits the query cache or
not
probe query-cache-hit();
probe query-cache-miss();
Probes that fire when the actual query exectuion start,ie
after parsing and checking the query cache, but before priv-
ilege checks,optimizing etc.
probe query-exec-start();
probe query-exec-done();
Probes that are used to perform to write operations towards
any handler are as listed below
probe insert-row-start();
probe insert-row-done();
probe update-row-start();
probe update-row-done();
probe delete-row-start();
probe delete-row-done();
probe is activated when calling external_lock for any han-
dler depending on the lock type being acquired or released
SunOS 5.11 Last change: 3
User Commands mysql_51(1)
probe handler-rdlock-start();
probe handler-rdlock-done();
probe handler-wlock-start();
probe handler-wrlock-done();
probe handler-unlock-start();
probe handler-unlock-done();
probes are activated when a filesort activity happens in a
query
probe filesort-start();
probe filesort-end();
The query types SELECT, INSERT, INSERT AS SELECT, UPDATE,
UPDATE with multiple tables, DELETE, DELETE with multiple
tables are all probed. The start probe always contains the
query text
probe select-start(char *query);
probe select-done();
probe insert-start(char *query);
probe insert-end();
probe insert-select-start(char *query);
probe insert-select-done();
probe update-start(char *query);
probe update-done();
probe multi-update-start(char *query);
probe multi-update-done();
probe delete-start(char *query);
probe delete-done();
probe multi-delete-start(char *query);
probe multi-delete-done();
These probes are used to measure the time waiting for net-
work traffic or identify network-related problems
probe net-read-start();
probe net-read-done();
probe net-write-start();
probe net-write-done();
AUTOMATIC SERVICE MANAGEMENT (SMF)
MySQL 5.1 for Solaris includes files necessary to register
with the service management facility described in smf(5).
SunOS 5.11 Last change: 4
User Commands mysql_51(1)
After installation of the database/mysql-51 package, regis-
ter the MySQL service as under:
example%svccfg import
/lib/svc/manifest/application/database/mysql_51.xml
The mysql:version_51 service is disabled by default. You can
check the status of the service by issuing the following
command :
example% svcs mysql
STATE STIME FMRI
disabled 14:27:09 svc:/application/database/mysql:version_51
Enable the mysql:version_51 service by issuing the following
command :
example%svcadm enable mysql:version_51
The state of the service instance should change to "online",
and the database server should be started :
example% svcs mysql
STATE STIME FMRI
online 14:30:08 svc:/application/database/mysql:version_51
The 32-bit MySQL daemon runs by default. To start the 64-bit
server, execute the following commands:
%svccfg
svc>select mysql:version_51
svc:/application/database/mysql:version_51>listprop
mysql/enable_64bit
mysql/enable_64bit boolean false
svc:/application/database/mysql:version_51>setprop
mysql/enable_64bit=true
svc:/application/database/mysql:version_51>listprop
mysql/enable_64bit
SunOS 5.11 Last change: 5
User Commands mysql_51(1)
mysql/enable_64bit boolean true
svc:/application/database/mysql:version_51>quit
%svcadm refresh mysql:version_51
%svcadm enable mysql:version_51
The 64-bit server is initiated.
STATE STIME FMRI
online 15.10:08 svc:/application/database/mysql:version_51
Note -
By default, the mysql/enable_64bit property is set to
False. Set it True to start the 64-bit server.
To shutdown the database instance and prevent automatic
restart (for example during scheduled downtime for mainte-
nance), disable the SMF service by running:
example% svcadm disable mysql:version_51
example% svcs mysql
STATE STIME FMRI
disabled 14:30:08 svc:/application/database/mysql:version_51
REFERENCES
http://www.mysql.com
ATTRIBUTES
See attributes(5) for descriptions of the following
attributes:
SunOS 5.11 Last change: 6
User Commands mysql_51(1)
+---------------+-------------------+
|ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+---------------+-------------------+
|Availability | database/mysql-51 |
+---------------+-------------------+
|Stability | Uncommitted |
+---------------+-------------------+
NOTES
This software was built from source available at
https://java.net/projects/solaris-userland. The original
community source was downloaded from http://down-
loads.mysql.com/archives/mysql-5.1/mysql-5.1.37.tar.gz
Further information about this software can be found on the
open source community website at http://dev.mysql.com/.
SunOS 5.11 Last change: 7