Select statement locking tables in the from clause....

[Jim Crippen]

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

Multiple masters to 1 slave??

[Jim Crippen]

I'm trying to find a way to set up an off-site replication (slave 3).  In
house I have several MySQL 4.0 servers that are using replication.  They
consist of 1 master (master1) for all data, 1 slave (slave 1) for optimized
web access and 1 slave (slave 2) for the internal database app.  Both
slaves' databases have additional tables not on the master and the
replication is using replicate-do-table=DBanme.Tablename in the /etc/my.cnf
files.  Here's the question.
 
In the my.cnf file on the off-site slave, can there be multiple masters
specified where it will replicate all 3 in-house servers to different
databases on itself?
 
Master1 -- Slave1 (same db name)
Master2 -- Slave2 (same db name)
 
Master1 -- Slave3 (diff db name)
Slave1 -- Slave3 (diff db name)
Slave2 -- Slave3 (diff db name)
 
Thanks,
 
Jim 

-
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