Re: Data file for MyISAM engine

2011-11-22 Thread Johan De Meersman
- Original Message - > From: "Yu Watanabe" > > It seems that MYD is the data file but this file size seems to be not > increasing after the insert sql. That's right, it's an L-space based engine; all the data that has, is and will ever be created is already in there, so storage never in

Data file for MyISAM engine

2011-11-22 Thread Yu Watanabe
Hi ! I would like to ask question regarding to the MyISAM engine. Is there any physical file that you have to be aware of its size for disk sizing, like the ibdata1 in innodb storage engine? It seems that MYD is the data file but this file size seems to be not increasing after the insert sql.

innodb space free decreasing by more then the amount of data we're adding

2011-11-22 Thread Sean Sidelko
We just moved a large amount of data off one of our db servers to another one (75gb of data). One thing I've noticed is that over the last couple days the free innodb space has been decreasing by over 2.5 gb a day while we've only been adding 400 mb of data a day to the db server. I'm at a loss

Re: Chinese characters not displaying in Workbench latest version

2011-11-22 Thread Neil Tompkins
The problem was the character set not loaded on the OS On 21 Nov 2011, at 22:08, Michael Cole wrote: > I think what he was asking is, Are you running the Mysql workbench on the > same > machine? You may not have the correct Fonts. > > Being replicated the character sets of the two dbs should

RE: Reusing "ibdata1" space

2011-11-22 Thread Rozeboom, Kay [DAS]
Johan, I think you are right about this. The problem does not appear to be with the database at all, but with the undo log. Thanks for pointing me in the right direction. -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Tuesday, November 01, 2011 10:01 AM

Re: Restoring failed due to Unexpected Error

2011-11-22 Thread Reindl Harald
yes - take your fingers away and go to a datarecovery company if it is not too late because you are damaging the disk more and more, NOW it is too late for backups! Am 22.11.2011 06:03, schrieb Adarsh Sharma: > Any comments to get the data back know. > My hard disk crashes about 90% but when I sta