HP OpenSource MySQL Server 5.0 ver 1.0 1
MySQL 5.0 MySQL 5.0 MySQL 5.0 MySQL 5.0.18 MySQL 5.0 Community Edition MySQL 5.0 Enterprise Server 1 MySQL 5.0 2 MySQL 5.0 3 MySQL 5.0 2
... 2... 2... 2... 3 1.... 4 1.1.... 5 1.1.1.... 5 1.1.2.... 5 1.1.3.... 6 1.2.... 7 1.2.1.... 7 1.2.2.... 7 1.2.3.... 7 1.3.... 8 1.3.1.... 8 1.3.2.... 8 1.3.3.... 9 1.4.... 10 1.4.1.... 10 1.4.2.... 10 1.4.3.... 12 1.5.... 13 1.5.1. UNIXLinux... 13 1.5.2. Windows... 14 1.6.... 14 2.... 15 2.1. MySQL... 15 2.2. MySQL... 15 2.3. InnoDB... 16 2.4.... 16 3.... 18 3.1. MySQL... 18 3.2. MySQL... 18 Appendix 1: MySQL... 19 Appendix 2:... 20 Appendix 3: MySQL... 21 A3.1. MySQL... 21 A3.2.... 22 3
1. MySQL 5.0 1 MySQL 1 MySQL 1MySQL 1MySQL MySQL (mysqld $datadir/.err SQL $datadir/.log long_query_time INDEX $datadir/-slow.log MySQL $datadir/-bin.xxxxxx (XXXXX 6 ) ) $datadir MySQL MySQL datadir 1. 2. 2.1. 4
2.2. MySQL MySQL Appendix 1: MySQL 2.3. MySQL MySQL (my.cnf/my.ini) 3. 1.1. 1.1.1. MySQL mysqld MySQL 1.1.2. 1.1.2.1. --log-error[=filename] MySQL.err MySQL Microsoft Windows --console --log-warnings[=level], -W [level] MySQL level 0 level 1 1 level 1 --console Microsoft Windows mysqld 1.1.2.2. mysql-error.log MySQL (my.cnf my.ini) UNIX Linux Windows \ MySQL MySQL mysql-error.log 1.1.2.3. MySQL MySQL mysqld /MySQL_DATA/mysql-error.log 5
MySQL UNIX Linux MySQL mysqld_safe --log-error mysqld MySQL MySQL 1.1.3. MySQL MySQL MySQL InnoDB 6
1.2. 1.2.1. SQL SQL MySQL 1.2.2. 1.2.2.1. --log[=filename], -l [filename] MySQL.log MySQL 1.2.2.2. mysql-query.log MySQL (my.cnf my.ini) UNIX Linux Windows \ MySQL MySQL mysql-query.log 1.2.2.3. MySQL MySQL mysqld /MySQL_DATA/mysql-query.log MySQL 1.2.3. 1.2.3.1. SQL 1.2.3.2. 7
Time Id Command Argument Command Query SQL 1.3. 1.3.1. MySQL long_query_time SQL MySQL 1.3.2. 1.3.2.1. --log-slow-queries[=filename] MySQL -slow.log --long-query-time=second 1 10 --log-queries-not-using-indexes --log-slow-admin-statements OPTIMIZE TABLE, ANLYZE TABLE, ALTER TABLE 1.3.2.2. mysql-slow.log 30 MySQL (my.cnf my.ini) UNIX Linux \ 8
Windows \\ MySQL MySQL mysql-slow.log 1.3.2.3. MySQL MySQL mysqld /MySQL_DATA/mysql-slow.log MySQL 1.3.3. 1.3.3.1. 1.3.3.2. mysqldumpslow mysqldumpslow 9
Windows 1.4. 1.4.1. MySQL MySQL MySQL 1.4.2. 1.4.2.1. --log-bin[=basename] MySQL -bin. 000001.index --log-bin-index[=filename] MySQL -bin.index --max-binlog-size=size 4096 1G4096 G 1G --sync-binlog={0 1} (1 ) MySQL 0 MySQL (0 ) --expire-logs-days=day MySQL 0 0 10
--binlog-do-db=dbname 2 (USE ) --binlog-ignore-db=dbname 2 1.4.2.2. mysql-bin mysql-bin.index 256MB 7 sales, prices 2 MySQL (my.cnf my.ini) UNIX Linux \ \ Windows \\ \ MySQL MySQL mysql-bin 256MB 7 MySQL sales prceis 1.4.2.3. MySQL MySQL mysqld MySQL 11
1.4.3. 1.4.3.1. MySQL 1% 1.4.3.2. mysqlbinlog newdb \ Windows # at 4# at 98 1 # at 98 CREATE DATABASE 1.4.3.3. MySQL 1 1 1 1 2 MySQL 12
2 1.5. 1.5.1. UNIX Linux MySQL MySQL mysqladmin flush-logs SQL FLUSH LOGS -old (1) MySQL (2) RELOAD : mysql-host.err ( mysql-host.err-old ) 13
: : : mysql-host.log mysql-host-slow.log mysql-bin.xxxxxx (+1 ) (3) mysqladmin flush-logs MySQL MySQL 1.5.2. Windows Unix Linux mysqladmin flush-logs \ : mysql-host.err ( mysql-host.err-old ) : mysql-bin.xxxxxx (+1 ) Microsoft Windows MySQL UNIX Linux MySQL 1.6. MySQL 2 MySQL 2 MySQL InnoDB MySQL InnoDB MySQL 5.0 Reference Manual 14
2. MySQL SQL MySQL 2.1. MySQL MySQL MySQL MySQL MySQL MySQL MySQL MySQL MySQL 2 MySQL MySQL MySQL SQL MySQL SHOW GLOBAL VARIABLES; SHOW SESSION VARIABLES; SHOW VARIABLES mysqladmin variables MySQL Windows MySQL 5.0 Reference Manual 5.2.3. System Variables 2.2. MySQL MySQL MySQL 2 MySQL MySQL SQL MySQL SHOW GLOBAL STATUS; SHOW SESSION STATUS; SHOW STATUS 15
mysqladmin extended-status MYSQL Windows MySQL 5.0 Reference Manual 5.2.5. Status Variables 2.3. InnoDB InnoDB MySQL InnoDB InnoDB InnoDB InooDB SQL SHOW INNODB STATUS\G mysql \ \\ \ Windows 2.4. PROCESS MySQL MySQL SQL SHOW PROCESSLIST\G mysql 16
\ \\ \ Windows SQL KILL mysql 17
3. 3.1. MySQL UNIX Linux ps Windows(2000/XP/2003) tasklist OS MySQL OS MySQL mysqladmin ping Unix Linux Windows 2000/XP/2003 \ 3.2. MySQL MySQL mysqladmin ping mysqladmin MySQL MySQL MySQL MySQL (UNIX ) 18
Appendix 1: MySQL MySQL UNIX Linux my.cnf Windows my.ini Windows my.cnf UNIX Linux MySQL (my.cnf) Windows MySQL (my.ini) Windows(/) 19
Appendix 2: MySQL --log-bin-trust-function-creators[={0 1}] MySQL FUNCTION CREATE FUNCTION MySQL MySQL (1 )(0 ) --binlog-cache-size=size MySQL 1 SQL 32KB --max-binlog-cache-size=size MySQL 1 --log-slave-updates={0 1} MySQL MySQL 1 0 20
Appendix 3: MySQL A3.1. MySQL MySQL 2 TCP/IP JDBC MySQL MySQL UNIX MySQL MySQL MySQL 8 28800 3 MySQL MySQL 2 MySQL interactive_timeout TCP/IP 28800 8 )mysql MySQL wait_timeout TCP/IP 28800 8 )JDBC MySQL mysql --batch 21
TCP/IP --batch mysql mysql MySQL TCP/IP --batch mysql mysql A3.2. MySQL 22
03-5304-6660 9:0019:00 10:0018:00 Linux/ http:/www.hp.com/jp/linux/ 23