BiTel

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
#replc
#server-id = 2
#relay-log = /var/lib/mysql/mysql-relay-bin
#relay-log-index = /var/lib/mysql/mysql-relay-bin.index
#replicate-do-db = bgbilling
######
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
default-storage-engine=InnoDB
innodb_file_per_table

# modified parameters
#-500 by historical maximum on bill-1(8Gb) 248 on febr2009
#max_connections=500
#x2
max_allowed_packet=50M
max_connections=1000
table_cache=4096
sort_buffer_size=8M
join_buffer_size=8M
thread_cache_size=384
thread_concurrency=12
#x0.25
query_cache_size = 64M
query_cache_limit = 2M
query_cache_type = 1
memlock
tmp_table_size = 1G
max_heap_table_size = 512M
#x16
#key_buffer_size = 1G
wait_timeout = 28800

# log slow queries
#log-slow-queries=/var/log/slowquery.log

# innodb
#skip-innodb
innodb_file_per_table
innodb_additional_mem_pool_size = 16M
#x8
innodb_buffer_pool_size = 1G
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_buffer_size = 8M
innodb_log_file_size = 128M
innodb_log_files_in_group = 2
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
##Khadimulin
innodb_flush_method = O_DIRECT
##
# misc
default-character-set=cp1251
default-collation=cp1251_general_ci

myisam_data_pointer_size = 6
max_connections=5000
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
[mysqldump]
max_allowed_packet=70M


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open-files-limit=32000

[client]
default-character-set=cp1251

#!/bin/sh

db_host='localhost'
db_port='3306'
db_name='bgbilling'
db_user='bill'
db_pass='bgbilling'

dump_name='/path/to/bgbilling.sql'


/path/to/mysql -h $db_host -P $db_port -u $db_user -p$db_pass -D $db_name -B -e "FLUSH TABLES WITH READ LOCK;SET GLOBAL read_only = ON;" > /dev/null 2>&1

cat <<SQL > $dump_name
DROP DATABASE IF EXISTS bgbilling;
CREATE DATABASE bgbilling DEFAULT CHARACTER SET cp1251 COLLATE cp1251_general_ci;
USE bgbilling;
SQL

/path/to/mysqldump \
--default-character-set=cp1251 \
--skip-add-drop-table \
--skip-add-locks \
--skip-tz-utc \
$db_name >> $dump_name

max_binlog_size  = 100M
expire_logs_days = 3