[sergius]

QUOTE(peterlaursen @ May 9 2005, 02:09 PM) [snapback]5381[/snapback]

I have noticed the each time I'm doing some experimenting with INNODB tables my INNODB data-file (ibdata1) grows. When I delete some DB and tables the file doesn't shrink. I simply think it is the way INNOBD behaves with MySQL. it “claims” diskspace when needed but does not free it when it is not needed.

Now the file here with me is about 200 MB and the data in it is just about 30 MB. Not a real problem but …

However is there any way to “shrink” that file except than dumping the DB, deleting the bases, stopping the MySQLserver, deleting the datafile, restarting the server and importing the dumps ? And could that be implemented with SQLyog ?

Could you suggest what to do when the data file grows to fill all the disk space?

[sergius]

Thanks, maybe I should switch to Norton, then. I've had other problems with ZoneAlarm, which were pretty annoying, but it never seemed to make false reports about programs accessing IP destinations.

And just because I'm paranoid doesn't mean they're not out to get me 🙂

[sergius]

Ritesh wrote on Feb 3 2003, 09:47 AM:

Start the create table dialog…( press Insert after selecting a DB in the object browser or select Create Table In The Database… in DB menu )

In the DATATYPE column table select ENUM and insert the ENUM values in LENGTH column.

For eg if you want to create a field month with value January, February etc. then select enum in the DATATYPE column and give the following value in Length column –

'January','February','March','April','May','June','July' etc.

Hope it helps.

I just had the same problem. I guess the UI could be a little crearer about that 🙂

[sergius]

It's a step ahead, for sure.

But the transparent-background PNG images are shown as black rectangles. When I save them as files and view them in a browser, they look fine.

And the installer screen still says version 4.06 🙂

[sergius]

I can monitor the status of DB connections using the statement SHOW PROCESSLIST, for example.

[sergius]

I'll try it again at some point, but I'm pretty sure it reported 0 ms taken even for very long queries (not necessarily with a lot of data to return, but the ones that took the server a long time to process).

[sergius]

Excellent, thanks! Do you know when that version will be available?

[sergius]

Apparently, the time reported is > 0 when there is a syntactical error in the statement, so maybe it's the time it takes the server to parse the statement or something like that…

Error Code : 1052

Column: 'gate_sweep_frequency' in where clause is ambiguous

(47 ms taken)

[sergius]

Maybe it is coming from the server (in my case, MySQL 4.0.16), but the messages have everything to do with the statements that I executed:

(599 row(s) returned)

(0 ms taken)

[sergius]

I'd like the hex view and external viewer features, too.

[sergius]

I haven't read all the replies here. In case this still matters, I also hit this bug.

MySQL 4.0.16 / Linux

SQLyog 4.0.5 / W2K

I tried to attach a small png screenshot to this post, but the interface wouldn't let me for some reason

[Author]

Posts