total vps newbie, cpu usage, ram etc
I need a box (currently using pc at home) to process csv, json and xml datafeeds up to 300MB in size. These contain anything up to 200,000 "rows" of product data.
I run these through a php script which will read each product, sanitize etc and then insert/update into a mysql table.
Currently these tables are up to 400MB in size.
I then do various things like output a csv to import to another server etc.
I do this many times through the day.
What spec VPS do I need as a minimum? is 256MB ram enough for mysql and tables this big? I dont know much about databases on a technical level.
Will I have problems running these tasks (via cron), in terms of CPU usage? What is typical procedure if you use too much CPU? a warning first, then suspension/termination?
Any help appreciated, very new to VPS's.