|[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]|
On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote:
Hello,I've always been left wondering what Engine to use while creating tables, I've read quite a few times about the same on wiki, articles etc....buthaven't actually been able to decide. I wanted to know whats the storage engine used on MySQL on big webapplication, the application i am developing currently, is kinda really big and data intensive, we are looking at about 1,00,000 registration atleastin the first few months, and their data lets say, each will have about 10-20 operations, accounts etc... So the data can get really big andtroublesome to maintain, I am more concerned about the data safety, as incrash recovery or auto backups etc...Basically, if the MySQL DB crashes, we sholdnt be at a loss, and all thedata till the very last operation should be available as a backup. Any headsup on this please? Thanks, Vinay Kannan.
Maybe google MySQL innodb. I think they have rollback and table locking. As well as foreign key capabilities. Limited exp. Sorry not much more help. Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php