Red Hat APPLICATION STACK 2.0 RELEASE Instrukcja Użytkownika Pobierz pdf (Strona 14)

A Principled Technologies test report 14

Red Hat Enterprise Linux 6: Performance advantages with an

open source software stack

tmp_table_size = 32M

max_heap_table_size = 32M

query_cache_type = 0

query_cache_size = 0

max_connections = 20000

thread_cache_size = 50

open_files_limit = 65535

table_definition_cache = 1024

table_open_cache = 2048

innodb_flush_method = O_DIRECT

innodb_log_files_in_group = 2

innodb_log_file_size = 512M

innodb_flush_log_at_trx_commit = 2

innodb_file_per_table = 1

innodb_buffer_pool_size = 2G

innodb_thread_concurrency = 0

innodb_log_group_home_dir = /mysql/logXYZZY

innodb_data_home_dir = /mysql/datXYZZY

log_error = /mysql/logXYZZY/mysql-error.log

log_queries_not_using_indexes = 1

slow_query_log = 1

slow_query_log_file = /mysql/logXYZZY/mysql-slow.log

default-storage-engine = InnoDB

#### from DVD Store installation instructions

ft_min_word_len = 3

ft_stopword_file =

[mysqldadmin]

socket = /mysql/logXYZZY/mysql.sock

3. Generate the configuration file for each instance by replacing the tag XYZZY with the instance number:

for i in 01 02 03; do

sed "s/XYZZY/$i/g" < mysql/my-template.cnf > mysql/my-${i}.cnf

done

4. Create the script files /mysql/MySQLstart, /mysql/MySQLstop and /mysql/MySQLdata with the following

contents:

# MySQLstart

for i in 01 02 03; do

echo Starting Instance ${i}

sleep 5

mysqld_safe --defaults-file=/mysql/my-${i}.cnf \

--basedir=/usr --user=mysql \

--datadir=/mysql/dat${i} \

--socket=/mysql/log${i}/mysql.sock \

>/dev/null 2>&1 &

done

# end of MySQLstart

# MySQLstop

for i in 01 02 03; do

echo Stopping Instance ${i}

mysqladmin -uroot -pPassword1 \

-S/mysql/log${i}/mysql.sock shutdown

done

1 2 ... 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Komentarze do niniejszej Instrukcji

Brak uwag

Red Hat APPLICATION STACK 2.0 RELEASE Instrukcja Użytkownika Strona 14

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Serwery Red Hat APPLICATION STACK 2.0 RELEASE