show tables; - prikazivanje svih tabela unutar baze
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