[Koha-devel] Koha sessions table is ridiculously huge

[Galen Charlton]

Hi,

On Thu, Feb 18, 2010 at 7:45 AM, Colin Campbell
<colin.campbell at ptfs-europe.com> wrote:
> If you have everything in one ibdata file it can be difficult to recover
> space.

Yes, that's why is a good idea to use a separate file for each InnoDB
table; you can enable this by turning on the innodb_file_per_table
option in the MySQL configuration file.  If you're using a single
InnoDB tablespace now, however, making the switch would involve either
dropping and recreating the database from a mysqldump or loading the
data into a new database or a replicate, pointing Koha to it, and
dropping the old database.

Regards,

Galen
-- 
Galen Charlton
gmcharlt at gmail.com