InnoDB - optimalizace mysql

[Tomas Mivalt]

zdravim, mam problem

upravil jsem soubor /etc/mysql/my.cnf na

Kód: [Vybrat]

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open-files-limit=7000

[mysqld]
user            = mysql
default_table_type=InnoDB
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking
table_cache = 1200
skip-locking
old_passwords   = 1
bind-address            = 127.0.0.1
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size       = 8
thread_concurrency = 4
query_cache_limit       = 1048576
query_cache_size        = 16777216
query_cache_type        = 1
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
sort_buffer_size = 10240K
net_buffer_length = 2048K
read_buffer_size = 10240K
read_rnd_buffer_size = 2048K
skip-bdb
myisam_sort_buffer_size = 8M
max_connect_errors=10
set-variable = max_connections=850
set-variable = max_connect_errors=65535
set-variable = max_user_connections=1000
set-variable = table_cache=2800
set-variable = sort_buffer=10M
set-variable = join_buffer_size=10M
set-variable = record_buffer=10M
set-variable = myisam_sort_buffer_size=10M
set-variable = wait_timeout=14400
set-variable = thread_cache_size=200
set-variable = back_log=512
set-variable = connect_timeout=30
set-variable = tmp_table_size=10M
set-variable = query_cache_size=64M
set-variable = max_allowed_packet=3M
set-variable = innodb_file_io_threads=40
default-character-set=utf8
default-collation=utf8_czech_ci
max_heap_table_size = 96000000
long-query-time = 1
innodb_file_per_table
innodb_thread_concurrency=4
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size = 800M
innodb_additional_mem_pool_size = 100M
innodb_autoextend_increment = 8
innodb_log_buffer_size = 10M
innodb_log_file_size=50M
innodb_open_files = 700
innodb_table_locks=0
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
innodb_flush_method=O_DSYNC

[mysqldump]
quick
max_allowed_packet = 64M

[mysql]
no-auto-rehash
#datadir=/var/lib/mysql
#user=mysql
#socket=/var/lib/mysql/mysql.sock

[isamchk]
key_buffer = 60M
sort_buffer_size = 60M
read_buffer = 6M
write_buffer = 6M

[myisamchk]
key_buffer = 60M
sort_buffer_size = 60M
read_buffer = 6M
write_buffer = 6M

[mysqlhotcopy]PO restartu PC a pri pokusu o spusteni demona mysql terminal vypisuje

Kód: [Vybrat]

charlie@merlin:~$ 070429 12:56:21 [Warning] Changed limits: max_open_files: 1024  max_connections: 850  table_cache: 82
bash: 070429: command not found
charlie@merlin:~$ 070429 12:56:21 [Warning] Can't create test file /var/lib/mysql/merlin.lower-test
> 070429 12:56:21 [Warning] One can only use the --user switch if running as root
>
> 070429 12:56:21  InnoDB: Operating system error number 13 in a file operation.
> InnoDB: The error means mysqld does not have the access rights to
> InnoDB: the directory.
> InnoDB: File name ./ibdata1
> InnoDB: File operation call: 'open'.
> InnoDB: Cannot continue operation.Nevi nekdo co s tim ? Dekuji za odpoved

[Vojtěch Weiss]

dyt to tam mas dokonce napsane...jednak sis zvetsil velikost transakcnich logu, takze ty stare si nekam backupni a pak smazni, druhou veci je, ze nemuze vytvorit testovaci fajl. druha vec je, ze tam mas prepnuti na nejakyho usera bez uvedeni parametru. pekne jsi tu konfiguraci zvrtal. ja tedy pouzivam tuning jak prase, ale aspon tak, aby to doopravdy jelo...