Optimising mysql There is never “best parameters”, the best parameters is those fits your needs, box hardware, mysql usage… So, I’ll not give the best parameters but rather how to define these ones. Make some tests, and you’ll quickly find your own parameters. There a lot of available parameters but only few one are very important to tweak your mysql box. The most important variables are: - max_connections - wait_timeout - thread_cache_size - table_cache - key_buffer_size - query_cache_size - tmp_table_size How to display mySql variables: 1) login on mysql 2)...
Written by: Pascal | Mysql |  |
How to stop mysql or start mysql The command depends on the linux distribution installed on your dedicated server or on your virtual private server. First your need login as root. After this you have to type: 1) RedHat Linux Start mysql server: # /etc/init.d/mysqld start stop mysql server: # /etc/init.d/mysqld stop restart mysql server # /etc/init.d/mysqld restart 2) Fedora Core Start mysql server: # /etc/init.d/mysqld start stop mysql server: # /etc/init.d/mysqld stop restart mysql server # /etc/init.d/mysqld restart 3) Cent OS Start...
Written by: Mysql FAQ | Mysql | |
|
