Sample Header Ad - 728x90

TokuDB + MariaDB 10: should I use a clustered index

0 votes
2 answers
774 views
I have a large table (200 Columns.. I know, but it wasn't my design) that will grow fast and I will have a lot of useless rows in it, identified by an IP (a varchar 32 column). The table will get hundreds of thousands of rows per day and I will need to delete few thousand rows with a specific IP in that column. During the day at regular intervals (5 min perhaps) I will need to select rows and avoid rows with certain IP. The deletions I'll probably do in the evening not to put too much load on the DB. Should I use a clustered index or a regular index on this column? TokuDB claim there's no performance loss unlike InnoDB but still we're talking 200 columns (a lot of them empty to be fair (or null or 0s)). I will need to add more indexes as well on a few other varchar columns as well over which I'll perform selects. Some will have huge cardinality as they're "Timestamps with milliseconds". Will I benefit or suffer from clustered indexes?
Asked by Recct (121 rep)
Jan 7, 2015, 04:21 PM
Last activity: Jan 6, 2018, 07:48 PM