|
1 '\" t |
|
2 .\" |
|
3 .\" CDDL HEADER START |
|
4 .\" |
|
5 .\" The contents of this file are subject to the terms of the |
|
6 .\" Common Development and Distribution License (the "License"). |
|
7 .\" You may not use this file except in compliance with the License. |
|
8 .\" |
|
9 .\" You can obtain a copy of the license at usr/src/OPENSOLARIS.LICENSE |
|
10 .\" or http://www.opensolaris.org/os/licensing. |
|
11 .\" See the License for the specific language governing permissions |
|
12 .\" and limitations under the License. |
|
13 .\" |
|
14 .\" When distributing Covered Code, include this CDDL HEADER in each |
|
15 .\" file and include the License file at usr/src/OPENSOLARIS.LICENSE. |
|
16 .\" If applicable, add the following below this CDDL HEADER, with the |
|
17 .\" fields enclosed by brackets "[]" replaced with your own identifying |
|
18 .\" information: Portions Copyright [yyyy] [name of copyright owner] |
|
19 .\" |
|
20 .\" CDDL HEADER END |
|
21 .\" |
|
22 .\" Copyright 2008 Sun Microsystems, Inc. All rights reserved. |
|
23 .\" Use is subject to license terms. |
|
24 .\" |
|
25 .\"ident "@(#)mysql.1.sunman 1.5 08/09/23 SMI" |
|
26 .\" |
|
27 .TH "mysql_50" "1" "" "" "User Commands" |
|
28 .SH NAME |
|
29 MySQL 5.0 \- MySQL RDBMS version 5.0 for Solaris |
|
30 .SH DESCRIPTION |
|
31 |
|
32 MySQL version 5.0 for Solaris is delivered as part of Entire Distribution |
|
33 Software Group (SUNWCall), in the following 3 packages: |
|
34 |
|
35 .TS |
|
36 box; |
|
37 cbp-1 | cbp-1 |
|
38 | | | . |
|
39 Package Contents |
|
40 = |
|
41 SUNWmysql5u MySQL 5.0 Server package (Usr component) |
|
42 = |
|
43 SUNWmysql5r MySQL 5.0 Server package (Root component) |
|
44 = |
|
45 SUNWmysql5test MySQL 5.0 test package |
|
46 |
|
47 .TE |
|
48 .PP |
|
49 |
|
50 The MySQL 5.0 software for Solaris is installed into a number of |
|
51 sub-directories of /usr/mysql/5.0. Symbolic links are created from all directories under /usr/mysql/5.0 to /usr/mysql directories. This enables the latest version of MySQL to be accessed from /usr/mysql. |
|
52 |
|
53 The SUNWmysql5u package installs the following directories: |
|
54 |
|
55 .TS |
|
56 box; |
|
57 cbp-1 | cbp-1 |
|
58 | | | . |
|
59 Directory Contents |
|
60 = |
|
61 /usr/mysql/5.0/bin Binaries and Scripts |
|
62 = |
|
63 /usr/mysql/5.0/lib Libraries for client API |
|
64 = |
|
65 /usr/mysql/5.0/include Development header files |
|
66 = |
|
67 /usr/mysql/5.0/lib Shared libraries |
|
68 = |
|
69 /usr/mysql/5.0/man/man1 Manual pages for client programs |
|
70 = |
|
71 /usr/mysql/5.0/man/man8 Manual pages for server programs |
|
72 = |
|
73 /usr/mysql/5.0/share Shared data:locale,timezone |
|
74 = |
|
75 /usr/mysql/5.0/docs HTML documentation |
|
76 |
|
77 .TE |
|
78 .PP |
|
79 |
|
80 The SUNWmysql5u package also installs the following 64-bit directories |
|
81 .TP |
|
82 .ie t \(bu |
|
83 .el o |
|
84 \fB/usr/mysql/5.0/bin/64\fR - 64-bit |
|
85 Binaries and scripts |
|
86 .TP |
|
87 .ie t \(bu |
|
88 .el o |
|
89 \fB/usr/mysql/5.0/lib/64\fR - 64-bit |
|
90 libraries for client API and shared libraries |
|
91 .RE |
|
92 .sp |
|
93 .LP |
|
94 |
|
95 |
|
96 |
|
97 The following directories are additionally created by SUNWmysql5r package |
|
98 |
|
99 .TS |
|
100 box; |
|
101 cbp-1 | cbp-1 |
|
102 | | | . |
|
103 Directory Contents |
|
104 = |
|
105 /var/mysql/5.0/data Default database data directory |
|
106 = |
|
107 /etc/mysql/5.0 Configuration file location |
|
108 |
|
109 .TE |
|
110 .PP |
|
111 |
|
112 The SUNWmysql5r package also installs the following SMF files to facilitate automatic service management |
|
113 (refer to smf(5) and the SMF section below): |
|
114 .RS |
|
115 .PP |
|
116 .br |
|
117 /var/svc/manifest/application/database/mysql.xml |
|
118 ./br |
|
119 /lib/svc/method/mysql |
|
120 .RE |
|
121 .PP |
|
122 |
|
123 The SUNWmysql5test package creates the following directories: |
|
124 .TS |
|
125 box; |
|
126 cbp-1 | cbp-1 |
|
127 | | | . |
|
128 Directory Contents |
|
129 = |
|
130 /usr/mysql/5.0/mysql-test MySQL test programs |
|
131 = |
|
132 /usr/mysql/5.0/sql-bench SQL Benchmark test |
|
133 |
|
134 .TE |
|
135 .PP |
|
136 .SH AUTOMATIC SERVICE MANAGEMENT (SMF) |
|
137 MySQL 5.0 for Solaris includes files necessary to register with the |
|
138 service management facility described in smf(5). |
|
139 |
|
140 After installation of the SUNWmysql5r package, register the MySQL service as under: |
|
141 |
|
142 .br |
|
143 example%svccfg import |
|
144 /var/svc/manifest/application/database/mysql.xml |
|
145 |
|
146 The mysql:version_50 service is disabled by default. You can check the status of the service by issuing the following command : |
|
147 |
|
148 .br |
|
149 example% svcs mysql |
|
150 .br |
|
151 STATE STIME FMRI |
|
152 .br |
|
153 disabled 14:27:09 svc:/application/database/mysql:version_50 |
|
154 |
|
155 |
|
156 Enable the mysql:version_50 service by issuing the following command : |
|
157 |
|
158 .br |
|
159 example%svcadm enable mysql:version_50 |
|
160 |
|
161 The state of the service instance should change to "online", and the database server should be started : |
|
162 |
|
163 .br |
|
164 example% svcs mysql |
|
165 .br |
|
166 STATE STIME FMRI |
|
167 .br |
|
168 online 14:30:08 svc:/application/database/mysql:version_50 |
|
169 |
|
170 .br |
|
171 |
|
172 The 32-bit MySQL daemon runs by default. To start the 64-bit |
|
173 server, execute the following commands: |
|
174 .sp |
|
175 .LP |
|
176 \fB%svccfg\fR |
|
177 .sp |
|
178 .LP |
|
179 \fBsvc>select mysql:version_50\fR |
|
180 .sp |
|
181 .LP |
|
182 \fBsvc:/application/database/mysql:version_50>listprop mysql/enable_64bit\fR |
|
183 .sp |
|
184 .LP |
|
185 \fBmysql/enable_64bit boolean false\fR |
|
186 .sp |
|
187 .LP |
|
188 \fBsvc:/application/database/mysql:version_50>setprop mysql/enable_64bit=true\fR |
|
189 .sp |
|
190 .LP |
|
191 \fBsvc:/application/database/mysql:version_50>listprop mysql/enable_64bit\fR |
|
192 .sp |
|
193 .LP |
|
194 \fBmysql/enable_64bit boolean true\fR |
|
195 .sp |
|
196 .LP |
|
197 \fBsvc:/application/database/mysql:version_50>quit\fR |
|
198 .sp |
|
199 .LP |
|
200 \fB%svcadm refresh mysql:version_50\fR |
|
201 .sp |
|
202 .LP |
|
203 \fB%svcadm enable mysql:version_50\fR |
|
204 .sp |
|
205 .LP |
|
206 The 64-bit server is initiated. |
|
207 .sp |
|
208 |
|
209 .sp |
|
210 .TS |
|
211 tab(^G); |
|
212 lw(.95i) lw(.79i) lw(3.76i) |
|
213 lw(.95i) lw(.79i) lw(3.76i) |
|
214 . |
|
215 STATE STIME FMRI |
|
216 .br |
|
217 online 15:00:08 svc:/application/database/mysql:version_50 |
|
218 |
|
219 .br |
|
220 |
|
221 |
|
222 .TE |
|
223 |
|
224 .LP |
|
225 Note - |
|
226 .sp |
|
227 .RS 2 |
|
228 By default, the \fBmysql/enable_64bit\fR property |
|
229 is set to \fBFalse\fR. Set it \fBTrue\fR to start |
|
230 the 64-bit server. |
|
231 .RE |
|
232 .sp |
|
233 .LP |
|
234 To shutdown the database instance and prevent automatic restart (for example |
|
235 during scheduled downtime for maintenance), disable the SMF service by running: |
|
236 |
|
237 example% svcadm disable mysql:version_50 |
|
238 .br |
|
239 example% svcs mysql |
|
240 .br |
|
241 STATE STIME FMRI |
|
242 .br |
|
243 disabled 14:30:08 svc:/application/database/mysql:version_50 |
|
244 |
|
245 .br |
|
246 |
|
247 .RE |
|
248 |
|
249 .SH "ATTRIBUTES" |
|
250 See attributes(5) for descriptions of the following attributes: |
|
251 |
|
252 .TS |
|
253 box; |
|
254 cbp-1 | cbp-1 |
|
255 | | | . |
|
256 ATTRIBUTE TYPE ATTRIBUTE VALUE |
|
257 = |
|
258 Availability SUNWmysql5r, SUNWmysql5u, SUNWmysql5test |
|
259 = |
|
260 Interface Stability Uncommitted. |
|
261 .TE |
|
262 .PP |
|
263 .SH SEE ALSO |
|
264 .PP |
|
265 smf(5), svcs(1), svcprop(1), svccfg(1), |
|
266 svcadm(1), mysql(1) |
|
267 |
|
268 .SH "NOTES" |
|
269 .PP |
|
270 Source for MySQL 5.0 is available on http://opensolaris.org |
|
271 |
|
272 .SH REFERENCES |
|
273 .PP |
|
274 http://www.mysql.com |