Author Topic: Mysql Question  (Read 4718 times)

0 Members and 1 Guest are viewing this topic.

Offline Western Rhythm

  • Newbie
  • *
  • Posts: 25
    • View Profile
    • http://www.westernrhythm.com
Mysql Question
« on: May 31, 2002, 11:05:37 AM »
Hi,

Is there any reason the 4images_sessions table is a 'HEAP' ?
and its using 1.1MB of database space?

I'm not utilising my members function I've totall disabled it, would it be safe to change? or delete?

Offline Western Rhythm

  • Newbie
  • *
  • Posts: 25
    • View Profile
    • http://www.westernrhythm.com
Mysql Question
« Reply #1 on: May 31, 2002, 10:16:30 PM »
can I get a response please? I have a limit on my sql database. and 1mb for table is alot...

cheers

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Mysql Question
« Reply #2 on: June 01, 2002, 07:09:28 PM »
hi,

you can change the table sessions to MyISAM type!

INFO:
HEAP is much faster than MyISAM ! BUT after restart from mySQL server are the entries gone..
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline Western Rhythm

  • Newbie
  • *
  • Posts: 25
    • View Profile
    • http://www.westernrhythm.com
Mysql Question
« Reply #3 on: June 02, 2002, 10:22:05 AM »
thanks! :)

cheers