Marc, what MySQL version you are using? Can you figure out what query is causing the warning?
Have you possibly mixed .frm files so that MySQL may have wrong information about column lengths? I have now added the following diagnostic code to a future version on InnoDB. It also explains what the warning is about. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ ........................... if (key_ptr > key_end) { /* The last field in key was not a complete key field but a prefix of it. Print a warning about this! HA_READ_PREFIX_LAST does not currently work in InnoDB with partial-field key value prefixes. Since MySQL currently uses a padding trick to calculate LIKE 'abc%' type queries there should never be partial-field prefixes in searches. */ ut_print_timestamp(stderr); fprintf(stderr, " InnoDB: Warning: using a partial-field key prefix in search.\n" "InnoDB: Table name %s, index name %s. Dump of the key\n" "InnoDB: value in the MySQL format:\n", index->table_name, index->name); fflush(stderr); ut_print_buf(original_key_ptr, key_len); fflush(stdout); fprintf(stderr, "\n"); if (!is_null) { dfield->len -= (ulint)(key_ptr - key_end); } } ----- Original Message ----- From: ""Mechain Marc"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, August 19, 2003 5:09 PM Subject: What's the meaning of: "InnoDB: Warning: using a partial-field key prefix in search" > In one of my logfiles I have quite repeatedly the following message: > > InnoDB: Warning: using a partial-field key prefix in search > > What does this warning mean ? > > Regards, > > Marc Mechain > Atos Origin > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
