*ãããããããããããããããããããããããåãåããããã >sh ./mysql.server start ãèåãããã >Starting mysqld daemon with databases from /usr/local/var 041008 22:05:29 mysqld ended ãèçãããçäãããããããã
ããããããã 041008 22:05:29 mysqld started /usr/local/libexec/mysqld: unrecognized option `--key_buffer=16M' /usr/local/libexec/mysqld Ver 3.23.57 for pc-linux on i686 Copyright (C) 2000 MySQL AB, by Monty and others This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Starts the MySQL server
Usage: /usr/local/libexec/mysqld [OPTIONS]
--ansi Use ANSI SQL syntax instead of MySQL syntax
-b, --basedir=path Path to installation directory. All paths are
usually resolved relative to this
--big-tables Allow big result sets by saving all temporary sets
on file (Solves most 'table full' errors)
--bind-address=IP Ip address to bind to
--bootstrap Used by mysql installation scripts
--character-sets-dir=...
Directory where character sets are
--chroot=path Chroot mysqld daemon during startup
--core-file Write core on errors
-h, --datadir=path Path to the database root
--default-character-set=charset
Set the default character set
--default-table-type=type
Set the default table type for tables
--delay-key-write-for-all-tables
Don't flush key buffers between writes for any MyISAM
table
--enable-locking Enable system locking
-T, --exit-info Used for debugging; Use at your own risk!
--flush Flush tables to disk between SQL commands
-?, --help Display this help and exit
--init-file=file Read SQL commands from this file at startup
-L, --language=... Client error messages in given language. May be
given as a full path
--local-infile=[1|0] Enable/disable LOAD DATA LOCAL INFILE
-l, --log[=file] Log connections and queries to file
--log-bin[=file] Log queries in new binary format (for replication)
--log-bin-index=file File that holds the names for last binary log files
--log-update[=file] Log updates to file.# where # is a unique number
if not given.
--log-isam[=file] Log all MyISAM changes to file
--log-long-format Log some extra information to update log
--low-priority-updates INSERT/DELETE/UPDATE has lower priority than selects
--log-slow-queries=[file]
Log slow queries to this log file. Defaults logging
to hostname-slow.log
--pid-file=path Pid file used by safe_mysqld
--myisam-recover[=option[,option...]] where options is one of DEAULT,
BACKUP or FORCE.
--memlock Lock mysqld in memory
-n, --new Use very new possible 'unsafe' functions
-o, --old-protocol Use the old (3.20) protocol
-P, --port=... Port number to use for connection
-O, --set-variable var=option
Give a variable an value. --help lists variables
-Sg, --skip-grant-tables
Start without grant tables. This gives all users
FULL ACCESS to all tables!
--safe-mode Skip some optimize stages (for testing)
--safe-show-database Don't show databases for which the user has no
privileges
--safe-user-create Don't new users cretaion without privileges to the
mysql.user table
--skip-concurrent-insert
Don't use concurrent insert with MyISAM
--skip-delay-key-write
Ignore the delay_key_write option for all tables
--skip-host-cache Don't cache host names
--skip-locking Don't use system locking. To use isamchk one has
to shut down the server.
--skip-name-resolve Don't resolve hostnames.
All hostnames are IP's or 'localhost'
--skip-networking Don't allow connection with TCP/IP.
--skip-new Don't use new, possible wrong routines. --skip-stack-trace Don't print a stack trace on failure
--skip-show-database Don't allow 'SHOW DATABASE' commands
--skip-thread-priority
Don't give threads different priorities.
--socket=... Socket file to use for connection
-t, --tmpdir=path Path for temporary files
--sql-mode=option[,option[,option...]] where option can be one of:
REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES,
IGNORE_SPACE, SERIALIZE, ONLY_FULL_GROUP_BY.
--transaction-isolation
Default transaction isolation level
--temp-pool Use a pool of temporary files
-u, --user=user_name Run mysqld daemon as user
-V, --version output version information and exit
-W, --warnings Log some not critical warnings to the log file
Default options are read from the following files in the given order: /etc/my.cnf /usr/local/var/my.cnf ~/.my.cnf The following groups are read: mysqld server The following options may be given as the first argument: --print-defaults Print the program argument list and exit --no-defaults Don't read default options from any options file --defaults-file=# Only read default options from the given file # --defaults-extra-file=# Read this file after the global files are read
To see what values a running MySQL server is using, type 'mysqladmin variables' instead of 'mysqld --help'. The default values (after parsing the command line arguments) are:
basedir: /usr/local/ datadir: /usr/local/var/ tmpdir: /tmp/ language: /usr/local/share/mysql/english/ pid file: /usr/local/var/yahoobb218126150038.pid TCP port: 3306 Unix socket: /tmp/mysql.sock
system locking is not in use
Possible variables for option --set-variable (-O) are: back_log current value: 50 binlog_cache_size current value: 32768 connect_timeout current value: 5 delayed_insert_timeout current value: 300 delayed_insert_limit current value: 100 delayed_queue_size current value: 1000 flush_time current value: 0 interactive_timeout current value: 28800 join_buffer_size current value: 131072 key_buffer_size current value: 8388600 long_query_time current value: 10 lower_case_table_names current value: 0 max_allowed_packet current value: 1048576 max_binlog_cache_size current value: 4294967295 max_binlog_size current value: 1073741824 max_connections current value: 100 max_connect_errors current value: 10 max_delayed_threads current value: 20 max_heap_table_size current value: 16777216 max_join_size current value: 4294967295 max_sort_length current value: 1024 max_tmp_tables current value: 32 max_user_connections current value: 0 max_write_lock_count current value: 4294967295 myisam_max_extra_sort_file_size current value: 256 myisam_max_sort_file_size current value: 2047 myisam_sort_buffer_size current value: 8388608 net_buffer_length current value: 16384 net_retry_count current value: 10 net_read_timeout current value: 30 net_write_timeout current value: 60 open_files_limit current value: 0 query_buffer_size current value: 0 record_buffer current value: 131072 record_rnd_buffer current value: 0 slave_net_timeout current value: 3600 slow_launch_time current value: 2 sort_buffer current value: 2097144 table_cache current value: 64 thread_concurrency current value: 10 thread_cache_size current value: 0 tmp_table_size current value: 33554432 thread_stack current value: 65536 wait_timeout current value: 28800 041008 22:05:29 mysqld ended ãæãããããããmysql_install_dbãããããããããããããããï
äämysqlbugãååããã
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)]
>Description: <precise description of the problem (multiple lines)> >How-To-Repeat: <code/input/activities to reproduce the problem (multiple lines)> >Fix: <how to correct or work around the problem, if known (multiple lines)>
>Submitter-Id: <submitter ID> >Originator: root >Organization: <organization of PR author (multiple lines)> >MySQL support: [none | licence | email support | extended email support ] >Synopsis: <synopsis of the problem (one line)> >Severity: <[ non-critical | serious | critical ] (one line)> >Priority: <[ low | medium | high ] (one line)> >Category: mysql >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> >Release: mysql-4.0.21-standard (Official MySQL-standard binary)
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux yahoobb218126150038.bbtec.net 2.4.20-8 #1 Thu Mar 13 17:54:28 EST 2003 i686 i686 i386 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: /usr/lib/gcc-lib/i386-redhat-linux/3.2.2/specs ãã spec ãèãèãä
ãããããããããã: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux
ããããããã: posix
gcc ããããã 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 10æ 2 00:22 /lib/libc.so.6 -> libc-2.3.2.so
-rwxr-xr-x 1 root root 1561228 11æ 13 2003 /lib/libc-2.3.2.so
-rw-r--r-- 1 root root 2332200 11æ 13 2003 /usr/lib/libc.a
-rw-r--r-- 1 root root 204 11æ 13 2003 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 9æ 24 05:31 /usr/lib/libc-client.a -> c-client.a
Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--with-embedded-server' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc'*
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
