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]> Per: Baruwa users list <[email protected]>, Data: 10/05/2013 17:23 Oggetto: Re: [Baruwa] Rif: Re: compacting database mysql baruwa Inviato da: [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] CC: [email protected] From: [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]> Per: "[email protected]" <[email protected]>, Data: 10/05/2013 17:15 Oggetto: Re: [Baruwa] compacting database mysql baruwa Inviato da: [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]] On Behalf Of [email protected] Sent: Friday, May 10, 2013 10:34 AM To: [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
