BiTel

#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
#user=mysql

[mysqld]
datadir=/var/lib/mysql
tmpdir = /tmp
socket=/var/lib/mysql/mysql.sock
user=mysql
log-slow-queries=/var/log/slowquery.log
skip-name-resolve
#
default-storage-engine = innodb
default-character-set=cp1251
default-collation=cp1251_general_ci
sql-mode=
#
max_allowed_packet=50M
max_connections=1000
#
memlock
table_cache=4096
thread_cache_size=300
thread_concurrency=2
#
# InnoDb
innodb_file_per_table
#
innodb_log_group_home_dir = /var/lib/mysql/
innodb_buffer_pool_size = 1G
innodb_additional_mem_pool_size = 16M
#
innodb_log_files_in_group = 2
innodb_log_file_size = 128M
innodb_log_buffer_size = 8M
innodb_lock_wait_timeout = 120
#
innodb_thread_concurrency = 2
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
#
# MyIsam
#key_buffer_size = 1G
#myisam_recover
#myisam_repair_threads = 1
#myisam_data_pointer_size = 6
#
# Replication
#server-id=1
#log-bin=/var/lib/mysql-binlog/mysql-bin
#expire_logs_days=3
#replicate-do-db=bgbilling
#relay-log-space-limit = 10G
#
[mysqld_safe]
open-files-limit=32000
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#
[client]
default-character-set=cp1251
#
[mysqldump]
max_allowed_packet=50M
default-character-set=cp1251

мы пишем текст. потом в окне, где набираем сообщение, выделяем нужный текст и нажимаем тег CODE

tmpdir = /tmp

#tmpdir = /tmp

tmpdir = /var/lib/mysql

[root@localhost etc]# service mysqld restart
Останавливается mysqld:                                    [  OK  ]
MySQL Daemon failed to start.
Запускается mysqld:                                        [СБОЙ ]
[root@localhost etc]# mc

[root@localhost log]# cat /var/log/mysqld.log
111220 14:25:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111220 14:25:37 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
111220 14:25:37 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
111220 14:25:37 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
111220 14:25:37  InnoDB: Initializing buffer pool, size = 1.0G
111220 14:25:37  InnoDB: Completed initialization of buffer pool
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
111220 14:25:38 [ERROR] Plugin 'InnoDB' init function returned error.
111220 14:25:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111220 14:25:38 [ERROR] Unknown/unsupported table type: innodb
111220 14:25:38 [ERROR] Aborting

111220 14:25:38 [Note] /usr/libexec/mysqld: Shutdown complete

111220 14:25:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
111220 14:32:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111220 14:32:43 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
111220 14:32:43 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
111220 14:32:43 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
111220 14:32:43  InnoDB: Initializing buffer pool, size = 1.0G
111220 14:32:43  InnoDB: Completed initialization of buffer pool
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
111220 14:32:43 [ERROR] Plugin 'InnoDB' init function returned error.
111220 14:32:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111220 14:32:43 [ERROR] Unknown/unsupported table type: innodb
111220 14:32:43 [ERROR] Aborting

111220 14:32:43 [Note] /usr/libexec/mysqld: Shutdown complete

111220 14:32:43 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[root@localhost log]#

[root@localhost log]# service mysqld restart
Останавливается mysqld:                                    [  OK  ]
MySQL Daemon failed to start.
Запускается mysqld:                                        [СБОЙ ]
[root@localhost log]# cat /var/log/mysqld.log                                                                                                                111220 14:46:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111220 14:46:02 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
111220 14:46:02 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
111220 14:46:02 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
111220 14:46:02  InnoDB: Initializing buffer pool, size = 5.0G
111220 14:46:02  InnoDB: Completed initialization of buffer pool
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
111220 14:46:02 [ERROR] Plugin 'InnoDB' init function returned error.
111220 14:46:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111220 14:46:02 [ERROR] Unknown/unsupported table type: innodb
111220 14:46:02 [ERROR] Aborting

InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html

[root@localhost mysql]# ls
ibdata1  ib_logfile0  ib_logfile1  mysql  test

#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
#user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
#symbolic-links=0

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
max_allowed_packet=50M
tmpdir = /tmp
old_passwords=1
##master-master preparations
#auto_increment_increment=2
#auto_increment_offset=1

# modified parameters
#-500 by historical maximum on bill-1(8Gb) 248 on febr2009
max_connections=1000
#x2
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 = 5G
wait_timeout = 28800

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

# replication
server-id=1
replicate-same-server-id=0
#log-bin=/var/log
expire_logs_days=3
replicate-do-db=bgbilling
relay-log-space-limit = 10G
relay-log=mysqld-relay-bin

## myisam
#read_buffer_size = 2M
#read_rnd_buffer_size = 16M
#bulk_insert_buffer_size = 64M
#myisam_sort_buffer_size = 1G
#myisam_max_sort_file_size = 10G
##unused since 5.0???
##myisam_max_extra_sort_file_size = 10G
##
#myisam_repair_threads = 1
#myisam_recover
#myisam_data_pointer_size = 6
## bdb
#skip-bdb

# innodb
#skip-innodb
#default-storage-engine = innodb
innodb_file_per_table
innodb_additional_mem_pool_size = 16M
#x8
innodb_buffer_pool_size = 5G
#A recommended value is 2 times the number of CPUs plus the number of disks.
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_group_home_dir = /tmp
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

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql.server]
user=mysql
basedir=/var/lib

[client]
default-character-set=cp1251

[root@localhost etc]# cat /var/log/mysqld.log
[root@localhost etc]#

[root@localhost etc]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root@localhost etc]#

[root@localhost bin]# service mysqld stop
Stopping mysqld (via systemctl):                           [  OK  ]
[root@localhost bin]#

[root@localhost etc]# service mysqld start
Starting mysqld (via systemctl):  Job failed. See system logs and 'systemctl status' for details.
                                                           [СБОЙ ]

InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 134217728 bytes!

innodb_log_file_size = 5242880

[root@localhost log]# service mysqld start
Starting mysqld (via systemctl):  Job failed. See system logs and 'systemctl status' for details.
                                                           [СБОЙ ]

111220 16:46:15 [ERROR] /usr/libexec/mysqld: unknown variable 'default-character-set=cp1251'

default-character-set=cp1251
default-collation=cp1251_general_ci

#
default-storage-engine = innodb
character-set-server = cp1251
collation-server = cp1251_general_ci
sql-mode=
#

mysql --version

[root@localhost etc]# service mysqld start
Инициализируется база данных MySQL:  Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h 127.0.0.1 password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

                                                           [  OK  ]
Запускается mysqld:                                        [  OK  ]
[root@localhost etc]#

[root@localhost etc]# cat /var/log/mysqld.log
111220 16:57:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111220 16:57:06 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
111220 16:57:06  InnoDB: Initializing buffer pool, size = 1.0G
111220 16:57:06  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
111220 16:57:06  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
111220 16:57:06  InnoDB: Log file /var/lib/mysql/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
111220 16:57:06  InnoDB: Log file /var/lib/mysql/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
111220 16:57:07  InnoDB: Started; log sequence number 0 0
/usr/libexec/mysqld: File '/var/log/slowquery.log' not found (Errcode: 13)
111220 16:57:07 [ERROR] Could not use /var/log/slowquery.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
111220 16:57:07 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
111220 16:57:07 [Warning] 'user' entry '@localhost.localdomain' ignored in --skip-name-resolve mode.
111220 16:57:07 [Note] Event Scheduler: Loaded 0 events
111220 16:57:07 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
[root@localhost etc]#

mysql  Ver 14.14 Distrib 5.1.60, for redhat-linux-gnu (x86_64) using readline 5.1

InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 134217728 bytes!

innodb_log_files_in_group = 2
innodb_log_file_size = 5242880
innodb_log_buffer_size = 8M
innodb_lock_wait_timeout = 120

#
default-storage-engine = innodb
#character-set = cp1251
#default-collation=cp1251_general_ci
sql-mode=
#

#
default-storage-engine = innodb
default-character-set=cp1251
default-collation=cp1251_general_ci
sql-mode=
#