免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1316 | 回复: 0
打印 上一主题 下一主题

mysqld ended 问题!!!!!! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2004-04-02 08:15 |只看该作者 |倒序浏览
系统:sun+solaris+apache+php4+mysql

apache和php都安装,运行正常。但# ./mysql.server start
总提示:
# Starting mysqld daemon with databases from /usr/local/mysql/var
040402 07:56:08  mysqld ended

more *.err 显示:

040401 18:01:22  mysqld started
/usr/local/mysql/libexec/mysqld: unrecognized option `--key_buffer=16M'
/usr/local/mysql/libexec/mysqld  Ver 3.23.53 for sun-solaris2.8 on sparc
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/mysql/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/mysql/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/mysql/
datadir:     /usr/local/mysql/var/
tmpdir:      /var/tmp/
language:    /usr/local/mysql/share/mysql/english/
pid file:    /usr/local/mysql/var/south.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
040401 18:01:22  mysqld ended




请高手指点!感激不尽!!
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP