4.1 client protocol?

[Todd Gruben]

I have an interesting problem.  I have developed a custom mysql 
replication client that we use for monitoring our mysql database.  Kinda 
like a poor man's trigger, but the power of an asynchronus trigger is 
very beneficial. Any way, I developed this client based on the 4.0 
version of mysql.  It appears that the network protocol has changed in 
4.1.  Is there any documentation of the 4.1 protocol, I figured the 4.0 
protocol out from the code, but that was a very time consuming 
experience for me and i was hoping for a slightly higher level bit of 
documentation than c code. Does such a beast exist?
---
Todd Gruben

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1 not using btree index on heap table on an UPDATE

[Todd Gruben]

Any reason why a SELECT which finds no matches returns instantly
but an update which has the same where clause takes about 2 secs to return.

explain reports that the select is exaninng 10 rows in a 300,000 row table.  
which is exactly what i am expecting.

are there any know issues?

-Todd

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

BTREE indexes in Heap table

[Todd Gruben]

how do your set the index type in 4.1?  My tables still appear to hash 
indexes.

-Todd

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Batch Deletes...

[Todd Gruben]

In an effort to speed up large batch deletes i devised this script.

LOCK TABLES t1 WRITE;
SELECT * INTO OUTFILE '/data/dump/t1' FROM t1 where date>="2003-06-09";
TRUNCATE TABLE t1;
LOAD DATA INFILE '/data/dump/t1' INTO TABLE t1;
UNLOCK TABLES;

this script would work great without the LOCK TABLES clause.  I receive an 
error saying there active locked tables.  This is a heap table and I am 
running mysql 4.0.12

Any ideas? i need the lock tables because there are some updates that will be 
happening to the current data, i just need to remove the old expired data. 
This takes about 30secs and my delete scripts takes about 4 hours. It is 
deleting about 500,000 rows out of a 4 million row table with several 
indexes.
-Todd


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]