Dinesh Pandey wrote:
I am inserting some log messages in the column "data". (Basically I am
inserting records from reading an xml file)
In the PRIMARY KEY, btree (scan_id, host_ip, port_num, plugin_id, severity,
data) data is of type TEXT and can contain long string values.
I'm still not convinced that "data" makes a sensible part of the primary
key. Can you give an example of "data" and explain why the whole value
determines unique-ness?
The question is how to remove this error "index row size 2728 exceeds btree
maximum, 2713" by increasing the btree size?
The big problem is "I can not add any additional column in this table."
Why not?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
