Hi Chris, 2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました: > 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.
You made an interesting point there with the locking mechanism. I double checked the innodb homepage. http://www.innodb.com/hotbackup.html While it says at the top as you stated no locks are written it also says under 3) how it locks and unlocks the tables. I guess thats best explained by Heikki ;-) - I copied her. Best regards Nils Valentin Tokyo/Japan > > 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. -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
