Hi,
Peter Schulz wrote:
> ok solution is - making varchar a little smaller
> (some i changed to 30 some to 50) ... that
> helped... i think that rowsize was already to
> large, but it failed with errno 738 because TEXT
> can't be to large or something like this... now
> all my tables are up... :)
>
> next question is only to understand something - if
> i duplicate this DB - could get me this in trouble
> with config? (limitations of keys or indexes or
> so? or is this "new" for each db?) how can i found
> out the good settings (we need at least 20 copies
> of that db ...)
>
If you duplicate the same DB in the same cluster then you need
to increase the number of tables, indexes and unique hash indexes
accordingly. Two tables in different DB's are always separate from
each other and have their own table, indexes and so forth.
Rgrds Mikael
> _pete®
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com