Web Hosting Talk







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