Splitting a database table into multiple segments for performance or manageability.
0
votes
0answers
52 views
MySQL Partioning: Is there a performance tradeoff between number of partitions and size of each partition?
I have a large table (several 100 million rows) that I would like to efficiently partition. My question is whether there is a tradeoff between partition size and number of partitions. As far as I ...
0
votes
0answers
50 views
Partition manager utility/script?
Does anyone know of any Utilities or scripts out there for partition management. Most of our partitioning is range based and I have a set of home grown scripts to expand as needed as well as maintain ...
0
votes
0answers
412 views
Why won't Oracle alter the size of a column that is used for sub partitioning?
I am trying to resize a varchar2 column, when I get an ORA-14265 error:
ORA-14265: data type or length of a table subpartitioning column may not be changed
With Oracle providing the unhelpful:
...
-1
votes
1answer
1k views
open files limit
I am getting "too many open files" error when I try to insert records in a partitioned table.
mysql> insert into test.ox_data_geo_span select * from vserv.ox_data_geo_span limit 100;
ERROR 1016 ...
