At 13:15 +0300 10/11/02, Victoria Reznichenko wrote:
>Abhi,
>Thursday, October 10, 2002, 8:30:43 PM, you wrote:
>
>A> I am not able to connect mysql server after executing this command
>
>A> ./safe_mysqld -O key_buffer=64M -O table_cache=256 -O
>A> sort_buffer=4M -O read_buffer_size=1M
The probable problem here is that read_buffer_size is called record_buffer
prior to MySQL 4.0.3.
>
>A> [repository@shoggoth bin]$ ./mysql -u root
>A> ERROR 2002: Can't connect to local MySQL server through socket
>A> '/tmp/mysql.sock' (2)
>
>[skip]
>
>A> but my process is running. I have tryed to restart also but unable to
>A> restart mysql server successifully.
>A> mysql> show processlist;
>A>
>+-------+------+-----------+---------+---------+------+-------------------------
>A> -----+--------------------------------------------------------------+
>A> | Id | User | Host | db | Command | Time |
>A> State
>A> | Info |
>A>
>+-------+------+-----------+---------+---------+------+-------------------------
>A> -----+--------------------------------------------------------------+
>A> | 19509 | root | localhost | mysql | Sleep | 481
>A> |
>A> | NULL |
>A> | 19532 | root | localhost | DS_data | Query | 0 |
>A> NULL
>A> | show processlist |
>A> | 19547 | root | localhost | DS_data | Query | 39 | Copying to tmp
>A> table on
>A> disk | select distinct name_server1 from tbl_raw_zone_file limit 10 |
>A>
>+-------+------+-----------+---------+---------+------+-------------------------
>A> -----+--------------------------------------------------------------+
>
>
>A> The error (2002) Can't connect to ... normally means that there isn't a
>A> MySQL server running on the system or
>A> that you are using a wrong socket file or TCP/IP port when trying to
>A> connect to the mysqld server.
>
>A> Error Log
>A> -------------
>A> 021010 10:30:41 mysqld started
>A> No variable match for: -O 'read_buffer_size=1M'
>A> /usr/local/mysql/libexec/mysqld Ver 3.23.49 for pc-linux-gnu on i686
>A> Use '--help' or '--no-defaults --help' for a list of available o
>
>A> I am using mysql version 3.23
>
>A> mysql> select version();
>A> +-------------+
>A> | version() |
>A> +-------------+
>A> | 3.23.49-log |
>A> +-------------+
>A> 1 row in set (0.00 sec)
>A> ptions
>A> 021010 10:30:41 mysqld ended
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
>But error log shows that MySQL didn't start. Do you have another MySQL
>server running?
>
>
>--
>For technical support contracts, goto https://order.mysql.com/?ref=ensita
>This email is sponsored by Ensita.net http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Victoria Reznichenko
> / /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
>/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> <___/ www.mysql.com
