Hi Stephen, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: > > I am feeling like loadercli is not getting attention it > needs. I've posted several topics related to it and wasted a > lot of time due to design > problems I have reported. Is no one at SAP / MySQL actively > taking this topic and responding on the list? > I'm terribly sorry if we didn't pay enough attention to the problems. I am one (among others) who feels responsible for the Loader and I read/write on the list.
> Interesting discovery I made regarding loadercli: > > Our FULL database backups are around 12GB in size without > logs. Using high compression schemes we can get this file > down to 2GB. [snipped output from "info state"] > > I found that using tableextract PAGES of all tables I get > 4.7GB. Is this because the indexes are left behind? 12GB vs > 4.7GB is pretty big difference. > Yep, could be. It depends of course on the indexes you created. And you should keep in mind that the tree structures (primary keys) need some space, too. And not to forget: as the indexes are simply stored in data files as statements upon TABLEEXTRACT (meaning sth like CREATE INDEX bla on blabla) they need to be recreated on the target db. That may consume some time (instead of space). > These dramatic differences in space required and I/O > performed make loadercli attractive as a backup solution in > some situations. However, the table locking... > Yes, the Loader works generally with isolation level 3 to have no inconsistencies. It is at the moment not adjustable with any parameter. But we could discuss this topic... > The inability to do a backup and restore to an alternate > platform creates this desire. If it were possible to do a > backup on Windows 2000 and > restore directly on Solaris I wouldn't have been spending so > much time or concern on loadercli ... > What a pitty ;-) Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
