Space is cheap. Not sure why your trying to recover a few hundred MBs. -- Jeremy McSpadden Flux Labs, Inc | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless Solutions Office : 850-250-5590x101<tel:850-250-5590;101> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955>
On May 10, 2013, at 10:48 AM, "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> wrote: from shell mysql i have tryed this command: ALTER TABLE messages "ENGINE"='InnoDB'; i cannot recover the space. it's very strange that there is not possible to compact database mysql and recover space thanks Da: marco rosenstein <[email protected]<mailto:[email protected]>> Per: Baruwa users list <[email protected]<mailto:[email protected]>>, Data: 10/05/2013 17:23 Oggetto: Re: [Baruwa] Rif: Re: compacting database mysql baruwa Inviato da: [email protected]<mailto:[email protected]> ________________________________ Sounds like you have a InnoDB table, not MyISAM. You can make OPTIMIZE TABLE work on other engines by starting mysqld --skip-new ________________________________ To: [email protected]<mailto:[email protected]> CC: [email protected]<mailto:[email protected]> From: [email protected]<mailto:[email protected]> Date: Fri, 10 May 2013 17:18:11 +0200 Subject: [Baruwa] Rif: Re: compacting database mysql baruwa the exact message is: TABLE DOES NOT SUPPORT OPTIMIZE,DOING RECREATE+ANALYZE Da: "Morgan, Jeffrey R" <[email protected]<mailto:[email protected]>> Per: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>, Data: 10/05/2013 17:15 Oggetto: Re: [Baruwa] compacting database mysql baruwa Inviato da: [email protected]<mailto:[email protected]> ________________________________ Have you run ‘OPTIMIZE TABLE’? See http://stackoverflow.com/questions/3927690/howto-clean-a-mysql-innodb-storage-engine/4056261#4056261 for some helpful information (and some considerations regarding the growth of ibdata1 From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]> Sent: Friday, May 10, 2013 10:34 AM To: [email protected]<mailto:[email protected]> Subject: [Baruwa] compacting database mysql baruwa hi i have deleted all messages from tables MESSAGES & ARCHIVE from mysql database baruwa i have launched baruwa-admin dbclean >/dev/null 2>&1# and it had taken about1 hour but the disk space is same what can i do to free compact database so i will have more free space Thanks Fabio_______________________________________________ http://pledgie.com/campaigns/12056 _______________________________________________ http://pledgie.com/campaigns/12056_______________________________________________ http://pledgie.com/campaigns/12056 _______________________________________________ http://pledgie.com/campaigns/12056
_______________________________________________ http://pledgie.com/campaigns/12056
