Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: Normando on September 28, 2008, 08:39:44 AM

Title: MySQL restart command?
Post by: Normando on September 28, 2008, 08:39:44 AM
What is the correct command for restart mysqld ?
Title: Re: MySQL restart command?
Post by: CharlieBrady on September 28, 2008, 05:07:11 PM
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.]
Title: Re: MySQL restart command?
Post by: fpausp on September 28, 2008, 05:08:38 PM
http://wiki.contribs.org/MySQL
Title: Re: MySQL restart command?
Post by: Normando on September 28, 2008, 06:45:58 PM
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

Title: Re: MySQL restart command?
Post by: CharlieBrady on September 28, 2008, 07:28:24 PM
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.

Quote
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.

Quote
I use this comman when I need to tweak mysqld parameters

What mysqld parameters do you need to tweak?
Title: Re: MySQL restart command?
Post by: Normando on September 28, 2008, 08:21:17 PM
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.