NameSniper
12-21-2006, 08:00 PM
Can you please tell me if you have heap enabled in your mysql and whether it its playing a positive role on mysql performance ?
![]() | View Full Version : Heap feature in mysql NameSniper 12-21-2006, 08:00 PM Can you please tell me if you have heap enabled in your mysql and whether it its playing a positive role on mysql performance ? juangake 12-22-2006, 10:03 AM Do you mean heap type of table? maxymizer 12-22-2006, 01:50 PM HEAP is table type. If you enable HEAP support, it doesn't speed up the performance unless you use that table type for your data. And if you use that table type, you must know its advantages and drawbacks (which are available at MySQL website, under the manual). NameSniper 12-22-2006, 08:00 PM I have read MySQL documentation but its still unclear for me whether if its a good idea to enable HEAP tables for forum database. Can anyone please advice ? maxymizer 12-23-2006, 05:40 AM HEAP tables store data to your RAM. So, if your server is rebooted - data is gone. Forever. :) But, you can use those tables to store not so crucial data, like sessions and it makes sense as it will be rather fast to read/delete/update sessions when they're stored to RAM instead on HDD. NameSniper 12-23-2006, 12:47 PM Thanks for info |