Page History

...

mysqlcheck -o --all-databases --optimizacija svih baza.

My.conf

mysqld
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

1. Default to using old password format for compatibility with mysql 3.x
2. # 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