Re: copying a static table

2009-12-17 Thread Michael Dykman
Tom, For MyISAM tables, as long as you aren't overlapping your update cycles, I can see nothing wrong with this. We used to rync to prepare slaves under inndb: do a broken rsync from the live data files on the master to the archives.. when that is complete, the result file is quite broken but si

copying a static table

2009-12-17 Thread Tom Worster
i have a large myisam table (about 3gb) that is updated once a day in the middle of the night. when it is not being updated, is there any reason not to copy it out with rsync without shutting down the server or flush tables with read lock or whatever? -- MySQL General Mailing List For list arc

Static Table

2003-06-11 Thread Mojtaba Faridzad
Hi, I read the document about Static table and Dynamic table. When we have VARCHAR, BLOB, and TEXT, default is Dynamic. But if we don't have BLOB, we can force MySQL to create static table. Now my question: There is a table with more than 15 records and about 130 fields and there are