List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 11 2002 10:54pm
Subject:re: MySQL Error
View as plain text  
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
Thread
MySQL ErrorAbhi10 Oct
  • re: MySQL ErrorVictoria Reznichenko11 Oct
    • re: MySQL ErrorPaul DuBois12 Oct