|
||||||||||||||||
|
||||||||||||||||
|
| |||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
|
 |
| |
|
| |
| |
|
|
|
|
|
АРХИВ :: nginx-ru |
|
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] Re: Нагрузка на FreeBSD
Нет, Mysql собирал из портов. Нигде статико не указывал. Что-то я подзабыл, как это в BSD делаетя (кроме как руками из исходников), но я поспрашиваю у гугла. а my.cnf вот: [mysql] character-sets-dir=/usr/local/share/mysql/charsets default-character-set=cp1251 [mysqladmin] character-sets-dir=/usr/local/share/mysql/charsets default-character-set=cp1251 [mysqlcheck] character-sets-dir=/usr/local/share/mysql/charsets default-character-set=cp1251 [mysqldump] character-sets-dir=/usr/local/share/mysql/charsets default-character-set=cp1251 [mysqlimport] character-sets-dir=/usr/local/share/mysql/charsets default-character-set=cp1251 [mysqlshow] character-sets-dir=/usr/local/share/mysql/charsets default-character-set=cp1251 [myisamchk] character-sets-dir=/usr/local/share/mysql/charsets [mysqld_safe] err-log = /var/log/mysql/mysql.err # add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations [mysqld] max_connections = 60 default-character-set = cp1251 character-set-server = cp1251 user = mysql port = 3306 log-error = /var/log/mysql/mysqld.err skip-locking key_buffer = 8M max_allowed_packet = 1000M table_cache = 512 sort_buffer_size = 2M net_buffer_length = 16K read_buffer_size = 1M read_rnd_buffer_size = 1M myisam_sort_buffer_size = 2M record_buffer = 2M thread_cache = 16 thread_concurrency = 8 query_cache_size = 16M language = /usr/local/share/mysql/english/ init-connect = "SET NAMES cp1251" bind-address = innodb_buffer_pool_size = 16M # this is the default, increase it if you have lots of tables innodb_additional_mem_pool_size = 8M # # i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-( # and upstream wants things to be under /var/lib/mysql/, so that's the route # we have to take for the moment innodb_data_home_dir = /var/db/mysql/ innodb_log_arch_dir = /var/db/mysql/ innodb_log_group_home_dir = /var/db/mysql/ # you may wish to change this size to be more suitable for your system # the max is there to avoid run-away growth on your machine innodb_data_file_path = ibdata1:10M:autoextend:max:128M # we keep this at around 25% of of innodb_buffer_pool_size # sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size) innodb_log_file_size = 5M # this is the default, increase it if you have very large transactions going on innodb_log_buffer_size = 8M # this is the default and won't hurt you # you shouldn't need to tweak it set-variable = innodb_log_files_in_group=2 # see the innodb config docs, the other options are not always safe innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 1000M [mysql] # uncomment the next directive if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M 2007/1/12, Andrey Y. Ostanovsky <andrey@xxxxxxxxxxxxxxxxx
>: -----BEGIN PGP SIGNED MESSAGE-----
|