Topic: MySQL restart command?

[Normando]

What is the correct command for restart mysqld ?

[CharlieBrady]

What is the correct command for restart mysqld ?

Why do you want to do that?

/etc/rc7.d/S*mysqld restart

Or, if you want to use sv directly, you can do:

sv t /service/mysqd

[I'm very surprised that you couldn't learn this yourself, by searching.]

[fpausp]

http://wiki.contribs.org/MySQL

[Normando]

I created this thread only for reference Charly, because wiki information is wrong.
Wiki say: service mysqld restart
and this command not work, and then I must restart the server.
I use this comman when I need to tweak mysqld parameters

[I'm very surprised that you couldn't learn this yourself, by searching.]

Because I need an official word.

Now I will fix the wiki

Thanks

[CharlieBrady]

I created this thread only for reference Charly, because wiki information is wrong.

If any documentation is incorrect, you should open a bug in the Bug Tracker, Documentation section.

Wiki say: service mysqld restart
and this command not work, and then I must restart the server.

That command should work (in SME 7.3), as that command should actually eventually call "sv restart mysqld". If it doesn't work, then you should open a bug in the bug tracker.

I use this comman when I need to tweak mysqld parameters

What mysqld parameters do you need to tweak?

[Normando]

The follow are the mysqld parameters I tweak, and the most used parameters

Code: [Select]

query_cache_limit=2M
query_cache_size=128M
query_cache_type=1
key_buffer_size= 98M
table_cache=1024
max_tmp_tables=100
sort_buffer_size=24M
thread_cache=32M
max_connections = 500
myisam_sort_buffer_size = 64M
join_buffer_size = 16M
read_buffer_size = 16M
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_connect_errors = 10
max_allowed_packet=16M

I will confirm if service mysqld restart work, and then I will create the bug.