...
mysqlcheck -o --all-databases
--optimizacija svih baza.
My.conf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# # clients (those using the mysqlclient10 compatibility package).
...
old_passwords=1
...
lower_case_table_names=1
#
[mysqld]
...
max_allowed_packet=16M
...
max_connections=80
...
key_buffer_size=768M
...
innodb_buffer_pool_size=1GB
...
table_open_cache=400
...
open_files_limit=800
...
sort_buffer_size=1M
...
read_buffer_size=1M
#
[mysql.server]
...
user=mysql
...
basedir=/var/lib
#
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log_slow_queries=/var/log/mysql/mysql-slow.log
long_query_time=2
log-queries-not-using-indexes
general_log_file=/var/log/mysql/mysql.log
general_log=1