2003年 8月 28日 木曜日 01:43、Nils Valentin さんは書きました: > 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]
