| Ady Wicaksono 2006-02-25, 9:43 am |
| [client]
port = 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
#thread_stack=128KB
#set-variable = table-type=innodb
default-table-type = innodb
port = 3306
socket = /var/lib/mysql/mysql.sock
max_connections = 910
max_connect_errors = 9999999
skip-locking
skip-innodb_doublewrite
key_buffer = 384M
max_allowed_packet = 4M
table_cache = 2049
sort_buffer_size = 12M
read_buffer_size = 12M
myisam_sort_buffer_s
ize = 64M
thread_cache = 48
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
# Master Replication
# ------------------
#log-bin
#server-id=1
# My Inno DB tables
# -----------------
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir
=
innodb_data_file_pat
h =
/data1/ibdata1:2000M;/data1/ibdata2:2000M;/data1/ibdata3:2000M;/data1/ibdata4:2000M;/data2/ibdata5:2000M;/data2/ibdata6:2000M;/data2/ibdata7:2000M;/data2/ibdata8:2000M;/data3/ibdata9:2000M;/data3/ibdata10:2000M;/data3/ibdata11:2000M;/data3/ibdata12:2000M;
/data4/ibdata13:2000M;/data4/ibdata14:2000M;/data4/ibdata15:2000M;/data4/ibdata16:2000M;/data5/ibdata17:2000M;/data5/ibdata18:2000M;/data5/ibdata19:2000M;/data5/ibdata20:2000M;
# ------ OLD ---
innodb_log_group_hom
e_dir = /data1
innodb_log_arch_dir = /data1
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_s
ize = 1300M
innodb_additional_me
m_pool_size = 80M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size
= 100M
innodb_log_buffer_si
ze = 8M
innodb_flush_log_at_
trx_commit = 1
innodb_lock_wait_tim
eout = 20
innodb_table_locks=0
transaction-isolation = REPEATABLE-READ
Javier Armendáriz wrote:
> Can you tell us about your config parameters?????
>
> Probably you must set up your max_connections, max_user_connections
>
> http://dev.mysql.com/doc/refman/5.0...parameters.html
>
>
> Ady Wicaksono escribió:
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|