MySQL Forums
Forum List  »  InnoDB

InnoDB: Warning: using a partial-field key prefix in search
Posted by: Keith Larson
Date: June 01, 2005 03:57PM

InnoDB: Warning: using a partial-field key prefix in search
4.0.23-standard-log


Hello,

We just had a DB crash. Recovered and now showing the same errors before the crash.

050523 19:26:52 InnoDB: Warning: using a partial-field key prefix in search
050523 19:27:48 InnoDB: Warning: using a partial-field key prefix in search
050523 19:29:32 InnoDB: Warning: using a partial-field key prefix in search
050523 19:31:29 InnoDB: Warning: using a partial-field key prefix in search
050523 19:38:31 InnoDB: Warning: using a partial-field key prefix in search
050523 19:38:51 InnoDB: Warning: using a partial-field key prefix in search
050523 19:39:34 InnoDB: Warning: using a partial-field key prefix in search
050523 19:39:49 InnoDB: Warning: using a partial-field key prefix in search
050523 19:39:58 InnoDB: Warning: using a partial-field key prefix in search
050523 19:41:03 InnoDB: Warning: using a partial-field key prefix in search
050523 19:41:29 InnoDB: Warning: using a partial-field key prefix in search
050523 19:41:38 InnoDB: Warning: using a partial-field key prefix in search

etc.......


050529 13:08:11 InnoDB: Warning: using a partial-field key prefix in search
050529 13:20:20 InnoDB: Warning: using a partial-field key prefix in search
050529 13:35:35050529 13:35:35 InnoDB: Warning: using a partial-field key prefix in search
InnoDB: Warning: using a partial-field key prefix in search
050529 13:44:42 InnoDB: Warning: using a partial-field key prefix in search
050529 13:51:33 InnoDB: Warning: using a partial-field key prefix in search
050529 14:01:09 InnoDB: Warning: using a partial-field key prefix in search
050529 14:12:56 InnoDB: Warning: using a partial-field key prefix in search


etc ...


050601 16:13:14 InnoDB: Warning: using a partial-field key prefix in search
050601 16:20:39 InnoDB: Warning: using a partial-field key prefix in search
050601 16:21:30 InnoDB: Warning: using a partial-field key prefix in search
050601 16:24:23 InnoDB: Warning: using a partial-field key prefix in search
050601 16:27:01 InnoDB: Warning: using a partial-field key prefix in search
050601 16:28:15 InnoDB: Warning: using a partial-field key prefix in search
050601 16:30:12 InnoDB: Warning: using a partial-field key prefix in search
050601 16:31:40 InnoDB: Warning: using a partial-field key prefix in search
050601 16:32:22 InnoDB: Warning: using a partial-field key prefix in search
050601 16:36:07 InnoDB: Warning: using a partial-field key prefix in search
050601 16:37:50 InnoDB: Warning: using a partial-field key prefix in search
050601 16:38:56 InnoDB: Warning: using a partial-field key prefix in search
050601 16:42:08 InnoDB: Warning: using a partial-field key prefix in search
050601 16:44:13 InnoDB: Warning: using a partial-field key prefix in search
050601 16:52:11 InnoDB: Warning: using a partial-field key prefix in search
050601 17:00:58 InnoDB: Warning: using a partial-field key prefix in search
050601 17:03:54 InnoDB: Warning: using a partial-field key prefix in search
050601 17:06:01 InnoDB: Warning: using a partial-field key prefix in search
050601 17:11:15 InnoDB: Warning: using a partial-field key prefix in search
050601 17:16:36 InnoDB: Warning: using a partial-field key prefix in search
050601 17:19:07 InnoDB: Warning: using a partial-field key prefix in search
050601 17:35:23 mysqld started
050601 17:35:23 Warning: Asked for 196608 thread stack, but got 126976
050601 17:35:24 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 800 2857359926
InnoDB: Doing recovery: scanned up to log sequence number 800 2862602752
InnoDB: Doing recovery: scanned up to log sequence number 800 2867845632
InnoDB: Doing recovery: scanned up to log sequence number 800 2873088512
InnoDB: Doing recovery: scanned up to log sequence number 800 2878331392


InnoDB: Doing recovery: scanned up to log sequence number 800 3250575872
InnoDB: Doing recovery: scanned up to log sequence number 800 3254596802
050601 17:36:13 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: position 0 749993558, file name mysql-bin.016
InnoDB: Last MySQL binlog file position 0 482547363, file name ./d2-bin.032
050601 17:37:05 InnoDB: Flushing modified pages from the buffer pool...
050601 17:37:47 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: '4.0.23-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Official MySQL RPM
050601 17:39:58 InnoDB: Warning: using a partial-field key prefix in search
050601 17:43:41 InnoDB: Warning: using a partial-field key prefix in search
050601 17:46:29 InnoDB: Warning: using a partial-field key prefix in search
050601 17:47:30 InnoDB: Warning: using a partial-field key prefix in search
050601 17:49:10 InnoDB: Warning: using a partial-field key prefix in search
050601 17:49:13 InnoDB: Warning: using a partial-field key prefix in search
050601 17:50:24 InnoDB: Warning: using a partial-field key prefix in search
050601 17:53:09 InnoDB: Warning: using a partial-field key prefix in search


Any Ideas on what is going on ?

Keith

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB: Warning: using a partial-field key prefix in search
4212
June 01, 2005 03:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.