mysql_51 - MySQL RDBMS version 5.1 for Solaris
Please see following description for synopsis
mysql_51(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 number of sub- directories of /usr/mysql/5.1. The database/mysql-51 package installs the following directories: +------------------------+----------------------------------+ | 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 direc- tories o /usr/mysql/5.1/bin/64 - 64-bit Binaries and scripts o The following directories are additionally created by database/mysql-51 package +--------------------+---------------------------------+ | 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 | | | | +----------------------+----------------------------------+ CAVEAT Active development for MySQL Database Server version 5.1 has ended as of December 31, 2013. MySQL 5.1 is covered under Oracle Sustaining Sup- port per https://www.mysql.com/support/eol-notice.html. Therefore this version of MySQL is now Obsolete and will be removed from a future release of Solaris. Please consider upgrading to a newer version, MySQL 5.5 or 5.6. 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 con- nection are probe connection-start(); probe connection-done(); Probes that fire at the start/end of any client command processing (including SQL queries) probe command-start(); probe command-done(); Probes that fire at the start/end of any SQL query processing. 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 privilege 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 handler depending on the lock type being acquired or released 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 network 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). After installation of the database/mysql-51 package, register 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 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 maintenance), 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: +---------------+-------------------+ |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://downloads.mysql.com/ar- chives/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/. mysql_51(1)