A very good question! One which I will attempt to provide a half-decent answer for.
Trying to execute a transaction that involves grabbing massive amounts of data from various tables while still allowing updates to be committed can be tricky. At best, this means performance problems. Please don't get me wrong - MySQL is the fastest database on the planet (and it looks to only get faster, with additional query caches, better designed caches and a helper thread architecture in the works) but there are certain things that are just hard to do quickly, even if you are the demigods that work at Innobase Oy and MySQL AB. The advantage of other methods is that you avoid all sorts of nasty locking on various parts of your database. The advantage of the Hot Copy product that Innobase Oy sell is that it doesn't place any locks on your InnoDB table space when it runs. In summary, it's not a question as to whether the current methods work, it's a question as to how well suited they are to your needs. For mine they work well, but if I was processing 600 queries / second, I think I'd want ibcopy to help me out. Regards, Chris <quote who="P Srinivasulu"> > > If the backup solutions are there already, why is that a future > requirement for Mysql? > > Thanks, > Srinivasulu. > > >>>> Chris Nolan <[EMAIL PROTECTED]> 8/27/2003 6:41:27 PM >>> > Hi! > > You can currently do this with InnoDB with mysqldump (look at the > --single-transaction switch). I use it for backing up a 12 GB mail > database without problems. > > Regards, > > Chris > > P.S. Keep up the great work over there at Novell! Tell us where to send > > the expensive bottles of alcohol for when you help put SCO out of their > > misery! > > P Srinivasulu wrote: > >>Hi All, >> >>The link below says that online backup functionality will be provided >>in Mysql-5.1. I think its already there in the form of mysqlhotcopy. > Is >>Mysql going to extend the functionality of mysqlhotcopy so that it > works >>for Innodb tables also? or they are going to provide independent > online >>backup functionality. Please clarify me. >> >>http://www.mysql.com/doc/en/TODO_MySQL_5.1.html >> >>Thanks, >>Srinivasulu. >> >> >> >> > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]