Для серваков с минимум 2 гигами + MySQL 5.0/5.1
Проверь корни!
База должна UTF-8 иметь, есле это невозможно, то utf8 на latin1 поменяй.
/etc/mysql/my.cnf
Код:
[client] character_sets_dir = /usr/share/mysql/charsets default_character_set = utf8 port = 3306 socket = /var/run/mysqld/mysqld.sock [mysql] character_sets_dir = /usr/share/mysql/charsets default_character_set = utf8 prompt = \u@\h [\d]>\_ no_auto_rehash [mysqladmin] character_sets_dir = /usr/share/mysql/charsets default_character_set = utf8 [mysqlcheck] character_sets_dir = /usr/share/mysql/charsets default_character_set = utf8 [mysqldump] character_sets_dir = /usr/share/mysql/charsets default_character_set = utf8 max_allowed_packet = 32M quote_names quick [mysqlimport] character_sets_dir = /usr/share/mysql/charsets default_character_set = utf8 [mysqlshow] character_sets_dir = /usr/share/mysql/charsets default_character_set = utf8 [isamchk] character_sets_dir = /usr/share/mysql/charsets key_buffer_size = 256M [myisamchk] character_sets_dir = /usr/share/mysql/charsets key_buffer_size = 256M [myisampack] character_sets_dir = /usr/share/mysql/charsets [mysqld_safe] err_log = /var/log/mysql/mysql.err [mysqld] character_sets_dir = /usr/share/mysql/charsets character_set_server = utf8 default_character_set = utf8 user = mysql port = 3306 bind_address = 127.0.0.1 socket = /var/run/mysqld/mysqld.sock pid_file = /var/run/mysqld/mysqld.pid log_error = /var/log/mysql/mysqld.err basedir = /usr datadir = /var/lib/mysql tmpdir = /var/tmp slave_load_tmpdir = /var/tmp language = /usr/share/mysql/english log_bin = /var/lib/mysql/mysql-bin relay-log = /var/lib/mysql/relay.log relay-log-index = /var/lib/mysql/relay.index relay-log-info-file = /var/lib/mysql/relay.info #master-info-file = /var/lib/mysql/master.info #master_host = <hostname> #master_user = <username> #master_password = <password> #master_port = 3306 #auto_increment_increment = 10 #auto_increment_offset = 1 server_id = 1 back_log = 50 sync_binlog = 0 binlog_cache_size = 1M max_binlog_size = 100M expire_logs_days = 7 slave_compressed_protocol = 1 lower_case_table_names = 1 delay_key_write = ALL safe_user_create = 1 myisam_recover = FORCE,BACKUP skip_locking skip_name_resolve skip_external_locking skip_show_database key_buffer_size = 512M record_buffer = 2M join_buffer_size = 2M sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M max_allowed_packet = 32M max_heap_table_size = 64M tmp_table_size = 64M table_cache = 1024 query_cache_type = 1 query_cache_size = 128M query_cache_limit = 16M thread_concurrency = 16 thread_cache_size = 16 max_connections = 100 ft_max_word_len = 20 ft_min_word_len = 3 local_infile = 0 log_warnings = 2 long_query_time = 3 log_slow_queries = /var/log/mysql/slow-queries.log log_queries_not_using_indexes #log_slave_updates log_long_format #skip_innodb innodb_thread_concurrency = 8 innodb_buffer_pool_size = 512M innodb_additional_mem_pool_size = 16M innodb_data_home_dir = /var/lib/mysql innodb_log_arch_dir = /var/lib/mysql innodb_log_group_home_dir = /var/lib/mysql innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend innodb_flush_method = O_DIRECT innodb_log_file_size = 100M innodb_log_buffer_size = 8M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 2 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 innodb_file_per_table [mysqlhotcopy] interactive_timeout
Просмотров: 1009