[peterlaursen]

BTW: First table-type was MyISAM. I changed to InnoDB to be able to ROLLBACK …

[peterlaursen]

simply:

CREATE TABLE `tablename1` (

`id` bigint(20) NOT NULL auto_increment,

`mytext` varchar(255) default NULL,

`c` longblob,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

You can downoad 10 images from

http://deepeter.dyndns.dk/Bigpics/CRW_0001.tif

http://deepeter.dyndns.dk/Bigpics/CRW_0004.tif

http://deepeter.dyndns.dk/Bigpics/CRW_0005.tif

http://deepeter.dyndns.dk/Bigpics/CRW_0017.tif

http://deepeter.dyndns.dk/Bigpics/CRW_0023.tif

http://deepeter.dyndns.dk/Bigpics/CRW_0024.tif

http://deepeter.dyndns.dk/Bigpics/CRW_0031.tif

http://deepeter.dyndns.dk/Bigpics/CRW_0046.tif

http://deepeter.dyndns.dk/Bigpics/CRW_0101.tif

http://deepeter.dyndns.dk/Bigpics/CRW_0119.tif

I have 128 kbit/sec in outgoing direction so it will take some time 😀

But it won't be faster for me to upload ..

Please give me a hint where you're finished!

[peterlaursen]

Just want to add that this crash corrupted the database.

[peterlaursen]

And finally …

an attempt to insert the 6th image generated this error. I might have hit the maximum swapfile size.

When an image has been save to the base, why does it not free the memory ?

As of now memory consumption is rising MORE THAN proportional to the number of files opened.

I shall stop now.

But I have more than 50 programs managing memory more efficient than SQLyog.

That does not mean that SQLyog is not an excellent program. :wub:

But there is something to improve on over time here …

[peterlaursen]

I had to delete all rows except for the first two to get BLOB viewer functional with that database again!

[peterlaursen]

SQLyog memory consumption after having opened the fourth big TIFF from BLOB viewer (save in between). Has been like that for about ½ hour now …

MySQL Server resource consumption is quite normal …

I know very well that this is abnormal use. But I can have open about 50 of those files in Photoshop at the same time before system load and performance becomes unacceptable.

Hardware is XP+ 1700, 512 MB RAM

[peterlaursen]

What's happening here ?? Message appears when inserting into 4th (as far as I remember) row.

Seems like BLOB-viewer interface demands unique content of rows or a PK.

The rows where all columns are NULL have earlier had data in BLOB-fields. Maybe rows should have been deleted when BLOB's were deleted and leaving all colums as NULL ?

A minor issue that should not delay RC2 .. or whatever you may name it!

[peterlaursen]

You won't have to uninstall 4.1 to install 4.0.

But there is more “fun stuff” in 5.0 than in 4.1 …

[peterlaursen]

Yes, but I also experienced that Blob Viewer fails to display the graphics after a while. After closing down and restarting SQLyog it works again …

I don't say it's a big deal. You would rarely put big images like this in the DB – rather a pointer to its position within the file system. And reading image data from a Database Server is not the same to reading image data directly from file system.

Never the less I think you should keep an eye on it in the future. I have hundreds of 35 MB 48 bit TIFFs that you might test with. And then you'll also see how beautiful a place Denmark is 🙂

[peterlaursen]

Yes …

SOMETIMES 😉 I remember to write that connection problems can be a firewall issue!

[peterlaursen]

transparant GIF's seem to function reasonably although it is not “true transparancy”.

With the image below the circle in the middle is transparent area.

@Sergio: I believe that PNG-transparancy is quite new and not yet fully standardized. I believe I read about it on the Mozilla or Opera Website … Correct me if I am wrong

[peterlaursen]

Quote:

… but the ones that took the server a long time to process

How can you tell if time was spent with the MySQL server or the Operating System/File System/Network Access ??

[peterlaursen]

Instead of “copy table to another host” I export table to a text-file, edit the text-file and and import it using SQLyog export/import-function.

Thsi incompability between MySQL-version affect several functions in SQLyog. Also the DB-syncronization feature. And here there is is no easy workaround! Actually I have 3 MySQL versions installed on my local machine (4.0.24, 4.1.12 and 5.0.7), and switch between them as needed (that's quite easy using “MySQL Administrator” “Service Control” and “Startup Variables” options – you only need to change 4 strings values, stop and restart the server. It can be done in less than 15 seconds. And exporting/importing even big files on localhost is very fast too). That's my workaround.

I know that the Webyog people would like to code some workaround into the program. But I don't know if they found a safe way to do it yet!

Quote:

Probably I should also be bugging my web host provider to upgrade to 4.1.

I would like mine to have 5.0.x since I make extensive use of VIEWs. But ISP are very conservative with that. And they have good reasons since that would involve also PHP and ASP configuration. Some users' .php and .asp code might need to be changed for it to work with new versions …

So most ISP's are still running Apache 1.3, php4 and MySQL 4.0, although newer version af all of them are available.

But I do believe that very soon we will se a change with the best (and most expensive!) ISPs and hosting providers.

[peterlaursen]

this link probably is more relevant:

http://dev.mysql.com/doc/mysql/en/charset-general.html

[peterlaursen]

Quote:

The local MySQL version is 4.1.12-nt and the remote is 4.0.23-nt.

That''s the crux of the problem. With MySQL 4.1 a much more sophisticated handling of localisation issues (among them new charset's and collations) was introduced. You can study the 4.1.x changelogs here http://dev.mysql.com/doc/mysql/en/news-4-1-x.html

Quote:

“DEFAULT CHARSET=latin1” clause. If I remove that part and execute the statement manually it works

There is no other way I believe … I use both 4.0.24 and and 5.0.7 and edit my SQL the same way when importing a DUMP from 5.x to 4.x

[Author]

Posts