MySQLd Problems

[mxtabs]

Hey everyone,

I'm running on a Cobalt Raq3i, and I installed the rpm version of 3.23.37.

Things were running fine, untill I needed to change a variable (max_connections). When I went to use mysqld -0 max_connections=125... mysqld could not be found

Further investigation showed that I had to call /usr/sbin/mysqld

I tried issuing the --set-variable command as before, but it said another mysqld server was running. Assuming that I had to shut mysql off, I ran mysqladmin shutdown.

However, I could not turn mysql back on. I tried going to the init.d directory and using mysql start, but that did not work. Likewise mysql.server start did not work.

On trying to run mysqld, that did not work as well.

In the end, the only way to restart mysql was to reboot the whole system. After a certain time, without me restarting it, mysql would come back up (Probably programmed into the system).

How do I restart mysql without rebooting the server? I also want to make those changes.. how can this be done?

Also, I can't seem to find safe_mysqld

Thanks for your time,
Jeremy Ferwerda

[eva2000]

you should be able to do it using

/etc/rc.d/init.d/mysql stop
/etc/rc.d/init.d/mysql start

[mxtabs]

Yes,
but how do I input my new params?
using the --set-variable command

[eva2000]

you can do that via a /etc/my.cnf file

i.e i have in my /etc/my.cnf file


[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=600
set-variable = key_buffer=20M
set-variable = join_buffer=6M
set-variable = record_buffer=6M
set-variable = sort_buffer=8M
set-variable = table_cache=1024
set-variable = myisam_sort_buffer_size=32M
set-variable = thread_cache_size=8

[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M


check my sig links for more info

[mxtabs]

ok, thanks