From: Date: December 6 2004 9:09pm
Subject: RE: Locking Issue?
List-Archive: http://lists.mysql.com/mysql/176919
Message-Id: <62D6B7C12242244DA66D9A4428688D92158566@fiexchange.friendster.local>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

=20

-----Original Message-----
From: Terry Riley [mailto:moscow@stripped]=20
Sent: Monday, December 06, 2004 10:12 AM
To: mysql@stripped
Subject: Locking Issue?

Can someone help, please?

We set up a server to handle a coldfusion web application (CFMX 6.1)
running against MySQL 4.1.3b-beta on WinNT.

When it is a little stretched, we are finding many instances of queries
listed as either 'Sending...' or 'Copying...' in the processlist,=20


Sending Data means stream the result set back, mysql found the rows and
is still searching.
Copying to tmp table means that it's using the tmp_table_size variable
and if it busts past that will write to a temp table.


Since you using innodb you need to increase your innodb buffer pool.
Additionaly increase your tmp_table_size buffer, and verify your
queries. You might need to tweak innodb_io_threads a feature specific
for windows, and the awe memory setting.

You might be system bound.


[mysqld]

max_connections=3D1000

basedir=3De:/mysql
datadir=3De:/mysql/data

wait_timeout=3D60

# TR added next 6 lines on 27/07/04, after instal of v4.1.3b
old-passwords local-infile query_cache_size=3D25M
query_cache_type=3D1
set-variable=3Dmax_allowed_packet=3D16M
set-variable=3Dkey_buffer=3D8M

log-bin=3D
log_slow_queries=3D


[mysql]
local-infile=3D1


Any pointers as to what I may be doing wrong? Please?

Yes, I know we should upgrade to 4.1.7, and we will - soon.

Cheers
Terry Riley


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Ddathan@stripped