Hi all,
We have just finished developing and application in C++ that uses a
mysql 3.23.52 database on Linux. It went into productions this morning and
now we are having problems with multiple select statements. When one user
runs a very learge select query, it locks the tables involved so no other
user can select, insert, or update them. Here is our my.cnf file for this
system. Thanks for any help.
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = max_connections=1000
set-variable = key_buffer=384M
set-variable = max_allowed_packet=1M
set-variable = table_cache=1024
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
log-bin
server-id = 1
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[isamchk]
set-variable = key_buffer=384M
set-variable = sort_buffer=384M
set-variable = read_buffer=128M
set-variable = write_buffer=128M
[myisamchk]
set-variable = key_buffer=384M
set-variable = sort_buffer=384M
set-variable = read_buffer=128M
set-variable = write_buffer=128M
[mysqlhotcopy]
interactive-timeout
James Crippen
Sr. LAN Engineer
Elite International
ph 281-775-2237
email [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
