Re: [VuFind-Tech] MySql Size

[Demian K. <dem...@vi...>]

I think that the MySQL "optimize table" command can help with this -- but you should probably make a backup before trying it, just to be safe (also not sure if it will cause any locking issues... or how long it might take).

- Demian

> -----Original Message-----
> From: Osullivan L. [mailto:L.O...@sw...]
> Sent: Thursday, July 11, 2013 6:11 AM
> To: 'vuf...@li...'
> Subject: [VuFind-Tech] MySql Size
> 
> Hi Folks,
> 
> I've emptied my session table of the 34GB of data but there has been no
> reduction in file size on the server.
> 
> I've had a look at
> http://stackoverflow.com/questions/3456159/how-to-shrink-purge-ibdata1-file-
> in-mysql
> which suggests the only way to actually get rid of the 34GB of data is
> to dump the databases, delete all databases, remove the ibdata1 and
> ib_log files, restart mysql and then restore from the dump.
> 
> Has anyone else tried something like this?
> 
> Cheers,
> 
> Luke
> ------------------------------------------------------------------------------
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> _______________________________________________
> Vufind-tech mailing list
> Vuf...@li...
> https://lists.sourceforge.net/lists/listinfo/vufind-tech