MySQL Size and Optimization Question
Firstly, apologies for what's probably a newb question but I'm really unfamiliar with mysql DBA.
I have two related questions and wondered if someone could help
1) Is there any potential damage in running a daily php cron job to OPTIMIZE all the tables in a database? I'm trying to reduce the overhead to keep the DB size to a minimum
2) I'm trying to get my head around storing a large amount of data - approximately 300,000 records that, from extrapolating the 1,000 records present, will take up about 750MB space for that table. Has anyone got first hand experience in doing something with this many records? Is the speed slow down likely to be highly noticable (i.e. greater than 3 second waits for queries)
In relation to number 2), if anyone also has a suggestion (utilising another server / upgrading ram) that would help I would be grateful
Thanks
Justin
yes, I am....