MySQL Forums
Forum List  »  Performance

MYSQL 3 questions
Posted by: Jozef Gavel
Date: July 19, 2011 12:01PM

Is possible to use MYSQL, if daily data amount downloaded to database is at minimum 1 milion rows (records).
Data are inserting every 20 seconds.
Data will be downloaded every day (24/7) - per 1 year is about 3 bilion records.
I need keep data for 3 years directly in database.

Question 1 : Which MYSQL version is good for this amount of data for properly function?
Question 2 : How to made indexing of database, is possible to do it online without switch-off database server?
Question 3: Is possible to connect MySQL with Oracle Bussiness Intelligence..is there any possible, known troubles?
Thanks for reply.

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL 3 questions
2740
July 19, 2011 12:01PM
883
July 28, 2011 07:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.