Re: MERGE table with some packed tables?

2004-03-22 Thread Dan Nelson
In the last episode (Mar 22), Chris Elsworth said: > Ah, well these tables do need to be queryable and thus live; I only > ask about packing because it'll save space and (apparently) make them > faster; I've never actually played with packing MyISAM tables before. > > Happen to know if MySQL will

Re: MERGE table with some packed tables?

2004-03-22 Thread Chris Elsworth
On Mon, Mar 22, 2004 at 01:40:29PM -0600, Dan Nelson wrote: > In the last episode (Mar 22), Chris Elsworth said: > > Now that's all well and good and I'm fairly sure it'll all work, but > > another interesting idea I was wondering over was - can I myisampack > > the tables that I know won't be upda

Re: MERGE table with some packed tables?

2004-03-22 Thread Dan Nelson
In the last episode (Mar 22), Chris Elsworth said: > Now that's all well and good and I'm fairly sure it'll all work, but > another interesting idea I was wondering over was - can I myisampack > the tables that I know won't be updated anymore, and still MERGE > them, with other unpacked-tables? It

MERGE table with some packed tables?

2004-03-22 Thread Chris Elsworth
Hello, Just a quick question to see if anyone's tried this and run into any problems, or if it'll even work - I have a *huge* table that's just crashed thanks to FreeBSD panicking, and the repair operation I'm estimating is going to be another 4 hours :( But anyway, I'm pondering over splitting t