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 > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
