Re: heap tables keep on disappearing!
At 11:41 -0800 3/6/03, Steve Quezadas wrote: I have a mysql table that I refer to a lot and needs to be quick. I set it as a HEAP table because of the speed (and HEAP tales ARE fast. zip baaannn). Anyway, whenever I restart the server the contents of the heap tables disappear! What the hell? But I read the manual and it seems that heap tables stay in memory and not disk. It surprises you that HEAP tables behave as documented? :-) The particular table I am using doesn't change very often (once every three months or so ).Is there a way that I can somehow keep the table from being erased on server restarts? Is the best way perhaps copying the table to a heap table every time the server starts up? Exactly. Maintain a version that is a permanent table on disk, and load it into the server at startup time. You might find the --init-file server option useful for this. - Steve sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: heap tables keep on disappearing!
Or just give MySQL plenty of ram and trust it to keep frequently used data in ram - which it does. "Prime" the system by doing some form of search which forces all the rows into memory (Select * from table where unindexedfield = somethingimpossible), the do a speed test on this versus a heap table. Wouldn't surprise me if they came out nearly the same. - Original Message - Store it in another table and have a start up script that creates a heap once the server is started ? Jerry From: "Steve Quezadas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 7:41 PM Subject: heap tables keep on disappearing! > I have a mysql table that I refer to a lot and needs to be quick. I set > it as a HEAP table because of the speed (and HEAP tales ARE fast. zip > baaannn). Anyway, whenever I restart the server the contents of > the heap tables disappear! What the hell? But I read the manual and it > seems that heap tables stay in memory and not disk. The particular table > I am using doesn't change very often (once every three months or so ).Is > there a way that I can somehow keep the table from being erased on > server restarts? Is the best way perhaps copying the table to a heap > table every time the server starts up? > > - Steve > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: heap tables keep on disappearing!
Store it in another table and have a start up script that creates a heap once the server is started ? Jerry - Original Message - From: "Steve Quezadas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 7:41 PM Subject: heap tables keep on disappearing! > I have a mysql table that I refer to a lot and needs to be quick. I set > it as a HEAP table because of the speed (and HEAP tales ARE fast. zip > baaannn). Anyway, whenever I restart the server the contents of > the heap tables disappear! What the hell? But I read the manual and it > seems that heap tables stay in memory and not disk. The particular table > I am using doesn't change very often (once every three months or so ).Is > there a way that I can somehow keep the table from being erased on > server restarts? Is the best way perhaps copying the table to a heap > table every time the server starts up? > > - Steve > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
heap tables keep on disappearing!
I have a mysql table that I refer to a lot and needs to be quick. I set it as a HEAP table because of the speed (and HEAP tales ARE fast. zip baaannn). Anyway, whenever I restart the server the contents of the heap tables disappear! What the hell? But I read the manual and it seems that heap tables stay in memory and not disk. The particular table I am using doesn't change very often (once every three months or so ).Is there a way that I can somehow keep the table from being erased on server restarts? Is the best way perhaps copying the table to a heap table every time the server starts up? - Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
