Chrispcritters - 3:03 pm on Jun 15, 2012 (gmt 0)

TABLE 1
--> ID,date,varchar(32),int,bigint
--> 17,000,000 records
--> Once daily batch INSERT of 500k records, DELETE of 500k records, once daily SELECT, no UPDATES

TABLE 2
--> ID,date,varchar(32),int,bigint
--> Table reset daily
--> Daily 500k INSERTS, 1m SELECTS daily, no UPDATES

TABLE 3
--> ID,bigint,int,int
--> Table reset daily
--> Once daily INSERT OF 250k records
--> 1m SELECTS daily

TABLE 4/5
--> ID,bigint,date,varchar(32)
--> 100k records normally
--> 500k INSERT, 500k SELECT, 50k DELETE daily

TABLE 6
--> ID,date,date,varchar(32),varchar(512)
--> 1,000,000 records
--> 500k SELECT, 450k UPDATE, 50k INSERT daily

several other smaller tables w/ < 50k records with with < 1k inserts, 100k selects daily

single server
mysql dump export weekly

looking for capacity for 100% growth.