Partial char key not used in conjuction with inequality comparison (MySQL5)

Hello list! I've noticed in MySQL 5.0 partial keys on character fields aren't always used. In 4.1 they were. They seem not to be used when using inequality comparison. I'm not sure whether this is a bug or intended (in the latter case I have to work around it to get the speed I got with 4.1

Re: monitoring SQL query response times

Is there a way to monitor SQL query response times? Mysqlperformanceblog has patches for higher granularity query log: http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ You could always just wrap the query calls in between some time registration of your own. --

Server not resolving and hostnames

I'm running multiple mysql servers on a local network. One of them has an additional network interface to the outside world. This server is the only one properly resolving any hostnames. All other servers fail to resolv anything. I'm running bind9 named for my outside domain and a local domain

Query cache confused when using different client protocols

Try this: Setup a database server, with MySQL 4.1, with query cache turned on Setup a client machine with MySQL 4.0 Setup a client machine with MySQL 4.1 (libmysqlclient14) Create very simple table : CREATE TABLE woepwoep (CNT int NOT NULL); Insert single row : INSERT INTO woepwoep SET CNT=10;